Hi all!
I'm preparing a trading journal where I want to see my Maximum Drawdown % (Max DD%) based on the MOST RECENT CONSECUTIVE TRADES that I have lost (considering I risked 1% of the account on each trade). Therefore, If I took 5 trades with the following results: LWLLL, I would like to see on the Maximum Drawdown % Cell the -3% (from the most recent 3 lost trades) instead of -4% (considering total losses). The reason of doing this is because, if my setup provides 1:4 risk to reward ratio, the first loss (-1%) should be recovered with the second trade that was a Win so I should not be in a drawdown for the next trade after the loss.
Most important columns of the chart are highlighted on the chart in red: K2 and O column (DD%).
Other detail to know:
For the O1 column, I used the formula: =IF(M8<0, $M8/H$2,"") THEREFORE NO 0 OR POSITIVE VALUES WILL APPEAR on the cell.
Not sure if I'm asking for too much here but thanks in advance!
-Josean
I'm preparing a trading journal where I want to see my Maximum Drawdown % (Max DD%) based on the MOST RECENT CONSECUTIVE TRADES that I have lost (considering I risked 1% of the account on each trade). Therefore, If I took 5 trades with the following results: LWLLL, I would like to see on the Maximum Drawdown % Cell the -3% (from the most recent 3 lost trades) instead of -4% (considering total losses). The reason of doing this is because, if my setup provides 1:4 risk to reward ratio, the first loss (-1%) should be recovered with the second trade that was a Win so I should not be in a drawdown for the next trade after the loss.
Most important columns of the chart are highlighted on the chart in red: K2 and O column (DD%).
Other detail to know:
For the O1 column, I used the formula: =IF(M8<0, $M8/H$2,"") THEREFORE NO 0 OR POSITIVE VALUES WILL APPEAR on the cell.
Not sure if I'm asking for too much here but thanks in advance!
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |
| 1 | Total Trades | Total Wins | Total Losses | Break Even | Winning % | Losing % | BE % | Starting Balance | Total $ Gain | Total % Gain | Max DD % | Avg RRR | ||||
| 2 | 5 | 1 | 4 | 0 | 20% | 80% | 0% | $ 100,000.00 | $ - | 0.0% | -4.0% | 4 | ||||
| 3 | ||||||||||||||||
| 4 | # of Trades | PAIR/ASSET | NY Time | Date | Session | Stop Loss (Pips/Units) | Risk % Per Position | Risk $ Per Position | RRR (1:X) | Account Pips | Account Cash | % Gain/Loss | P&L | P&L% | DD % | Win/Loss |
| 5 | 1 | USDJPY | 12:05 AM | 04/04/22 | London | 10 | 1.0% | $ 1,000.00 | -1 | -10 | $ 99,000.00 | -1.0% | -1,000 | -1.0% | -1.0% | L |
| 6 | 2 | 04/05/22 | 10 | 1.0% | $ 1,000.00 | 4 | 40 | $ 103,000.00 | 3.0% | 4,000 | 4.0% | W | ||||
| 7 | 3 | 04/06/22 | 10 | 1.0% | $ 1,000.00 | -1 | -10 | $ 102,000.00 | 2.0% | -1,000 | -1.0% | -1.0% | L | |||
| 8 | 4 | 04/07/22 | 10 | 1.0% | $ 1,000.00 | -1 | -10 | $ 101,000.00 | 1.0% | -1,000 | -1.0% | -1.0% | L | |||
9 | 5 | 04/08/22 | 10 | 1.0% | $ 1,000.00 | -1 | -10 | $ 100,000.00 | 0.0% | -1,000 | -1.0% | -1.0% | L |
-Josean
