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.
http://files.gove.net/shares/files/11w/ammonshu/Automated_Appraisal_rpts_writeup_Ammon_Shumway.pdf
http://files.gove.net/shares/files/11w/ammonshu/Automated_Appraisal_Rpts.xlsm
No comments:
Post a Comment