Real-Time Options Data, Plus Stocks, ETFs & More
Spreadsheets, REST API, Python
Get your bearings with reliable real-time options data—Greeks, IV, quotes, and more—alongside full coverage for stocks and ETFs. Whether you're coding in Python or working in Sheets, Market Data helps you stay on course.
Multi-Asset Data Coverage
All U.S. Market Data, One Flat Fee
Get complete access to U.S. stocks, options, ETFs, mutual funds, and more — all included in a single membership. No upsells, no add-ons. Just one simple plan for everything you need.
Stocks
Harness real-time quotes and decades of historical pricing data. Access fundamental data, earnings, and more.
Options
Master volatility. Get current and historical options quotes and option chains.
ETFs
Performance data for all index funds and manager-managed funds that trade in the US.
Mutual Funds
Venture into the landscape of mutual funds with our pricing and performance data.
Closed-End Funds
Discover the advantages of CEFs with Market Data's historical pricing and performance metrics.
Indices
Empower your strategy with top-tier equity indices from the US and beyond.
Futures
Historical and front month futures pricing for insights into the global commodities trade.
Currencies
Defy borders, redefine trading. Dive fearlessly into currencies data.
Crypto
Elevate your crypto trading. Power-packed data for crypto champions.
Bonds
Master fixed income securities, explore yield curves, and immerse yourself in bond data.
Economic Indicators
From employment rates to inflation, gain a 360-degree view of the US economy with our economic indicators.
Recent API & Sheets Tutorials
Get up and running quickly with our API and Google Sheets Add-on. Learn how to access real-time or historic market data programmatically or in your spreadsheet. View all
How To Bulk Download Stock Data in Google Sheets
Download stock data in bulk with the STOCKDATA formula for Google Sheets: many symbols in one request, so large spreadsheets refresh fast and cost less.
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.
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.
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.
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 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 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 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 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 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.
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.
Pricing
Quality Financial Data at a Fair Price
Begin a free 30 day trial today — no credit card required. Start working with Market Data today at no cost.
Agent setup
Paste one prompt. Your agent does the setup.
The prompt points your coding agent at our llms.txt. The agent works out whether you want the data in a spreadsheet or in code, reads your token from the MARKETDATA_TOKEN variable and finishes with a real call.
The prompt works in
- Claude Code
- Codex
- Cursor
- GitHub Copilot
- Gemini CLI
- Claude Desktop
- ChatGPT
Paste into your coding agent
Read https://www.marketdata.app/llms.txt and set up Market Data. Decide if I want data in a spreadsheet or in code; if unclear, ask one question. Spreadsheet: set up the Google Sheets add-on and its formulas (STOCKDATA, OPTIONDATA, OPTIONCHAIN, EARNINGS) and link its docs. Code: start with the official Market Data SDK for my language (Python, JavaScript, Java, C#, Go, PHP; https://www.marketdata.app/docs/sdk/); never write your own HTTP client while an SDK exists. If I have no account, tell me to sign up for the free trial at https://www.marketdata.app/signup/ and set MARKETDATA_TOKEN myself; you cannot do that step. Read the token from MARKETDATA_TOKEN, never paste it in chat or source, then make one real call (an SDK stock quote or one formula in a cell) to confirm it works.
Prefer to do it yourself? Start the free trial or read the API docs.
In a spreadsheet
You install the free Google Sheets add-on, which signs in with your Google account. The agent then writes the formula for the cell: STOCKDATA for quotes and candles, OPTIONDATA and OPTIONCHAIN for options, EARNINGS for the reporting calendar. One formula in a cell is the first call.
In code
The agent starts with the official SDK for your language: Python, JavaScript, Java, C#, Go and PHP. Every SDK reads MARKETDATA_TOKEN and handles the request and the response for you, so the agent writes no HTTP client of its own. The REST reference is there for a language without an SDK.
What the agent gets right
Our llms.txt tells it what breaks a first integration: the token travels as a Bearer header, a 203 response is a success from the cache, a 402 means the plan does not cover the request, and a 403 clears itself after five minutes. It also knows that signing up and requesting your token are your steps, not its own.