Hi there, I would be grateful for some help with maximum drawdown, spreadsheet attached.
Column A is a series of dates over the last three years
Column B is the values at the end of each month
Column C is the drawdown, (current value/max of all previous values)
I can establish what the low point is, but I am having a problem with the formulae showing when the drawdown started. For example, the low point was on 31/1/11 (row 21), but started on 31/8/10 (row 16), however the formulae is show the starting point as 31/11/09 (row 7), help would be appreciated with the formulae in F3