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.

go

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.

real time market data

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.

standard vs non-standard options

What Are Non-standard Options?

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

A conceptual image with a Microsoft Excel theme, representing stock earnings, featuring the title 'EARNINGS' prominently in the center. The image includes visual elements like Excel spreadsheets, pie charts, bar graphs, and financial data. The background mimics the classic green and white color scheme of Excel, emphasizing the use of spreadsheets in financial analysis. This image conveys the practical and analytical aspects of handling stock earnings in Excel.

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.

api

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.

candlestick chart

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

stock market holidays

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.

stock market holidays

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.

candlestick chart

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

How To Get An Option Chain In Google Sheets

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.

calculate theta

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

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.

Winning trades are born from superior data.

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

Sign Up For Free