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 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.
Created custom report detailing all accounts and assets under management using Crystal Reports to connect to Qube's SQL database. This is just one example of the possibilities.
Wednesday, July 14, 2010 at 9:31PM Share Article Email Article in Crystal Reports, Moxy, Qube 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.
The Style Analysis Module (SAM) was created as an add-on exhibit to one of our first account summary reports. The SAM application allows users to categorize mutual funds within a five by five style matrix. Whenever the application is started it checks the Axys database of securities to see if any new funds have been added to Axys that need to be categorized within the style matrix. When SAM reports are generated representative boxes for each matrix cell with a value are created. These cells are filled with the funds held by a portfolio, color coded, and sized relative to the total holding of the matrix cell. Custom colors may be defined.
For many years, we have supported the system design and automation needs of firms running the backoffice for other firms.
As an example, one of the firms we work with manages the backoffice accounting for many firms using Axys. All of the firms they support own and maintain multi-user Axys licenses, but the company works from a central Axys database. Some Axys information files are shared, but most are not. Axys users can go into any of the companies they service by simply clicking the appropriate Axys shortcut for that company
Axys reports, macros, scripts, VB, and VBA automation have been designed to leverage centralized processing whenever possible, but allow decentralized processing so the the backoffice staff can work on a given company independently when they want to. DXData downloads, pricing, ACD downloads, and conversions have all been automated.
Wednesday, July 14, 2010 at 9:57PM Share Article Email Article in Backoffice, Reconciliation, Workflow Created a means of trading across consolidated families of accounts through the automated creation of consolidated relationship portfolios in Axys, and the use of those portfolios in earlier versions of Moxy.
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.