Penny Stocks Under 10 Rs: Complete Guide to Screening and Analyzing Low-Price Indian Shares

M
MarketXLS Team
Published
Updated
Penny stocks under 10 Rs analysis in Excel showing fundamental data, PE ratios, and market capitalization with MarketXLS

Penny stocks under 10 Rs are among the most searched and debated investment topics in the Indian stock market. These ultra-low-price shares, typically trading below ₹10 on the NSE and BSE, attract investors with the promise of extraordinary returns—but they come with equally extraordinary risks. In this comprehensive guide, we explain what penny stocks are in the Indian context, their advantages and disadvantages, the key financial metrics to evaluate them, and how to use MarketXLS formulas to analyze these stocks with professional-grade tools in Excel.

Before investing in any penny stock, thorough research and due diligence are absolutely essential. This guide provides the analytical framework—not investment recommendations.


What Are Penny Stocks in the Indian Market?

Penny stocks under 10 Rs in the Indian equity market refer to shares that trade at a very low price, usually below ₹10 per share. These stocks are typically from smaller companies with lower market capitalization, often listed on the NSE (National Stock Exchange) or BSE (Bombay Stock Exchange).

Key Characteristics of Penny Stocks Under 10 Rs

CharacteristicDescription
Price RangeBelow ₹10 per share
Market CapitalizationTypically micro-cap (below ₹500 crore)
Trading VolumeOften low and inconsistent
LiquidityLimited—difficult to buy/sell large quantities
Regulatory OversightLess stringent than large-cap stocks
Information AvailabilityLimited analyst coverage and financial reporting
VolatilityExtremely high—10-20% daily swings common
Institutional OwnershipVery low or none

How Penny Stocks Under 10 Rs Differ from Blue-Chip Stocks

FactorPenny Stocks Under 10 RsBlue-Chip Stocks (e.g., Reliance, TCS)
Share PriceBelow ₹10₹500-₹5,000+
Market CapBelow ₹500 Cr₹1 Lakh Cr+
Daily VolumeInconsistent, often thinHigh, consistent liquidity
Analyst CoverageMinimal or noneExtensive coverage
Financial ReportsMay be unreliableAudited, transparent
Price Manipulation RiskHighVery low
Dividend HistoryUsually noneRegular dividends
Suitable ForHigh-risk-tolerance investorsAll investor profiles

Advantages and Disadvantages of Penny Stocks Under 10 Rs

Advantages

  1. Affordability: Penny stocks under 10 Rs allow small investors to enter the market with minimal capital. You can buy thousands of shares for the cost of one blue-chip share.

  2. High Return Potential: If the company behind a penny stock grows successfully, the returns can be extraordinary. A stock moving from ₹2 to ₹10 represents a 400% gain.

  3. Portfolio Diversification: With small investments, you can spread risk across many penny stocks rather than concentrating in one expensive stock.

  4. Multibagger Potential: Some of today's large-cap companies were once penny stocks. Early investors in companies that eventually grew captured massive wealth.

  5. Learning Opportunity: Penny stocks can teach new investors about market dynamics, risk management, and fundamental analysis.

Disadvantages

  1. Extreme Volatility: Penny stocks under 10 Rs can swing 10-20% in a single day, leading to significant losses for unprepared investors.

  2. Low Liquidity: Many penny stocks have very thin trading volumes. You may not be able to sell when you want to, or you may have to accept a much lower price.

  3. Price Manipulation Risk: Due to low volumes and limited oversight, penny stocks are susceptible to "pump and dump" schemes where manipulators artificially inflate prices before selling.

  4. Limited Information: Unlike large-cap companies, penny stock companies often have limited financial reporting, minimal analyst coverage, and less regulatory scrutiny.

  5. Fraud Risk: Some penny stock companies may have questionable business practices, inflated revenue claims, or undisclosed liabilities.

  6. No Dividend Income: Most penny stock companies don't pay dividends, so your only return comes from price appreciation—if it happens.


Is It a Good Idea to Buy Penny Stocks Under 10 Rs?

Investing in penny stocks under 10 Rs in the Indian stock markets is highly speculative and risky. These stocks often come from small or distressed companies with limited track records. Their low prices might seem attractive, but they are also prone to high volatility and low liquidity.

Due to less regulatory oversight, these stocks can be more susceptible to price manipulation. Therefore, while the potential for high returns exists, the chances of significant losses are also high. Investors need to conduct thorough research and exercise extreme caution.

