Getting option chain data in Google Sheets is something that most people assume is impossible. The built-in GOOGLEFINANCE function in Google Sheets has absolutely zero support for options data. No option chains, no strike prices, no expiration dates, no implied volatility, no Greeks. Nothing.
But there is a way. MarketXLS is a Google Sheets add-on that provides full options chain data, options Greeks, implied volatility, put/call ratios, and advanced pricing models directly inside Google Sheets. It is the only Google Sheets add-on that gives options traders the data they need without switching to a separate platform.
Why You Cannot Get Options Data from GOOGLEFINANCE
GOOGLEFINANCE is limited to basic stock price data. It supports about 18 attributes like price, volume, PE ratio, and 52-week high/low. Options are not on the list. There is no =GOOGLEFINANCE("AAPL", "optionchain") or any equivalent. Google has never added options support to GOOGLEFINANCE, and there are no signs they ever will.
This means options traders who prefer Google Sheets have been stuck with one of these workarounds:
- Copy and paste from a brokerage or options website (tedious, manual, and stale by the time you finish)
- Write Apps Script code to call an external API (requires programming knowledge, unreliable, hard to maintain)
- Use a third-party API like Alpha Vantage or Yahoo Finance (requires coding, rate limited, breaks frequently)
- Give up on Google Sheets and switch to a desktop platform (defeats the purpose of using a spreadsheet)
MarketXLS eliminates all of these workarounds with simple formulas.
How to Get Option Chain Data in Google Sheets
Install MarketXLS from the Google Workspace Marketplace, then use a single formula to pull the full options chain:
=QM_GetOptionChain("AAPL")
This returns the complete options chain for Apple directly into your Google Sheets spreadsheet. You get every available expiration date, every strike price, and the following data for each contract:
- Bid price
- Ask price
- Last traded price
- Volume
- Open interest
- Implied volatility
- Delta, Gamma, Theta, Vega, Rho
Filter Options Chains
You can also filter the options chain to show only specific contracts:
=QM_GetOptionChainAtTheMoney("AAPL") // At-the-money options only
=QM_GetOptionChainInTheMoney("AAPL") // In-the-money options only
These filtered views make it easier to focus on the contracts that matter for your strategy.
Options Greeks in Google Sheets
Options Greeks are essential for understanding risk and building strategies. MarketXLS provides all Greeks for any option contract in Google Sheets.
Delta measures how much the option price changes for a $1 move in the underlying stock. A delta of 0.50 means the option price moves roughly $0.50 for every $1 move in the stock.
Gamma measures the rate of change of delta. High gamma means delta is changing quickly, which affects hedging requirements.
Theta measures time decay. Options lose value every day, and theta tells you how much. This is critical for income strategies like covered calls and iron condors.
Vega measures sensitivity to implied volatility changes. When IV spikes or crushes, vega tells you how much your option price will be affected.
Rho measures sensitivity to interest rate changes. Less commonly used but important for longer-dated options.
All of these Greeks are included in the options chain data returned by =QM_GetOptionChain("AAPL"). You do not need to calculate them manually.
Advanced Options Pricing in Google Sheets
MarketXLS includes advanced options pricing models that institutional traders use. These are available as simple formulas in Google Sheets:
Black-76 Model: Used for pricing European-style options on futures and forward contracts.
Heston Model: A stochastic volatility model that accounts for the fact that implied volatility is not constant. This gives more accurate pricing than Black-Scholes in many market conditions.
American Option Pricing: For American-style options that can be exercised before expiration, which is the case for most US equity options.
Bachelier Model: Used when the underlying can take negative values, common in interest rate options.
SABR Model: A stochastic alpha-beta-rho model used for modeling the volatility smile.
These are institutional-grade pricing models that you would normally need a Bloomberg terminal or specialized software to access. MarketXLS makes them available as spreadsheet formulas in Google Sheets.
Put/Call Ratios and Options Analytics in Google Sheets
Beyond individual option contracts, MarketXLS provides aggregate options analytics:
Put/Call Volume Ratio: The ratio of put volume to call volume for a stock. A high put/call ratio can indicate bearish sentiment.
Put/Call Open Interest Ratio: Similar to the volume ratio but based on open interest, which reflects longer-term positioning.
Historical Implied Volatility: Track how implied volatility has changed over time for a stock.
Historical Greeks: Track how delta, gamma, and other Greeks have changed over time for specific contracts.
These analytics help options traders understand market sentiment, identify potential reversals, and manage portfolio risk.
Building an Options Strategy Tracker in Google Sheets
Here is how to build a simple options strategy tracker in Google Sheets with MarketXLS:
Step 1: In cell A1, type =QM_GetOptionChain("AAPL") to pull the full options chain.
Step 2: Identify the contracts you want to track. Note the strike price, expiration date, and whether it is a call or put.
Step 3: In a separate area of your spreadsheet, create a strategy tracker:
| Column | Data |
|---|---|
| A | Strategy name (e.g., "AAPL Bull Call Spread") |
| B | Long leg symbol |
| C | Short leg symbol |
| D | Entry price (long) |
| E | Entry price (short) |
| F | Current price (long) via =QM_Last() |
| G | Current price (short) via =QM_Last() |
| H | P/L calculation |
| I | Days to expiration |
Step 4: Use the stock price data to track your underlying:
=Last("AAPL") // Current stock price
=ChangeinPercent("AAPL") // Daily % change
Step 5: Add risk metrics using the Greeks data from the options chain to monitor delta exposure, theta decay, and vega risk across your positions.
Who Needs Options Data in Google Sheets
Options Traders: Anyone who trades options and prefers the flexibility of Google Sheets over a brokerage platform. Google Sheets lets you build custom analytics, share with trading partners, and access your data from any device.
Financial Advisors: Advisors who run covered call programs, protective put strategies, or collar strategies for client portfolios need options data in a format they can present to clients. Google Sheets dashboards with live options data are perfect for client meetings.
Quantitative Analysts: Quants who want to prototype options strategies in a spreadsheet before implementing them in code. Google Sheets with MarketXLS provides the data, and the spreadsheet environment makes it easy to test ideas quickly.
Students and Educators: Options pricing theory comes alive when you can pull real options data into a spreadsheet and apply Black-Scholes, Greeks calculations, and strategy P/L analysis. MarketXLS turns Google Sheets into an options education platform.
GOOGLEFINANCE vs MarketXLS for Options in Google Sheets
| Options Feature | GOOGLEFINANCE | MarketXLS |
|---|---|---|
| Option chains | Not available | =QM_GetOptionChain() |
| ATM options | Not available | =QM_GetOptionChainAtTheMoney() |
| ITM options | Not available | =QM_GetOptionChainInTheMoney() |
| Bid/Ask | Not available | Included in chain data |
| Volume | Not available | Included in chain data |
| Open interest | Not available | Included in chain data |
| Implied volatility | Not available | Included in chain data |
| Delta | Not available | Included in chain data |
| Gamma | Not available | Included in chain data |
| Theta | Not available | Included in chain data |
| Vega | Not available | Included in chain data |
| Rho | Not available | Included in chain data |
| Put/call ratios | Not available | Available |
| Pricing models | Not available | Black-76, Heston, American, Bachelier, SABR |
| Historical IV | Not available | Available |
The comparison is clear. GOOGLEFINANCE offers zero options functionality. MarketXLS provides everything.
How to Get Started
- Install MarketXLS from the Google Workspace Marketplace
- Get your license from the MarketXLS pricing page
- Type
=QM_GetOptionChain("AAPL")in any cell - You now have live options data in Google Sheets
The same functions work in Microsoft Excel if you also use the Excel add-in. The function names are identical on both platforms.
Frequently Asked Questions
Can I get option chain data in Google Sheets?
Yes. Install MarketXLS from the Google Workspace Marketplace and use =QM_GetOptionChain("AAPL") to pull the full options chain with bid, ask, volume, open interest, implied volatility, and all Greeks directly into Google Sheets.
Does GOOGLEFINANCE support options?
No. GOOGLEFINANCE has zero options support. There is no way to get option chains, Greeks, or any options data using GOOGLEFINANCE.
What options data does MarketXLS provide in Google Sheets?
MarketXLS provides full options chains with bid, ask, last price, volume, open interest, implied volatility, delta, gamma, theta, vega, and rho. It also provides put/call ratios, historical implied volatility, and advanced pricing models including Black-76, Heston, and American option pricing.
Can I use MarketXLS for options strategy analysis?
Yes. You can pull live options chain data, track individual contract prices using =QM_Last(), calculate P/L for multi-leg strategies, and monitor Greeks exposure. Google Sheets lets you build custom strategy trackers with live data.
Does MarketXLS support SPX and index options?
Yes. You can use =QM_GetOptionChain("^SPX") for S&P 500 index options and other index options in Google Sheets.
Summary
Getting option chain data in Google Sheets is now possible with MarketXLS. While GOOGLEFINANCE offers zero options support, MarketXLS provides full options chains, all Greeks, implied volatility, put/call ratios, and institutional-grade pricing models. It is the only Google Sheets add-on that gives options traders everything they need.
Install MarketXLS, type =QM_GetOptionChain("AAPL"), and you have live options data in Google Sheets.
Get MarketXLS for Google Sheets | View Pricing | Options Profit Calculator | Option Scanner
