Nifty 50 Stock List: Complete Guide to India's Benchmark Index (With Excel Tracking)

The Nifty 50 is the National Stock Exchange of India's benchmark index of 50 large, liquid Indian companies, weighted by free-float market capitalization; Financial Services is its largest sector. The list below groups the constituents by sector as of this article's last update, and a PDF of the list with MarketXLS symbols is available. The composition changes at each semi-annual review, so confirm the current list on NSE Indices. For tracking Indian stocks in Excel, MarketXLS serves India through marketxls.in, with live data through broker connections such as Zerodha and Angel One.

See it in actionMarketXLS video

The full MarketXLS demo

Watch full demoBook a demo

Try it in your own spreadsheet

Get the free MarketXLS sample workbook (.xlsx).

Email address

Download free workbook

No account needed. MarketXLS live data requires a paid plan. Preview workbook

Explore more videos +

IntroductionHistorical DataOptions DataUse-cases

What Is the Nifty 50 Index?

The Nifty 50, officially known as the NIFTY 50, is a stock market index managed by NSE Indices Limited (formerly India Index Services & Products Limited, or IISL). It was launched on April 22, 1996, with a base date of November 3, 1995, and a base value of 1,000. The index represents approximately 66% of the free-float market capitalization of all stocks listed on the NSE.

Key Facts About the Nifty 50

The Nifty 50 serves multiple purposes: it acts as a benchmark for portfolio performance, underlies derivatives trading (Nifty futures and options are among the most traded contracts globally), and serves as the basis for numerous index funds and ETFs both in India and internationally.

Complete Nifty 50 Stock List by Sector

The list below groups Nifty 50 constituents by sector. Index composition changes at each semi-annual review, so companies may have been added or removed since this list was compiled; verify the current list on NSE Indices.

Financial Services (Largest Sector Weight)

Financial Services is the dominant sector in the Nifty 50, typically accounting for over 30% of the index weight.

Information Technology

Oil, Gas & Energy

Consumer Goods

Automobile

Metals & Mining

Pharmaceuticals & Healthcare

Cement & Construction

Telecom

Diversified / Other Sectors

Note: All symbols in MarketXLS carry the ":IN" suffix to distinguish Indian stock symbols from US market symbols. Use the MarketXLS Symbol Lookup feature in Excel to find any Indian stock.

Nifty 50 Sector Weightage Breakdown

Understanding sector allocation helps investors grasp the index's exposure and potential risks.

Financial Services dominates the Nifty 50, meaning the index is heavily influenced by banking and financial sector performance. This is an important consideration for portfolio diversification.

How the Nifty 50 Index Is Calculated

The Nifty 50 uses the free-float market capitalization weighted methodology. Here is the formula:

Index Value = (Current Total Free-Float Market Cap of 50 Stocks / Base Market Cap) × Base Value (1,000)

Key terms:

• Free-float market capitalization: Only shares available for public trading are counted (excludes promoter holdings, government holdings, and strategic investments)
• Base market cap: The total free-float market cap on the base date (November 3, 1995)
• Investable Weight Factor (IWF): Applied to each stock to account for shares not available for trading

Eligibility Criteria for Nifty 50 Inclusion

For a stock to be included in the Nifty 50, it must meet these criteria:

1. Domicile: Must be listed on the NSE
2. Liquidity: Must have traded at an average impact cost of 0.50% or less during the last six months for 90% of observations
3. Float-adjusted market cap: Should be at least 1.5 times the smallest constituent
4. Listing history: Minimum 1 month of listing
5. Derivatives availability: Must be available for trading in the F&O segment
6. Differential Voting Rights (DVR): Eligible for inclusion

The index is reviewed semi-annually by the Index Maintenance Sub-Committee of NSE Indices.

Nifty 50 vs. Other Global Indices

How to Track Nifty 50 Stocks in Excel Using MarketXLS

A Nifty 50 tracker in Excel is one row per stock with MarketXLS formulas for price, valuation, and dividends. Indian market data is offered through marketxls.in; function availability and symbol format for Indian stocks can differ from the US product, so confirm them with MarketXLS India before building the full sheet.

Step 1: Get Current Stock Prices

Use the =Last() function to pull the latest price for any Nifty 50 stock:

=Last("RELIANCE:IN")
=Last("TCS:IN")
=Last("HDFCBANK:IN")

