Stock & ETF Data
US stock and ETF data, simplified.
Access real-time prices, historical data, and fundamentals for every listed stock and ETF—via API or Google Sheets.
Market Data Stock APIs
Simple to Use, Quick to Deploy, Easy to Adapt
Get market data into your applications without the overhead. Our APIs are designed for speed, clarity, and flexibility—so you can focus on building, not debugging.
Unlock the U.S. Stock Markets
Get fast, responsive pricing for U.S. equities—ideal for apps, dashboards, and tools that need consistent, up-to-the-minute quote data.
- Live pricing for any U.S. stock
- Last trade, daily & percent change included
- 52-week high/low optional
- Optional intraday-updated daily candle information
{
"s": "ok",
"symbol": ["AAPL"],
"ask": [182.12],
"askSize": [3],
"bid": [182.1],
"bidSize": [3],
"mid": [182.11],
"last": [182.1],
"change": [-0.3],
"changepct": [-0.0016],
"volume": [4051215],
"o": [182.85],
"h": [182.96],
"l": [181.93],
"c": [182.1],
"52weekHigh": [199.62],
"52weekLow": [164.08],
"updated": [1715175712]
}Supercharge your Charts & Analysis
Access robust, high-quality candlestick data to power your charting and analysis tools. One simple endpoint gives you flexible access to intraday and daily pricing, with full support for historical and recent trading activity.
- Flexible daily and intraday resolutions—1 minute to 1 year
- High-quality daily & intraday candles, updated throughout the trading day.
- Choose between as-traded or split-adjusted historical data
- Covers both regular and extended hours sessions
- Query by start/end, relative dates, or fixed count
{
"s": "ok",
"o": [221.03,
218.55,
220],
"h": [222.49,
221.5,
220.94],
"l": [217.19,
217.14,
218.83],
"c": [217.68,
221.03,
219.89],
"v": [33463820,
24018876,
20730608],
"t": [1569297600,
1569384000,
1569470400]
}Take Control of Quarterly Earnings
Don't let earnings sneak up on you. Get programmatic access to earnings reports, including reporting dates, analyst EPS estimates, earnings surprises, and more. Enhance your financial analysis with comprehensive data on reported and estimated earnings per share.
- Includes analyst EPS estimates, allowing for direct comparison with reported figures
- Earnings data for each fiscal quarter, ensuring comprehensive coverage throughout the year
- Surprise EPS values and their percentage differences for performance evaluation
- Dates of earnings reports and expected report times for precise planning
{ "s": "ok",
"symbol":
["AAPL", "AAPL", "AAPL", "AAPL"],
"fiscalYear":
[2023, 2023, 2023, 2023],
"fiscalQuarter":
[1, 2, 3, 4],
"date":
["2022-12-31", "2023-03-31", "2023-06-30", "2023-09-30"],
"reportDate":
["2023-02-02", "2023-05-04", "2023-08-03", "2023-11-02"],
"reportTime":
["after close", "after close", "after close", "after close"],
"currency":
["USD", "USD", "USD", "USD"],
"reportedEPS":
[1.88, 1.52, 1.26, 1.46],
"estimatedEPS":
[1.94, 1.43, 1.19, 1.39],
"surpriseEPS":
[-0.06, 0.09, 0.07, 0.07],
"surpriseEPSpct":
[-0.0309, 0.0629, 0.0588, 0.0504],
"updated":
["2024-05-09", "2024-05-09", "2024-05-09", "2024-05-09"]}Get The Why Behind Each Move
Get a steady stream of headlines and summaries from trusted sources, helping users stay current on what's moving the market. Ideal for personal dashboards, watchlists, or chart annotations.
- Query by date range or request a specific number of headlines
- Includes headline, content excerpt, and source URL for each story
- Delivered as HTML for easy display in personal tools and apps
{
"s": "ok",
"symbol": [
"AAPL",
"AAPL"],
"headline": [
"iPhone Exports From India Double, Predicted To Hit Record $13B This Year As Apple's Pivot Away From China Pays Off",
"Warren Buffett's $189 Billion Subtle Warning to Wall Street Shouldn't Be Ignored"],
"source": [
"https://finance.yahoo.com/news/iphone-exports-india-double-predicted-113756676.html",
"https://finance.yahoo.com/news/warren-buffetts-189-billion-subtle-084100685.html"],
"publicationDate": [
1715572800,
1715572800],
"updated": 1715572800
}The STOCKDATA Formula
One Formula For Real-Time + Historical Data
Designed for both real-time insights and in-depth historical analysis, STOCKDATA is fully configurable and provides a comprehensive view of market movements. Resolutions down to the minute and real-time quotes are supported.
STOCKDATA real-time stock data example
STOCKDATA spreadsheet without headers
STOCKDATA 1-minute candles using relative dates for automatic updating
Get Started With Stock Data
Learn how to make the most of our stock data with these quickstart tutorials for Google Sheets and the Market Data API. View all
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 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 Shee
How To Calculate Implied Volatility In Your Spreadsheet
Using the OPTIONDATA formula, you can calculate implied volatility for any option.
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 Calculate Theta For An Option
Learn how to calculate theta and understand how to add time decay to your spreadsheets.
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 Bulk Download Stock Data in Google Sheets
Learn how to perform bulk stock data downloads using Market Data's Google Sheets Add-on.
How To Get Options Prices in Google Sheets
Learn how to add real-time and historical options prices into your Google Sheets spreadsheets using a single formula.
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 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 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.