Max Drawdown + implementation

[ocannon1]

Hi,

First things first, I have never used a macro/VBA before, so i do not know what im doing.
I've searched for an answer to my problem (below), but don't know how to go about adding it to my worksheet, setting the correct range, putting it into a cell etc..- so i need help with the solution AND getting it into my sheet...

it's just a simple maximum drawdown problem which i could do 'manually', but because the sheet im producing is meant to be saving time, it'd like to have a single cell that will calculate maximum drawdown for its own row - as part of a table.

i've attached a sample sheet, but on my actuall worksheet the dates go back to Oct-86 and not every series goes back the same length of time

any help is appreciated

EDIT: Solved myself, just had to learn how to use VBA

[JBeaucaire]

Not sure how VBA plays into this. But from the sample provided, the MAX functions seems straightforward:

=MAX(Table1[@[Oct-12]:[Jun-13]])

or

=MAX(D8:L8)

[ocannon1]

Not sure how VBA plays into this. But from the sample provided, the MAX functions seems straightforward:

=MAX(Table1[@[Oct-12]:[Jun-13]])

or

=MAX(D8:L8)

because maximum drawdown is a measurement of peak-to-trough over time from the performance data and not simply the maximum/minimum number from a set of data.

[JBeaucaire]

Since the Questions and Answers serve as a learning tool for others, could you please post the VBA solution that solved your draw down puzzle?

Thanks!