How to Build a Stock Screener

Here is a step by step guide to build a stock screener and identify financially sound and good business.  This is a guest post by Indraneal Balasubramanian, a passionate equity enthusiast who blogs at cognicraftingIndraneal needs no introduction to Facebook group Asan Ideas for Wealth regulars.

The following can be thought as a sequel to Krishna Kishore's guest post explaining the features of screener.in

and as a guide to the Freefincal Excel Stock Screener

~~~~~~~~~~~~~~~~~

Information is a double-edged sword when it comes to investment in stocks. Investors are constantly bombarded with information about stock prices, macroeconomic data, news, which in turn could lead to suboptimal decision-making because people are more worried about the scoreboard than the field of play, which is the characteristics and performance of the business.

However, on the flipside, the internet and technology have also made it a lot easier to screen stocks and get historical as well as current information on the businesses they represent. Since when you buy the stock of a company, you are in fact buying a claim on current and all future earnings of the business, so long as you hold the shares of that company.

In order to construct a stock screen, the first step would be to think about what some basic characteristics of a financially sound, good business are. I created a mind map to help me think about this (click to enlarge).

guide-to-stock-screener-1
Figure 1: Thinking about what to look for

This is not a comprehensive list by any means, but I think it is a decent place to start. I’ve categorized what I want to look for into 4 basic categories – Hygiene factors in Financials, Business Performance, Efficient use of capital and Reasonable valuation.

Hygiene Factors

Charlie Munger has often said, “Tell me where I'm going to die, that is, so I don't go there”. Hygiene factors are aspects of the financials that are red flags and should be used to weed out potential sources of trouble.

Low Debt: Companies get into trouble when they take on leverage due to high interest expenses which have to be paid out before the bottom line. In crunch times, debt holders will still expect to be paid which means less money flows to the bottom line.

  • Debt to Equity Ratio: It indicates the capital structure of the company and is typically calculated using – Total Liabilities / Shareholder Equity. Less than 1 is ideal, though I like to take a value lower than 0.5 for safety’s sake.
  • Interest Coverage Ratio: Indicates the ability of the company to service its interest commitments on debt. Calculated as EBIT / Interest Expenses, and the higher the better. Look for minimum of 5-10.

Low Shareholder Pledging: Promoters can pledge their shareholding as collateral in order to secure financing. Typically a cover in terms of the share value to loan value is maintained, with a clause that if the value falls below a threshold, the promoter will have to pledge more shares to maintain the minimum cover. If the promoters are unable to unable to do so or fail to service the debt, they will need to sell pledged shares to pay off the debt. This could leave to severe corrections in the share price and hurt minority shareholders.

Overall Financial Risk

Altman Z score: It is a sort of credit strength test to measure the likelihood of bankruptcy. Look for a value above 3.

Piotroski score: A 9 point score based on 9 fundamental components. Use low scores to weed out companies. I typically look for a score of atleast 4 or better

Efficient use of Capital

The company’s management are not only there to operate the business, but are capital stewards who are supposed to use capital judiciously to enhance value. There are a lot of ways to check this, but these are the most common. Emphasis on rising or at least consistent values over 5 to 10 year periods.

  1. Return on Equity = Net Income / Average Shareholder Equity

In order to really understand the components of Return on Equity calculation, you should look at the DuPont model. I wrote about this in a Quora answer a while back

  1. Return on Capital Employed = EBIT / Total Capital Employed.

This is a way to determine how effectively the firm is using its capital to create value. There is some ambiguity about this because the definition of capital employed and hence the denominator may vary in certain calculations. Screener.in defines Capital Employed as Fixed Assets + Working Capital, which I think is a fair way to go about it. Total Assets – Current Liabilities is also used.

  1. Dividend Payout Ratio = Dividend per share / Earnings per share.

All things considered, I like firms paying dividends. Not only is the presence of a consistent dividend an indication that profits are real and not merely accounting gimmickry, but also a sign that the management is willing to payout cash that cannot be effectively used to grow the business rather than hoard it or use it in a less than efficient manner. I consider a minimum of 15%.

Business Performance

As far as businesses go, boring is better for investors. Warren Buffet’s wit is on offer in his 2001 Berkshire Hathway Shareholder letter as he quips – “I will tell you now that we have embraced the 21st century by entering such cutting-edge industries as brick, carpet, insulation and paint. Try to control your excitement”

