Portfolio Performance Monitoring 1.0 - User Guide and FAQ

Frequently Asked Questions - Portfolio Performance Monitoring

1. Why can't I see all of the cell formulas?
   The worksheets are protected to ensure the robustness of operation. However, critical formulas are outlined in the embedded help prompts.
   
   
2. When I open the file, it asks me if I want to enable macros. What should I do?
   You need to click "Yes" to accept macros in order to run the tools.
   
   
3. When I open the file, it doesn't ask me if I want to enable macros. Therefore, the macros are disabled. What should I do?
   In this case you need to set your macro security settings to Medium. You can do this by opening a blank workbook and choosing Tools >> Options >> Security >> Macro Security, and selecting the Medium level. You should now be presented with the option to enable macros on opening the template file.
   
   
4. Why can't I see the VBA code?
   The VBA code has been protected to ensure the robustness of operation and for intellectual property purposes.
   
   
5. Can other users open the models that I have completed?
   When other users open the model for the first time on another computer, they are presented with the 30-day trial version. After 30 days, if they have not registered the model, they will still be able to view completed models, but not run processes. In this way, the templates can be freely distributed to clients and/or interested parties to view results.
   
   
6. When should I "Roll Over" my portfolio model?
   The model can be "rolled over" to a new reporting period at any time. Usually this is on an annual basis; however some users choose to report periodic portfolio performance more frequently.
   
   
7. I "Rolled Over" my portfolio, and all of my transactions disappeared. What's going on?
   When you "roll over" your portfolio, all transactions are cleared out and appended to the History sheet in order to record transactions for the new reporting period.
   
   
8. The "Net Return Over the Period" for one of my investments look wrong in the Performance sheet, compared to the start and end values. Why is this?
   The "Net Return Over the Period" calculation takes into account of distributions, incremental investments, and divestments made during the reporting period; thereby adjusting the straight return calculation accordingly.