Formula Underwater /Time to recovery Excel

[MasDimash]

Hello Guys,

I have some financial data of several portfolio and I am doing some calculations on. First i calculated the drawdown periods for each one, now I would like to calculate the maximum time that the serie get back positive from being negative. Some one call this time to recovery or Underwater Period! Let me know if you know it! Greetly appreciate if are normal formulas and not vba/macro.

thank you mates!

MasDimash

[DannyJ]

Hi MasDimash,

Welcome to the forums.

Does this thread help you.

http://www.excelforum.com/excel-gene...he-period.html

Regards

Danny

[MasDimash]

It was not what I was meaning, but I will post the solution in the next days! thank you!

Massimo

[Juan Ochoa]

Hi Masdimas:
Did you finally posted the solution to the underwater period?
If so, could you share it?
Thank you and best regards

[FDibbins]

Hi Masdimas:
Did you finally posted the solution to the underwater period?
If so, could you share it?
Thank you and best regards

This thread is almost 10 years old, I doubt it is still being followed. You would do better to start your own (new) thread for your question.