Important Guidelines:

  • Never invest more than 5-10% of your total portfolio in penny stocks
  • Diversify across multiple penny stocks rather than concentrating in one
  • Always verify financial statements independently
  • Set strict stop-losses and stick to them
  • Consult a financial advisor before making investment decisions
  • Penny stocks are generally more suitable for experienced investors with a high risk tolerance

Key Financial Metrics for Evaluating Penny Stocks Under 10 Rs

Before considering any penny stock, you should evaluate these fundamental metrics using MarketXLS:

1. Current Share Price

The starting point for any penny stock analysis is the current price:

=Last("SYMBOL.NS")

For NSE-listed penny stocks, append .NS to the ticker symbol. This gives you the real-time last traded price.

2. Price-to-Earnings (P/E) Ratio

The P/E ratio tells you how much investors are willing to pay per rupee of earnings:

=PERatio("SYMBOL.NS")

How to Interpret P/E for Penny Stocks:

  • P/E below 10: Potentially undervalued, but check if earnings are sustainable
  • P/E 10-20: Reasonable valuation for a growing small company
  • P/E above 50: Overvalued or speculative—proceed with extreme caution
  • Negative P/E: Company is losing money—highest risk category

3. Market Capitalization

Market cap helps you understand the company's total size:

=MarketCapitalization("SYMBOL.NS")

Market Cap Categories for Indian Penny Stocks:

  • Below ₹50 Cr: Nano-cap—extremely risky, minimal institutional interest
  • ₹50-200 Cr: Micro-cap—very risky but more established
  • ₹200-500 Cr: Small micro-cap—somewhat more stable
  • Above ₹500 Cr: May not be a true penny stock even if price is below ₹10

4. Revenue

Revenue tells you whether the company has a real business generating income:

=Revenue("SYMBOL.NS")

Why Revenue Matters for Penny Stocks: A penny stock company with zero or declining revenue is essentially a speculative bet on future potential. Companies with growing revenue at least demonstrate a functioning business model.

5. Revenue Growth

=RevenueGrowth("SYMBOL.NS")

Positive revenue growth over multiple years suggests the company is genuinely expanding, not just riding a one-time event.

6. Dividend Information

Most penny stocks don't pay dividends, but checking is worthwhile:

=DividendYield("SYMBOL.NS")
=DividendPerShare("SYMBOL.NS")

A penny stock that pays a dividend demonstrates financial stability and shareholder focus—a rare and positive sign.


How to Use MarketXLS to Screen and Analyze Penny Stocks Under 10 Rs

Step 1: Setting Up MarketXLS

  1. Install MarketXLS: Ensure you have the MarketXLS add-in properly installed and licensed on your Excel application.
  2. Log in: Log into MarketXLS with your account credentials.

Step 2: Building Your Penny Stock Screening Spreadsheet

Create a spreadsheet with candidate penny stocks and pull key data for each:

====================================
Penny Stock Under 10 Rs Analysis
====================================

Stock Symbol   | Price          | P/E Ratio         | Market Cap              | Revenue              | Revenue Growth
SYMBOL1.NS     | =Last("X.NS") | =PERatio("X.NS")  | =MarketCapitalization("X.NS") | =Revenue("X.NS") | =RevenueGrowth("X.NS")
SYMBOL2.NS     | =Last("Y.NS") | =PERatio("Y.NS")  | =MarketCapitalization("Y.NS") | =Revenue("Y.NS") | =RevenueGrowth("Y.NS")
SYMBOL3.NS     | =Last("Z.NS") | =PERatio("Z.NS")  | =MarketCapitalization("Z.NS") | =Revenue("Z.NS") | =RevenueGrowth("Z.NS")

Step 3: Using the MarketXLS Screener

MarketXLS has a powerful stock screener that can be accessed directly from Excel or via the MarketXLS website:

  1. Access the Screener:

    • From Excel: Click on the "Screener" tab in the MarketXLS menu.
    • From the Website: Go to the stock screener section through the features tab on MarketXLS.
  2. Set Up the Screener for Penny Stocks Under 10 Rs:

    • Choose Exchange: Select "NSE" as your preferred exchange.
    • Price Filter: Set the price criteria to filter stocks priced under ₹10.
    • Volume Filter: Add a minimum daily volume filter (e.g., 10,000+ shares) to ensure basic liquidity.
    • Market Cap Filter: Optionally filter by market capitalization range.
    • Other Criteria: Add additional filters such as P/E ratio, revenue growth, etc.
  3. Save and Run Screen:

    • After setting up your criteria, save your filter.
    • Run the screener to get a list of stocks that meet your criteria.

