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.
Being able to see how your portfolio is performing with unrealized gains is one thing, but taking into account your earned dividends is something else. We’re focusing on passive income, so it makes sense to take a quick peek at how you’re doing with both the market and income generated thus far. My dividend tracker doesn’t do this just yet but update 0.9 changes the game.
I may have messed up the formulas that calculate all the values on the summary tab. This then provides incorrect figures that do not match up with what’s in your portfolio. After making a few edits to the spreadsheet dividend tracker with update 0.7, it seems as though Google automated some alterations to these working formulas and I didn’t spot them.
I’m still looking to add some small touches here and there to the dividend tracker. I originally planned this 0.7 update to be one that added a feature, but it’ll also be used as a means to roll out a fix to the UK template of the tracker.
This is a quick update for the dividend tracker, bringing the version up to 0.6. This release includes a quick fix for an error I made when calculating the dividend yield on cost of the stock. I made the mistake of incorrectly calculating this metric, which makes it all look messy.
Coming up in this dividend tracking spreadsheet update release, we’ll be updating the transactions tab to handle holdings in both GBP and GBX. For now, the spreadsheet isn’t smart enough to tell the difference between UK stocks in £ and p, but all that’s about to change.
It’s time for another quick update to the spreadsheet tracker. I’ve added more charts, because everyone loves to see data visualised. The goal with this tracker and dividend investing is to improve your life. A great way of aiding this is to have you spend as less time as possible gazing at this spreadsheet.
The dividend tracker is pretty good, but it’s not perfect. You may have spotted a version number on the data tab, which denotes which version of the tracking spreadsheet you’re rocking. I’ve made some substantial changes to the tracker, which allows us to move to version 0.3. Pretty awesome, right?
The dividend tracker I use on a daily basis was created from scratch, using the excellent spreadsheet from Investment Moats as inspiration. Whether you have a single portfolio or a few spread across different brokerages, this tracker will aid you in keeping everything logged with the ability to dive in and check out some graphs.