🔍 Building Your First Quantitative Stock Screen

Step-by-Step Guide to Systematic Stock Discovery Using Screener.in

📅 Published: Saturday, July 13, 2025 | ⏱️ Reading Time: 20-25 minutes

❌ Random Stock Picking Approach

News Headlines + Tips + Gut Feelings = Inconsistent Results

❌ What Most Retail Investors Do Wrong:

  • News-driven decisions - Buying stocks after they've already moved on headlines
  • Tip-based investing - Following recommendations without understanding the rationale
  • Emotional reactions - FOMO buying and panic selling based on market sentiment
  • No systematic process - Different criteria for each investment decision
  • Lack of diversification - Concentrating in familiar names or sectors
Reality Check: Random stock picking has a 50% chance of outperforming the market - same as flipping a coin. Professional investors use systematic screening to consistently find undervalued opportunities.

✅ Systematic Quantitative Screening

Systematic Filters + Quality Metrics + Consistent Process = Repeatable Alpha

✅ What Professional Investors Do:

  • Systematic discovery - Screen entire market using objective criteria
  • Multi-factor analysis - Combine value, quality, and momentum factors
  • Consistent framework - Same process applied to all investment decisions
  • Quantitative validation - Numbers-based evidence before fundamental analysis
  • Scalable process - Analyze hundreds of opportunities efficiently
Professional Advantage: Systematic screening identifies hidden gems that random picking misses, leading to consistent outperformance through disciplined, repeatable investment processes!

🎧 Quantitative Screening Masterclass

Build professional stock screens step-by-step with live examples

0:00 / --:--
🔍 What you'll master:
Screener.in Tutorial: Navigate the platform like a professional with live filtering examples.
Filter Building: Magic Formula, F-Score, and multi-factor screen construction methodology.
Results Analysis: How to interpret screening results and avoid common interpretation mistakes.
Next Steps: Converting screening results into investment-ready watchlists for further analysis.

🎯 Why Quantitative Screening Changes Everything

The foundation of systematic investing success

"How do professional investors consistently find great opportunities?" The answer isn't luck or insider information - it's systematic quantitative screening. This process transforms investing from random stock picking into a disciplined, repeatable framework for discovering undervalued companies.

Quantitative screening is the first step in professional portfolio management. It filters thousands of stocks using objective criteria, identifying candidates that meet specific financial and quality standards before any fundamental analysis begins.

⚠️ Important Disclaimer

Quantitative screening identifies potential opportunities, not guaranteed winners. Always combine screening results with fundamental analysis, business understanding, and proper risk management before making investment decisions.

1
Setting Up Your Screener.in Account

Why Screener.in? It's the most comprehensive free screening platform for Indian stocks, offering access to 10+ years of financial data, multiple screening criteria, and professional-grade filtering capabilities.

Getting Started:

  1. Visit screener.in and create a free account
  2. Navigate to "Screen" in the top menu
  3. Familiarize with the interface: Filters on left, results on right
  4. Start with "Create Screen" to build your first filter

💡 Pro Tip

Bookmark Screener.in and set aside 30 minutes weekly for screening. Consistency in running screens helps you spot trends and identify opportunities before they become obvious to the market.

2
Building Your First Magic Formula Screen

The Magic Formula combines two powerful factors: Earnings Yield (value) and Return on Equity (quality). This creates a systematic approach to finding cheap, profitable companies.

🎯 Live Magic Formula Tutorial

Follow these exact steps in Screener.in

Step-by-Step Magic Formula Screen:

🔍 Basic Filters

Market Cap > 1000 crores
Sales > 100 crores
Current Price > 10

📊 Quality Filters

ROE > 15%
ROE 3 Years Avg > 12%
Debt to Equity < 1

💰 Value Filters

PE Ratio < 25
Price to Book < 3
EV/EBITDA < 15

🛡️ Safety Filters

Current Ratio > 1.2
Interest Coverage > 3
Promoter Holding > 30%
Magic Formula Ranking Formula: 1. Calculate Earnings Yield = EBIT / Enterprise Value 2. Calculate Return on Capital = EBIT / (Working Capital + Fixed Assets) 3. Rank all stocks by both metrics 4. Combined Rank = Earnings Yield Rank + Return on Capital Rank 5. Select stocks with lowest combined ranks
3
Adding Piotroski F-Score Filters

The Piotroski F-Score adds a quality overlay to identify financially healthy companies. We'll build filters that approximate the 9-point scoring system.

💪 Profitability (3 Points)

Net Income > 0
Operating Cash Flow > 0
ROA > ROA Previous Year

🏗️ Leverage & Liquidity (3 Points)

Debt to Equity < Previous Year
Current Ratio > Previous Year
Shares Outstanding ≤ Previous Year

⚡ Operating Efficiency (3 Points)

Gross Margin > Previous Year
Asset Turnover > Previous Year
Operating Margin > Previous Year

💡 Screening Strategy

Start with broad Magic Formula filters, then add F-Score criteria to narrow results. Target 20-50 stocks for further fundamental analysis rather than trying to find the "perfect" screen that returns only 5 stocks.

4
Running and Analyzing Results

Once your screen is built, it's time to run it and analyze the results systematically. This is where screening transforms from academic exercise to practical investment tool.

📊 Sample Screening Results

Here's what a typical Magic Formula + F-Score screen might return:

