Label Replicator

Created label replicator to take labels from Axys client files, and add them to performance files.

Lock File Utility

Occasionally, Axys, or the workstation Axys is running on locks up while editing, or creating files. These unexpected exception result in the creation of lock files related to licenses and other data files. This program searches all directories in and below the Axys root directory to find lock files. Once the lock files have been found they can be selected, and deleted.

Mutual Fund Portfolio Analyzer

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.

Performance Plugger

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

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.

Price Tolerance Report

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%.

Price Wizard

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.

Quarterly Reporting Macros

Created a simple program to generate quarterly reporting scripts and macros in Axys. The scripts and macros generated create report packages that are collated based on last name independent of whether accounts are grouped, or individuals.

Report Style Management

Created program to manage report styles among multiple PCs. This program was created for Axys 1.0, and is no longer required for later versions of Axys.

xPort

The xPort utility exports all critical information from Axys (and APX) to comma separated format, and if requested xPort will build Microsoft Access tables that contain this data.