Stable businesses in industries that don’t change a lot are less vulnerable to newcomers challenging their position or a shift in the inherent nature of the business. For example, I don’t know what a technology company might look like 10 or 20 years from now, but I can feel fairly sure the odds of a biscuit or toothpaste company not changing much are pretty good.

  • Margins: If margins are coming under pressure, it could indicate either higher input costs, increased competitiveness, while high, stable or rising margins relative to industry players could indicate competitive advantage.
  • Sales, Profits and Cashflows. Again, look for consistency and trends emerging over 3, 5 and 10 year periods.

Valuations

The form of valuation that I covered in the mind map is known as relative valuation, because it makes business parameters comparable through a form of standardization. There are dozens of ratios, but some of the commonly used ones are –

  • Price to Earnings: Typically, this is calculated as the Current Market Price / Trailing Twelve Month Earnings per Share (Add up last 4 quarterly EPS). It is often an expression of investor sentiment, as it reflects how much an investor is willing to pay for each rupee of earnings. Stable, well known businesses will command higher multiples as the market feels they are more predictable, which is why you will often see FMCG companies trading at higher P/E multiples to the rest.

A company with a high P/E is not necessarily expensive, contrary to common belief. Professor Sanjay Bakshi explained this beautifully in this article.

Warning: Cyclical stocks can look cheap on a P/E basis after a few growth years.  Do not be fooled!

  • PEG Ratio: First used by Peter Lynch, this is P/E Ratio divided by Annual EPS growth. Most screeners will use EPS growth last year, but I recommend calculating EPS growth over 5 and 10 year periods to determine whether the business is undervalued relative to its long term earnings growth.
  • Price to Free Cash flow. Arguably a better metric than P/E, because all things being equal, a firm with higher Free Cash Flows (Operating Cash flow – Capital Expenditure) is superior. 
  • Price to Book Value: Current Market Price / Book value per Share

This is typically used to value banks and capital intensive industries. I would check the value relative to the industry to determine potential overvaluation and undervaluation. Firms that employ lower amounts of fixed assets like consumer companies and software companies will typically show much higher average P/BV than others.

  1. Dividend Yield: People neglect dividend yield thinking that since they are only receiving say 1-2% of their invested amount as dividend, it should be neglected. However, over long periods of time, dividends can not only reduce the cost basis of shares to a negligible amount, if reinvested they can produce mind-boggling differences in results.

guide-to-stock-screener-2

 

Warning: Don’t be seduced by overly high dividend yields (often seen in commodity stocks). If share prices fall rapidly, it can push up dividend yields to unsustainable levels. Dividend yield should be looked at in conjunction with stable earnings growth and dividend payout ratios.

Putting it all Together in a Screener.

Now that we know what to look for, we can use a screening tool to help us identify stocks that meet criteria. I like using Screener.in because I find its interface very intuitive and versatile in customization options. Not only does it give you the option of writing your own custom screens, but there are also many user created screens for you to play around with.

Figure 2: A sample screener.in dashboard that can give you a snapshot of a company.
Figure 2: A sample screener.in dashboard that can give you a snapshot of a company.

If you like what you see, you can export the financials to excel (top right blue button) for further analysis, or add the stock to a watch list (green button)

Writing a sample screen. Click to enlarge
Writing a sample screen. Click to enlarge

If you need help on how to define the variables, click the “Show all variables button on the bottom” right.

guide-to-stock-screener-5
Figure 4: Results of the Screen

Concluding thoughts

After generating a screen and look at the financials, I typically look at downloading and reading the last 5 years Annual Reports to get more detailed information on the business. Key things to note are disclosures to financial statements as well as management commentary on strategy and future growth. Look for honesty above all else, I would rather that the management recognizes challenges and has a roadmap rather than present a uniformly rosy picture.

I hope this article gives you a basic idea on how to go about generating stock ideas through a screener. You do not have to rigidly follow the values I have taken either as there are many more permutations and combinations to what I have discussed, and I highly encourage you to experiment with the tool as well as the metrics involved.

~~~~~~~~~~~~~~~~~

Do join me in thanking Indraneal for a comprehensive guide to build a stock screener. Now that you know how to get a short-list of sound business, check out this automated stock analyzer to finalize your picks!

Install Financial Freedom App! (Google Play Store)

Install Freefincal Retirement Planner App! (Google Play Store)

book-footer

Buy our New Book!

