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 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.
Created Axys and Excel macros to import Axys asset holdings into an Excel trading template for portfolio rebalancing.
Created Excel worksheets automation via VBA and macros to pull Charles River portfolio data and summarize data to client specifications.
Thursday, July 15, 2010 at 12:20PM Share Article Email Article in Excel Automation, Portfolio Aggregation 
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.
Thursday, July 15, 2010 at 1:16AM Share Article Email Article in Custom Reporting, Data Extraction, Excel Automation 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 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.
