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.

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

Axys Tax Lot Reconciliation

Created a program to reconcile tax lots held by Axys with tax lots held by custodian. Working with a file provided by the custodian this program successfully identifies exceptions, and corrects exceptions via automated trade blotter entries.

Axys Training

When a local company experienced 100% turnover in the portfolio accounting department. We trained their new staff immediately, and helped them maintain their Axys system during the retraining process. Though this is not our typical training engagement, we are available to train your staff as needed, and on short notice.

Axys Transaction Filter

Created the first transaction filter distributed to the Registered Investment Advisors of one of the largest custodian's in the United States. This transaction filter worked by creating a system of rules to include and exclude certain transactions using any combination of field criteria.