Option Formulas

• Last updated Sep 1, 2026
• View as Markdown

📄️ OPTIONDATA

The OPTIONDATA formula fetches a current or historical option quote into your spreadsheet. See the syntax, sample usage and data availability.

📄️ 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 option chain into your spreadsheet. See the syntax, sample usage and data availability.