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.

Entries in Crystal Reports (2)


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 Management Reporting Module

Our performance management module pulls data from Axys, and APX.  This module allows clients to generate informative reports that detail the select time period performance of indices and accounts in ways that would be difficult to do in Axys and APX. The reports break down asset class returns, and can be sorted and filtered based on total assets under management per relationship. Given this flexibility, the reports are frequently used by top level managers to review performance of investment managers. They can also be used by investment managers, and operations staff for quality control purposes.