How to Use Screener.in for Stock Analysis: Complete Tutorial for Beginners

If you've been searching for a comprehensive screener.in tutorial to sharpen your stock picking, you're in the right place — and probably at the right stage of your trading evolution. Most retail traders on NSE and BSE spend hours watching YouTube tips or chasing Telegram calls, but the ones who consistently build wealth learn to read financial data themselves. Screener.in is the single most powerful free tool available to Indian equity investors for doing exactly that.

The problem is simple: Screener.in has an enormous feature set — custom queries, financial ratios, peer comparisons, export tools — and most beginners barely scratch the surface. They look up a stock, glance at the PE ratio, and move on. That's like buying a Bloomberg terminal and only checking the time. This tutorial walks you through every feature that matters, with real examples using stocks like HDFCBANK, TCS, RELIANCE, and BAJFINANCE, so you can actually build a repeatable stock analysis workflow.

Why Screener.in Matters for Indian Retail Traders

India has over 5,000 listed companies on NSE and BSE combined. SEBI's 2023 study on investor behavior showed that a majority of retail traders make decisions based on tips, social media, or single-metric filters like "low PE." That approach is how 9 out of 10 F&O traders lose money (per SEBI's own January 2024 data). Fundamental screeners exist to solve this — they let you filter the entire listed universe using financial data, not opinions.

Screener.in is India-specific, covers every NSE/BSE listed company, and pulls data directly from annual reports and quarterly filings. Unlike global tools like Finviz or TradingView's stock screener, it understands Indian accounting standards (Ind AS), Indian fiscal year conventions (March endings), and SEBI's disclosure requirements. It's free for most features, with a premium tier (Screener Pro) that adds Excel exports and custom ratios.

Here's what separates good stock analysts from mediocre ones: they don't just look at one number. They build a checklist — a combination of growth rates, margins, debt levels, and valuations — and Screener.in lets you encode that checklist into a query. Once you understand how, you can filter 5,000+ stocks down to 15-20 candidates in under five minutes.

Getting Started: The Screener.in Dashboard and Company Pages

Head to screener.in and create a free account. The homepage gives you a search bar — type any NSE/BSE ticker or company name. Let's start with HDFCBANK.

The company page is where most beginners land, and it's packed with data. Here's what each section gives you:

Top bar: Current price, market cap, PE ratio, book value, dividend yield, ROCE, ROE, and face value. For HDFCBANK, you'll typically see a PE around 18-20, ROCE around 7-8% (banks have lower ROCE due to asset-heavy models), and a market cap above ₹12 lakh crore.
Pros and Cons: Screener auto-generates these based on financial data. For instance, it might flag "Company has a low return on equity of 15%" as a con for a manufacturing company, or "Company has been maintaining a healthy dividend payout" as a pro.
Quarterly Results: Revenue, expenses, operating profit, OPM%, net profit — laid out quarter by quarter. This is where you spot trends. If TCS shows three consecutive quarters of declining OPM%, that's a flag.
Profit & Loss (Annual): 10-year annual data. Revenue CAGR, profit CAGR, margin trends — all visible at a glance.
Balance Sheet: Total assets, liabilities, equity, debt, reserves. For a company like BAJFINANCE, you want to track how fast borrowings are growing relative to equity.
Cash Flow: Operating cash flow, investing cash flow, financing cash flow. This is the section most beginners ignore and most professionals check first.
Ratios: ROCE, ROE, debt-to-equity, interest coverage, and more — trended over 10 years.
Shareholding Pattern: FII, DII, promoter, and public holdings — quarter by quarter. A steadily declining promoter holding in a mid-cap is often a red flag.
Peer Comparison: Screener automatically compares your stock against sector peers. HDFCBANK gets compared against ICICIBANK, KOTAKBANK, SBIN, AXISBANK, etc.

Pro tip: Scroll to the bottom of any company page and check the "Compounded Sales Growth" and "Compounded Profit Growth" tables. They show 3-year, 5-year, and 10-year CAGR. A stock like DEEPAKNTR might show 25%+ profit CAGR over 10 years — that's the kind of compounder you want to find early.

Mastering the Query Screen: The Real Power of Screener.in

If you're learning how to use screener.in for stock analysis beginners India style, the query screen is where you graduate from beginner to intermediate. Navigate to the "Screens" section from the top menu.

