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.