MarketXLS India Excel Function Reference
Streams live stocks, indices, futures and options data into Excel via broker connections. Supported brokers: Zerodha and Angel One.
Use the mxlsIN. namespace. Symbols: RELIANCE:IN (stock), NIFTY:IN (index),NIFTY23OCT24000CE:IN (option).
Function Index
Zerodha streaming
Angel One streaming
Options utilities
Zerodha streaming functions
All functions stream live data. Asset type support is listed with each function.
ZerodhaLast
Returns live last traded price.
=mxlsIN.ZerodhaLast("RELIANCE:IN")
Assets: Stock, Index, Option, Future
ZerodhaVolume
=mxlsIN.ZerodhaVolume("HDFC:IN")
Assets: Stock, Index, Option, Future
ZerodhaOpen
=mxlsIN.ZerodhaOpen("RELIANCE:IN")
Assets: Stock, Index, Option, Future
ZerodhaHigh
=mxlsIN.ZerodhaHigh("RELIANCE:IN")
Assets: Stock, Index, Option, Future
ZerodhaLow
=mxlsIN.ZerodhaLow("RELIANCE:IN")
Assets: Stock, Index, Option, Future
ZerodhaPreviousClose
=mxlsIN.ZerodhaPreviousClose("INFY:IN")
Assets: Stock, Index, Option, Future
ZerodhaBuyQuantity
=mxlsIN.ZerodhaBuyQuantity("NIFTY:IN")
Assets: Stock, Index, Option, Future
ZerodhaSellQuantity
=mxlsIN.ZerodhaSellQuantity("NIFTY:IN")
Assets: Stock, Index, Option, Future
ZerodhaChange
=mxlsIN.ZerodhaChange("TCS:IN")
Assets: Stock, Index, Option, Future
ZerodhaLastTradeTime
=mxlsIN.ZerodhaLastTradeTime("RELIANCE:IN")
Assets: Stock, Index, Option, Future
ZerodhaOpenInterest
=mxlsIN.ZerodhaOpenInterest("NIFTY23OCT24000CE:IN")
Assets: Option, Future
ZerodhaOpenInterestDayHigh
=mxlsIN.ZerodhaOpenInterestDayHigh("NIFTY23OCT24000CE:IN")
Assets: Option, Future
ZerodhaOpenInterestDayLow
=mxlsIN.ZerodhaOpenInterestDayLow("NIFTY23OCT24000CE:IN")
Assets: Option, Future
Angel One streaming functions
All functions stream live data.
AngelOneLast
=mxlsIN.AngelOneLast("TATAMOTORS:IN")
Assets: Stock, Index, Option, Future
AngelOneVolume
=mxlsIN.AngelOneVolume("NIFTY:IN")
Assets: Stock, Index, Option, Future
AngelOneOpen
=mxlsIN.AngelOneOpen("RELIANCE:IN")
Assets: Stock, Index, Option, Future
AngelOneHigh
=mxlsIN.AngelOneHigh("RELIANCE:IN")
Assets: Stock, Index, Option, Future
AngelOneLow
=mxlsIN.AngelOneLow("RELIANCE:IN")
Assets: Stock, Index, Option, Future
AngelOnePreviousClose
=mxlsIN.AngelOnePreviousClose("INFY:IN")
Assets: Stock, Index, Option, Future
AngelOneBuyQuantity
=mxlsIN.AngelOneBuyQuantity("NIFTY:IN")
Assets: Stock, Index, Option, Future
AngelOneSellQuantity
=mxlsIN.AngelOneSellQuantity("NIFTY:IN")
Assets: Stock, Index, Option, Future
Options utilities
ExpirationNext
Returns next option expiry as an Excel date for a symbol.
=mxlsIN.ExpirationNext("NIFTY:IN")
Assets: Option, Underlying for deriving options
StrikeNext
Returns next strike closest to the underlying's last price. Optional expiry allowed.
=mxlsIN.StrikeNext("NIFTY:IN")
Assets: Option, Underlying for deriving options
OptionSymbol
Builds a standard option symbol string from inputs.
=mxlsIN.OptionSymbol("NIFTY", mxlsIN.ExpirationNext("NIFTY:IN"), "C", 24000)
Assets: Option
Option Greeks
Use: spot price, option market price, expiry (YYYY-MM-DD), type (C/P), strike, optional risk-free rate, dividend, and sigma.
=mxlsIN.opt_Delta(2450, 128, "2024-11-28", "C", 2400)=mxlsIN.opt_Gamma(2450, 128, "2024-11-28", "P", 2400)=mxlsIN.opt_Vega(2450, 128, "2024-11-28", "C", 2400)=mxlsIN.opt_ImpliedVolatility(2450, 128, "2024-11-28", "C", 2400)
Assets: Option
Futures
futureSymbol
Create a MarketXLS-formatted futures symbol from base + expiry.
=mxlsIN.futureSymbol("NIFTY", "2024-11-28")
Assets: Future
Notes
- Only Zerodha and Angel One are supported at this time.
- Data streams live while your Excel workbook is open and connected.
- Examples are illustrative; values shown are not investment advice.