Screener.in uses a simple query language. You type conditions, and it filters the entire NSE/BSE universe. Let's build a practical screen step by step.

Building Your First Custom Screen

Say you want to find quality mid-cap companies with consistent growth. Here's a query:

Market Capitalization > 5000 AND Market Capitalization < 50000 AND Sales growth 5Years > 15 AND Profit growth 5Years > 15 AND Return on equity > 15 AND Debt to equity < 1

What this does:

Market Cap between ₹5,000 Cr and ₹50,000 Cr: Targets mid-caps on NSE/BSE.
5-year sales growth > 15%: Eliminates stagnant businesses.
5-year profit growth > 15%: Ensures top-line growth is translating to bottom-line.
ROE > 15%: Filters for capital-efficient companies. Warren Buffett's threshold, and it works in India too.
Debt-to-equity < 1: Removes over-leveraged companies. In a rising rate environment (RBI has kept repo rate at 6.5% for extended periods), highly leveraged companies suffer.

Run this screen and you'll typically get 40-80 results. Companies like POLYCAB, ASTRAL, PERSISTENT, or CAMS frequently appear in screens like this. Each result is clickable — you can dive straight into the company page.

Useful Pre-Built Screens

Screener.in offers several pre-built screens worth studying:

High ROCE, Low Debt: Classic quality screen. Finds companies like PIDILITIND, COLPAL.
Growing at a Reasonable Price (GARP): Combines growth with valuation. Typically uses PEG ratio logic.
Increasing Profit Every Quarter (YOY): Great for momentum-fundamental hybrid strategies. Finds stocks where every quarter's profit exceeds the same quarter last year.

You can clone any pre-built screen and modify it. Add a condition like Promoter holding > 50 to ensure skin in the game, or Current ratio > 1.5 to filter for liquidity.

Advanced Query Tricks

Custom ratios: In Screener Pro (₹4,999/year), you can create custom columns. For instance, a "Cash Conversion Ratio" (Operating Cash Flow / Net Profit) identifies companies that convert paper profits into actual cash. A ratio consistently below 0.8 for a non-financial company — red flag.
Relative valuation: Use Price to Earning < Industry PE to find stocks trading below their sector average PE.
Quarterly data queries: Filter using Sales growth quarterly > 20 to catch companies in an acceleration phase. This is how you spot turnaround stories early.

Analyzing Financial Statements on Screener.in: A Practical Walkthrough

Let's walk through a real analysis. Open RELIANCE on Screener.in.

Step 1: Revenue trend. Look at the P&L section. Reliance's consolidated revenue crossed ₹9 lakh crore in FY24. But revenue alone means nothing for a conglomerate. Check the OPM% (Operating Profit Margin). Reliance typically operates at 15-17% OPM. If it dips below 14%, dig into whether it's a Jio pricing war, O2C margin compression, or retail expansion costs.

Step 2: Cash flow check. Reliance is famous for heavy capex. Look at "Cash from Investing Activities" — it's usually a large negative number (₹1-2 lakh crore). Then check "Cash from Operating Activities." If operating cash flow comfortably exceeds capex, the growth is self-funded. If not, check "Cash from Financing Activities" — large positive numbers here mean the company is borrowing or raising equity to fund growth.

Step 3: Balance sheet health. Reliance's debt-to-equity has fluctuated. Post the Jio fundraise in 2020, it dropped significantly. Track this ratio over 5 years on Screener.in's ratio chart. A company that's deleveraging while growing revenue is a strong signal.

Step 4: Shareholding changes. Check if FIIs are increasing or decreasing stake. For RELIANCE, FII holding around 22-24% is typical. A sudden 2-3% drop in FII holding over two quarters deserves investigation — it often precedes negative news flow.

Step 5: Peer comparison. Click the "Peer Comparison" section. Compare RELIANCE's PE, ROE, and sales growth against ONGC, IOC, BPCL (O2C peers) and BHARTIARTL (telecom peer). Reliance's PE premium over ONGC is structural — it reflects Jio and Retail. But if the premium expands beyond 2x historical average, valuation risk increases.

Common Mistakes Beginners Make With Screener.in

Even with a solid screener.in tutorial in hand, traders frequently fall into these traps:

