Cumulative Drawdown

[akardar1]

Hi Team,

Looking for Guidance on how to create a cumulative percentage drawdown column.
He have a equity balance in column A which looks like the data below.
Drawdown is generally defined as the peak to trough change in account value.
I'd like to create an additional column that will allow me to chart this the historical cumulative percentage drawdown

Any ideas on how to do this ?


[TABLE="width: 71"]
<tbody>[TR]
[TD="width: 71, align: right"]$1,116,793[/TD]
[/TR]
[TR]
[TD="align: right"]$1,106,652[/TD]
[/TR]
[TR]
[TD="align: right"]$1,179,335[/TD]
[/TR]
[TR]
[TD="align: right"]$1,185,313[/TD]
[/TR]
[TR]
[TD="align: right"]$1,183,744[/TD]
[/TR]
[TR]
[TD="align: right"]$1,177,245[/TD]
[/TR]
[TR]
[TD="align: right"]$1,172,663[/TD]
[/TR]
[TR]
[TD="align: right"]$1,170,567[/TD]
[/TR]
[TR]
[TD="align: right"]$1,155,870[/TD]
[/TR]
[TR]
[TD="align: right"]$1,152,055[/TD]
[/TR]
[TR]
[TD="align: right"]$1,146,519[/TD]
[/TR]
[TR]
[TD="align: right"]$1,140,569[/TD]
[/TR]
[TR]
[TD="align: right"]$1,139,048[/TD]
[/TR]
[TR]
[TD="align: right"]$1,136,959[/TD]
[/TR]
[TR]
[TD="align: right"]$1,130,068[/TD]
[/TR]
[TR]
[TD="align: right"]$1,129,641[/TD]
[/TR]
[TR]
[TD="align: right"]$1,122,785[/TD]
[/TR]
</tbody>[/TABLE]