FFN Dashboard on the Web!Hi all,
I promised a public dashboard for FFN investors. I've been working on it since late July and been testing it since August 1. So far, so good.
You can see it at https://dupli.ca/ffn Please send me your feedback, suggestions, questions, corrections.
IMPORTANT: This is still a work in progress. It is meant for educational purposes only.
Couple of things:
- Estimated NAV will likely not be "bang on" but should be within about 7 cents of the real number.
- Exchange rate is from openexchangerates.org and is automatically updated hourly during weekdays.
- Stock data for all stock is pulled automatically every 30 minutes from 9AM to 5PM on weekdays.
- Dividend amounts for all stocks are updated automatically and will be included in the “Dividends Receivables” at the right time. This will increase the value of the fund and the NAV at the same time.
- Shares outstanding for FFN and FFN.PR.A are also pulled automatically (those do not change very often).
- The official NAV before and NAV after distribution is updated automatically whenever Quadravest updates the data on the “fund feature” page.
- I use the official Quadravest weightings from the latest available quarter report. Those weightings are currently updated manually, each quarter, by looking at the “quarterly portfolio disclosure” PDF document or the semi-annual report, or the annual report.
- I try to make AS LITTLE adjustments to weightings between quarter reports as possible. I'll do it when the cash weighting changes and when we need to adjust the total CAN % vs USA %. The idea is to have this dashboard as automated as possible. If I change a weighting for a specific stock, it will show in red.
- The cash value is calculated using the % provided by Quadravest in their month-end “fund update” PDF document and is based on the $ value of the fund at the previous month-end. The cash value in $ will also recalculate (using the same % as the previous month-end) when Quadravest updates the NAV on the “fund feature” page (usually around the 15th of the month).
- When there is a holiday in one country but not the other, the dashboard will not be updated properly (I don't really think I'll spend time on this honestly).
- Keep using your own spreadsheets if you have because there’s no guarantee that I will be maintaining this forever