The software is easily setup and simple to use. The two-step process is as follows:
a) Monthly account and benchmark performance data is loaded directly into a database from simple xls/csv templates. For Advent Axys® users, the data can be pulled directly by pointing to pbf (gross returns), prf(net returns) and dex(benchmark) files without the use of a database.
b) In the report input screen, the user selects the account/composite with the relevant benchmark and risk free rate, the “through date” and up to 6 periods (e.g. 1m, YTD, 36m, 60m, 120m, ITD) to run the risk measures. The user also must choose the Asset Class and Data Category (e.g. Total Net Return, Equity Gross Return).
Click Run Report and you’re done.
The software allows reporting of the following measures:
- Standard Deviation
- Tracking Error
- Information Ration
- Annualized and Cumulative Returns
- Correlation
- R-squared
- Sharpe Ratio
- Treynor Ration
- Alpha
- Beta
- Downside Deviation
- Annualized Downside Deviation
- Sortino Ratio
- Batting Average
- Up-and-Down Market Capture Ratios