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: Mario :-) who wrote (59945)	10/14/2017 2:59:00 PM
From: E_K_S	2 Recommendations Recommended By Mario :-) mike macklin Read Replies (2) \| Respond to of 78752

Look at the GN spreadsheet that I modified to calculate the GN value and discount to market price. The spreadsheet has two separate spreadsheet sections called (1) Data and the other (2) Set-Up. The Set-Up Sheet defines all the fields/labels and the Data sheet pulls out 59 data element using a http:download function and import data command. You can see the specific fields/location that the main spreadsheet uses. Sometimes the main spreadsheet delivers no result. That may be due to EPS estimate for Current Year is not available. There is a EPS estimate for Next Year field that could be also used (or in addition to current year) to signal EPS trend (higher vs lower). It is a bit more difficult to write a global script routine that test every symbol and then group results into those categories you listed. The interesting candidate companies would be in the small and mid cap (maybe Russell 1000) but many do not meet the positive EPS over last 10 years. The EPS analyst estimates are not always available in the Yahoo database. If you go to the NASDAQ database and search Research, Analysts Forecast it provides a good table of EPS and no. of analysts. Here is an example for CIO a REIT. You might be able to develop a script that picks this data element out. I find that NASDAQ database is much cleaner than Yahoo Finance but a bit more difficult to 'scrape' data from. That's how you learn by doing. I can remember entering the information by hand into my Visicalc spreadsheet software (before the Lotus-123 version). That beats doing the calculations by hand w/ pencil, paper and calculator. Good Investing EKS