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.

Filter:

API Google Sheets Show All

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.

Blue isometric circuitry lettered HISTORICAL STOCK DATA API, above a pill reading GETTING STARTED: LEARN BY EXAMPLE.

How To Use The Historical Stock Data API

Learn by example and get started with the historical stock data api. Both daily and intraday data is available going back decades.

STOCK MARKET API in white and cyan lettering on dark navy, between a browser window with a rising candlestick chart on the left and three request rows wired to a code window on the right, over a blue particle wave.

How To Use the Stock Market API — With Examples!

Get real-time and historical market data from the stock market api. Learn quickly with easy to use examples that work right from your browser.

A diagram splitting the option symbol AAPL251219C00150000 into eight labelled parts: symbol, year, month, day, call or put, front padding, strike price dollars and strike price cents, noting that expiry falls on the third Friday and that the strike price is exactly eight digits, front-padded with zeros

How To Read An Option Symbol — Learn By Example

The best way to understand how to read a U.S. option symbol is with an real life example. Stock Ticker + YYMMDD + C/P + 8 Digit Strike Price.

How To Use The Google Finance API in 2026

The Google Finance API allowed users to query market data and portfolio data until it was shutdown. Learn how to use Google's finance data today.

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

How To Get Real Time Market Data For US Markets

Get real-time market data for stocks and options via API. Use the spreadsheet add-on to download live market data into Sheets or Excel.

OPTION DATA API in heavy black capitals, rim-lit in cyan against a deep navy starfield, with faint candlesticks arcing upward behind the words.

How To Use The Option Data API — With Examples!

The Option Data API allows you to easily get a real-time or historical option quote for stock, ETF, or index options.

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.

Winning trades are born from superior data.

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