Anybody who needs to calculate Time-Series data can use this tool, all you need is Excel.
PerTOOLS Financial Analysis for Excel is an extremely valuable tool for Excel that allows anyone to easily analyse time-series data automatically, with flexibility, speed and full user control.
You can choose from a range of over 60 functions each of which runs very quickly and can be called from a cell formula in exactly the same way you might use an Excel formula like =SUM() or =AVERAGE().
All functions refresh automatically when data is added, deleted or changed and you can easily use thousands of these functions in a single spreadsheet without experiencing speed issues.
All appropriate functions are supplied in both geometric and arithmetic versions so you can choose how to compound returns.
A comprehensive manual is also provided which contains full explanations of all functions together with all necessary mathematical formulae and examples.
An example spreadsheet is also provided which shows examples of all functions being used in practice.
Full VBA integration is available.
The functions have been written so that the user only needs to remember a minimum about how to use them. For example, the function =PT_Cum_Ret_
It can produce:
- A monthly output
- An output for the whole period
- An annualised output
The advantage is that the user doesn’t need to remember 3 different functions; he just needs to remember one. In this way, fewer functions can have many implementations.
All of the functions, manual and example spreadsheet are included for one price.
There are literally hundreds of uses for this product which include:
- Create custom statistics in Excel that update when new data is added
- Monitor peer-group performance
- Create custom functions of your own, easily
- Create custom reports branded with the company logo
- Create stats for presentations that update automatically when new data is added
- Integrate different data sources such as PerTrac, Reuters and Bloomberg
- Analyse third party data and compute statistics based on that data
- Speed up VBA development times by using these functions within VBA
- Use in conjunction with PerTOOLS Data Extractor for Excel to add a whole new dimension to your analysis of PerTrac data
Paul Darvell of PerTOOLS said, “This new comprehensive tool is a result of us responding to both the massive demand and the feedback from our clients. We have established ourselves as the specialists in Time-Series Analysis software and this new tool will strengthen our position as the leaders in this field. PerTOOLS Financial Analysis for Excel with over 60 formulae built-in caters to every need of the Financial Analyst when it comes to Time Series Analysis.
As with all our products, PerTOOLS Financial Analysis for Excel is available for a six-week free trial. It is hard to comprehend how beneficial these tools are and how much time you can save until you have actually tried them.
We have now consolidated PerTOOLS into two Products. These are designed to work either separately or together. When the two are used together it can add a whole new dimension to your financial analysis. For those that can benefit from both products we are now offering the two for one low price. For more information just visit our website www.pertools.com”
To find out more about the PerTOOLS products, free trials and special offers go to their website at www.pertools.com.
