Skip to main content

Tutorials

Welcome to Market Data’s Quickstart Tutorials! Here, you’ll find comprehensive guides and tutorials to help you get started with our two powerful products: the Market Data API and the Google Sheets Add-On. Whether you’re a developer looking to integrate real-time and historical market data into your applications using our API or a trader who prefers the simplicity and flexibility of Google Sheets, we have the resources you need.

APIGoogle SheetsShow All
The Greek alphabet in white capitals on dark grey, five rows of five, delta and theta among them.

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.

The purple Yahoo! logo in raised letters on the white panelled facade of an office building.

How To Use The Yahoo Finance API

How to reach Yahoo Finance data through unofficial API endpoints: stock quotes, historical prices and more, with Python and JavaScript examples.

The letters API at the centre of a cyan network diagram, its spokes radiating to eight ringed nodes on dark navy.

How To Use The Option Chain API — With Examples!

The Option Chain API allows for ample sorting & filtering during each request, making it easy to get exactly the data you need.

Wooden blocks lettered S&P 500, each on a taller stack of coins than the last, against a black background.

How To Find The S&P 500 Ticker Using Google Finance (SPX)

Learn how to pull S&P 500 data into Google Sheets using the correct Google Finance ticker. Avoid common errors with simple, clear guidance.

Rows of five-decimal quotes such as 1.20506 and 1.18189 glowing green and blue on a dark screen.

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.

Covered call payoff profile: the combined position breaks even at 95, rises to a profit of 5.00 at 100, and stays flat above it, while losses continue below 95.

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.

A black felt letter board spelling DOWNLOAD, a 3.5-inch floppy disk propped on its corner, on a wooden table.

How To Download Historical Options Prices in CSV Format

Market Data makes it easy to download historical options prices for the entire market or for a single symbol.

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

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.

Sign Up For Free