Formula documentation: Last

This returns the last traded price in Indian Rupees. Put all 50 symbols in one column and =Last() in the next to build a price dashboard.

Step 2: Pull Fundamental Data

For valuation analysis, use these MarketXLS formulas:

PE Ratio:

=PERatio("INFY:IN")
=PERatio("RELIANCE:IN")

Formula documentation: PERatio

Market Capitalization:

=MarketCapitalization("TCS:IN")
=MarketCapitalization("HDFCBANK:IN")

Formula documentation: MarketCapitalization

Dividend Yield:

=DividendYield("ITC:IN")
=DividendYield("COALINDIA:IN")

Formula documentation: DividendYield

Earnings Per Share:

=EarningsPerShare("SBIN:IN")

Formula documentation: EarningsPerShare

Revenue:

=Revenue("RELIANCE:IN")

Formula documentation: Revenue

Step 3: Add Sector and Industry Classification

MarketXLS can automatically classify stocks:

=Sector("HDFCBANK:IN")
=Industry("HDFCBANK:IN")

Formula documentation: Sector, Industry

This allows you to build pivot tables and sector-level analysis directly in Excel.

Step 4: Build a Complete Nifty 50 Dashboard

Here is a suggested layout for your Excel tracker:

Step 5: Track Historical Performance

For historical fundamental data, use the hf_ family of functions:

=hf_revenue("RELIANCE:IN", "2024", "2")
=hf_netIncome("TCS:IN", "ly")
=hf_eps("INFY:IN", "lq")

Formula documentation: hf_revenue, hf_eps

The "ly" parameter returns the last reported year, "lq" returns the last reported quarter, and "lt" returns the trailing 12 months — so your spreadsheet updates automatically when new filings are released.

Screening Nifty 50 Stocks by Fundamental Criteria

You can screen Nifty 50 stocks in Excel by applying filters to the formula columns:

Value Screen (Low PE, High Dividend)

Set up conditional formatting or filters where:

• =PERatio(symbol) < 20
• =DividendYield(symbol) > 2%

Quality Screen (High ROE, Strong Margins)

=ReturnOnEquity("TCS:IN")
=GrossMargin("HINDUNILVR:IN")
=OperatingMargin("INFY:IN")
=ProfitMargin("HDFCBANK:IN")

Formula documentation: ReturnOnEquity, GrossMargin, OperatingMargin, ProfitMargin

Growth Screen (Revenue and Earnings Growth)

=RevenueGrowth("BAJFINANCE:IN")

Formula documentation: RevenueGrowth

You can combine these into a scoring model where each stock receives points based on how it ranks across value, quality, and growth metrics.

Methods for Investing in the Nifty 50

Understanding Nifty 50 Weightage and Rebalancing

The semi-annual rebalancing can create significant trading activity. When a stock is added to or removed from the Nifty 50:

• Additions often see price appreciation as index funds buy the stock
• Removals may experience selling pressure as index funds liquidate positions
• Weight changes cause proportional buying or selling by passive funds

Tracking these changes using MarketXLS in Excel allows you to anticipate portfolio adjustments and understand market cap movements over time.

Historical Performance of the Nifty 50

Approximate historical returns for the Nifty 50 (not verified against a current source; check NSE Indices for exact figures):

These returns are in INR terms and do not account for dividends. With dividends reinvested (Nifty 50 Total Return Index), returns are approximately 1.5–2% higher annually.

Disclaimer: Past performance does not guarantee future results. These figures are approximate and for educational purposes only.

Key Risks of Investing in Nifty 50 Stocks

1. Sector Concentration: Heavy financial services weighting (30%+) means banking sector downturns significantly impact the index
2. Currency Risk: For international investors, INR depreciation can erode returns
3. Regulatory Risk: Changes in Indian government policies can affect specific sectors
4. Liquidity: While Nifty 50 stocks are among the most liquid in India, they may still have wider spreads compared to S&P 500 stocks
5. Geopolitical Risk: Regional tensions can cause volatility
6. Valuation Risk: Indian markets sometimes trade at premium valuations compared to other emerging markets

Download the Nifty 50 Stock List PDF

You can download the complete Nifty 50 stock list with MarketXLS symbols as a PDF:

Download Nifty 50 Stock List PDF

