One of the biggest challenges every investor faces is how to find companies that are worth investing? And the question is valid, there are more than 5,000 companies listed in the stock market, going through each of them to find a handful of investment worthy stocks is like finding needle in a haystack.
That is the reason why you need a filtration process to weed out all the poor quality stocks so that you get a list of only high quality ideas.
While there are many useful screening tools such as Capital Line, Ace Equity etc., but all these tools are very expensive and may not be as useful for an average investor. One of the most useful tools I have been using for the past many years for the same purpose is Screener.in.
In this post of how to use screener.in, we will learn how to use this free online tool to find the best stocks for long term investment.
Note: Before I begin explaining how to use screener.in for selecting good stocks, let me tell you this, researching stocks is beyond number crunching, screening tools simply give you details about past performance of the business, and does not say anything about the quality of business and its longevity. Relying solely on screening tools for your research is not a great investment strategy.
Screener.in is a free stock screening tool that can be used to find best stocks based on various fundamental factors. In this post we will learn how to use screener.in for basic screening of stocks.
Step 1: The first step in our tutorial of how to use screener.in is to create a free screener.in account by clicking on the Login button on the top right corner of the website. You will see a login page that will ask you for your login id and password, the page looks like this:

Step 2: When you click on the “register for free”, button, you will see a page asking for your email ID, and password. Simply enter the email ID and password and click “Register” button, that’s it! You have successfully created an account.

Once you have created a free account, it’s now time to filter stocks based on certain criteria. Screener.in has a feature called “Query builder” which can be used to enter various criteria for selecting stocks.
This is how a query box of screener.in looks like:

What is Query Builder?
Contents
A query builder is a tool provided by screener.in that is used to request data from database of screener.in that qualify certain criteria specified by the user. For example, if you are looking to find stocks trading at a P/E ratio of less than 20, the query that you will enter in the query box will be as follows:
Price to Earning <20
Once you enter this query, it will give you a list of all the stocks that are trading at a P/E less than 20. If you want to select stocks based on more than one criteria, you can do so by entering multiple queries. For example, if you want a list of stocks that are trading at a P/E ratio below 20, and have a market capitalization of more than 500 crores, you can do so by entering the following query in the query box:
Price to Earning <20 AND
Market Capitalization> 500
Remember, it is important to use the term “AND” (without quotes) while entering multiple filtration criteria otherwise, it will lead to error message.
Suggested Read: 5 Financial Ratios that you should use to become a smart investor
The question however is, what are the criteria you should be using to find great stocks for long term investment? As per Vishal Khandelwal, author of a very popular blog Safalniveshak.com, there are five major criteria that you must look at while looking for stocks for long term investment, these are:
High Sales Growth (shows how fast company is growing)
High Net Profit (shows if company is generating sufficient profits)
High Return on Equity and Capital Employed (Shows if company is stylizing its invested capital efficiently to generate more profits)
Low debt (shows how much debt the company has on its books, too much debt can ruin a great business)
Low Market Capitalization (smaller companies have better potential to grow)
Low Valuation (No matter how good a company is, it’s not a good investment if you pay too much for it.)
Based on the above mentioned criteria, Vishal Khandelwal has created a basic search query to find stocks that have been growing well in the past. The query is as follows:
- 5-year sales growth > 10%
- 5-year profit growth> 10%
- Average return on equity over 5 years > 20%
- Average return on capital employed over 5 years > 20%
- Debt to equity < 0.5x
- Market Capitalization > Rs 1000 crores
- Price to Earning < 25x
The query above will give you a list of stock that have been performing well for the past 5 years on various criteria.
Looking Beyond Numbers:
However, finding a list of stocks that have done well in the past is not enough, reason? Because, every financial statement is a record of historical performance of the company and does not tell you anything about its future growth potential.
Since an investor today cannot profit from yesterday’s growth, in order to find great stocks for long term investment, you must make sure that the company in question will be able to repeat its past financial performance in the future as well.
Following is a list of questions you must ask yourself (and look for in a business) before making an investment decision.

