How to Screen NSE Stocks for Fundamentals: A Practical Guide

Most retail investors in India pick stocks the wrong way: a tip from a friend, a YouTube video, or a Telegram alert. The investors who consistently outperform over the long run do something different - they screen. This guide shows you exactly how to filter 5,000+ NSE-listed stocks down to a shortlist worth researching.

Why Stock Screening Beats Stock Tips

A stock tip gives you a conclusion without a process. A stock screen gives you a process without a conclusion. The difference matters enormously:

• Tips have unknown quality control - you don't know the tipper's track record, incentives, or methodology
• Screens are repeatable, auditable, and improvable - you can backtest them and refine over time
• Screens force you to define what "good" looks like before you look at any specific stock - reducing hindsight bias

Screener.in, the most popular free fundamental screener for Indian stocks, has over 3 million registered users. Learning to use it well is one of the highest-ROI skills an Indian retail investor can develop.

The 5 Fundamental Ratios That Matter Most for Indian Stocks

Ratio	What it measures	Good range (Indian market)
PE Ratio	Price / Earnings - how much you pay per ₹1 of earnings	Below sector average; < 25 for most sectors
ROCE	Return on Capital Employed - how efficiently capital generates profit	> 15% is good, > 20% is excellent
Debt to Equity	Total debt / Shareholder equity - financial leverage	< 0.5 for manufacturing; < 0.3 for IT/consumer
Promoter Holding %	Percentage of shares held by founders/promoters	> 50% signals skin in the game
Sales Growth (3yr CAGR)	Revenue compounding rate over 3 years	> 10% for large-cap, > 15% for mid-cap

These five ratios used together are a powerful first filter. They won't find every great stock, but they will eliminate most bad ones. Quality screening is primarily about elimination, not identification.

How to Use Screener.in: Step-by-Step

Screener.in is free for the core features that matter most. Here's how to get started:

1. Create a free account at screener.in - required to save screens and access some data
2. Click "Screen" in the top navigation
3. You'll see a query box. Screener uses a simple English-like query language
4. Type your criteria - example: PE < 25 AND ROCE > 15
5. Click "Run this Query" - Screener returns all NSE/BSE stocks matching the criteria
6. Sort results by Market Cap, ROCE, or PE to prioritise your investigation
7. Save the screen - click "Save" and name it. Screener will run it fresh every day

The power of Screener is the automatic daily update - once you save a screen, the results refresh with latest quarterly data so you see new entrants and exits automatically.

A Ready-to-Use Screening Formula for Quality Indian Stocks

Here is a proven starting screen you can paste directly into Screener.in:

PE < 30 AND Return on capital employed > 15 AND Debt to equity < 0.5 AND Promoter holding > 50 AND Sales growth 3Years > 10 AND Market Capitalization > 500

What each condition does:

• PE < 30: Eliminates the most expensive stocks - you're not paying more than 30x earnings
• ROCE > 15: Ensures the business earns decent returns on what it deploys
• Debt/Equity < 0.5: Conservative balance sheet - reduces bankruptcy risk
• Promoter holding > 50%: Founder/family still has significant skin in the game
• Sales growth > 10% (3yr): Business is actually growing, not shrinking
• Market Cap > 500 Cr: Filters out micro-caps with illiquid markets and low disclosure quality

This screen typically returns 80-150 companies from 5,000+ listed stocks. That's your starting shortlist for deeper research.

What Screener.in Can't Tell You

Screener.in is excellent for financial ratios but has significant blind spots:

• Promoter transaction data (PIT filings): Screener shows promoter holding %, but not real-time buying/selling activity from NSE PIT disclosures
• Grey market premium (GMP): No IPO intelligence
• Bulk and block deal data: Large institutional trades aren't surfaced
• Management quality signals: Pledging trends, AGM attendance, related party transactions
• Technicals: Screener has basic chart functionality but Trendlyne or TradingView are far better

