There is much debate regarding whether even the simplest of Max Drawdown calculations is really feasible in Excel. Even those who say it is possible would normally agree that it is very difficult. If you want to work out the maximum drawdown, time spent in a drawdown, peak date, trough date, time spent recovering and recovery date, that is a lot of effort, or at least it used to be...
PerTOOLS.com have just announced their latest release of PerTOOLS Financial Analysis for Excel with increased Max Drawdown and Maximum Run-up functionalities. With a single cell formula not unlike the simple =SUM() Excel formula you can now calculate all of the above-mentioned statistics.
The Maximum Run-Up functionality allows for simple calculation of the Run-up amount, valley date, peak date and the number of months spent in Run-up.
I asked Paul Darvell, the founder of PerTOOLS what the driver was behind these enhancements and he told me, “we have been delighted with the demand for PerTOOLS Financial Analysis for Excel. Since its recent launch, the feedback that we have received from our clients has been amazing. This new enhancement is a direct result of us listening to the needs of our users. After all, PerTOOLS was formed to create analysis tools FOR Financial Analysts that were designed BY Financial Analysts, so by listening to our clients we are simply continuing that tradition”.
There is a lot of other new functionality in this release but Maximum
Drawdown and Maximum Run-up are by far the most interesting!
The first is that it is easy to integrate both the Financial Analysis tool along with the Data Extractor into a single spreadsheet with no performance impact. This means that you can extract the raw data and do your analysis automatically and when the data in your database updates, so does your spreadsheet.
The second key point is their free trial policy. All PerTOOLS.com products can be tried free of charge.
Further information regarding this new release is available on the
PerTOOLS.com website.