Company Market Cap PE Ratio ROE Debt/Equity ROA Magic Formula Rank
Company A (Chemicals) ₹2,500 Cr 12.4 22.1% 0.3 15.2% 15
Company B (Auto Parts) ₹1,800 Cr 14.8 18.7% 0.5 12.8% 23
Company C (Textiles) ₹3,200 Cr 16.2 19.4% 0.7 11.5% 31
Company D (Pharma) ₹4,100 Cr 18.9 16.8% 0.4 13.7% 42
Company E (Engineering) ₹1,200 Cr 11.7 20.3% 0.6 14.1% 38

🎯 Analysis Insights:

  • All companies show strong ROE (>15%) indicating quality business models
  • Low debt levels (<1.0 D/E) suggest financial stability
  • Reasonable valuations (PE <20) provide margin of safety
  • Diverse sectors reduce concentration risk

🔍 Results Analysis Framework:

  1. Quick Quality Check: Scan for obvious red flags (very high PE, excessive debt, negative margins)
  2. Sector Distribution: Ensure results aren't concentrated in one sector
  3. Ranking Analysis: Focus on top 20-30 ranked stocks for deeper analysis
  4. Historical Context: Check if current metrics represent normal or exceptional performance
  5. Create Watchlist: Export top candidates for fundamental analysis
5
Advanced Multi-Factor Screening

Once comfortable with basic screening, add momentum and additional quality factors to create sophisticated multi-factor screens that professionals use.

📈 Momentum Factors

Sales Growth (3Y) > 10%
Profit Growth (3Y) > 15%
Price Performance (6M) > -20%

🏆 Quality Factors

ROCE > 20%
Operating Margin > 10%
Asset Turnover > 1

💎 Low Volatility

Beta < 1.2
Earnings Stability Consistent Growth
Dividend Yield > 1%

🔍 Size Factor

Small Cap 1000-10000 Cr
Mid Cap 10000-50000 Cr
Large Cap > 50000 Cr

🛠️ Interactive Screen Builder

Build and test your screening criteria with this interactive tool

Estimated Results: --
Screen Quality: --
Expected Alpha: --
Risk Level: --
Recommended Action: --

⚠️ Common Screening Mistakes to Avoid

Learn from these frequent errors

❌ Over-Filtering

Mistake: Using too many strict filters that return only 2-3 stocks.

Solution: Aim for 20-50 results to ensure adequate diversification opportunities.

❌ Static Screens

Mistake: Running the same screen for months without adjustment.

Solution: Adapt screens to market conditions and evolving investment opportunities.

❌ Ignoring Sector Bias

Mistake: Screens that heavily favor one sector during favorable cycles.

Solution: Monitor sector concentration and adjust filters for balance.

❌ No Fundamental Follow-up

Mistake: Buying stocks purely based on screening results.

Solution: Always conduct fundamental analysis on screening candidates.

⚠️ Critical Screening Principles

Screening Identifies Candidates, Not Final Decisions: Think of screening as a sophisticated filtering system, not a buy/sell signal generator.

Quality Over Quantity: 20 well-researched stocks from screening beats 100 randomly selected names.

Market Cycle Awareness: Adjust screens based on market conditions - value works in some periods, growth in others.

Continuous Refinement: Track performance of screened stocks to improve filter effectiveness over time.

🎯 From Screen to Portfolio: Next Steps

Converting screening results into investment decisions

📋 Post-Screening Analysis Workflow:

Phase 1: Initial Filtering (15 minutes per stock)

  • Business Model Check: Understand what the company does and how it makes money
  • Industry Position: Is it a leader, challenger, or niche player?
  • Recent News Scan: Any major developments affecting the business?
  • Management Quality: Quick review of promoter background and corporate governance

Phase 2: Fundamental Deep-Dive (2-3 hours per stock)

  • Financial Analysis: 5-year trends in revenues, margins, and cash flows
  • Competitive Analysis: Market share, competitive advantages, threats
  • Valuation Work: DCF model, peer comparison, scenario analysis
  • Risk Assessment: Industry risks, company-specific risks, regulatory issues

Phase 3: Portfolio Integration (Final decision)

  • Position Sizing: How much allocation based on conviction level?
  • Sector Balance: Does this fit portfolio diversification requirements?
  • Entry Timing: Technical analysis for optimal entry points
  • Exit Strategy: Target prices and stop-loss levels

💡 Efficiency Tips

Batch Processing: Analyze all screening results in dedicated sessions rather than random timing.

Template Approach: Create standard analysis templates to ensure consistent evaluation criteria.

Decision Journal: Track why you selected or rejected each screened stock for continuous improvement.

Regular Review: Monthly review of screening performance and filter effectiveness.

🚀 Your Quantitative Screening Journey Starts Now

Systematic stock screening isn't just a tool - it's the foundation of professional investing. Start with one basic Magic Formula screen, refine it based on results, and gradually add complexity as you gain experience.

📚 Continue Learning

Master the underlying concepts:

  • Quantitative Investing Foundations
  • Magic Formula Implementation
  • Piotroski F-Score Mastery
  • Multi-Factor Model Construction

🛠️ Build Your Toolkit

Essential screening resources:

  • Screener.in premium for advanced filters
  • Regular screening schedule (weekly)
  • Results tracking spreadsheet
  • Analysis templates and checklists

🎯 Practice Regularly

Build screening discipline:

  • Run 2-3 different screens weekly
  • Track historical screen performance
  • Refine filters based on results
  • Integrate with fundamental analysis

📈 Scale Systematically

Professional development path:

  • Start with Magic Formula basics
  • Add F-Score quality overlay
  • Incorporate momentum factors
  • Develop custom multi-factor screens