<< Back to all Blogs
Login or Create your own free blog
Home > Screening for Stocks with Nested Conditional Statements in Excel

Screening for Stocks with Nested Conditional Statements in Excel

June 20th, 2012 at 02:07 pm

I should have read Amazon.com reviews of Peter D. Schiff's "The Real Crash" audiobook prior to attempting to listen to it. Out of the 2 of 5 discs I bothered to listen to, I got one independent clause of value, and that was a reiteration of the value I saw in _Crash Proof_.

That was to look for dividend-yielding global companies. I logged onto ValueLine and customized a screen for Foreign Stocks with Dividends higher than 3%.
I gathered short ratio and short float, target price, Price/sales ratio, current price from FinViz.com; Buy Price recommendations from Morningstar; IQ ratings from Standard and Poor. Tgt/Price is my custom formula for target price - current price, divided by the current price, or "upside potential, baby."

My conditional statement looks like this:
IF(AND(price<buy_at,Dividend>2.5,PriceSales<MEDIAN(PriceSales)),"buy", IF(AND(Return_on_Equity>15,IQ>90,tgt_price>0.3), "buy"))
leaving me currently with ArcelorMittal ADR (MT) and Total ADR (TOT).

0 Responses to “Screening for Stocks with Nested Conditional Statements in Excel”

Leave a Reply

(Note: If you were logged in, we could automatically fill in these fields for you.)
Will not be published.

* Please spell out the number 4.  [ Why? ]

vB Code: You can use these tags: [b] [i] [u] [url] [email]