These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Friday, April 15, 2011

Appraisal Reports

A young investment fund is changing its administration software to another platform that better tracks the portfolio’s performance. I originally thought that I would be extracting data and performing the performance analysis, but it turns out that we do not have adequate access to the necessary index weighting and return history to properly accomplish that. Luckily, the new software is able to do it if given the portfolio’s performance history.

The current account administration software is web-based. This project accesses the fund’s current performance history through this website and navigates the site’s menu, selects the proper report for each trading day since the fund’s initiation, formats the report in Excel, and saves the report. The reports will be imported to the new platform.

No comments:

Post a Comment

Blog Archive