Spreadsheet: 770290d1645979502-drawdown-calc-within-a-sequence-my-drawdown-calc
Sheet: Sheet1

Day | Date | Trade Count | P&L | Weekly P&L | Drawdown | [NAME] for each sequence | Number of trades within each sequence
 | 2022-01-24 00:00:00 | 1 | -310
 |  | 1 | -310
 |  | 1 | -310
 |  | 1 | -310
 | 2022-01-24 00:00:00 | 2 | 0
 | 2022-01-24 00:00:00 | 3 | 120
 |  | 3 | 150
 |  | 3 | 250
 |  | 3 | 0
 | 2022-01-24 00:00:00 | 4 | 120
 |  | 4 | 150
 |  | 4 | 250
 |  | 4 | 300
 | 2022-01-24 00:00:00 | 5 | 120
 |  | 5 | 150
 |  | 5 | 250
 |  | 5 | 300
 | 2022-01-24 00:00:00 | 6 | 120
 |  | 6 | 150
 |  | 6 | 250
 |  | 6 | 0
 | 2022-01-24 00:00:00 | 7 | 120
 |  | 7 | 150
 |  | 7 | 250
 |  | 7 | 0
 | 2022-01-24 00:00:00 | 8 | 120
 |  | 8 | 150
 |  | 8 | 250
 |  | 8 | 0
 | 2022-01-24 00:00:00 | 9 | 120
 |  | 9 | 150
 |  | 9 | 250
 |  | 9 | 0
 | 2022-01-24 00:00:00 | 10 | 0
 | 2022-01-24 00:00:00 | 11 | -646
 | 2022-01-25 00:00:00 | 12 | 120
 |  | 12 | -255.4999999999973
 |  | 12 | -255.4999999999973
 |  | 12 | 0
 | 2022-01-25 00:00:00 | 13 | -117
 | 2022-01-25 00:00:00 | 14 | 120
 |  | 14 | 150
 |  | 14 | -194.0000000000009
 |  | 14 | 0
 | 2022-01-25 00:00:00 | 15 | 600
 | 2022-01-25 00:00:00 | 16 | 120
 |  | 16 | 150
 |  | 16 | -310
 |  | 16 | 0
 | 2022-01-25 00:00:00 | 17 | 0
 | 2022-01-25 00:00:00 | 18 | 120
 |  | 18 | 150
 |  | 18 | 250
 |  | 18 | 0
 | 2022-01-25 00:00:00 | 19 | 120
 |  | 19 | -175
 |  | 19 | -175
 |  | 19 | 0
 | 2022-01-25 00:00:00 | 20 | 0
 | 2022-01-25 00:00:00 | 21 | -646
 | 2022-01-26 00:00:00 | 22 | 600
 | 2022-01-26 00:00:00 | 23 | 120
 |  | 23 | 150
 |  | 23 | 250
 |  | 23 | 300
 | 2022-01-26 00:00:00 | 24 | 120
 |  | 24 | 150
 |  | 24 | 250
 |  | 24 | 0
 | 2022-01-26 00:00:00 | 25 | 120
 |  | 25 | 150
 |  | 25 | 250
 |  | 25 | 0
 | 2022-01-26 00:00:00 | 26 | -310
 |  | 26 | -310
 |  | 26 | -310
 |  | 27 | -310
 | 2022-01-26 00:00:00 | 27 | 120
 |  | 27 | 150
 |  | 27 | -310
 |  | 28 | 0
 | 2022-01-26 00:00:00 | 29 | 0
 | 2022-01-26 00:00:00 | 30 | 120
 |  | 30 | 150
 |  | 30 | 250
 |  | 30 | 0
 | 2022-01-26 00:00:00 | 31 | 600
 | 2022-01-26 00:00:00 | 32 | 600
 | 2022-01-26 00:00:00 | 33 | 120
 |  | 33 | 150
 |  | 33 | 250
 |  | 33 | 300
 | 2022-01-26 00:00:00 | 34 | 120
 |  | 34 | 150
 |  | 34 | 250
 |  | 34 | 300
 | 2022-01-26 00:00:00 | 35 | 600
 | 2022-01-26 00:00:00 | 36 | 0
 | 2022-01-26 00:00:00 | 37 | 600
 | 2022-01-27 00:00:00 | 38 | -790
 | 2022-01-27 00:00:00 | 39 | -651
 | 2022-01-27 00:00:00 | 40 | 120
 |  | 40 | 150
 |  | 40 | 250
 |  | 40 | 300
 | 2022-01-27 00:00:00 | 41 | 120
 |  | 41 | -310
 |  | 41 | -310
 |  | 41 | 0
 | 2022-01-27 00:00:00 | 42 | 0
 | 2022-01-27 00:00:00 | 43 | 0
 | 2022-01-27 00:00:00 | 44 | -651
 | 2022-01-28 00:00:00 | 45 | -772
 | 2022-01-28 00:00:00 | 46 | -310
 |  | 46 | -310
 |  | 46 | -310
 |  | 46 | -310
 | 2022-01-28 00:00:00 | 47 | 600
 | 2022-01-28 00:00:00 | 48 | 120
 |  | 48 | 150
 |  | 48 | 250
 |  | 48 | 0
 | 2022-01-28 00:00:00 | 49 | 120
 |  | 49 | 150
 |  | 49 | 250
 |  | 49 | 0
 | 2022-01-28 00:00:00 | 50 | 120
 |  | 50 | 150
 |  | 50 | 250
 |  | 50 | 300
 | 2022-01-28 00:00:00 | 51 | 0
 | 2022-01-28 00:00:00 | 52 | 600
 | 2022-01-28 00:00:00 | 53 | 120
 |  | 53 | 150
 |  | 53 | -310
 |  | 53 | 0
 | 2022-01-28 00:00:00 | 54 | 600
 | 2022-01-28 00:00:00 | 55 | 600
 | 2022-01-28 00:00:00 | 56 | 0
 | 2022-01-28 00:00:00 | 57 | -651
 | 2022-01-28 00:00:00 | 58 | -310
 |  | 58 | -310
 |  | 58 | -310
 |  | 58 | -310
 | 2022-01-28 00:00:00 | 59 | 0
 | 2022-01-28 00:00:00 | 60 | 120
 |  | 60 | 150
 |  | 60 | 250
 |  | 60 | 0
 | 2022-01-31 00:00:00 | 1 | -194 |  |  |  | 1
 | 2022-01-31 00:00:00 | 2 | 120
 |  | 2 | 150
 |  | 2 | -103.5000000000036
 |  | 2 | 0
 | 2022-01-31 00:00:00 | 3 | -821
 | 2022-01-31 00:00:00 | 4 | 600
 | 2022-01-31 00:00:00 | 5 | 600
 | 2022-01-31 00:00:00 | 6 | 120
 |  | 6 | 150
 |  | 6 | 250
 |  | 6 | 0
 | 2022-01-31 00:00:00 | 7 | 120
 |  | 7 | 150
 |  | 7 | 250
 |  | 7 | 300
 | 2022-01-31 00:00:00 | 8 | 120
 |  | 8 | 150
 |  | 8 | 250
 |  | 8 | 0
 | 2022-01-31 00:00:00 | 9 | -310
 |  | 9 | -310
 |  | 9 | -310
 |  | 9 | -310
 | 2022-02-01 00:00:00 | 10 | 120
 |  | 10 | 150
 |  | 10 | 250
 |  | 10 | 0
 | 2022-02-01 00:00:00 | 11 | -310
 |  | 11 | -310
 |  | 11 | -310
 |  | 11 | -310
 | 2022-02-01 00:00:00 | 12 | 600
 | 2022-02-01 00:00:00 | 13 | -310
 |  | 13 | -310
 |  | 13 | -310
 |  | 13 | -310
 | 2022-02-01 00:00:00 | 14 | 0
 | 2022-02-01 00:00:00 | 15 | -651
 | 2022-02-01 00:00:00 | 16 | 120
 |  | 16 | 150
 |  | 16 | 250
 |  | 16 | 0
 | 2022-02-02 00:00:00 | 17 | 120
 |  | 17 | 150
 |  | 17 | 250
 |  | 17 | 300
 | 2022-02-02 00:00:00 | 18 | 120
 |  | 18 | 150
 |  | 18 | -113.5000000000036
 |  | 18 | 0
 | 2022-02-02 00:00:00 | 19 | -721
 | 2022-02-02 00:00:00 | 20 | -651
 | 2022-02-02 00:00:00 | 21 | 0
 | 2022-02-02 00:00:00 | 22 | 600
 | 2022-02-03 00:00:00 | 23 | -153
 | 2022-02-03 00:00:00 | 24 | 120
 |  | 24 | 150
 |  | 24 | -188.5000000000036
 |  | 24 | 0
 | 2022-02-03 00:00:00 | 25 | 600
 | 2022-02-03 00:00:00 | 26 | 120
 |  | 26 | 150
 |  | 26 | 250
 |  | 26 | 300
 | 2022-02-03 00:00:00 | 27 | -310
 |  | 27 | -310
 |  | 27 | -310
 |  | 27 | -310
 | 2022-02-03 00:00:00 | 28 | 0
 | 2022-02-03 00:00:00 | 29 | 120
 |  | 29 | -310
 |  | 29 | -310
 |  | 29 | 0
 | 2022-02-03 00:00:00 | 30 | 0
 | 2022-02-03 00:00:00 | 31 | 600
 | 2022-02-03 00:00:00 | 32 | -208.4999999999945
 |  | 32 | -208.4999999999945
 |  | 32 | -208.4999999999945
 |  | 32 | -208.4999999999945
 | 2022-02-03 00:00:00 | 33 | 0
 | 2022-02-03 00:00:00 | 34 | 120
 |  | 34 | 150
 |  | 34 | 250
 |  | 34 | 0
 | 2022-02-03 00:00:00 | 35 | 120
 |  | 35 | 150
 |  | 35 | 250
 |  | 35 | 300
 | 2022-02-03 00:00:00 | 35 | 120
 |  | 35 | 150
 |  | 35 | 250
 |  | 35 | 300
 | 2022-02-04 00:00:00 | 36 | -767
 | 2022-02-04 00:00:00 | 37 | 120
 |  | 37 | 150
 |  | 37 | 250
 |  | 37 | 0
 | 2022-02-04 00:00:00 | 38 | 120
 |  | 38 | 150
 |  | 38 | 250
 |  | 38 | 300
 | 2022-02-04 00:00:00 | 39 | -310
 |  | 39 | -310
 |  | 39 | -310
 |  | 39 | -310
 | 2022-02-04 00:00:00 | 40 | 120
 |  | 40 | 150
 |  | 40 | 250
 |  | 40 | 0
 |  | 41 | -164
 |  | 42 | 600
 | 2022-02-04 00:00:00 | 43 | -310
 |  | 43 | -310
 |  | 43 | -310
 |  | 43 | -310
 |  | 44 | -164