1. Friend of StocksCafe
I finally decided to subscribe to become a "friend" of StocksCafe and gave up on my attempt to track dividends manually on Excel spreadsheet which is causing too much grief over the years. Time to fall in along with modern times. It turns out that StocksCafe is extremely easy to use and allows one to keep many different portfolios. The dividends feature also ease the mammoth effort to track it manually as well as give a projected dividend forecast for the next 12 months in it.
While StocksCafe allows data import, I decided to take the easy way out for this migration and just key all equities at the high level by assigning an average cost as the first transaction for the respective purchases. So effectively from 1 January 2021, my profit and losses with dividends will...