Having A Look at DBS in Tableau

 Hope everybody's doing well!

I thought it would be fun to construct a heat map of DBS- this was a short piece of work in Tableau.

Firstly, the fundamental premise here is that we are using 3 years worth of DBS stock data- for simplicity's sake, I used the adjusted close price (to account for dividends) from Yahoo Finance on a monthly basis- 1st Jan, 1st Feb, 1st Mar and so on. The y-axis here is the month that the position in DBS was entered and the x-axis is the month where the position was exited. . Furthermore, I used CAGR as a benchmark to gauge the performance of the stock between the time of buying and the time of selling. Feel free to comment how I can improve my little analysis here!

As we can see here, entering a position of a longer duration generally outperforms shorter duration positions (more green than red). But interestingly, shorter duration positions also produce higher profits (green of higher intensity)- which does make sense too. Another observation is that entering in 2018 period will generally yield negative CAGR (red data).

Happy to hear from you!

OCBC Scrip Dividend Again

 It has been a long time since I posted, and virus numbers seem to be improving. Praying that this will persist. 

It is that time again of the year where it's scrip dividend news!

I had a look at my previous post where I wrote about the scrip dividend last year. Issue price was $9.57 and market price then was about $10.49 (~8.77% discount).

The stats for now is an issue price of $7.81 and market price is about $8.56 on Sep 4 closing (~8.76%). I wasn't very enthusiastic about the last scrip because I thought the price was rather high then. I will be entering for this as $7.81 is a pretty good price to accumulate (bearing in mind the 52-week low is $7.80).

How about you?