Best Excel Plugin for Indian Stock Market: 2026 Comparison Guide

The right Excel plugin for the Indian stock market depends on your broker and setup. If you trade through Zerodha or Angel One, MarketXLS India streams live NSE and BSE prices, open interest, and option Greeks into Excel through your broker connection using formulas such as =mxlsIN.ZerodhaLast("RELIANCE:IN"), and it runs on Windows, Mac, and Excel Online. If you want a data feed independent of any broker, TrueData Velocity and NimbleExcelLite (Global Datafeeds) are Windows-based alternatives, and free VBA or web-query scrapers work only for occasional, non-real-time use.

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

This guide compares the four options on streaming, broker support, platforms, options data, setup, and pricing. MarketXLS publishes this guide; competitor details are based on their public descriptions and may change.

---

The Contenders

We are comparing four categories of solutions:

1. MarketXLS India: Excel add-in with Zerodha and Angel One integration
2. TrueData (Velocity): Dedicated data feed software
3. NimbleExcelLite (Global Datafeeds): Real-time data plugin for Excel
4. Free VBA/Web Query Solutions: DIY approaches using the NSE website

---

Quick Comparison Table

---

Detailed Comparison

1. MarketXLS India

What it is: A JavaScript-based Excel add-in that connects to your Zerodha or Angel One broker account and streams live market data into Excel cells using simple formulas.

How it works:

You type formulas like:

=mxlsIN.ZerodhaLast("RELIANCE:IN")
=mxlsIN.AngelOneLast("TATAMOTORS:IN")
=mxlsIN.ZerodhaVolume("HDFCBANK:IN")
=mxlsIN.ZerodhaOpenInterest("NIFTY23OCT24000CE:IN")

Data streams live via WebSocket from your broker connection. No DDE links, no VBA, no external software.

Strengths:

• Cross-platform: Works on Windows, Mac, and Excel Online. Of the four options compared here, it is the only one that runs on Mac
• Short setup: Install the add-in, log in to your broker, start using formulas
• Built-in option Greeks: Delta, Gamma, Vega, and Implied Volatility calculated directly in Excel:

=mxlsIN.opt_Delta(24150, 180, "2026-03-27", "C", 24200)
=mxlsIN.opt_Gamma(24150, 180, "2026-03-27", "C", 24200)
=mxlsIN.opt_Vega(24150, 180, "2026-03-27", "C", 24200)
=mxlsIN.opt_ImpliedVolatility(24150, 180, "2026-03-27", "C", 24200)

• Option utility functions: Auto-detect next expiry and nearest strike:

=mxlsIN.ExpirationNext("NIFTY:IN")
=mxlsIN.StrikeNext("NIFTY:IN")
=mxlsIN.OptionSymbol("NIFTY", ExpiryCell, "C", 24000)

• Futures symbol builder:

=mxlsIN.futureSymbol("NIFTY", "2026-03-27")

• Buy/Sell pressure data: Total buy and sell quantity:

=mxlsIN.ZerodhaBuyQuantity("RELIANCE:IN")
=mxlsIN.ZerodhaSellQuantity("RELIANCE:IN")

Limitations:

• Requires an active Zerodha or Angel One account (data comes through your broker)
• No fundamental data for Indian stocks (real-time streaming only)
• No historical data for Indian market

Best for: Traders who already use Zerodha or Angel One and want the simplest possible way to get live data in Excel. Especially strong for Mac users and those who need Greeks.

See it in action: Our step-by-step guides show what you can build: a real-time portfolio tracker, a live option Greeks calculator, and an intraday trading dashboard. Or download our free template to try the formulas yourself.

MarketXLS access: Downloading a workbook does not include live data access. Refreshing MarketXLS formulas requires a paid MarketXLS subscription.

Pricing: MarketXLS India costs ₹3,500 a month. See the India pricing page for current plans and offers.

---

2. TrueData (Velocity 2.0)

What it is: A standalone real-time data feed service that pushes NSE/BSE data into Excel using DDE (Dynamic Data Exchange) or RTL.

How it works: You install the TrueData Velocity software, which runs as a background service and pushes data into Excel via DDE links or their RTL add-in.

Strengths:

• Independent data feed; does not require a broker account
• Supports large symbol counts (200-500 symbols simultaneously)
• Historical tick data available
• MCX commodity data included in higher plans

Limitations:

• Windows only: No Mac or Excel Online support
• Requires DDE or RTL configuration, which can be complex
• Separate software running in the background
• No built-in option Greeks
• Steeper learning curve for setup

Best for: Windows-only traders who want a dedicated data feed without tying it to a broker, or those who need tick-level historical data for backtesting.

Pricing: Plans typically range from ₹1,500 to ₹3,000/month depending on features and symbol limits.

---

3. NimbleExcelLite (Global Datafeeds)

What it is: An Excel plugin from Global Datafeeds that provides real-time data for NSE F&O, NSE CDS, BSE F&O, and MCX.

How it works: The plugin installs into Excel and provides real-time data with zero delay. It includes option Greeks (IV, Delta, Theta, Vega, Gamma) and supports multiple matrices in a single call.

Strengths:

• Comprehensive exchange coverage including currency derivatives
• Built-in option Greeks (16+ matrices in single call)
• Multiple data points per symbol
• Established provider in Indian market data space

Limitations:

