Options in Google Sheets

How To Get An Option Chain In Google Sheets

Use the OPTIONCHAIN formula to get a complete real-time option chain in Google Sheets. Filter by date, days to expiration, strike, deltas, and more.

How to Calculate Theta For An Option

Learn how to calculate theta and understand how to add time decay to your spreadsheets.

How To Get Historical Options Prices For Your Spreadsheet

Using the Market Data Add-on, it is possible to get historical options prices going back decades directly into your spreadsheet with a simple formula.

How To Calculate The Intrinsic / Extrinsic Value of an Option In Your Spreadsheet

Using the OPTIONDATA formula, you can automatically calculate the implied volatility of any option that is currently trading.

How To Calculate Implied Volatility In Your Spreadsheet

Using the OPTIONDATA formula, you can calculate implied volatility for any option.

How To Calculate Option Greeks In Your Spreadsheet

The OPTIONDATA formula will calculate the option greeks to your spreadsheet automatically using the keyword "greeks" as a parameter. Risk management has never been easier.

How To Build A Covered Call Spreadsheet

Learn how to build a covered call spreadsheet to track all your covered calls. Download our free covered call tracking spreadsheet example sheet for Google Sheets and begin tracking your covered calls today.

How To Get Options Prices in Google Sheets

Learn how to add real-time and historical options prices into your Google Sheets spreadsheets using a single formula.