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 custom Axys report which computes the first standard deviation of a portfolio's returns over a period of time. The report then uses the first standard deviation to show risk relative to S&P, and other relevant indices.
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.
Wednesday, November 11, 2009 at 12:21AM Share Article Email Article in Tax Lot Reconciliation, Utilities 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.
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.
Created Axys and Excel macros to import Axys asset holdings into an Excel trading template for portfolio rebalancing.
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.
Wednesday, July 14, 2010 at 9:25PM Share Article Email Article in Data Quality, Fixed Income Reports Created a method of creating and updating labels containing current cash values to faciliate easier addition of cash to many reports using Axys reports, macros and scripts.
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 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.
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.