• Windows only: No Mac support
• Requires separate software installation and configuration
• Data feed is independent of your broker
• Setup can take 30-60 minutes
• Interface is less intuitive than formula-based approaches

Best for: Professional derivatives traders on Windows who need comprehensive exchange coverage including currency derivatives and MCX.

Pricing: Plans typically start from ₹1,500/month, varying by exchange coverage and features.

---

4. Free VBA/Web Query Solutions

What it is: DIY approaches using Excel's built-in Web Query feature or custom VBA macros that scrape data from the NSE website.

How it works: You create web queries that pull data from nseindia.com, or write VBA code that fetches data via HTTP requests and parses the response.

Strengths:

• Completely free
• Full control over the code and data
• Good learning experience

Limitations:

• Not real-time: Requires manual refresh or a VBA timer (which NSE may block)
• Breaks frequently: NSE changes its website structure, breaking scrapers
• VBA knowledge required: You need coding skills to set up and maintain
• Rate limited: NSE blocks excessive requests
• Limited on Mac and Excel Online: VBA macros do not run in Excel Online, and web requests behave differently on Mac
• No streaming: Data is polled, not streamed
• No option Greeks: You must implement Black-Scholes yourself
• No buy/sell quantity: Not available from website scraping

Best for: Students, hobbyists, or those who want to learn and do not need real-time data.

Pricing: Free (but costs significant time)

---

Decision Matrix

Choose MarketXLS India if:

• You use Zerodha or Angel One as your broker
• You need Mac or Excel Online support
• You want the simplest setup (formulas, no DDE/VBA)
• You need built-in option Greeks (Delta, Gamma, Vega, IV)
• You value buy/sell pressure data for intraday analysis
• You want option utility functions (auto expiry, nearest strike, symbol builder)

Choose TrueData if:

• You are on Windows only and that is fine
• You do not want to tie data to a broker account
• You need historical tick data for backtesting
• You trade MCX commodities alongside equities
• You are comfortable with DDE/RTL configuration

Choose NimbleExcelLite if:

• You are on Windows only
• You need currency derivatives (NSE CDS)
• You want a dedicated data feed independent of broker
• You trade across multiple exchanges extensively

Choose Free VBA if:

• You are a student or hobbyist
• You do not need real-time data
• You enjoy coding and maintaining VBA macros
• You have no budget for market data

---

Feature Deep Dive: What Makes MarketXLS India Different

1. Formula-Based Approach

While other solutions use DDE links or external software, MarketXLS uses native Excel formulas. This means:

=mxlsIN.ZerodhaLast("RELIANCE:IN")

is just as easy to use as:

=SUM(A1:A10)

You can reference these in other formulas, use them in IF statements, build charts from them, and copy them across your workbook.

2. Complete Zerodha Function Library

MarketXLS provides specialised functions for every data point Zerodha streams:

3. Angel One Equivalent Functions

Every Zerodha function has an Angel One counterpart:

=mxlsIN.AngelOneLast("TATAMOTORS:IN")
=mxlsIN.AngelOneVolume("NIFTY:IN")
=mxlsIN.AngelOneHigh("RELIANCE:IN")
=mxlsIN.AngelOneBuyQuantity("NIFTY:IN")

4. Smart Option Tools

MarketXLS India includes these option helpers:

• Auto-detect next expiry: =mxlsIN.ExpirationNext("NIFTY:IN")
• Nearest strike finder: =mxlsIN.StrikeNext("NIFTY:IN")
• Symbol builder: =mxlsIN.OptionSymbol("NIFTY", ExpiryCell, "C", 24000)
• Futures symbol builder: =mxlsIN.futureSymbol("NIFTY", "2026-03-27")

These eliminate the tedious process of manually constructing option and futures symbols.

---

Pricing Comparison Summary

Among the four options compared, MarketXLS India is the one that works on Mac, uses plain Excel formulas instead of DDE or VBA, and includes built-in option Greeks and symbol helpers. It requires a Zerodha or Angel One account.

---

Frequently Asked Questions

Can I use multiple plugins simultaneously?

Yes. MarketXLS India is an Excel add-in and does not conflict with other data feed solutions. Some traders use MarketXLS for its formula convenience and another service for historical data.

What about Google Sheets?

MarketXLS offers a Google Sheets add-on; check with MarketXLS India support whether your broker-linked Indian data is available in Sheets. The other solutions listed here are Excel-based.

Is the data accurate?

MarketXLS streams directly from your broker's connection (Zerodha Kite API or Angel One SmartAPI). The data comes from the same source as your broker's own platform.

What if I switch brokers?

If you move from Zerodha to Angel One (or vice versa), you simply change Zerodha to AngelOne in your formulas. The function parameters and symbol format remain identical.

Can I try before I buy?

Visit the MarketXLS India page to book a demo and see the plugin in action with your own broker account.

---

Our Recommendation

For most Indian stock market traders and investors in 2026:

• If you use Zerodha or Angel One → MarketXLS India streams live data into Excel through your existing broker login, with option Greeks and symbol helpers built in.
• If you need historical tick data → TrueData is the stronger choice.
• If you trade currency derivatives heavily → NimbleExcelLite has broader exchange coverage.
• If you are just starting out → Begin with free VBA solutions, then upgrade when you are ready.

Try MarketXLS India →

MarketXLS India costs ₹3,500 a month. Works on Windows, Mac, and Excel Online. Cancel anytime.