Step 4: Deep-Dive Analysis for Each Candidate

For each penny stock that passes your screening criteria, perform a comprehensive analysis:

====================================
Deep-Dive Analysis: [SYMBOL].NS
====================================

PRICE & VALUATION
-----------------
Current Price:     =Last("SYMBOL.NS")
P/E Ratio:         =PERatio("SYMBOL.NS")
Market Cap:        =MarketCapitalization("SYMBOL.NS")

REVENUE & GROWTH
-----------------
Revenue:           =Revenue("SYMBOL.NS")
Revenue Growth:    =RevenueGrowth("SYMBOL.NS")
Revenue Per Share: =RevenuePerShare("SYMBOL.NS")

DIVIDENDS
---------
Dividend Yield:    =DividendYield("SYMBOL.NS")
Dividend/Share:    =DividendPerShare("SYMBOL.NS")

TECHNICAL INDICATORS
--------------------
RSI (14-day):      =RSI("SYMBOL.NS")
SMA 50-Day:        =SimpleMovingAverage("SYMBOL.NS", 50)
SMA 200-Day:       =SimpleMovingAverage("SYMBOL.NS", 200)

Step 5: Technical Analysis Signals

Technical indicators help you time your entry and exit points:

=RSI("SYMBOL.NS")

RSI Interpretation for Penny Stocks:

  • RSI above 70: Overbought—potential for pullback
  • RSI between 30-70: Normal range
  • RSI below 30: Oversold—potential bounce, but verify fundamentals first
=SimpleMovingAverage("SYMBOL.NS", 50)
=SimpleMovingAverage("SYMBOL.NS", 200)

Moving Average Signals:

  • Price above 50-day SMA: Short-term uptrend
  • 50-day SMA above 200-day SMA (Golden Cross): Bullish signal
  • Price below both SMAs: Downtrend—avoid or exit

Step 6: Creating Watchlists

To keep track of your screened penny stocks:

  • Use the MarketXLS Watchlist feature to create a custom watchlist
  • Save selected stocks on the website
  • Import to Excel for ongoing analysis with real-time functions

Penny Stock Under 10 Rs: Evaluation Framework

Use this scoring framework to compare penny stocks systematically:

Evaluation CriteriaWeightGreen Flag (Score 3)Yellow Flag (Score 2)Red Flag (Score 1)
P/E Ratio20%P/E 5-15 (profitable)P/E 15-30Negative or P/E > 50
Revenue Growth20%Growing 15%+ annuallyGrowing 0-15%Declining revenue
Market Cap15%₹200+ Cr₹50-200 CrBelow ₹50 Cr
Trading Volume15%50,000+ daily shares10,000-50,000Below 10,000
Dividend History10%Pays regular dividendsOccasional dividendNo dividends ever
RSI Signal10%30-60 (healthy)60-70 or 20-30Above 70 or below 20
Revenue Existence10%Positive and growingPositive but flatZero or unverifiable

Scoring:

  • 18-21 points: Worth deeper research
  • 12-17 points: Proceed with caution, significant risks
  • Below 12 points: Too risky for most investors

Common Risks and Red Flags in Penny Stocks Under 10 Rs

Red Flag 1: Zero or Unverifiable Revenue

=Revenue("SYMBOL.NS")

If this returns zero or an extremely small number relative to market cap, the company may not have a viable business. This is the most common trap in penny stock investing.

Red Flag 2: Sudden Volume Spikes Without News

A penny stock that suddenly sees 10-50x its normal trading volume without any corresponding news announcement is a classic sign of potential manipulation. Compare current volume to historical averages.

Red Flag 3: Extremely High P/E Ratio

=PERatio("SYMBOL.NS")

A P/E ratio above 100 for a penny stock means the market is pricing in extraordinary growth that is extremely unlikely to materialize. This often indicates speculation rather than fundamental value.

Red Flag 4: No Institutional Holdings

If no mutual funds, insurance companies, or institutional investors hold the stock, it suggests that professional analysts have evaluated and rejected it.

Red Flag 5: Frequent Promoter Pledging

If company promoters have pledged a large percentage of their shares as collateral for loans, it suggests financial stress at the promoter level.


How Penny Stocks Under 10 Rs Compare to Other Investment Options

