Download the Template
Get a ready-to-use Excel stock price template for Indian stocks with live data formulas pre-built.
Download Free Template (.xlsx)
Requires: MarketXLS India subscription (starts at ₹3,500/month) + Zerodha or Angel One account.
What Is Inside the Template
The template has three sheets, each fully pre-built with MarketXLS India formulas:
Sheet 1: Stock Price Tracker
A watchlist of 15 top NSE stocks plus Nifty 50 and Bank Nifty indices. Every cell streams live data from your Zerodha account.
Columns included:
| Column | Data | Formula Used |
|---|---|---|
| Last Price | Live traded price | =mxlsIN.ZerodhaLast("RELIANCE:IN") |
| Open | Day opening price | =mxlsIN.ZerodhaOpen("RELIANCE:IN") |
| High | Day high | =mxlsIN.ZerodhaHigh("RELIANCE:IN") |
| Low | Day low | =mxlsIN.ZerodhaLow("RELIANCE:IN") |
| Prev Close | Previous day close | =mxlsIN.ZerodhaPreviousClose("RELIANCE:IN") |
| Change | Price change | =mxlsIN.ZerodhaChange("RELIANCE:IN") |
| Volume | Traded volume | =mxlsIN.ZerodhaVolume("RELIANCE:IN") |
| Buy Qty | Total buy quantity | =mxlsIN.ZerodhaBuyQuantity("RELIANCE:IN") |
| Sell Qty | Total sell quantity | =mxlsIN.ZerodhaSellQuantity("RELIANCE:IN") |
| Last Trade Time | Timestamp of last trade | =mxlsIN.ZerodhaLastTradeTime("RELIANCE:IN") |
Pre-loaded stocks: Reliance, TCS, HDFC Bank, Infosys, ICICI Bank, Hindustan Unilever, SBI, Bharti Airtel, Tata Motors, L&T, Bajaj Finance, Axis Bank, Maruti Suzuki, Wipro, Adani Enterprises.
Pre-loaded indices: Nifty 50, Bank Nifty.
To add your own stocks, copy any row and change the symbol in column B. All formulas reference the symbol cell, so they update automatically.
Sheet 2: Portfolio Tracker
Enter your holdings and the template calculates live P&L.
What you fill in:
- Symbol — the NSE ticker (e.g., RELIANCE)
- Qty — number of shares you own
- Buy Price — your average purchase price
What the template calculates automatically:
| Metric | How It Works |
|---|---|
| Invested Amount | Qty × Buy Price |
| Live Price | =mxlsIN.ZerodhaLast(Symbol&":IN") — streams from your broker |
| Current Value | Qty × Live Price |
| P&L (₹) | Current Value − Invested |
| P&L (%) | P&L ÷ Invested |
| Day Change | Live Price − =mxlsIN.ZerodhaPreviousClose(Symbol&":IN") |
Portfolio summary section at the bottom gives you:
- Total invested
- Total current value
- Total P&L
- Overall return percentage
- Today's P&L
The template comes pre-loaded with 8 sample holdings (Reliance, TCS, HDFC Bank, Infosys, Tata Motors, SBI, ICICI Bank, Bajaj Finance). Replace these with your actual holdings.
Sheet 3: Nifty Option Chain with Greeks
A live option chain for Nifty with 11 strikes (5 above ATM, ATM, 5 below ATM) and real-time Greeks.
Reference data (auto-detected):
Nifty Spot: =mxlsIN.ZerodhaLast("NIFTY:IN")
Next Expiry: =mxlsIN.ExpirationNext("NIFTY:IN")
ATM Strike: =mxlsIN.StrikeNext("NIFTY:IN")
For each strike, the template shows:
| Column | Formula |
|---|---|
| Option Symbol | =mxlsIN.OptionSymbol("NIFTY", ExpiryCell, "C", StrikeCell) |
| Last Price | =mxlsIN.ZerodhaLast(OptionSymbol&":IN") |
| Open Interest | =mxlsIN.ZerodhaOpenInterest(OptionSymbol&":IN") |
| OI Day High | =mxlsIN.ZerodhaOpenInterestDayHigh(OptionSymbol&":IN") |
| Delta | =mxlsIN.opt_Delta(Spot, Premium, Expiry, "C", Strike) |
| Gamma | =mxlsIN.opt_Gamma(Spot, Premium, Expiry, "C", Strike) |
| Vega | =mxlsIN.opt_Vega(Spot, Premium, Expiry, "C", Strike) |
| Implied Volatility | =mxlsIN.opt_ImpliedVolatility(Spot, Premium, Expiry, "C", Strike) |
The expiry and ATM strike update automatically each week. No need to manually change anything when a new expiry rolls in.
To switch to Bank Nifty: Replace "NIFTY" with "BANKNIFTY" in the reference cells and the option chain formulas. Adjust the strike interval from 50 to 100.
To view Puts: Change "C" to "P" in the OptionSymbol and Greeks formulas.
Sheet 4: Instructions & Formula Reference
A complete reference of every MarketXLS India formula with descriptions. Keep this sheet as a cheat sheet while you build your own analysis.
How to Set Up the Template
Step 1: Subscribe to MarketXLS India
Visit marketxls.com/stock-data-excel-plugin-india and choose a plan:
- Monthly: ₹3,500/month
- Annual: ₹30,000/year (₹2,500/month effective)
Step 2: Install the MarketXLS Add-in
Open Excel → Insert → Get Add-ins → Search for MarketXLS → Click Add.
The add-in works on:
- Windows (Excel 2016+)
- Mac (Excel 2016+)
- Excel Online (Office 365)
Step 3: Connect Your Broker
Open the MarketXLS panel in Excel and log in with your Zerodha or Angel One credentials. The connection uses secure OAuth — your password is never stored.
Step 4: Open the Template
Open the downloaded .xlsx file. Once your broker connection is active, all formulas start streaming live data automatically.
Using with Angel One Instead of Zerodha
The template ships with Zerodha formulas by default. To switch to Angel One, replace Zerodha with AngelOne in every formula:
| Zerodha | Angel One |
|---|---|
mxlsIN.ZerodhaLast | mxlsIN.AngelOneLast |
mxlsIN.ZerodhaOpen | mxlsIN.AngelOneOpen |
mxlsIN.ZerodhaHigh | mxlsIN.AngelOneHigh |
mxlsIN.ZerodhaLow | mxlsIN.AngelOneLow |
mxlsIN.ZerodhaPreviousClose | mxlsIN.AngelOnePreviousClose |
mxlsIN.ZerodhaVolume | mxlsIN.AngelOneVolume |
mxlsIN.ZerodhaBuyQuantity | mxlsIN.AngelOneBuyQuantity |
mxlsIN.ZerodhaSellQuantity | mxlsIN.AngelOneSellQuantity |
The symbol format (RELIANCE:IN), option functions (ExpirationNext, StrikeNext, OptionSymbol), and Greeks functions (opt_Delta, opt_Gamma, opt_Vega, opt_ImpliedVolatility) work the same with both brokers.
Tip: Use Excel's Find & Replace (Ctrl+H) to replace all instances of Zerodha with AngelOne across the entire workbook in one step.
Customising the Template
Add More Stocks
- Right-click on the last stock row in Sheet 1
- Insert a new row
- Enter the NSE symbol in column B (e.g., HCLTECH)
- Copy formulas from the row above — they reference column B automatically
Track Futures
Use the futures symbol builder to add Nifty or Bank Nifty futures:
=mxlsIN.futureSymbol("NIFTY", "2026-03-27")
Then use ZerodhaLast, ZerodhaVolume, and ZerodhaOpenInterest with the generated symbol.
Add More Option Strikes
Copy the last row in the Option Chain sheet, then adjust the strike offset formula. Each row independently builds its own option symbol and calculates Greeks.
Why Use This Template Instead of Building Your Own
You could build a stock tracker from scratch — our step-by-step guides cover building a portfolio tracker, setting up a live Greeks calculator, and creating an intraday trading dashboard. But this template saves you time:
- Pre-formatted with branded headers, alternating row colors, and proper column widths
- Pre-loaded with 15 high-liquidity NSE stocks and 2 major indices
- Portfolio sheet with summary formulas already wired up
- Option chain with Greeks — the most complex part — already built
- Instructions sheet so you (or your team) can reference formulas without leaving Excel
- Works immediately once you connect your broker
Frequently Asked Questions
Is the template really free?
Yes, the .xlsx file is free to download. However, the formulas inside require an active MarketXLS India subscription (starts at ₹3,500/month) and a Zerodha or Angel One broker account to stream live data.
Does it work on Mac?
Yes. MarketXLS India works on Windows, Mac, and Excel Online. This is the only Indian stock market Excel plugin that supports Mac.
Can I share this template with others?
Yes. Share the file with anyone. They will need their own MarketXLS subscription and broker account for the formulas to work.
What happens outside market hours?
The template shows the last traded prices from the previous session. When the market opens at 9:15 AM IST, streaming resumes automatically.
Can I add BSE stocks?
The :IN suffix works for both NSE and BSE listed stocks. Use the same symbol format.
Download Now
Download Free Template (.xlsx)
Not sure if MarketXLS India is right for you? Read our honest comparison of the best Excel plugins for Indian stocks.
Subscribe to MarketXLS India → to activate the live data formulas. Starts at ₹3,500/month. Cancel anytime.
