Advertisement IC Markets

Compute Maximum Drawdown With Four Columns

Document your personal trading journey. Track daily equity curves, review winning and losing streaks, share trade screenshots, and get constructive feedback.
Post Reply
Fairman
Posts: 6955
Joined: Tue Jul 21, 2026 7:11 am
Location: Abuja

Compute Maximum Drawdown With Four Columns

Post by Fairman »

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.
It’s Fairman :geek:
Recommended broker for automated trading & scalping IC Markets
FXS Prop Desk
Posts: 1689
Joined: Wed Oct 07, 2026 9:52 am

Re: Compute Maximum Drawdown With Four Columns

Post by FXS Prop Desk »

Fairman wrote: Column C, running peak, including a starting value of zero so a losing first trade counts as a drawdown.
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

Post by Amanhasnoname »

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.
Fairman
Posts: 6955
Joined: Tue Jul 21, 2026 7:11 am
Location: Abuja

Re: Compute Maximum Drawdown With Four Columns

Post by Fairman »

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.
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.

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 :geek:
Post Reply