Source for accurate FA data

[galumay]

Hey all, I am fiddling around with screening along the lines that David Dreman describes in his book, "Contrarian Investing Stategies" and I am struggling to find accurate data.

Basically I want to select a universe of companies like the ASX500, and then screen for the 100 with the lowest p/e, or p/b or p/fcf or debt/equity or the 100 with the highest yield.

I found https://au.investing.com/stock-screener/ but the data is hopelessly out of date.

I want p/e based on eps from last AR and most recent sp.

I would prefer to be able to create an exportable portfolio so I can play with it in excel - and the site I linked does that well, just that the data is useless!

I dont mind if I have to pay, just want to know it works before I shell out!

 

[rnr]

Hey all, I am fiddling around with screening along the lines that David Dreman describes in his book, "Contrarian Investing Stategies" and I am struggling to find accurate data.

Basically I want to select a universe of companies like the ASX500, and then screen for the 100 with the lowest p/e, or p/b or p/fcf or debt/equity or the 100 with the highest yield.

I found https://au.investing.com/stock-screener/ but the data is hopelessly out of date.

I want p/e based on eps from last AR and most recent sp.

I would prefer to be able to create an exportable portfolio so I can play with it in excel - and the site I linked does that well, just that the data is useless!

I dont mind if I have to pay, just want to know it works before I shell out!

Robert Brain, who is associated with BullCharts, may be able to help out (link to some info below).

http://www.robertbrain.com/members-...05_scans-fundamentals-dividend-date_PAGE1.pdf

 

[galumay]

I should have mentioned I need the data OS agnostic, I dont run any Windoze hardware.

 

[galumay]

Robert Brain, who is associated with BullCharts, may be able to help out (link to some info below).

http://www.robertbrain.com/members-...05_scans-fundamentals-dividend-date_PAGE1.pdf

Thanks mate, looks windows specific, and honestly, anyone in business with such an awful website rather puts me off!

 

[galumay]

Looked at Morningstar, but again their p/e ratios are completely wrong so that wont work.

 

[galumay]

Looked at asxiq ....but date is even more out of date than the others! How hard can it really be??

 

[galumay]

Sharefilter.com - data incorrect.

 

[McLovin]

Sharefilter.com - data incorrect.

Are you sure the data is incorrect and not just adjusted?

 

[galumay]

Are you sure the data is incorrect and not just adjusted?

I guess its hard to know the difference! I just want the current ratio, so for p/e i want today's closing price/eps for most recent AR. I dont want the data 'adjusted' for undefined variables or historical points.

The thing is if I have no confidence in the accuracy of the simplest ratio like p/e it stops me having any confidence in the more complex ratios. So at this stage I am simply checking p/e of businesses where I already know the correct value. I think all the services I have looked at so far give different values for the same company!

 

[Quant]

I guess its hard to know the difference! I just want the current ratio, so for p/e i want today's closing price/eps for most recent AR. I dont want the data 'adjusted' for undefined variables or historical points.

The thing is if I have no confidence in the accuracy of the simplest ratio like p/e it stops me having any confidence in the more complex ratios. So at this stage I am simply checking p/e of businesses where I already know the correct value. I think all the services I have looked at so far give different values for the same company!

500 stocks is a lot but excel skills with a few minutes here and there data entry aint overly hard work and then you can be assured of accurate data . I go through this process with the stocks I follow . Hell I even do stats/charts on forward earnings revisions , there is a trend in price and trend in earnings projections , a lot can be gleaned from the spread between 1 & 2 years forward , I do concentrate on mature more predictable companies though ... good luck with it

 

[galumay]

500 stocks is a lot but excel skills with a few minutes here and there data entry aint overly hard work and then you can be assured of accurate data

Quant, you are right, but the problem is that filtering down to say 500 with capitalisation is easy, and to then filter for the lowest quintile of p/e is not too difficult - price is easy, most recent eps is time consuming for 500 companies though, and if I have to duplicate that for p/b and p/fcf its starts to be a pretty time consuming process - probably beyond my level of interest to be honest!

If I were certain it was a process that was going to lead to investments then it might be more compelling!

 

[craft]

Morning Star data from Dat Analysis Premium. (screen shot of a query I just downloaded)

As with any ratio unless you know how a vendor specifies the components you don't really know much about the output. P/E is very influenced by earnings determination and probably more importantly share count.

But you can draw out the raw data to your hearts content.

Takes a few seconds to cover the whole market and there are hundreds of data lines available.

As with all data bases - human error and interpretation rules can effect data quality but there is links to data source documents if you feel the need to verify something for yourself.

 

[Quant]

The data isn't hard to find but getting a data feed straight into excel is the bottleneck time wise , I personally think its worth the effort but you likely wont know until you've put in the effort . A lot of my research is fruitless but without the failures there would be no success , I need to know either way and the successes outweigh the failures exponentially . I think if someone does a complete job with excel formulas and complete accurate data sets there is actually some coin to be made selling it . Not my gig but may suit some . The possibilities are huge

 

[craft]

The attached file shows the data items available - search and query engine lets you basically explore anything you can dream up and drop resulting data into an excel file in a few seconds.

S&P capital IQ goes an extra step and allows you to drag data straight into your own excel models. Not sure if S&P database for Australia is their own or they white label another database.

I know the Morningstar database was originally the Aspect Huntley database - Morningstar brought them a while back for 30m. I guess given the costs to collect and verify there are probably only a couple at most original source databases around for a given country - most retail offerings will just be white labelled data, possibly with their own spin on ratio's and ways of analysing the data and no (easy) access to downloading the raw data itself. (limiting download access to 3rd parties of the raw data would be a part of the commercial agreement with the database owner)