It’s midway through July and here I am typing out my Q2 2017 Portfolio Update. I have the necessary data but I was too lazy to slice and dice the data and organize it into a coherent post. Guess I’ll be doing it today.

I’m using Kyith’s Stock Portfolio Tracker and dividends received are presented in a yearly format. In my last quarter update, I had to manually slice and dice the data in order to present the same information in a quarterly format. I spent yesterday night writing a R script to automate that process. Now quarterly updates will be that much more simpler.

Here are the outputs of my R scripts (history of dividends received by Year/Quarter in SGD and USD, respectively):

Moving forward, I foresee a huge drop in the dividends received. I did some thinking in end April/early May as to how I would react …