I think excel is the best because everyone has different preferences for graphs and tables they want to see. All of the brokers I’ve used have very different portfolio tracking features that might not be useful to you.
I have mentioned it before, but I use Sharesight to track all my portfolios. It is really good for dividends because all data is input automatically as companies report divs. You can then run reports (income report and future income could be good for you) and import that data to excel if you want graphs like the ones you mentioned. But the good thing is that you don’t need to manually update (just add buy and sell transactions) and just run reports when you need.
edit: this is a paid service, but it definitely worth it for me. I tried a few services and there is nothing free that does the same thing.
I currently have my portfolio on Google Sheets. Could migrate it to excel in the future, but either way dividends remain the real headache. I’ve done a fair bit of digging on ways to try and automate the process and seen some XML methods which I can get to work for US stocks but which is hit-miss to the point of useless on UK stocks… but even if I do figure that out there’s still the question of what on earth to do with dividend-paying ETFs
I have it down to a tee if dividends are just totally excluded, which is fine if I’m looking to sell and switch on non-dividend stocks or low-yielding stocks that I feel have gone from undervalued to overvalued but isn’t really sustainable in the long term. Willing to manually track dividends as a last resort but am still searching around for a better option before I want to commit to doing it; the idea is I do the hard work up front and then can review at my leisure.
@freetrade any chance dividend payments could be added to the activity feed of each share in a portfolio? At the moment, you can see buys and sells, but it would be helpful if dividends appeared in there too to help keep track of dividend reinvestment, and to give a more accurate idea of how well that stock is performing.
Hope that makes sense. (Appreciate that the dividends appear in the general activity tab, but I’m talking about the recent activity section of each individual stock).
I use an app called stock events (the free version) although I may upgrade as its been so good. Has details about dividends, tells you what you have received month by month and what you can expect next year. I’ve been looking for such an app for a while and it ticks all of the boxes. Lots of charts to play around with and I keep finding additional options.
Do you know how many watchlist spots you get for a free account? I’ve downloaded Stock Events as I wish to try it and it says the pro version gives you unlimited watchlist spots but it’s frustrating that neither instructions within the app nor internet searches give you any indication of what a free account gives you.