General Topics
Markets
Technical Topics
Brokerage Firms
Company Specific
Community Lounge
Site Support

# Max DD Formula

Discussion in 'Strategy Building' started by Corso482, Oct 19, 2003.

1. ### Corso482

I'm trying to figure out the maximum draw down for my backtesting results In Excel.

I have a column with a running total of my account balance, i.e. my equity curve. How do I extrapolate the maximum draw down from that column? Thanks.

2. ### bdixon619

Couldn't you use the MIN function for the column? No wait just find the difference s from point to point and then use the MIN function on That column.

4. ### Mr Subliminal

If you don't have the trade by trade P&L but equity (account balance), you can also use this method :

Assume equity is in A1:An. In column B, let B1 equal +A1. Then in B2 enter =IF(A2>=B1,A2,B1) and copy this down to Bn. In column C, let C1 equal +A1-B1 and copy this down to Cn. The maximum drawdown (in dollar terms) is the minimum of column C, or =MIN(C1:Cn).

thank you

6. ### olintner

Hi Coros482,

please be aware that MDD is a path-dependent variable. That means if you reshuffle your trades, they will give you a need max draw down. Your average earnings don't vary through reshuffling because at the end of the day the earnings will show up...

If you only use closed-trades-pnl you also run the risk of running out of margin if a very bad opening or intra-day-move hits you. Given that many long-term-trend followers have an equity-margin ratio of up to 60% that's a real threat.