TrueData Sheets Option Chain Formulas

+ K

Searching...

functions Formulas

menu_book Pages

manage_search Content Match

search_off

No results for ""

Go to Platform open_in_new

Loading Content

functions

Formula Reference

Option Chain Formulas

Formula	Category	Description
â–¶ OPTIONCHAIN	Chain Data	Full CE + PE chain for any underlying and expiry
Summary Full CE + PE chain for any underlying and expiry Parameters symbol, expiry, startCell, refreshInterval Pro Tip Syntax: =OPTIONCHAIN(symbol, expiry, startCell, refreshInterval) Result Result : NIFTY · BANKNIFTY · SENSEX · Any F&O stock refreshInterval available : 1m , 2m , 3m , 5m , 10m
â–¶ OPTIONCHAINWITHGREEKS	Chain Data	Full chain including Delta, Theta, Gamma, Vega, and IV
Summary Full chain including Delta, Theta, Gamma, Vega, and IV Parameters segment , symbol, expiry, startCell, refreshInterval Pro Tip Syntax: =OPTIONCHAINWITHGREEKS(segment , symbol, expiry, startCell, refreshInterval) Result Result: delta · theta · gamma · vega · rho · IV refreshInterval available : 1m , 2m , 3m , 5m , 10m
â–¶ COMPANYNAME	Contract Info	Fetches company name for a symbol from EQ/BSEEQ segment.
Summary Fetches company name for a symbol from EQ/BSEEQ segment. Parameters symbol Pro Tip =COMPANYNAME(A1) Result Tata Consultancy Services Ltd
â–¶ LOTSIZE	Contract Info	Fetches lot size for an NSE or BSE symbol.
Summary Fetches lot size for an NSE or BSE symbol. Parameters symbol Pro Tip =LOTSIZE(A1) Result 175
â–¶ EXPIRY	Expiry	Fetches the N-th expiry date for an underlying symbol on NSE and BSE.
Summary Fetches the N-th expiry date for an underlying symbol on NSE and BSE. Parameters symbol, expiryIndex Pro Tip =EXPIRY(A1, 1) Result 24-09-2026
â–¶ EXPIRIES	Expiry	Fetches all expiry dates for a symbol and lists them in the cells below.
Summary Fetches all expiry dates for a symbol and lists them in the cells below. Parameters symbol Pro Tip Keep the cells below empty — the result spills downward. Result 24-09-2026
â–¶ ATMSTRIKE	Strike Info	Fetches the ATM strike for a symbol and expiry.
Summary Fetches the ATM strike for a symbol and expiry. Parameters symbol, expiry Pro Tip =ATMSTRIKE(A1, "260924") Result 3100
â–¶ STRIKESTEP	Strike Info	Fetches the strike step (gap between consecutive strikes) for a symbol and expiry.
Summary Fetches the strike step (gap between consecutive strikes) for a symbol and expiry. Parameters symbol, expiry Pro Tip =STRIKESTEP(A1, "260924") Result 20

Sheets by Truedata

Empowering traders and analysts with high-performance real-time market data directly within their spreadsheets.

Formula Reference

Option Chain Formulas

Resources

Support