Hello fellow valuebuddies
Recently I was trying to analyse some company fundamentals, and got a headache doing it. I guess looking at 1000 numbers on a page is not my cup of tea.
So I wrote a program to help me make some sense of the numbers. I am quite proud of it.
Not sure if there exists stocks screeners which do this.
I share with you the report for UMS Holdings. [
attachment=1010]
I now use it to help me scan through the fundamentals to raise red flags and yellow flags. Only then I start digging deeper if I am interested in the company.
Comments anyone?
Hi there shuoyanz,
This looks really good for an overview. Does it take a long time for you to compile the data individually, or is it automated.
Cheers!
theasiareport.com
(21-07-2014, 10:51 PM)shuoyanz Wrote: [ -> ]Hello fellow valuebuddies
Recently I was trying to analyse some company fundamentals, and got a headache doing it. I guess looking at 1000 numbers on a page is not my cup of tea.
So I wrote a program to help me make some sense of the numbers. I am quite proud of it. Not sure if there exists stocks screeners which do this.
I share with you the report for UMS Holdings.
I now use it to help me scan through the fundamentals to raise red flags and yellow flags. Only then I start digging deeper if I am interested in the company.
Comments anyone?
How do you determine the yellow flags?
Hello theasiareport
Thanks! I grabbed some data off online sources and calculated some automatically using the program. Takes 2-3 minutes per report.
Hello dxdx
The yellow flags are based off what I think I should look out for in a company. I does not mean the company is bad, but warrants a further investigation. Do you have another idea in mind?
Nice! can share the program?
(22-07-2014, 11:52 AM)shuoyanz Wrote: [ -> ]Hello theasiareport
Thanks! I grabbed some data off online sources and calculated some automatically using the program. Takes 2-3 minutes per report.
Hello dxdx
The yellow flags are based off what I think I should look out for in a company. I does not mean the company is bad, but warrants a further investigation. Do you have another idea in mind?
very nice.
what software do you use?
i currently use excel
(22-07-2014, 11:52 AM)shuoyanz Wrote: [ -> ]Hello theasiareport
Thanks! I grabbed some data off online sources and calculated some automatically using the program. Takes 2-3 minutes per report.
Hello dxdx
The yellow flags are based off what I think I should look out for in a company. I does not mean the company is bad, but warrants a further investigation. Do you have another idea in mind?
Really good stuff. I recommend checking out the Altman Z Score and the Beneish M Score. I am sure you can calculate it easily with the financial data you have.
They are the most commonly used ratios for detecting red flags.
Hi shuoyanz,
Great piece of tool !
But...................there are limitations..........
To really appreciate or demostrate its limitations - try changing your input data for UMS Holdings to only 4 years - from 2010 to 2013 inclusive - and see how different the outputs are compare to what you have got !
Also, on dividend payout, it was
FY2010 = SGD 5.00 cents
FY2011 = SGD 6.00 cents
FY2012 = SGD 5.00 cents
FY2013 = SGD 6.50 cents
where do you get the data from?
(22-07-2014, 10:44 PM)Boon Wrote: [ -> ]Hi shuoyanz,
Great piece of tool !
But...................there are limitations..........
To really appreciate or demostrate its limitations - try changing your input data for UMS Holdings to only 4 years - from 2010 to 2013 inclusive - and see how different the outputs are compare to what you have got !
Also, on dividend payout, it was
FY2010 = SGD 5.00 cents
FY2011 = SGD 6.00 cents
FY2012 = SGD 5.00 cents
FY2013 = SGD 6.50 cents
Hi Boon
Indeed, the figures will change if you change your timespan. I chose 10 years data so that one-off events, or a bad year like 2009 will not skew the figures too much.
Argh, thanks for pointing out, let me fix the dividend figures.
Hi theasiareport
Good idea, I will look into them. Thanks!
Hi wahkao
Some data comes from Morningstar, some data comes from Yahoo Finance, some is calculated by me.