Custom Index Creation by Portfolio Mix

Created Axys customization that allows clients to map representative indexes to industry codes, and generate custom indexes using the specific asset values at the end of each month to determine what percentage of the representative indexes should be in the custom index.

13G Reporting via Bloomberg and Axys Automation

We created 13G worksheets that are utilized to track current investments and determine whether the percentage of shares owned by clients as a percentage of total shares outstanding are an issue.  To pull information from Axys and Bloomberg as needed to populate the worksheet we created User Defined Functions (UDFs).  The worksheets created update Axys data on demand, update Bloomberg data on demand and produce value and formatting snapshots of the worksheets on demand.

635 Report Modifications

Modifed Axys 635 report to customized select time periods, added N/As where applicable, and added section headers for asset classes versus indices via replang.

Advent Axys / APX to INDATA conversion

Assisted investment firm with conversion from Axys to INDATA using our xPort application and created additional data feeds in xPort specifically for Advent Axys & APX users converting to INDATA.

Built INDATA tables for fx, price, performance, portfolios, security master, client lot table, client portfolio holdings and composites.

Asset Class Report over Time Horizon

Created an Excel sheet which details Axys asset class exposure over a given time horizon. This Excel sheet assigns a numerical value for each time period and portfolio which allows operators to easily identify the asset class breakdown.

Auto-Affirmation Utility

Automated Reconciliation Processors

Created Axys customization to reconcile accounts automatically using Visual Basic. In most cases, accounts are reconciled automatically. In the first pass of the program accounts are automatically reconciled. Some accounts do require manual intervention though, and these accounts are reconciled in the second pass of the program.

Axys Beta/Testing Environment Switch

Created an icon on the taskbar to switch between the actual Axys environment and a testing environment.

Axys Company/Department Switch

Created a front end menu to allow our clients to easily switch between multiple sets of Axys files.

Axys Price and Index Update via Bloomberg and Excel Automation

We have created Excel worksheets to automate data pulls as needed from Bloomberg, and make calls to Axys from Excel VBA to post that information into Axys.