Hi all, I am looking for a formula for a single cell where the formula returns the maximum percentage drawdown for a given price series. Importantly the max price must be before the min price and the function must return the minimum value (maximum drawdown) for the entire series - not just the drawdown from the all time max price to the lowest price thereafter.
I had a functioning formula that followed the logic of min(if(row(price low)>row(price high), ((price low) - (price high))/(price high),"")) but it was returning the decline from the all time high to the low thereafter rather than the min of all drawdowns.
Cheers.
Bookmarks