Option Formulas

• Last updated Sep 1, 2026
• View as Markdown

📄️ OPTIONDATA

The OPTIONDATA formula fetches current or historical option quotes for one contract or a whole range of contracts. See the syntax, samples and limits.

📄️ OPTIONLOOKUP

Look-up the OCC option symbol from text or 4 cell references containing (1) underlying symbol, (2) expiration date, (3) strike, (4) call or put.

📄️ OPTIONCHAIN

The OPTIONCHAIN formula fetches a current or end-of-day historical option chain into your spreadsheet. See the syntax, samples and data availability.