You Can Be Rich With Goal-based Investing A book by  P V Subramanyam (subramoney.com) & M Pattabiraman. Hard bound. Price: Rs. 399/- and Kindle Rs. 349/-. Read more about the book and pre-order now!
Practical advice + calculators for you to develop personalised investment solutions

Thank you for reading. You may also like

About Freefincal

Freefincal has open-source, comprehensive Excel spreadsheets, tools, analysis and unbiased, conflict of interest-free commentary on different aspects of personal finance and investing. If you find the content useful, please consider supporting us by (1) sharing our articles and (2) disabling ad-blockers for our site if you are using one. We do not accept sponsored posts, links or guest posts request from content writers and agencies.

Blog Comment Policy

Your thoughts are vital to the health of this blog and are the driving force behind the analysis and calculators that you see here. We welcome criticism and differing opinions. I will do my very best to respond to all comments asap. Please do not include hyperlinks or email ids in the comment body. Such comments will be moderated and I reserve the right to delete  the entire comment or remove the links before approving them.

26 thoughts on “How to Build a Stock Screener

  1. abhishek

    I always wandered what to look for in screener.in.. This post is very useful for newbie like me. Simple yet effective. Thank you indraneal sir for writing and pattu sir for sharing it. 🙂

    Reply
  2. abhishek

    I always wandered what to look for in screener.in.. This post is very useful for newbie like me. Simple yet effective. Thank you indraneal sir for writing and pattu sir for sharing it. 🙂

    Reply
  3. rohit

    Hi Pattu

    You are doing a very great jop in providing so much infomation , guidance and analysis free of cost ,very thankfull for it

    I have a request , if you can also provide some way -where we can find out -like what mutual funds are buying /selling in a month- this information is available , but too scattered , did not get much clarity

    this information will help ,people like me who want to self invest , but know our limitations , but want to ride on mutual fund big ideas /picjs -like idfc investment in page in 2010 , motilal oswal taking big position in eicher in 2012 .....

    definately this approach has downfall means every pick of mutual fund manager is not a multibagger but it helps in reducing the universe of stocks to be picked and you can figure out the size of bet also which gives a insight of how much conviction they have with a particular stock

    thanks again

    regards
    rohit

    Reply
  4. rohit

    Hi Pattu

    You are doing a very great jop in providing so much infomation , guidance and analysis free of cost ,very thankfull for it

    I have a request , if you can also provide some way -where we can find out -like what mutual funds are buying /selling in a month- this information is available , but too scattered , did not get much clarity

    this information will help ,people like me who want to self invest , but know our limitations , but want to ride on mutual fund big ideas /picjs -like idfc investment in page in 2010 , motilal oswal taking big position in eicher in 2012 .....

    definately this approach has downfall means every pick of mutual fund manager is not a multibagger but it helps in reducing the universe of stocks to be picked and you can figure out the size of bet also which gives a insight of how much conviction they have with a particular stock

    thanks again

    regards
    rohit

    Reply
    1. Indraneal Balasubramanian

      It wasn't my intention to say that if you do this specifically you are guaranteed a "multibagger". The idea was more to get people thinking about a process that they could follow to identify a potential stock for investment, and do so using a few basic indicators that suggest good businesses to narrow down candidates. Obviously there is a lot more to it, but to cover every aspect of it a single post is neither possible nor the intention of this article.

      Reply
    1. Indraneal Balasubramanian

      It wasn't my intention to say that if you do this specifically you are guaranteed a "multibagger". The idea was more to get people thinking about a process that they could follow to identify a potential stock for investment, and do so using a few basic indicators that suggest good businesses to narrow down candidates. Obviously there is a lot more to it, but to cover every aspect of it a single post is neither possible nor the intention of this article.

      Reply
  5. Rajesh

    Thanks Pattu & Inderneel, stock picking could never be this easy!! Didn't even know such a thing existed though I always thought of having such a tool and infact was planning to code one!! You saved me few precious days 🙂

    Reply
  6. Rajesh

    Thanks Pattu & Inderneel, stock picking could never be this easy!! Didn't even know such a thing existed though I always thought of having such a tool and infact was planning to code one!! You saved me few precious days 🙂

    Reply
  7. Ravi Kiran

    Sir, nice write up. But would have been better if parameters for peg ratio n cash flow ratios were given . For ex peg < 1 is considerable etc.

    Reply

Do let us know what you think about the article