Having the spreadsheet dividend tracker calculate just how much weight you have in each of your stock holdings is handy to better diversify your portfolio. This is how it’s supposed to work, but that depends solely on me getting the formulae working to make it all happen. Unfortunately, I broke the said formulae in a recent update to the UK template.
The data tab holds most of the magic for the spreadsheet to work, including the stock diversity chart on the summary tab. I updated the spreadsheet recently to allow you to switch between GBX and GBP on the UK market tab, which created a new column.
I thought I updated everything, but alas it seems the UK template passed through without being altered. Thankfully, someone smarter than I managed to spot the issue and gave me a heads up. After fixing the formulae, the stock diversity chart will now correctly populate on the summary tab.
- Fixed incorrect formulae in the Data tab for the UK template. (Thanks, Mike for spotting the error!)
How do I update my tracker?
This is an easy update to apply to your UK template. Simply follow these steps:
- Change the top-most EU and US cells (
E14in the template) on the
- Change the top UK cell (
D14in the template) to
- Drag these new cells all the way down to copy the new formulae to each subsequent row.