Screener for Stock Market

Selecting Robust Businesses

The main objective of this post is to provide a practical, time-efficient method to filter thousands of listed stocks down to a manageable list of high-quality companies for trading.

The key takeaways from the sources are as follows:

1. The Challenge of Scale

There are between 1,500 to 2,000 companies listed on the NSE and approximately 5,000 on the BSE. It is not practically possible for a trader to track the financial results or news for every single company. Instead, the goal is to filter these down to a “trackable” list of 130 to 160 companies to which technical chart patterns and strategies can then be applied.

The source recommends using Screener.in as the most effective tool for accessing financial information. While a paid version exists, the session highlights that the free version is sufficient for creating custom screens and identifying top-tier companies.

3. Five Essential Filtering Criteria

To identify “great companies,” the session outlines five specific financial metrics to enter into the query builder:

  • Debt to Equity Ratio < 0.25: This ensures that the company’s debt is no more than 25% of the shareholders’ equity.
  • Return on Capital Employed (ROCE) > 20%: This identifies companies that are highly efficient at generating profits from their capital.
  • Net Profit > 200 (Crores): This filters for established companies with a significant profit baseline.
  • Public Holding < 30%: A very high public holding can sometimes be a cause for concern; keeping this under 30% helps filter for stronger ownership structures.
  • Pledging Percentage < 10%: This ensures that the promoters have not pledged an excessive amount of their shares.

Running this query typically results in a list of about 128 high-quality companies, including well-known names like TCS, HUL, and ITC.

4. Accounting for Banks and NBFCs

The criteria mentioned above (specifically ROCE > 20%) often exclude banking and NBFC (Non-Banking Financial Company) stocks because their business models naturally result in lower ROCE. To complete your list, you should manually add:

  • The top 10 banks by market capitalization.
  • The top 20 NBFCs by market capitalization.

This brings the total watch-list to approximately 158 companies.

5. Practical Data Management

  • Manual Export: Since the “Export to Excel” button is a paid feature, you can copy the data directly from the screen and paste it into an Excel file to create your own master list.
  • Watch-lists: Once identified, these companies should be added to a TradingView watch-list for regular monitoring. Note that the free version of TradingView has limits on the number of watch-lists, which may require specific workarounds.

Analogy for Understanding: Think of the stock market like a massive ocean with thousands of fish. You cannot catch them all, and many are not worth your time. The Screener query acts like a specialized net with specific mesh sizes: it lets the small, debt-ridden, or unprofitable fish swim away, leaving you with only the “prize catches.” Because some valuable species (like banks) don’t fit the standard net, you simply go back with a smaller hand-net to pick the very best of them individually.