Mistake 1: Screening without context. A PE of 8 looks cheap — until you realize the company is a PSU bank with ₹15,000 crore in NPAs. Always click through to the company page after running a screen. Numbers without narratives are dangerous.

Mistake 2: Ignoring cash flows. Screener.in's P&L section gets 10x more attention than the cash flow section. But Indian markets are full of companies with growing profits and zero free cash flow — classic cases of aggressive revenue recognition or endless working capital traps. Textile and infra companies are frequent offenders. Always check: is operating cash flow positive and growing?

Mistake 3: Over-optimizing screens. Adding 15 conditions to a screen and getting 3 results isn't smart — it's overfitting. Start with 4-5 core conditions, get a manageable list (30-80 stocks), then manually review. The best analysts use screeners to narrow, not to decide.

Mistake 4: Using standalone (non-consolidated) data. For companies with subsidiaries — think BAJAJ-AUTO (which owns a significant stake in Bajaj Finance indirectly), or TATAPOWER with its renewable subsidiaries — standalone numbers miss the picture entirely. Always toggle to "Consolidated" on the company page. Screener.in defaults to consolidated when available, but verify.

Mistake 5: Snapshot bias. Looking at one year's data and making a decision. Screener.in gives you 10 years of financial history. Use it. A company showing 30% ROE this year but averaging 12% over the last decade is an outlier, not a compounder. The 10-year median is your friend.

What to Actually Do: Your Weekly Screener.in Workflow

Here's a practical routine that takes 2-3 hours per week:

Sunday morning: Run your core screens. Maintain 3-4 saved screens — one for quality compounders, one for turnarounds, one for value picks, one for dividend plays. Check for new entries. If a stock newly qualifies, it goes on your watchlist.
Monday: Review quarterly results. During earnings season (January, April, July, October), check the quarterly results of your watchlist companies on Screener.in. Compare actual numbers against your expectations. If PERSISTENT reports 5% QoQ revenue growth when you expected 8%, investigate before acting.
Wednesday: Peer comparison deep dive. Pick one sector per week. Compare 5-6 peers using Screener.in's peer table. Rank them by ROE, ROCE, debt-to-equity, and 5-year profit CAGR. The top 2 go on your watchlist. Do this consistently and in 3 months you'll have an intimate understanding of 15+ sectors.
Ongoing: Track shareholding patterns. Screener.in updates shareholding data quarterly. Increasing mutual fund and FII holdings in a fundamentally strong mid-cap — like what happened with TRENT before its multibagger run — is a strong convergence signal.
Export and annotate. Screener Pro lets you export data to Excel. Build your own valuation models. Even a simple DCF using 10-year cash flow data from Screener.in beats gut-feel investing.

The edge isn't in finding Screener.in — every serious Indian investor knows about it. The edge is in using it systematically, week after week, building pattern recognition that no shortcut can replace.

Beyond Screener.in: Combining Fundamental Screens With Technical Timing

A screener tells you what to buy. It doesn't tell you when. The best Indian market practitioners use fundamental screens to build a universe, then apply technical analysis or quantitative signals for entry and exit timing.

For example, your Screener.in query might surface DIXON as a high-growth electronics manufacturer with improving margins. But if DIXON is trading at an RSI of 82 on the weekly chart and is 40% above its 200-DMA, chasing it here is risky. You add it to your watchlist, set alerts, and wait for a mean-reversion entry near the 50-DMA or a consolidation breakout.

This is where Screener.in's strength — deep fundamental analysis — meets its limitation: it doesn't do real-time price action, volume analysis, or options flow. You need complementary tools for that layer.

Similarly, sector rotation signals, institutional activity patterns, and market regime analysis (trending vs. range-bound) require a different data stack. SEBI's 2024 disclosure norms now make FII and DII daily flow data available — combining this with your fundamental shortlist creates a significantly sharper edge than either approach alone.

Screener.in is an essential first step in becoming a self-reliant Indian equity analyst — but fundamental screening is just one layer of a complete trading intelligence system. For the next layer — AI-driven pattern recognition, real-time institutional flow analysis, and actionable signals that combine fundamentals with technical timing — explore what MarketNetra brings to NSE and BSE traders who want data doing the heavy lifting.