How to calculate multiple maximum drawdowns in excel

Good day all

*

Is anyone able to assist with a formula that calculates multiple maximum drawdowns as the different peaks to troughs occur in a return series? I have found a formula to calculate the maximum drawdown for the entire series but would like to break it up and see the different drawdowns as they occur.

*

Additionally, are there also formulas to find the period of the drawdown and the number of days to recovery?

*

Feel free to edit the sheet as needed.

*

Col. B is the hypothetical fund returns, Col. C is is the cumulative growth factor; Col D. has formulas for the drawdowns and cell E3 is the maximum drawdown.

*

Best regards

Iaian