Last Updated on August 8, 2026 at 10:58 pm
Here is an Excel stock screener to scan & filter Indian stocks with multiple criteria. Cap-wise screening & sector-wise screening possible. It gets data from Value Research and allows the user to screen capitalization-wise and sector-wise.
I have always wanted to build a stock screener and hence this sheet. I am well aware that they are pretty good online screeners available. What is being offered is a choice, and I am confident that the Excel screener will evolve into something at least useful to a small group of users, if not as a unique tool. I seek your help in evaluating this sheet and in making it better.
Those who are comfortable with using Excel’s data sort options can screen in several ways with this sheet.
For users who are not familiar with the sort options, several simple stock screens are incorporated after consultations with Krishna Kishore – tyroinvestor and Indraneal Balasubramanium – cognicrafter.
🔥Secure your future with our Robo-advisory tool trusted by over 3,500 investors and advisors. From effortless retirement planning to funding your children’s biggest dreams, turn your financial goals into reality. 🔥
Subscribe for money management solutions via email! (Link takes you to our email sign-up form) Join 32,000+ readers in our community.
👉 New Tool Alert! NaviPlan: A Privacy-Focused Multi-asset Tracker and Goal Planner 👈
They are my go-to guys when it comes to stock analysis. They are capable of simplifying valuation quite efficiently for a low-attention-span dummy like me.
Excel Stock Screener: How to use Video
This video may help build your own screens.
Capitalisation-wise stock screening
This is the screenshot of the cap-wise stock screener
In order to use the tool, one must first login to Value Research via Excel. Necessary steps are given below.
As you can see there are five sample screens which can be used independently or combined with each other. Other sort options can also be enabled from the data sheet.
The green cells refer to stocks with current PE lesser than median PE (5Y or 3Y -duration listed).
The following screens are available
Piotroski Score – Higher the score, better the strength of the company and confidence in its operation. VR article on the score.
Altman-Z Score – Higher the score, lower the probability of bankruptcy. This is how VR computes it
Modified C-Score – lower the score, lower the chance of accounting manipulation. This is how VR computes C-Score.
Debt to Equity – a measure of debt used by the company to operate. Lower is typically less risky. Less than one, preferred by many.
PEG – The PE ratio divided by annual EPS growth. Less than one, could represent undervalued stock.
Enterprise Multiple EV/EBITDA – Compares EBITA, the earnings before interest, taxes, depreciation and amortization with EV, the enterprise value. Low values could mean undervaluation. However, ‘low’ is sector dependent.
Current PE less than Median PE – Median is the mid-point of a distribution of values (PEs in this case). Maybe used for solid companies (thanks Krishna).
Current PE more than Median PE – Maybe used for small companies which are expanding, provided other checks are in place.
Sector-wise stock screening
In this case, only essential checks are retrieved.
Download the freefincal Excel Stock Screener Sep 2018 Version 3 (with Joel Greenblatt Magic Formula Screener)
Download the freefincal Excel Stock Screener Dec 2017 Version 2 (included screening by index and an error in FMCG sector download, thanks to feedback from users)
Download the freefincal Excel Stock Screener Jan 2016 Version 1
Also check out the individual stock analysis sheet with multiple valuation techniques: Automated Stock Analysis V9: Earnings Growth Estimation
Guest post by Krishna: A Guide to Understanding Stock Screeners
Guest post by Indraneal: How to Build a Stock Screener
Note: Please do the following to login to Value Research
- Open blank excel
- Select Data in the menu
- Click get external data and then from web
- A browser window will open and there will annoying script error messages. Dismiss them.
- Then Go to VR online in that window and go to main page. There will annoying messages. Dismiss them.
- Click on login. If you are not able to do so. Stop the page from downloading and then click
- Login with your email (preferable) and click on remember me.
- Now you can exit the browser window and start using the screener. It should work fine now.
We are on Google News
Use this button to add freefincal.com as a preferred personal finance source on Google News.
Explore 1,400+ videos on YouTube!
Subscribe to get posts via email!
Join 32,000+ readers and get free money management solutions delivered to your inbox! (Link takes you to our email sign-up form)Join our WhatsApp Channel
Explore our products
🔥Join our community of 9000+ users! 🔥- Use our Robo-advisory Tool to create a complete financial plan! More than 3,500 investors and advisors use this! Use the discount code robo25 for 20% off. Plan your retirement (early, normal, before, and after), plus non-recurring financial goals (such as child education) and recurring financial goals (such as holidays and appliance purchases). The tool helps anyone aged 18 to 80 plan for retirement, plus six non-recurring and four recurring financial goals, with a detailed cash flow summary.
- Our Flagship Course! Learn to manage your portfolio like a pro to achieve your goals regardless of market conditions! More than 3,500 investors and advisors are part of our exclusive community! Get clarity on how to plan for your goals and achieve the necessary corpus no matter the market conditions! Watch the first lecture for free! One-time payment! No recurring fees! Lifelong access to videos! Reduce fear, uncertainty and doubt while investing! Learn how to plan for your goals before and after retirement with confidence.
- Join the freefincal investor circle! An exclusive space for investors, advisors, fintech employees and students to access financial planning and insurance tools, mutual fund and stock analysis tools, coding strategies and Excel macros for data extraction. 750+ members are now part of our investor circle.
- Increase your income by getting people to pay for your skills! More than 900 salaried employees, entrepreneurs and financial advisors are part of our exclusive community! Learn how to get people to pay for your skills! Whether you are a professional or small business owner seeking more clients through online visibility, or a salaried individual looking for side or passive income, we will show you how to do it by showcasing your skills and building a community that trusts and pays you. (Watch the 1st lecture for free). One-time payment! No recurring fees! Lifelong access to videos!
- Portfolio Tracker! Track your mutual funds and stock investments with our Google Sheet!
- We also publish monthly screeners for
Our Podcast: Let's Get Rich With Pattu
On Spotify: Let's Get RICH With PATTU! Every single Indian CAN grow their wealth! On Audible: Listen to the Let's Get Rich with Pattu Podcast
Listen to the Let's Get Rich With Pattu podcast on YouTube.
Now watch Let's Get Rich With Pattu தமிழில் (in Tamil)!About The Author
Dr M Pattabiraman giving a lecture
- Dr M. Pattabiraman (PhD) is the founder, managing editor and primary author of freefincal. He is an associate professor at the Indian Institute of Technology, Madras.
- He has over 14 years of experience publishing news analysis, research and financial product development. He has over 28 years of teaching and research experience. He is also a public speaker and keynote presenter.
- He is a patron and co-founder of “Fee-only India,” an organisation promoting unbiased, commission-free, AUM-independent investment advice.
- Connect with him via @pattufreefincal on X LinkedIn YouTube
- Pattabiraman has co-authored three print books.
This book helps you ask the right questions and find the right answers. It also includes nine online calculators to create custom solutions.
(2) Gamechanger: Forget Startups, Join Corporate & Still Live the Rich Life You Want. 
Both the boy and girl versions of "Chinchu Gets a Superpower".
Most investor problems stem from a lack of poor decision-making. We made bad decisions and money mistakes when we started earning, and we spent years undoing them. Why should our children go through the same pain? What is this book about? As parents, what if we had to groom one ability in our children that matters not only for money management and investing but for every aspect of life? My answer: Sound decision-making. So, in this book, we meet Chinchu, who is about to turn 10. The story follows what he wants for his birthday and how his parents plan it, while also teaching him key ideas about decision-making and money management. What readers say! 
Feedback from a young reader after reading Chinchu Gets a Superpower!
Must-read book even for adults! This is something that every parent should teach their kids right from a young age. The importance of money management and decision-making based on their wants and needs. Very nicely written in simple terms. - Arun.
About freefincal & its content policy
Freefincal is a News Media organisation dedicated to providing original analysis, reports, reviews and insights on mutual funds, stocks, investing, retirement and personal finance developments. We do so without conflict of interest and bias. Follow us on Google News. Freefincal serves more than three million readers a year (5 million page views) with articles based only on factual information and detailed analysis by its authors. All statements made will be verified with credible and knowledgeable sources before publication. Freefincal does not publish paid articles, promotions, PR, satire or opinions without data. All opinions will be inferences backed by verifiable, reproducible evidence/data. Contact Information: To get in touch, please use our contact form. (Sponsored posts or paid collaborations will not be entertained.)Our publications
- Your Ultimate Guide to Travel. This is an in-depth exploration of vacation planning, including how to find affordable flights, budget accommodations, and practical travel tips. It also examines the benefits of travelling slowly, both financially and psychologically, with links to relevant web pages and guidance at every step. Get the PDF for Rs 300 (instant download)
- How to profit from content writing: Our ebook is for those interested in getting a side income via content writing. It is available at a 50% discount for Rs. 500 only!