Introducing my Dividend Stock Tracker
How it came about
It started off with a frustration that i had whenever i use my excel sheet to keep track of my dividend stocks and other not-so-good dividend stocks. The frustration was that whenever i see a stock that was sold down pretty badly, i had to find the stock price and key it into my excel sheet, then i need to find the current market cap so that my excel sheet would just compute.
I got abit frustrated about it, and at the same time i think its a good time to learn abit php and web programming by coming out with a little project.
So what is it
Dividend Stock Tracker tracks a list of dividend stocks that are listed on the SGX. They can be:
- Business Trusts
- REITs
- Utilities and Infrastructure stocks
- Telecommunication stocks
- Blue Chips
- Others
The prices of these stocks will be updated daily at the end of each day. The data will be recomputed and the new ratios and yields will be displayed.
Some of the fundamental data covered are:
- Operating Cashflow
- Dividend Yield
- PE and Earnings Yield
- Operating Cashflow Yield
- Price-to-book ratio
- EV/EBITDA
- Return Premium
- Debt/Asset
- % Payout
- % Cash holding of Assets
You may have observed that not all are displayed on the main table, thats because i can’t put everything into a small table.
Clicking on the name of each stock will display more detail information.
Moderating Dividend Payout
You would have notice that some of the yields are quite different from what brokerage houses display. This is because the yields are moderated by me. One time special dividends and dividends that seems unsustainable are moderated downwards so that it doesn’t give people an impression that if you buy now your yield will be that much.
So that is why Courage Marine’s payout is much less than what they paid out last year. I used an average payout for that.
Currency
For Stocks whose balance sheet data are in USD or RMB for example, i will use an exchange conversion. Most of the balance sheet data are thus like what they display in their annual report. E.g. Hongwei’s Total assets in this case is in RMB.
Balance Sheet Data
Balance Sheet Data are updated annually except for assets and debts which are updated quarterly.
Will I be adding more stocks to it?
Definitely, though i will need to control my addition since the more i add the more problematic i will be when updating these information annually and quarterly haha!
Conclusion
I hope its useful to you as an investor. You can access my dividend stock tracker by clicking on the link next to the home.
Take a look at the dividend tracker >>
If you enjoyed this post, please consider to leave a comment or subscribe to the feed and get future articles delivered to your feed reader.
Comments
thanks for the support. hope i can improve on it.
anyway if you guys have good dividend stocks to suggest i can put it up if i feel its right we monitor it.
best regards.
Hi Drizzit,
Just wondering, I know you’ve stated your dividend yield calculation is different, but I would like to find out more on how did you calculate M1.
When the price was 1.87, Div Yield was 7.8%, which means dividend was about 14.5 cents. I suppose this would be the April 08 + August 08 payout.
However, Payout Ratio was stated as 79%, which meant EPS is 18.4 cents.
1) How did you arrive at 18.4 cents? EPS for 1H08 was 8.8 cents, 4Q07 was 4.2 cents, 3Q07 was 4.9 cents. Total EPS I’ve calculated was 17.9 cents, which means payout ratio should be 81%.
Sorry to be so nitpicky though…heh. 
hi king meng! the dividend used is 14.6 cents, which is paid out in 2007 from SGX. that is less the capital reduction. i believe they should be able to pay out similarly this year. there is still time for one more massive payout.
as for the eps, i calculate abit differently. i actually did not calculate the eps but used 2007 net profit divide by market capitalisation. since no of shares outstanding would likely be different, it might explain the difference.
Hi Drizzit,
Your have a good informative website. I wonder where and how you got your information. I would also want to do something like yours myself.
Hope you can enlighten me.
Nice work there Drizzt! Unfortunately I’m still on excel