This is why a complete research workflow combines Screener.in for fundamentals with PIT data (NSE), bulk deal data (NSE/BSE), and technical signals (Trendlyne/TradingView).

Screener.in vs Trendlyne vs Tickertape

Feature	Screener.in	Trendlyne	Tickertape
Custom screening	✅ Excellent (best in class)	✅ Good	✅ Good
Historical financials depth	✅ 10+ years	✅ 10+ years	⚠️ Limited
Technical indicators	❌ Basic	✅ Comprehensive	✅ Good
Promoter activity	⚠️ Quarterly only	✅ Better coverage	⚠️ Quarterly only
Alerts & watchlist	✅ Good (free)	✅ Excellent (paid)	✅ Good
Bulk/block deals	❌ No	✅ Yes	⚠️ Limited
Price	Free (core) / ₹999/yr	Free (limited) / ₹2,500/yr	Free / ₹1,999/yr
Best for	Fundamental screening	Technical + fundamental combo	Beginners, clean UI

Recommendation: Start with Screener.in (free, best fundamentals). Add Trendlyne if you want technical layers. Tickertape is the most beginner-friendly but thinner on data depth.

How to Build Your Watchlist After Screening

The funnel from 5,000 listed stocks to actual positions:

1. Screen (5,000 → 100): Apply the fundamental screen above - removes 98% of stocks
2. Sector filter (100 → 40): Exclude sectors you don't understand or want no exposure to (PSU banks, cyclicals, etc.)
3. Business model check (40 → 15): Read the company's annual report executive summary - do you understand how it makes money? Can it raise prices?
4. Management quality (15 → 7): Check promoter pledging, related party transactions, auditor qualifications in the annual report
5. Valuation vs history (7 → 3-5): Is the current PE lower than its own 5-year average? Is it cheap vs peers?
6. Buy (3-5 stocks): Position size based on conviction and portfolio construction rules

How stoicHQ Adds the Signals Screener Misses

stoicHQ's Stock Research module adds the layer Screener.in doesn't have: real-time NSE PIT disclosure tracking, bulk and block deal alerts, pledging trend alerts, and IPO pipeline scores - all on the same dashboard. Think of it as Screener.in for the quantitative fundamentals, plus a daily signal feed for the qualitative and market-microstructure signals that move prices before earnings.

Join the waitlist - Beta access is open.

FAQ

Is Screener.in free to use in India?

Yes - the core screening functionality, 10+ years of financial data, and watchlists are free. The paid plan (₹999/year) adds Excel export, portfolio tracking, and some advanced features. For most retail investors, the free tier is sufficient to start.

What is a good ROCE for Indian stocks?

ROCE above 15% is generally considered good for non-financial Indian companies. Above 20% is excellent and characteristic of quality businesses with pricing power (think Asian Paints, Page Industries, Pidilite). For capital-intensive sectors like steel or cement, 12-15% ROCE can be acceptable. For IT and FMCG companies, look for 25%+.

How do I find stocks with low PE and high ROCE in India?

Use Screener.in with: PE < 20 AND Return on capital employed > 20. This combination - cheap on earnings, efficient on capital - is the classic value quality screen. Results are typically 30-60 companies and represent the most interesting universe for deeper research.

What is the difference between Screener.in and Trendlyne?

Screener.in is stronger for fundamental data depth and custom screening flexibility - the query language is more powerful. Trendlyne is stronger for technical indicators, bulk/block deal tracking, and real-time alerts. Most serious retail investors use both: Screener for the fundamental shortlist, Trendlyne for technical entry timing and ongoing alerts.

How do I filter NSE small cap stocks by fundamentals?

In Screener.in: Market Capitalization < 5000 AND Market Capitalization > 500 AND ROCE > 15 AND Debt to equity < 0.3 AND Sales growth 3Years > 15. The tighter ROCE and growth filter for small-caps compensates for their higher risk. Small-cap screening should also mandate checking for pledging (add AND Pledged percentage < 5) since pledging risk is disproportionately higher in small-caps.