Angel One Excel Integration: Connect SmartAPI for Live NSE, BSE & MCX Data

To get live Angel One data into Excel, install the MarketXLS India add-in, log in, select Angel One (SmartAPI) as your broker, and enter your Angel One client ID and password. Formulas such as =mxlsIN.AngelOneLast("RELIANCE:IN") then return live NSE, BSE, and MCX prices that update during market hours, with no coding. You need an active Angel One trading account and a MarketXLS India subscription (served from marketxls.in).

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 walks through each step, then shows how to build a watchlist, an options chain, and futures trackers with the same formulas.

What You'll Learn

✅ Set up Angel One SmartAPI credentials ✅ Connect SmartAPI to Excel via MarketXLS India ✅ Stream live stock prices, options, and futures data ✅ Build automated trading dashboards ✅ Create dynamic options chains that update in real-time ✅ Track your portfolio with live P&L calculations

Time Required: 15 minutes from installation to live data streaming

---

What is Angel One SmartAPI?

SmartAPI is Angel One's official API platform that allows developers and traders to access live market data and place trades programmatically.

Key Features of SmartAPI

• Real-time Data Streaming: Live prices via WebSocket connections
• Full Market Coverage: NSE, BSE, MCX - stocks, derivatives, commodities
• Historical Data: OHLCV data for backtesting
• Order Management: Programmatic order placement through SmartAPI

SmartAPI vs Manual Data Entry

---

Prerequisites

Before starting, ensure you have:

1. Angel One Trading Account

• Active Angel One demat & trading account
• Angel One app installed and working
• Your client ID (usually your registered mobile number)

Don't have an Angel One account? Open one here

2. SmartAPI Credentials

You'll need these from Angel One:

