Sheets

Get insights and instructions on how to leverage real-time and historical market data directly within Google Sheets using the Market Data Sheets Add-on. Get tips for effective data manipulation, and ways to customize your data analysis experience. This resource is designed to help both novice and experienced users maximize the potential of our add-on, transforming Google Sheets into a powerful tool for financial analysis and decision-making.

Filter:

Google Sheets Show All

No articles on this page match that filter.

Rows of green and magenta prices beside six-figure volumes on an angled market quote board.

How To Bulk Download Stock Data in Google Sheets

Download stock data in bulk with the STOCKDATA formula for Google Sheets: many symbols in one request, so large spreadsheets refresh fast and cost less.

The word EARNINGS across a wireframe globe, ringed by bar charts, pie charts, line graphs and spreadsheet panels on a green background.

How To Get An Earnings Calendar For Any Stock In Google Sheets

Add an earnings calendar to Google Sheets using Market Data's EARNINGS formula. Find what Wall Street Analysts are projecting for next quarter.

A pencil on a blue-tinted calendar page, crossed by a red band lettered MARKET HOLIDAYS.

How To Get Stock Market Holidays In Your Spreadsheet

Get past, present, and future stock market holidays for the United States directly into your spreadsheet with the MARKETSTATUS formula.

CANDLES VS QUOTES in white and cyan above two windows: a green candlestick chart with a volume bar on the left and a quote table with green bid rows, red ask rows and sparklines on the right, on a dark navy grid.

Candles vs Quotes, What’s The Difference?

Candles or quotes? STOCKDATA returns both, and picking the wrong one skews your spreadsheet. Here is what each one holds and when to use it.

A phone home screen in close-up: the green Google Sheets icon between the Google and Instagram icons.

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.

The Greek letter theta, the options Greek for time decay, glowing white against a purple starfield.

How to Calculate Theta For An Option

Learn how to calculate theta for an option and add time decay to your Google Sheets spreadsheet with the OPTIONDATA formula and Black-Scholes.

HISTORICAL OPTIONS PRICES in white and green inside a translucent pill, between two spreadsheet grids and above a rising candlestick chart on a dark green grid.

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.

CALCULATING INTRINSIC & EXTRINSIC VALUE in white on deep green, a Google Sheets icon at left, a spreadsheet window at right, and an option value curve rising to a dashed strike line.

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.

CALCULATING IMPLIED VOLATILITY in white fading to green on deep green, a spreadsheet window at right and a glowing volatility curve with a marked peak beneath it.

How To Calculate Implied Volatility In Your Spreadsheet

Calculate the implied volatility of any option in Google Sheets with the OPTIONDATA formula, then chart the volatility curve across a whole option chain.

CALCULATE OPTION GREEKS in white and green on the left, a glowing delta curve with dashed gamma and theta curves below it, and a spreadsheet window with a chart window on the right, on a dark green grid.

How To Calculate Option Greeks In Your Spreadsheet

The OPTIONDATA formula pulls delta, gamma, theta and vega straight into your spreadsheet, so position risk updates itself with the market.

REAL-TIME STOCK PRICES in white and green above a Google Sheets window on the left and a rising line chart with volume bars on the right, on a dark green grid.

How To Get Real-Time Stock Prices in Google Sheets

The GOOGLEFINANCE formula gives 15-min delayed stock prices. Get real-time stock prices into Google Sheets using the STOCKDATA formula.

How To Build A Covered Call Spreadsheet

Build a covered call tracker in Google Sheets, formula by formula — and download our free example sheet to start tracking your positions today.

A close, shallow-focus photograph of green and red candlesticks on a dark trading screen.

How To Get Intraday Stock Prices in Google Sheets

Learn how to get intraday stock prices in Google Sheets (with prices down to the minute) using a simple formula that works the same way as GoogleFinance.

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.

Winning trades are born from superior data.

Free 30 day demo for new accounts. No credit card required.