SI
SI
discoversearch

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: Dave who wrote (24256)7/6/2006 10:19:17 PM
From: Marc Hyman  Read Replies (2) | Respond to of 78958
 
This talk of various stock screens has me wondering... what are people using for things like historical P/E, P/B, and other ratios? It's such a pain to look up and dig through old edgar filings to get such information. Has anyone found an easier way?

// marc



To: Dave who wrote (24256)7/7/2006 7:21:59 AM
From: bruwin  Respond to of 78958
 
Dave, I have two screening operations. The first is a stock screen (one of several), built up on a particular web site, incorporating financial ratio targets and one or two other criteria.
The web site searches 9000 to 10000 USA stocks for those that match my criteria, as best it can. The web site can go back to between 3 and 5 years, depending on the screen item.
However, most of my items are for current figures.

From this short list of between, say, 40 to 50 companies, further "pruning" is required because web site screening data doesn’t always give one exactly the financial ratio etc.., that one is looking for, so one has to get as close as possible with what’s available.

To narrow the list down even further, I import a company’s Income Statement and Balance Sheet directly from the web into my EXCEL spreadsheet for the second screening process. This contains a further screening mechanism which tells me whether a stock, SIMULTANEOUSLY, meets or exceeds ALL of my required criteria.

From those stocks that pass the test, I consider which are currently relatively cheap or expensive. Those that are currently on the cheap side are examined in terms of their possible greatest, medium term percentage price increase. The companies that top that list are the ones I would target.