Is the business of the company easy to understand?
It is always easy to understand businesses that are simple in nature, compared to those that are too complex. What does a simple business mean? Mostly, these are the businesses that we interact with on a daily basis, and don’t really have to dig deeper to understand them. For example, companies like Nestle and HUL are much easier to understand as we use their products in our daily lives, compared to an IT or a Pharmaceutical company that have much more complex business models.
Will the company be around and stay profitable for the next 10 years?
Finding the answer to this question is necessary as it gives you a lot of insight continuity of demand for the products or services of the company. Longer the continuity remains, stronger are the chances of longevity of business. Businesses that have better longevity can be great compounding machines, giving multi-fold returns to shareholders in the long term.
Does the company have a sustainable economic moat and a long term durable competitive advantage?
Economic moat refers to a unique ability of a business to protect itself from being taken over by competitors. A sustainable economic moat provides a business significant lead over peers. Economic moats are the reason how companies have better pricing power, a loyal customer base that allows them to get repeat sales without spending too much on advertising and marketing.
How good is the management of the company?
The quality of management is determined by how prudent they are in terms of capital allocation. Companies that allocate their capital wisely, get higher return on their invested capital compared to their peers. This is evident when the Return on capital of a company is higher than its peers.
The second factor that determines the quality of the management is the Corporate Governance. An honest and able management is always vocal about the ongoing activities in the business and have a clear vision about future growth.
Companies that have a clear growth targets and a blueprint on how they are going to achieve it, can be trusted compared to the management that makes tall promises, uses a lot of jargons about the business ion their annual report but fails to chalk out a clear plan of action on how they are going to achieve it. (You will be able to know a lot about a business and its management if you read the annual report of the company, especially, the Chairman’s letter and management discussion and analysis section)
Does the company require continuous capital expenditure to keep growing?
There is an old saying in the Wall Street, “never invest in something that eats or needs repairs.” Companies that continuously need more cash in order to grow are not great investments. Why? Since they need continuous capital infusion to fund their business, the moment business runs out of further sources to raise capital to fund itself, its growth will come to a screeching halt.
Put simply, spending continuously in order to grow is like running on a treadmill, the moment you stop running, you will fall flat on your face.
Does the company generate more cash than it consumes?
The logic is simple here, if a company generates more cash than it needs to grow itself, it will be left with a lot of free cash that can be used to fund future expansions without relying on external debt. Also, cash generators have a better probability to survive during tough times and bad economic situations.
Asking these questions mentioned above will help you in narrowing down to the stocks that have not only performed financially well in the past, but also have a great potential to keep growing in the future.
Before I conclude this post, here is a quick summary on the entire process of stock picking and what we have learned so far.
Quick Summary:
- Create a list of good stocks that have performed well in the past, have low debt, continuously generated high return on invested capital and are selling at decent valuations.
- Invest within your circle of competence, know your limits and stay within those limits, it does not matter how big or small your circle of competence is, all you need is a handful of good stocks. For the start, look around your house and find the companies that you interact with on a daily basis.
- Look for stable businesses, that have been consistent performers for the past 7-10 years, do not confuse speed of growth with great performance, it is the consistency of growth that matters, not rate of growth.
- Next, look for sustainable economic moats, characteristics that keep a business safe from being taken over by competitors (such as brand name, monopoly, patents, high entry barrier, strong distribution network), and high return in invested capital, which shows that company’s management is prudent in terms of capital allocation.
- Finally, find out if the stock is trading at a reasonable price. Great businesses usually trade at a slight premium, however, it is still important to avoid overpaying, you can use valuation methods like P/E Ratio, and Discounted Cash Flow method to ascertain value of a stock.
Suggested Read: Shocking Revelations Financial Ratios Can Make
There is a saying in the financial industry, where is the customer’s Yacht? Which implies, if the investment advisors were so effective in making money for their clients, why none of their clients have ever made a fortune?
Stock tips and investment advice never created a rich, successful investor, the only way can succeed in the world of investing is by doing your own research carefully and buying good businesses for long term.
I hope you find this article useful and knowledgeable, do let me know your questions, opinions and views in the comment section below. Thank You for reading, happy investing.
Hi sir,I am from Mumbai,please help to inform good classes to understand best use of sites like screener,investing etc in Mumbai ,preferably in Andheri where I stay ..thks in advance
Hi Harinder,
There are many tutorials online that will help you learn how ti use these sites efficiently. Since sites like Screener.in are based on excel, you might need to learn some basics of excel to get the maximum bebefit out of it.