Investment TypeMinimum InvestmentRisk LevelPotential ReturnLiquiditySuitable For
Penny Stocks Under 10 Rs₹100-1,000Very HighVery High (or total loss)LowExperienced, high-risk investors
Small-Cap Mutual Funds₹500 (SIP)HighHighModerateGrowth-oriented investors
Index Funds (Nifty 50)₹500 (SIP)ModerateModerate (10-12% avg)HighAll investors
Fixed Deposits₹1,000Very LowLow (6-7%)Low (locked)Conservative investors
Gold ETFs₹500Low-ModerateModerateHighDiversification seekers
Government Bonds₹10,000Very LowLow-Moderate (7-8%)ModerateIncome seekers

Building a Penny Stock Monitoring Dashboard in Excel

Here's the complete MarketXLS template for monitoring your penny stock watchlist:

====================================================
Penny Stocks Under 10 Rs - Monitoring Dashboard
====================================================

WATCHLIST OVERVIEW
------------------
Stock 1: =Last("A.NS") | PE: =PERatio("A.NS") | MCap: =MarketCapitalization("A.NS") | Rev: =Revenue("A.NS")
Stock 2: =Last("B.NS") | PE: =PERatio("B.NS") | MCap: =MarketCapitalization("B.NS") | Rev: =Revenue("B.NS")
Stock 3: =Last("C.NS") | PE: =PERatio("C.NS") | MCap: =MarketCapitalization("C.NS") | Rev: =Revenue("C.NS")
Stock 4: =Last("D.NS") | PE: =PERatio("D.NS") | MCap: =MarketCapitalization("D.NS") | Rev: =Revenue("D.NS")
Stock 5: =Last("E.NS") | PE: =PERatio("E.NS") | MCap: =MarketCapitalization("E.NS") | Rev: =Revenue("E.NS")

TECHNICAL SIGNALS
-----------------
Stock 1: RSI: =RSI("A.NS") | SMA50: =SimpleMovingAverage("A.NS", 50)
Stock 2: RSI: =RSI("B.NS") | SMA50: =SimpleMovingAverage("B.NS", 50)
Stock 3: RSI: =RSI("C.NS") | SMA50: =SimpleMovingAverage("C.NS", 50)

FUNDAMENTAL GROWTH
------------------
Stock 1: Rev Growth: =RevenueGrowth("A.NS") | Div Yield: =DividendYield("A.NS")
Stock 2: Rev Growth: =RevenueGrowth("B.NS") | Div Yield: =DividendYield("B.NS")
Stock 3: Rev Growth: =RevenueGrowth("C.NS") | Div Yield: =DividendYield("C.NS")

MarketXLS Templates for Indian Stock Analysis

MarketXLS offers ready-made templates specifically designed for Indian market analysis:

NSE Stocks Live Tracking Template

This template provides real-time tracking of NSE-listed stocks with automated data feeds:

The template includes:

  • Real-time price updates using =Last() and =Stream_Last()
  • Fundamental data columns (P/E, market cap, revenue)
  • Technical indicator columns (RSI, moving averages)
  • Custom watchlist functionality

MarketXLS has hundreds of templates to get you started quickly, saving hours of manual data collection and spreadsheet setup.


Frequently Asked Questions About Penny Stocks Under 10 Rs

Are penny stocks under 10 Rs safe to invest in?

Penny stocks under 10 Rs are among the riskiest investments in the Indian stock market. They are prone to extreme volatility, low liquidity, price manipulation, and limited financial transparency. While the potential for high returns exists, the probability of significant losses is equally high. Always use MarketXLS functions like =PERatio("SYMBOL.NS") and =Revenue("SYMBOL.NS") to verify fundamentals before investing, and never allocate more than 5-10% of your portfolio to penny stocks.

How do I find penny stocks under 10 Rs on the NSE?

You can use the MarketXLS stock screener to filter NSE-listed stocks priced below ₹10. Set the exchange to NSE, price filter under ₹10, and add minimum volume requirements (10,000+ daily shares). Then import the results into Excel and analyze each stock using =Last("SYMBOL.NS"), =MarketCapitalization("SYMBOL.NS"), and =RevenueGrowth("SYMBOL.NS") to separate potentially viable companies from pure speculation.

What is a good P/E ratio for penny stocks under 10 Rs?

A P/E ratio between 5 and 15 is generally considered favorable for penny stocks under 10 Rs, as it suggests the company is profitable and not wildly overvalued. Use =PERatio("SYMBOL.NS") to check. A negative P/E means the company is losing money (high risk), while a P/E above 50 suggests speculative pricing. However, P/E alone is not sufficient—always cross-reference with revenue (=Revenue("SYMBOL.NS")) and market cap (=MarketCapitalization("SYMBOL.NS")).

