Compute Maximum Drawdown With Four Columns
Goal: a drawdown calculator you can paste any trade list into.
Layout. Column A holds each trade's result in R, starting in row 2. Row 1 holds headers.
Column B, cumulative result. In B2: =SUM($A$2:A2) and fill down. Column C, running peak, including a starting value of zero so a losing first trade counts as a drawdown. In C2: =MAX(0,MAX($B$2:B2)) and fill down. Column D, drawdown from peak: in D2: =B2-C2.
The maximum drawdown is the smallest value in column D. In a summary cell: =MIN(D2:D100).
Test with five trades: plus 1, minus 1, minus 1, plus 2, minus 1. Column B gives 1, 0, minus 1, 1, 0. Column C gives 1, 1, 1, 1, 1. Column D gives 0, minus 1, minus 2, 0, minus 1. The maximum drawdown is minus 2R.
Now test a start with a loss: minus 1, minus 1, plus 3. Column B: minus 1, minus 2, 1. Column C with the zero floor: 0, 0, 1. Column D: minus 1, minus 2, 0. The maximum drawdown is minus 2R. Without the zero floor, a first-trade loss would not register, a subtle error in many sheets.
To convert to percent at fixed risk, multiply by your risk per trade. At 1 percent, a 2R drawdown is about 2 percent.
Add a second summary: the longest losing streak, using a helper column that counts consecutive negatives.
Exercise: paste your last fifty trades and find your maximum drawdown in R.
Compute Maximum Drawdown With Four Columns
Compute Maximum Drawdown With Four Columns
It’s Fairman 
-
FXS Prop Desk
- Posts: 1689
- Joined: Wed Oct 07, 2026 9:52 am
Re: Compute Maximum Drawdown With Four Columns
Including zero in the running peak is the detail people miss, and without it a strategy that starts with losses shows no drawdown at all. One addition worth considering: a column for drawdown in percent of the account rather than R, since prop firms measure the daily and max loss limits that way.
FXS Official Team | The Idea Lab & Strategy
-
Amanhasnoname
- Posts: 2060
- Joined: Fri Oct 30, 2026 9:45 am
Re: Compute Maximum Drawdown With Four Columns
The zero floor in the running peak is the part that saved me from fooling myself. My first version of this sheet started the peak at the first trade, and a month that opened with three straight losers showed a tiny drawdown even though the account was clearly underwater from day one. Once I added the zero it matched what my broker statement showed.
I pasted in my last fifty trades as suggested and got a maximum drawdown of 6.4R, which was well above what I assumed from memory. It came from one afternoon where I revenge traded after a stop-out, and seeing it as a single ugly dip in column D made the habit hard to ignore.
The longest losing streak helper column was the next thing I added. Mine was seven, and that number now tells me when to stop for the day instead of guessing how bad it feels.
I pasted in my last fifty trades as suggested and got a maximum drawdown of 6.4R, which was well above what I assumed from memory. It came from one afternoon where I revenge traded after a stop-out, and seeing it as a single ugly dip in column D made the habit hard to ignore.
The longest losing streak helper column was the next thing I added. Mine was seven, and that number now tells me when to stop for the day instead of guessing how bad it feels.
Re: Compute Maximum Drawdown With Four Columns
Fair point, and it is an easy one to bolt on. Put the starting balance in a fixed cell, say H1, and add column E for equity: E2 is =$H$1+SUM($F$2:F2), where F is each trade's result in dollars rather than R. Column G is the running equity peak, =MAX($H$1,MAX($E$2:E2)), and the percent drawdown is =(E2-G2)/G2.FXS Prop Desk wrote:One addition worth considering: a column for drawdown in percent of the account rather than R, since prop firms measure the daily and max loss limits that way.
Worked example on a 100,000 account risking 0.5 percent, so 500 a trade. Four losers in a row is minus 2,000, which reads as minus 2 percent from peak. For a firm with a 5 percent daily limit that leaves room for six more losers that day, not ten, once you count commissions.
One catch: many firms use a static max loss from the starting balance, others trail it from the high-water mark. The sheet above is the trailing version. For static, swap G for $H$1.
@Amanhasnoname, a 7-loss streak at 0.5 percent is 3.5 percent, worth knowing before a daily cap does it for you.
It’s Fairman 