I need some help with a formula or function that can calculate the maximum draw down from a high water mark.
I have attached an extract from my sheet but it is very simple.
Column A is sequential dates
Column C is the daily profit/ loss
Column B is the accumulated overall P&L
So I'd like a formula that looks at the data as a whole (the series contains several years of daily data) and calculates the maximum pull back between new highs in column B.
If it's possible to also calculate the number of days that pullback took and also the subsequent recovery time to a new high water mark that would be amazing but I'd settle just for the Max draw down at this point!
Thanks in advance for any assistance. I'm using Office 365.
Bookmarks