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.

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

Bond Identification

Created a program to identify bonds that were originally longed in (LI'd) to Axys versus those bonds that have been sold or are still held.

Client Billing Systems

We have created several client billing solutions. Our first program was created in 1990.  These solutions vary from extremely simply modifications of standard Axys reports to stand alone applications that interface with Axys. Unfortunately, we have seen very few clients with identical billing requirements.  We have two fundemental solutions:

Our more complex billing solution is EZFee which extracts data from Axys/APX and creates client statements via Crystal Reports.  EZFee supports and reports on multiple billing parties.  It also does forward billing and back billing.  These reports are customized to look just like your Axys reports.  EZFee also creates a number of CSV data extracts, and/or reports detailing management information about billing including, custodian invoices, representative payout summaries, etc.

The simpler alternative is a one page compound report clearing detailing managed assets, billing calculations and which accounts are billed how much.

Correction of Upper and Lower Case Issues in Axys

Axys data was unreliable due to their inconsistent use of upper and lower case in filenames.  Though the client preferred to keep all files names in lowercase, at some point the case of a seemingly random group of files was changed to upper case. We created a program to rename upper case performance and client files back to lower case as required by the client.

Custom Interface for SEI

Created a custom data interface for SEI's point to point interface by utilizing the generic Axys interface, and creating the necessary transaction mappings for SEI.

Extract Reporting Module for Axys (ERMA)

ERMA creates a comprehensive account summary with tables, charts and graphs by collecting data from several Axys reports via a system of scripts, macros and custom reports. Once the data has been collected, reports are generated via Excel and Visual Basic. Reports that were previously created manually can be generated in seconds with ERMA.