This work log details selected products, projects, experience and events we have participated in since we started working with investment advisors over twenty years ago. It is meant to be an informal, but informative accounting of what we do for our clients. Many of these solutions are still in use today. However, some have been replaced by solutions that we created later.
Created a program that allowed the creation of model portfolios using Visual Basic, Crystal Reports and FoxPro. This program created model portfolio reports that contained summary data information of fields selected from Principia. Additional fields such as up market, down market, and risk were created. Risk was calculated from the second level monthly returns data providing a meaningful risk figure.
Working from Advent's standard realized gain/loss report created a custom reports to lump like mutual funds, and breakdown short and long term gains. The de facto realized gain/loss reporting looks utterly ridiculous due to the frequent reinvestment of dividends. This report makes the realized gain/loss report look respectable.
We reapplied our modifications to the 3.7 version of the standard Axys report today.
Wednesday, November 11, 2009 at 12:29AM Share Article Email Article in Mutual Fund Reports, Realized Gain/Loss Created a combination of Axys scripts and macros to generate a report that details all occurances of negative interest accrued for quality control purposes. The first report in the macro identifies portfolios that contain negative interest accurued and creates a group. The second report in the macro creates a fixed income report for the portfolios in the group.
Wednesday, July 14, 2010 at 9:39PM Share Article Email Article in Data Quality, Fixed Income Reports Working from the standard Axys performance history report used Replang to create a custom report that omits cumulative performance columns making room for up to nine indices in landscape report format.
Our performance management module pulls data from Axys, and APX. This module allows clients to generate informative reports that detail the select time period performance of indices and accounts in ways that would be difficult to do in Axys and APX. The reports break down asset class returns, and can be sorted and filtered based on total assets under management per relationship. Given this flexibility, the reports are frequently used by top level managers to review performance of investment managers. They can also be used by investment managers, and operations staff for quality control purposes.
Cash returns have always been a problem in Axys. The nature of performance calculations made by Axys skew the cash performance values. In order to address this issue many clients that report cash performance returns are forced to manually plug returns. This program automatically plugs cash returns that are outside of a given range for a selected time period with a manually computed cash return figure. This program is typically run one period at time.
PQ, or Population Query, was designed to break a universe of Axys accounts into sub groups and products. Working off of custom labels, market values, and asset class percentages PQ allows users to define products. Once these products have been defined PQ actually creates the .CPG, .PBF, and .GRP files required to utilize Advent's composite reporting features.
Created custom price tolerance program for quality control purposes. The price tolerance program is run each day in an effort to identify Axys pricing issues. Working off a comfort zone this program generates a list of price that fall outside of the range -- i.e. 10%.
Created price wizard utility utilizing a combination of Axys scripts, and macros with Visual Basic to automate the daily pricing process at various clients sites. The purpose of the price wizard is to utilize available prices from interface price and position files thereby minimizing the cost of pricing via IDC.