This PDF includes all 50 stocks with their NSE symbols, MarketXLS symbols (with :IN suffix), sector classification, and industry details.

Using MarketXLS Symbol Lookup for Indian Stocks

MarketXLS includes a built-in Symbol Lookup feature that makes finding Indian stocks easy:

1. Open Excel with MarketXLS installed
2. Use the Symbol Lookup from the MarketXLS ribbon
3. Search for any company name or partial symbol
4. The tool returns the correct MarketXLS symbol with the ":IN" suffix

This works for all Nifty 50 stocks as well as Bank Nifty, Nifty Next 50, and other NSE indices.

Frequently Asked Questions

What is the Nifty 50 Stock List?

The Nifty 50 Stock List is the collection of 50 large-cap companies that make up India's benchmark stock market index on the National Stock Exchange. These companies represent 13 sectors and approximately 66% of NSE's total free-float market capitalization.

How often does the Nifty 50 stock list change?

The Nifty 50 is reviewed semi-annually by the Index Maintenance Sub-Committee of NSE Indices. Stocks can be added or removed based on eligibility criteria including liquidity, market capitalization, and trading frequency.

Can I track Nifty 50 stocks in Excel?

Yes. With MarketXLS, you can track all 50 stocks directly in Microsoft Excel. Use formulas like =Last("RELIANCE:IN") for prices, =PERatio("TCS:IN") for valuations, and =DividendYield("ITC:IN") for income analysis. All Indian stocks use the ":IN" suffix in MarketXLS.

What is the difference between Nifty 50 and Sensex?

The Nifty 50 comprises 50 stocks listed on the NSE, while the BSE Sensex comprises 30 stocks listed on the Bombay Stock Exchange. Both are free-float market cap weighted indices, but the Nifty 50 has broader representation due to its larger constituent count.

Which sector has the highest weight in the Nifty 50?

Financial Services has the highest weight in the Nifty 50, typically accounting for 32–35% of the total index weight. This includes banks, NBFCs, insurance companies, and other financial institutions.

How do I use MarketXLS to analyze Nifty 50 stocks?

Get MarketXLS for India through marketxls.in, then use formulas like =Last("symbol:IN"), =PERatio("symbol:IN"), =MarketCapitalization("symbol:IN"), and =DividendYield("symbol:IN") with any Nifty 50 stock symbol. You can build comprehensive dashboards, screening tools, and tracking spreadsheets entirely within Excel.

Technical Analysis Complement for Nifty 50 Stocks

While fundamental analysis tells you what to buy, technical indicators can help with timing. MarketXLS provides technical functions that complement your Nifty 50 tracking:

=RSI("RELIANCE:IN")
=SimpleMovingAverage("TCS:IN", 50)
=SimpleMovingAverage("HDFCBANK:IN", 200)
=Volume("INFY:IN")

Formula documentation: RSI, SimpleMovingAverage, Volume

Combining fundamental screening (low PE, high dividend yield) with technical confirmation (RSI, moving averages) creates a more robust analysis framework for Nifty 50 stocks.

Dividend Analysis for Nifty 50 Income Investors

Many Nifty 50 companies pay regular dividends. These MarketXLS formulas pull the dividend fields:

=DividendYield("ITC:IN")
=DividendPerShare("COALINDIA:IN")
=DividendFrequency("POWERGRID:IN")
=PayoutRatio("NTPC:IN")

Formula documentation: DividendYield, DividendPerShare, DividendFrequency, PayoutRatio

High-dividend Nifty 50 stocks typically include ITC, Coal India, Power Grid Corporation, NTPC, and Hindustan Unilever. Build a dividend-focused dashboard by filtering stocks with =DividendYield() above your target threshold and checking sustainability with =PayoutRatio().

Real-Time Streaming for Active Traders

For live Nifty 50 prices, MarketXLS India (marketxls.in) connects to Indian broker feeds such as Zerodha and Angel One. The US streaming functions (QM_Stream_*) use QuoteMedia data, which covers US, Canadian, UK, German, and Australian markets, so confirm the streaming setup for NSE symbols with MarketXLS India.

Build Your Nifty 50 Tracker Today

To track the Nifty 50 in Excel, list the constituents, add a formula column for each field you need, and refresh. For Indian market plans and broker connections, see MarketXLS India.