Hello all, first time on this board
I have this draw down calculation which works out the draw down based on numeric values stored in column E, SPY Close
=MIN(0,(E34-MAX($E$2:E34))/MAX($E$2:E34))
This will calculate the maximum draw down based on the SPY close (Column E) values...... (non % values)
I now want to do this same result with a % series of numbers.
I have attached a screen shot to show what I am trying to achieve:
https://2.bp.blogspot.com/-6RrCOaPpW.../image%2B1.png
This shows in a chart, the out put of the current formula: =MIN(0,(E34-MAX($E$2:E34))/MAX($E$2:E34))
I just need to do the same with the BE, Cumulative % return column.
Really appreciate any insight into this one!
Thanks!
Andrew
Bookmarks