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