• Client ID (your Angel One login ID)
• Password (your Angel One password)
• API Key (obtained from SmartAPI portal - we'll cover this)
• MPIN (your 4-digit trading PIN)

3. Microsoft Excel

• Windows: Excel 2016 or later
• Mac: Excel 2016 or later
• Online: Office 365 with Excel Online

4. MarketXLS India Subscription

• Active subscription with login credentials
• See current plans on the MarketXLS India pricing page

---

Why Choose Angel One for Excel Integration?

Advantages of Angel One SmartAPI

1. Market Coverage

• NSE Equity (all stocks)
• NSE Derivatives (F&O)
• BSE Equity
• Currency derivatives
• MCX Commodities (Gold, Silver, Crude, etc.)

2. Additional Features

• SmartAPI documentation and support
• Mobile app integration
• Research and recommendations

When to Choose Angel One Over Zerodha

Consider Angel One if:

• ✅ You're already an Angel One customer (no new broker account needed)
• ✅ You need MCX commodity data in Excel
• ✅ You want access to Angel One's research calls in your dashboard
• ✅ You prefer Angel One's margin policies
• ✅ You're looking for backup/redundancy (use alongside Zerodha)

---

Installing MarketXLS India Add-in

Step 1: Open Excel Add-ins Store

1. Launch Microsoft Excel on your computer
2. Click the Insert tab in the ribbon
3. Select Add-ins → Get Add-ins (or "More Add-ins" on some versions)
4. The Office Add-ins marketplace will open

Step 2: Find MarketXLS India

1. In the add-ins store, click the Store tab
2. Use the search box to search for "MarketXLS"
3. You'll see two versions listed:
   • MarketXLS (global version for US/international markets)
   • MarketXLS India (for NSE/BSE/Indian markets) ← Select this one
4. Click Add or Continue to begin installation

Important: Make sure you're installing MarketXLS India, not the global version. The India version includes broker integrations for Angel One and Zerodha.

Step 3: Complete Installation

1. Accept the permissions when prompted
2. Wait for the installation to complete (usually 30-60 seconds)
3. You'll see a confirmation message
4. The MarketXLS India panel will appear on the right side of your Excel window

If the panel doesn't appear:

• Go to Insert → My Add-ins
• Click MarketXLS India
• The panel will open

---

Connecting Angel One SmartAPI

Now let's connect your Angel One account to start streaming live data.

Step 1: Login to MarketXLS India

1. In the MarketXLS India panel (right side of Excel), click the Login button
2. A login dialog will appear
3. Enter your MarketXLS credentials:
   • Username: Found in your purchase confirmation email
   • Password: Found in your purchase confirmation email
4. Click Allow Access when prompted for permissions

First-time user? Your credentials were emailed when you purchased MarketXLS India. Can't find them? Check spam folder or contact support@marketxls.com

Step 2: Select Angel One Broker

After logging into MarketXLS:

1. You'll see a broker selection dropdown in the panel
2. Click the dropdown menu
3. Select Angel One (SmartAPI) from the list
4. Click the Connect button

Step 3: Enter Angel One Credentials

A credentials dialog will appear asking for:

Required Fields:

1. Client ID

   • This is your Angel One login ID (usually your registered mobile number)
   • Example: A12345678 or your mobile number

2. Password

   • Your Angel One login password
   • Same password you use for the Angel One app/website

3. API Key (optional but recommended for advanced features)

   • Obtained from smartapi.angelone.in
   • See "Getting Your API Key" section below

4. MPIN (if prompted)

   • Your 4-digit trading PIN
   • Only required for order placement features

Step 4: Authenticate Connection

1. Click Connect after entering credentials
2. MarketXLS will establish a connection to Angel One SmartAPI
3. You may see a "Connecting..." status message for 5-10 seconds
4. Once connected, you'll see "Connected to Angel One" status

Step 5: Save Login (Optional)

To avoid re-entering credentials every time:

1. After successful connection, you'll see a Save Login option
2. Click Save Login to encrypt and store your credentials securely
3. Next time you open Excel, you'll auto-connect without re-entering details

Security Note: Saved credentials are stored on your machine. Contact support@marketxls.com with questions about how they are protected.

---

Streaming Live Stock Data

With Angel One connected, let's start pulling live NSE/BSE data into Excel.

Quick Start: Example Sheet

The fastest way to get started:

1. In the MarketXLS India panel, click "Create Examples Sheet"
2. A new worksheet is created with live data for popular stocks:
   • Ticker symbols (TCS, Reliance, HDFC Bank, Infosys, etc.)
   • Last Price (updating in real-time)
   • Open, High, Low
   • Previous Close
   • Change and Change %
   • Volume
   • Last Update Time

This gives you a working template to understand the formula structure.

Understanding MarketXLS Formulas

All data is fetched using simple Excel formulas:

=mxlsIN.AngelOneLast(A2)

Formula Breakdown:

• mxlsIN → MarketXLS India namespace
• AngelOneLast → Function name (gets last traded price from Angel One)
• A2 → Cell reference containing ticker symbol

Ticker Symbol Format

Important: All Indian stock tickers must include the :IN suffix:

SYMBOL:IN

Examples:

Why the :IN suffix? It tells MarketXLS to fetch data from Indian markets (NSE/BSE) rather than US markets.

Available Stock Data Functions

Here's your complete function reference for live stock data:

Building a Custom Live Watchlist

Let's create a professional watchlist from scratch:

Step 1: Create ticker column (Column A)

A1: Ticker
A2: RELIANCE:IN
A3: TCS:IN
A4: HDFCBANK:IN
A5: INFY:IN
A6: ITC:IN
A7: SBIN:IN
A8: NIFTY:IN

Step 2: Add column headers (Row 1)

B1: Last Price
C1: Open
D1: High
E1: Low
F1: Change
G1: Change %
H1: Volume
I1: Last Update

Step 3: Enter formulas in Row 2

B2: =mxlsIN.AngelOneLast(A2)
C2: =mxlsIN.AngelOneOpen(A2)
D2: =mxlsIN.AngelOneHigh(A2)
E2: =mxlsIN.AngelOneLow(A2)
F2: =(mxlsIN.AngelOneLast(A2)-mxlsIN.AngelOnePreviousClose(A2))
G2: =(mxlsIN.AngelOneLast(A2)-mxlsIN.AngelOnePreviousClose(A2))/mxlsIN.AngelOnePreviousClose(A2)*100
H2: =mxlsIN.AngelOneVolume(A2)

Note: Change and Change % are calculated manually since there's no direct function for percentage.

Step 4: Copy formulas down

Select cells B2:I2, then drag down to row 8 (or however many tickers you have).

Result: You now have a live watchlist that automatically updates during market hours! 📊

---

Building Options Chains

MarketXLS India builds live NSE options chains from Angel One data by combining =mxlsIN.OptionSymbol with the Angel One price functions.

Understanding Options in MarketXLS

Unlike stocks, options require four parameters to identify a contract:

1. Underlying Symbol (e.g., "NIFTY", "BANKNIFTY", "RELIANCE")
2. Expiry Date (e.g., "28-May-2025")
3. Option Type ("CALL" or "PUT")
4. Strike Price (e.g., "24000")

MarketXLS India provides the optionsymbol() function to generate the correct contract identifier.

Creating Your First Option Symbol

Step 1: Set up input cells

A1: Underlying
A2: NIFTY

B1: Expiry
B2: 28-May-2025

C1: Type
C2: CALL

D1: Strike
D2: 24000

Step 2: Generate option symbol

E1: Option Symbol
E2: =mxlsIN.OptionSymbol(A2, B2, C2, D2)

Result in E2: NIFTY25MAY24000CE (or similar format based on NSE naming)

This is the complete contract identifier that MarketXLS uses to fetch data from Angel One.

Fetching Live Options Data

Now use the option symbol to get any metric:

F1: Premium (Last Price)
F2: =mxlsIN.AngelOneLast(E2)

G1: Open Interest
G2: Use StrikeNext or ExpirationNext utilities for option chains

H1: Volume
H2: =mxlsIN.AngelOneVolume(E2)

I1: Buy Quantity
I2: =mxlsIN.AngelOneBuyQuantity(E2)

J1: Sell Quantity
J2: =mxlsIN.AngelOneSellQuantity(E2)

Formula documentation: StrikeNext, ExpirationNext

Note: For Implied Volatility (IV), use the Black-Scholes Greeks function: =mxlsIN.opt_ImpliedVolatility(spotPrice, optionPrice, expiry, "C/P", strike)

All these values update live as options trade on NSE during market hours!

Building a Complete Options Chain

To see all available strikes for an expiry:

Step 1: Create a strike ladder

In column D, list all strikes:

D1: Strike
D2: 23000
D3: 23100
D4: 23200
D5: 23300
D6: 23400
... (continue for all relevant strikes)

Step 2: Generate option symbols

In column E, create formulas (note the $ for absolute references):

E2: =mxlsIN.OptionSymbol($A$2, $B$2, $C$2, D2)
E3: =mxlsIN.OptionSymbol($A$2, $B$2, $C$2, D3)
E4: =mxlsIN.OptionSymbol($A$2, $B$2, $C$2, D4)
...

Why $A$2? The dollar signs create absolute references, so:

• Underlying (A2), Expiry (B2), Type (C2) stay fixed
• Strike (D2, D3, D4...) changes for each row

Step 3: Add data columns

Copy your data formulas down for each strike:

F2: =mxlsIN.AngelOneLast(E2)        // Copy down
G2: =mxlsIN.AngelOneVolume(E2)      // Copy down
H2: =mxlsIN.AngelOneBuyQuantity(E2) // Copy down
I2: =mxlsIN.AngelOneSellQuantity(E2)// Copy down

Step 4: Create PUT side

Duplicate the structure but change:

C2: PUT

Run the same formulas and you'll have the complete PUT side of the chain.

---

Tracking Futures Contracts

Futures traders need just two inputs to track contracts via Angel One.

Creating a Futures Symbol

Required Inputs:

1. Underlying Symbol (e.g., "NIFTY", "BANKNIFTY", "CRUDEOIL")
2. Expiry Date (e.g., "28-May-2025")

Setup:

A1: Underlying
A2: NIFTY

B1: Expiry
B2: 28-May-2025

C1: Futures Symbol
C2: =mxlsIN.futureSymbol(A2, B2)

Result: NIFTY25MAYFUT (or NSE's standard format)

Fetching Futures Data

Use the standard data functions:

D1: Last Price
D2: =mxlsIN.AngelOneLast(C2)

E1: Volume
E2: =mxlsIN.AngelOneVolume(C2)

F1: Buy Quantity
F2: =mxlsIN.AngelOneBuyQuantity(C2)

G1: Sell Quantity
G2: =mxlsIN.AngelOneSellQuantity(C2)

Commodity Futures (MCX)

Angel One SmartAPI supports MCX commodities! Track Gold, Silver, Crude Oil:

A2: GOLD
B2: 05-Jun-2025
C2: =mxlsIN.futureSymbol(A2, B2)
D2: =mxlsIN.AngelOneLast(C2)

Supported Commodities:

• GOLD:IN - Gold futures
• SILVER:IN - Silver futures
• CRUDEOIL:IN - Crude oil futures
• NATURALGAS:IN - Natural gas futures
• COPPER:IN - Copper futures

---

Video Tutorial

Watch the complete step-by-step walkthrough (covers both Angel One and Zerodha):

Watch on YouTube: MarketXLS India Complete Guide

Video includes:

• ✅ Add-in installation process
• ✅ Angel One broker connection
• ✅ Live stock data streaming demo
• ✅ Building options chains
• ✅ Futures symbol creation
• ✅ Troubleshooting common issues

---

Next Steps

Now that you've connected Angel One SmartAPI with Excel, here's what to explore next:

1. Build Advanced Dashboards

• Portfolio tracker with live P&L
• Sector heatmap showing top movers
• Options strategy analyzer with Greeks
• Intraday screener with technical filters

2. Explore All MarketXLS Functions

Beyond the basics covered here:

• Fundamental data (P/E, Market Cap, EPS, etc.)
• Technical indicators (RSI, MACD, Bollinger Bands)
• Historical price data for backtesting
• Custom screener functions

Check the complete function library.

3. Compare with Zerodha

Curious about alternatives? Read our detailed comparison: Zerodha vs Angel One: Which Broker Integration is Best?

4. Connect Zerodha as Alternative

Want a backup broker? Learn how to connect Zerodha Kite: Zerodha Integration Guide

---

Conclusion

Congratulations! You've successfully connected Angel One SmartAPI with Excel to stream live NSE/BSE data. Whether you're:

• 📊 Tracking your portfolio with real-time P&L
• 📈 Building sophisticated options analysis tools
• 💹 Monitoring futures basis and spreads
• 🔍 Screening stocks with custom criteria
• 🏭 Analyzing MCX commodities

...the same mxlsIN.AngelOne* formulas cover each of these use cases.

Key Takeaways:

• ✅ Installation takes under 15 minutes
• ✅ No coding required - simple Excel formulas
• ✅ Live updates during market hours
• ✅ Works with stocks, options, futures, commodities
• ✅ Persistent connections across sessions
• ✅ Full options & futures chain capabilities
• ✅ MCX commodity support

Ready to Get Started?

👉 Subscribe to MarketXLS India - ₹3,500 a month

👉 Watch Tutorial Video - Complete visual guide

👉 Browse Excel Templates - Find sample workbooks and pre-built watchlists

---

Last updated: February 2025 | Questions? Contact support@marketxls.com

Keywords: Angel One Excel integration, SmartAPI Excel, NSE live data Excel, Angel One API Excel, real-time stock data Excel India, Angel One SmartAPI guide, Excel options chain, MarketXLS India, Angel One Excel add-in, live market data Excel