Silicon Investor (SI) -- The First Internet Community

STOCKTALK

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor. We ask that you disable ad blocking while on Silicon Investor in the best interests of our community. If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.

Strategies & Market Trends : Value Investing -- Ignore unavailable to you. Want to Upgrade?

To: E_K_S who wrote (59947)	10/14/2017 7:50:46 PM
From: William Cloutier	Read Replies (2) \| Respond to of 78753

Where the 22,5 comes from in the GN formula ? I guess it's a combo of the Earning multiple and the book value multiple, but why 22,5 and not 25 or 20 ? Can we take a 5 years earnings average ? Can we replace earnings by Sales and changing the multiple accordingly ? I'm not very confortable using any formula for investing and I prefer to look on all company, which is very very long, but it's helping me a lot in learning many things. Just curious WIll :)

To: E_K_S who wrote (59947)	10/15/2017 10:33:58 PM
From: Mario :-)	Read Replies (1) \| Respond to of 78753

E_K_S, thank you very much and sorry for late reply. Yes something strange is happening with Yahoo I always get proper price and book value, but not EPS. What is most troubling, error is not consistent. I re-ran script for tickers that got wrong EPS and the same error was not repeated. Like when washer machine is not working until service guy shows up then it is working, how do you troubleshot this... I ran script for LPX you have in the spreadsheet and EPS was pulled from estimate for next year (one field to the right) it was 1.94 instead of 2.13 and GN was of course a little bit off, 20.16 instead of 21,12. Thank you for the nasdaq suggestion, will try to figure it out how to scrape from it. And I will also need to learn better scrapping technique in general, I will get there, just takes some time... I already have pretty current (2016) list of tickers for Russel 2000, would that one work or they are too small cap? If so i will get me list for Russell 1000. The only thing is, with larger list of companies, there will be many more positive hits (especially after some market correction, after prices drop) and it would probably be a good idea to add some additional condition such as maybe debt you mentioned previously? Low debt requirements would make sense, companies with undervalued GN tend to be in some kind of trouble or distress and low debt condition would eliminate some of more troubling companies? I was looking at your modified spreadsheet but I didn't see any difference in calculating GN, formula seems to me to be the same as previously: GN = SQRT(22.5(BV * EPS), while BV and EPS are being pulled from Yahoo. Monday/Tuesday I will start working on the script again, it may take weeks before I have something better, i'm slow :-)))