Tuesday, September 29, 2020

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!

No comments:

Post a Comment

OCBC Dividend too

 Another choice to make here: OCBC is offering a cash or stock option. Similarly to Mapletree NAC, I think cash is the way to go for this ti...