VBA : search and make difference between 2 dates

[M_Michael]

Hi guys,

Please open this file :

Fichier exemple.xlsm

I have a huge problem. According to my file, I need to calculate what is called the "time between dates" in my file with a VBA code.

There is already a VBA function who calculates well the maximum drawdown. The complement I want needs to add in my function must calculate : When the maximum drawdown was ( 12.03.2003), when he as finished ( 03.01.2006) and how many days long it was ( 1028 days).

Please...help me ! I must send this document to be assess on friday !

Thank you so much !

jack

[haripopuri]

Please Login or Register  to view this content.

[M_Michael]

Thank you for answering,

The dates are only in column A, the price are in the column B. Any idee ?

[haripopuri]

How to calculate Maximum drawdown's date & Recovery date?

[M_Michael]

Ahi,
Here's the an explanation of the maximum drawdown.

http://www.babypips.com/school/drawd...-drawdown.html

The recovery date stands for the time you have to wait from the maximum drawdown to the moment where you are one more time at your investment point.

If you see my file attached on the 1st post, it's easier to understand (there's also the VBA code in "modul 1")

[haripopuri]

Hi,

Intead of macros, you can do it in excel if you want.

[M_Michael]

I need to do it in VBA, it concerns a report I have to do for University.

[haripopuri]

Please check if attachment helps you.

[M_Michael]

It works, thank you ahi.

[haripopuri]

Glad I could help. If the reply resolved your query please update thread as 'solved'