Angel One SmartAPI Integration Guide - Live NSE Data in Excel

Stream real-time Indian stock market data directly into Excel with Angel One's SmartAPI and MarketXLS India

Introduction

Angel One (formerly Angel Broking) is one of India's largest retail broking houses, serving millions of active traders. If you're an Angel One user looking to supercharge your analysis with live NSE/BSE data in Excel, you've come to the right place.

This comprehensive guide shows you how to connect Angel One's SmartAPI with Microsoft Excel using MarketXLS India to stream real-time market data without writing a single line of code.

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 (with MarketXLS Pro)
• Low Latency: Institutional-grade infrastructure

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
• Special Offer: ₹3,500/month with lifetime price lock
• Get subscription here

Why Choose Angel One for Excel Integration?

Advantages of Angel One SmartAPI

1. Massive User Base

• 15+ million clients (as of 2024)
• Large community for support and tips

2. Comprehensive Market Coverage

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

3. Competitive Pricing

• ₹20 per trade (F&O)
• Zero brokerage on equity delivery
• No additional charges for API access

4. Reliable Infrastructure

• 99.9% uptime
• Fast execution speeds
• Enterprise-grade data centers

5. 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 (seamless integration)
• ✅ 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 (Pro version)

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: Credentials are encrypted using AES-256 and stored locally on your machine. MarketXLS uses OAuth 2.0 standards for secure API communication.

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:

=MXLS.IN.0_last(A2)

Formula Breakdown:

• MXLS.IN → MarketXLS India namespace
• 0_last → Function name (gets last traded price)
• 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: =MXLS.IN.0_last(A2)
C2: =MXLS.IN.0_open(A2)
D2: =MXLS.IN.0_high(A2)
E2: =MXLS.IN.0_low(A2)
F2: =MXLS.IN.0_change(A2)
G2: =MXLS.IN.0_changepercent(A2)
H2: =MXLS.IN.0_volume(A2)
I2: =MXLS.IN.0_lasttime(A2)

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

Options traders - this is where Angel One SmartAPI integration really shines. Build live NSE options chains with zero manual effort.

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: =MXLS.IN.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: =MXLS.IN.0_last(E2)

G1: Open Interest
G2: =MXLS.IN.0_oi(E2)

H1: Volume
H2: =MXLS.IN.0_volume(E2)

I1: Bid Price
I2: =MXLS.IN.0_bid(E2)

J1: Ask Price
J2: =MXLS.IN.0_ask(E2)

K1: Implied Volatility (IV)
K2: =MXLS.IN.0_iv(E2)

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: =MXLS.IN.optionsymbol($A$2, $B$2, $C$2, D2)
E3: =MXLS.IN.optionsymbol($A$2, $B$2, $C$2, D3)
E4: =MXLS.IN.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: =MXLS.IN.0_last(E2)     // Copy down
G2: =MXLS.IN.0_oi(E2)       // Copy down
H2: =MXLS.IN.0_volume(E2)   // Copy down
I2: =MXLS.IN.0_iv(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: =MXLS.IN.futuresymbol(A2, B2)

Result: NIFTY25MAYFUT (or NSE's standard format)

Fetching Futures Data

Use the standard data functions:

D1: Last Price
D2: =MXLS.IN.0_last(C2)

E1: Open Interest
E2: =MXLS.IN.0_oi(C2)

F1: Volume
F2: =MXLS.IN.0_volume(C2)

G1: Change
G2: =MXLS.IN.0_change(C2)

H1: Change %
H2: =MXLS.IN.0_changepercent(C2)

Commodity Futures (MCX)

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

A2: GOLD
B2: 05-Jun-2025
C2: =MXLS.IN.futuresymbol(A2, B2)
D2: =MXLS.IN.0_last(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

...you now have institutional-grade market data infrastructure right in your spreadsheets.

Key Takeaways:

• ✅ Installation takes under 15 minutes
• ✅ No coding required - simple Excel formulas
• ✅ Real-time updates (~1 second latency)
• ✅ Works with stocks, options, futures, commodities
• ✅ Persistent connections across sessions
• ✅ Full options & futures chain capabilities
• ✅ MCX commodity support (unique to Angel One)

Ready to Get Started?

👉 Subscribe to MarketXLS India - ₹3,500/month lifetime price lock

👉 Watch Tutorial Video - Complete visual guide

👉 Download Sample Templates - 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