Trader Excel – Real-Time BSE & NSE Market Data

Trader Excel brings real-time BSE and NSE market data directly into Microsoft Excel. Get stocks, futures, options, option chains, open interest, volume, OHLC data and Black-Scholes Greeks inside Excel, then build your own trading models, dashboards, scanners and analysis using standard Excel formulas.

Trader Excel is designed for traders and analysts who want market data in Excel without building and maintaining a separate data pipeline. Search for symbols, select instruments and let Trader Excel handle market-data retrieval, normalization and updates while your workbook remains the place where you do your analysis.

Native Excel Formulas with TX.*

Use Trader Excel market data directly from Excel formulas:

• =TX.LTP("NIFTY") - Real-time LTP
• =TX.ALL("BANKNIFTY","NEAR") - 10-column market-data row with Symbol, Expiry, LTP, OHLC, OI, Volume and Timestamp
• =TX.OPEN(), =TX.HIGH(), =TX.LOW(), =TX.CLOSE()
• =TX.OI() and =TX.VOLUME()
• =TX.OPTION.LTP(), =TX.OPTION.OI() and =TX.OPTION.VOLUME()
• =TX.GREEK() for option Greeks

Build your own Excel formulas, calculations, dashboards and trading models without manually copying market data into your workbook.

Real-Time Option Chain with Greeks

Build and analyze NSE and BSE option chains directly in Excel with CE and PE market data, including LTP, open interest, volume, change in open interest and Black-Scholes Greeks.

• Real-time option chain data in Excel
• CE and PE option data
• Configurable strike depth, up to ATM ±10 on supported plans
• Automatic ATM re-centering
• Implied Volatility, Delta, Gamma, Theta, Vega and Rho
• Current and next supported expiries

Ready-to-Use Excel Trading Templates

Start with pre-built Excel templates for common market-analysis workflows:

• Options Chain Tracker
• Auto-Refreshing Watchlist Dashboard
• Futures OI & Price Tracker
• Spot vs Futures Structure Dashboard
• NIFTY, BANKNIFTY & SENSEX Trend Dashboard
• Dynamic Support & Resistance Option Chain Dashboard

Every template remains an Excel workbook. Use your own formulas, charts, conditional formatting, lookups and calculations to create the analysis you want.

Zero Broker API Setup

Trader Excel does not require customers to configure a broker API, manage API tokens, write Python scripts or maintain a separate market-data application. Activate your Trader Excel license, open Excel and use the market-data tools and formulas inside your workbook.

Supported Market Data

Trader Excel supports BSE and NSE market data across stocks, futures, indices and options, including commonly used instruments such as NIFTY, BANKNIFTY, FINNIFTY, MIDCPNIFTY, SENSEX and BANKEX, subject to the supported instrument and expiry configuration.

Important: Trader Excel provides market data and Excel analysis tools. It does not provide investment advice, trading recommendations or guaranteed trading results. Market data and calculated Greeks are provided for analytical purposes.

Subscription required: Trader Excel requires an active Trader Excel subscription and license key to access market-data functionality. Plans and pricing are available through Trader Excel.