Forum Discussion
hackfifi
Helper V
Helper VDAX Help to For Drawdown
Good Day I am trying to calculate the "Drawdown" row as per the below data table example. As you can see the TOTAL CUMATIVE Formula used gives the Cumulative by Year resulting in a value of $186 ...
I don't pretend to understand the definition of drawdown (despite having read the article multiple times) but here is a solution proposal.
hackfifiHelper V
Helper Vlbendlin - The expected result is the "Drawdown" row below
| ID | WIN STATUS | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 |
| P01 | NO WIN | $5 | $10 | ||||||||
| P02 | NO WIN | $5 | |||||||||
| P03 | NO WIN | $5 | $5 | ||||||||
| P04 | NO WIN | $5 | |||||||||
| P05 | NO WIN | $2 | $2 | ||||||||
| P06 | NO WIN | $3 | $3 | ||||||||
| P07 | NO WIN | $5 | $5 | ||||||||
| P08 | NO WIN | $5 | $5 | ||||||||
| P09 | NO WIN | $5 | $10 | ||||||||
| P10 | NO WIN | $5 | $10 | ||||||||
| P11 | NO WIN | $5 | |||||||||
| P12 | WIN | $10 | $5 | ||||||||
| P13 | NO WIN | $5 | $5 | ||||||||
| P14 | WIN | $5 | $5 | ||||||||
| P15 | NO WIN | $5 | $5 | ||||||||
| P16 | WIN | $6 | $10 | ||||||||
| P17 | NO WIN | $5 | $10 | ||||||||
| P18 | WIN | $10 |
| NO WIN | $5 | $25 | $15 | $5 | $20 | $40 | $20 | $5 | $0 | $0 |
| WIN | $0 | $0 | $0 | $16 | $10 | $0 | $15 | $10 | $0 | $0 |
| TOTAL CUMULATIVE | $5 | $30 | $45 | $66 | $96 | $136 | $171 | $186 | $186 | $186 |
| DRAWDOWN | $181 | $156 | $141 | $152 | $142 | $102 | $97 | $102 | $102 | $102 |
lbendlin
Super User
Super UserI don't pretend to understand the definition of drawdown (despite having read the article multiple times) but here is a solution proposal.