Maximum drawdown for the period

Hello guys!

I searched through the forum for "Drawdown" but still couldn't find an answer to my question.

My task is to find return and drawdown (risk) for the specified period.

I have calculated the return for the period using Index and Match functions.
But I don't know how to calculate drawdown (DD) for the same period.

The main problem is that during the period, my equity can set new highs repeatedly, which leads to a constant recalculation of the DD and finding a new maximum DD value.

So I have to choose the maximum DD for the selected period of several DD for the period.

I've attached a file with an example and description.

Thanks in advance for any help

See attached...

Insert 2 columns after column E for helper columns.

In new F3 enter:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER not just ENTER so you see { } brackets surround the formula... then copy down.

then in G3 enter:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER not just ENTER and copy down

then in K7 to get final result enter:

Please Login or Register  to view this content.

confirmed with normal ENTER only.

Since you seem to be use exactly the same template, then give this a try:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER not just ENTER.

If this doesn't work, please start a new thread with a link to this thread if needed.