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:

How To Use The Mutual Fund API

Learn by example and get started with the mutual fund api. Get candlestick and pricing data going back decades.

SPX vs SPXW Options — What’s The Difference?

Learn about the all differences in SPX vs SPXW options contracts and determine which contracts are best for you.

RUT vs RUTW Options — What’s The Difference?

Learn about the all differences in RUT vs RUTW options contracts and determine which options are best for your trading strategy.

NDX vs NDXP Options — What’s The Difference?

Learn all about the differences in NDX vs NDXP options contracts and determine which contracts are best for you.

Getting Started With The Golang Stock API

Get financial data in Go using the Golang Stock API. The SDK includes a variety of methods for accessing financial data such as real-time stock quotes.

How To Bulk Download Stock Data in Google Sheets

Learn how to perform bulk stock data downloads using Market Data's Google Sheets Add-on.

What Are Non-standard Options?

Explore non-standard options: learn how corporate actions like splits change contracts, affect trading strategies, and impact markets.

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.

How To Use The Free Stock Market API: A Guided Tour of our Swagger UI

Finally, a free stock market API without scraping or proxies. Learn how to get stock pricing data, both current and historical, using swagger.

How to Look Up Preferred Stock Symbols?

For NYSE preferred stock stock symbols, use a lowercase p or use a - symbol (e.g. CDRpB or CDR-B). For NASDAQ, use the full 5 letter symbol, (e.g. LFMDP).

How To Use The Stock Market Holidays API

Use the stock market holidays API to get the open or closed status for any date in the past, present or future.

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, What’s The Difference?

What's the difference between candles vs quotes when it comes to stock data? Market Data offers both candlestick and quote data, so make sure you use the right data for your spreadsheets.

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 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.

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.

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 2024

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.

How To Get Real Time Market Data For US Markets

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

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.

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 Use The Yahoo Finance API

Learn how to access Yahoo Finance data using unofficial API methods. This guide walks you through retrieving stock quotes, historical prices, and more using publicly available endpoints.

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.

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.

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

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 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 Install The Market Data Token in Google Sheets

Getting started with Market Data is quick and easy. Authorize the add-on, open the panel, and then add your token.

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.

How To Get Options Prices in Google Sheets

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

How To Access The Market Data API From A Web Browser Securely

Add the access token to your browser's headers to access the Market Data API from a browser.