Can penny stocks under 10 Rs become multibaggers?

Yes, some penny stocks have historically become multibaggers, delivering 5x, 10x, or even 100x returns over several years. However, for every success story, hundreds of penny stocks have gone to zero or been delisted. The key is identifying companies with genuine revenue growth (=RevenueGrowth("SYMBOL.NS")), reasonable valuations (=PERatio("SYMBOL.NS")), and increasing market capitalization (=MarketCapitalization("SYMBOL.NS")). Diversifying across multiple carefully screened penny stocks improves your odds.

How much money should I invest in penny stocks under 10 Rs?

Financial experts generally recommend allocating no more than 5-10% of your total investment portfolio to highly speculative investments like penny stocks under 10 Rs. This means if your total portfolio is ₹10 lakh, your maximum penny stock allocation should be ₹50,000-₹1,00,000. Within that allocation, diversify across 10-20 stocks rather than concentrating in one or two. Always consult a registered financial advisor for personalized guidance.

What is the difference between NSE and BSE penny stocks?

Both the NSE (National Stock Exchange) and BSE (Bombay Stock Exchange) list penny stocks under 10 Rs. NSE generally has stricter listing requirements and higher liquidity, making it the preferred exchange for most retail investors. BSE has more total listings, including many smaller companies. Some penny stocks are listed on both exchanges (dual-listed), while others are on only one. Use MarketXLS to analyze stocks from either exchange by appending .NS (NSE) or .BO (BSE) to the ticker symbol.


Summary

Penny stocks under 10 Rs in the Indian market represent a high-risk, high-potential-reward segment that requires careful analysis and disciplined risk management. The key to successful penny stock investing is thorough fundamental analysis—not tips, rumors, or social media recommendations.

Using MarketXLS, you can bring professional-grade analysis to penny stock evaluation:

  • Price verification: =Last("SYMBOL.NS") for real-time pricing
  • Valuation analysis: =PERatio("SYMBOL.NS") for earnings-based valuation
  • Size assessment: =MarketCapitalization("SYMBOL.NS") for company scale
  • Business viability: =Revenue("SYMBOL.NS") and =RevenueGrowth("SYMBOL.NS") for business health
  • Technical timing: =RSI("SYMBOL.NS") and =SimpleMovingAverage("SYMBOL.NS", 50) for entry/exit signals
  • Income potential: =DividendYield("SYMBOL.NS") for rare dividend-paying penny stocks

Remember: no analytical tool can eliminate the inherent risks of penny stock investing. Always invest responsibly, diversify your holdings, set strict stop-losses, and never invest money you cannot afford to lose.


Ready to analyze Indian penny stocks with professional-grade tools? Explore MarketXLS pricing plans and access 1,100+ Excel functions for fundamental analysis, technical indicators, and stock screening—including full NSE and BSE coverage.

Important Disclaimer

The information provided in this article is for educational and informational purposes only and should not be construed as investment advice, a recommendation, or an offer to buy or sell any securities. MarketXLS is a financial data platform and is not a registered investment advisor, broker-dealer, or financial planner. Always conduct your own research and consult with a qualified financial professional before making any investment decisions. Past performance is not indicative of future results. Trading and investing involve substantial risk of loss.

Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
I agree to the MarketXLS Terms and Conditions
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement "your own" investment strategies in Excel with thousands of MarketXLS functions and templates.
I use MarketXLS to manage my personal portfolio. I can easily pull in stock quotes, betas, and dividends. I also like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance, Penn State University

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel.

Lloyd L.

Professional Trader

I can now concentrate on manipulating financial data, valuing stocks and making investment decisions, rather than hacking around with VBA or copying and pasting data from websites.

Samir Khan

InvestExcel.net

I have been using MarketXLS for the last 6+ years and they really enhanced the product every year.

Kirubakaran K.

Investment Professional

I Love My MarketXLS. The market speaks to you when you know how to listen. With MarketXLS, the market truly does speak. Patterns emerge. Pricing behavior becomes clearer.

Don Zelezny

Entrepreneur & Options Trader

Meet The Ultimate Excel Solution for Investors

Live Streaming Prices in your Excel
All historical (intraday) data in your Excel
Real time option greeks and analytics in your Excel
Leading data service for Investment Managers, RIAs, Asset Managers
Easy to use with formulas and pre-made sheets