# Quickstart Tutorials: Google Sheets & API

> Welcome to Market Data's Quickstart Tutorials! Comprehensive guides and tutorials to help you get started with our Market Data API and Google Sheets Add-On.

Source: https://www.marketdata.app/tutorials/

---

# 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](/tutorials/api/)[Google Sheets](/tutorials/sheets/)[Show All](/tutorials/)

[

(image: A monitor on an office desk displaying MUTUAL FUNDS API, surrounded by glowing candlestick charts and network lines.)

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.

](/api/funds/how-to-use/)[

(image: A dark red tile lettered SPX above SPXW, separated by the word vs, on a red gradient background.)

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.

](/education/options/spx-vs-spxw-options/)[

(image: A teal tile lettered RUT above RUTW, separated by the word vs, on a teal gradient background.)

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.

](/education/options/rut-vs-rutw-options/)[

(image: A dark purple tile lettered NDX above NDXP, separated by the word vs, on a purple gradient background.)

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.

](/education/options/ndx-vs-ndxp-options/)[

(image: The Go language GO wordmark with trailing speed lines, glowing white against a purple starfield.)

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.

](/sdk/go/golang-stock-api/)[

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

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.

](/sheets/stocks/bulk-download-stock-data/)[

(image: Two labelled cubes: STANDARD OPTIONS, one clear block marked 100; NON-STANDARD OPTIONS, a cluster of odd blocks.)

What Are Non-standard Options?

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

](/education/options/non-standard-options/)[

(image: The word EARNINGS across a wireframe globe, ringed by bar charts, pie charts, line graphs and spreadsheet panels on a green background.)

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.

](/sheets/stocks/earnings-calendar/)[

(image: 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 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.

](/api/stocks/free-stock-market-api/)[

(image: A close, shallow-focus photograph of green and red candlesticks on a dark trading screen.)

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

](/education/stocks/how-to-look-up-preferred-stock-symbols/)[

(image: A pencil on a blue-tinted calendar page, crossed by a red band lettered 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.

](/api/stocks/stock-market-holidays/)[

(image: A pencil on a blue-tinted calendar page, crossed by a red band lettered MARKET HOLIDAYS.)

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.

](/sheets/stocks/stock-market-holidays/)
