# Market data in Excel and Google Sheets

Tools with a spreadsheet add-in — where the built-in GOOGLEFINANCE and STOCKHISTORY functions stop, and what picks up.

*https://stockmarketstack.com/collections/spreadsheets*

## What the built-in functions do not do

Google Sheets ships `GOOGLEFINANCE` and Excel on Microsoft 365 ships `STOCKHISTORY`. Both are
free, both cover prices, and for a lot of work they are the right answer. Three limits send people
looking for something else:

**Depth.** Ten years of income statements, segment breakdowns, estimates — none of that is in
either function. This is what [Wisesheets](https://stockmarketstack.com/tools/wisesheets),
[GuruFocus](https://stockmarketstack.com/tools/gurufocus) and [Daloopa](https://stockmarketstack.com/tools/daloopa) sell.

**Breadth.** Non-US listings, funds, FX pairs and asset classes the built-ins handle unevenly or
not at all. [EODHD](https://stockmarketstack.com/tools/eodhd) and [Twelve Data](https://stockmarketstack.com/tools/twelve-data) are both here for that.

**Terms.** Data pulled through the built-in functions is licensed for use in that spreadsheet. The
moment a model is a deliverable — a client report, a product, anything leaving your account — it
is the wrong source, whatever the numbers say.

## The same key, a very different call budget

Most of these add-ins are a second front end onto an API the vendor already sells:
[Alpha Vantage](https://stockmarketstack.com/tools/alpha-vantage), [Financial Modeling
Prep](https://stockmarketstack.com/tools/financial-modeling-prep), [Intrinio](https://stockmarketstack.com/tools/intrinio) and [Nasdaq Data
Link](https://stockmarketstack.com/tools/nasdaq-data-link) all serve the same data to a script and to a cell.

What changes is how often you call it. A script runs when you run it; a sheet recalculates on
every edit, every open, and every drag of a fill handle down two hundred rows. The rate limit that
never bound a Python job is the first thing you meet in a spreadsheet, and it is worth reading the
per-minute number on a card rather than the per-month one.

## Not only data vendors

[OpenBB](https://stockmarketstack.com/tools/openbb) brings an open-source terminal's data into a sheet;
[Quantower](https://stockmarketstack.com/tools/quantower) and [Stock Events](https://stockmarketstack.com/tools/stock-events) push the other way, letting
a platform or a tracker feed a sheet that was already the place you did the thinking. Different
starting points, same reason: the model lives in the grid and the data has to come to it.

## Cards

- [Alpha Vantage](https://stockmarketstack.com/tools/alpha-vantage.md) — The API most people's first script talks to — free key, wide coverage, hard rate limits.
- [AlphaSense](https://stockmarketstack.com/tools/alphasense.md) — AI search over 500M+ filings, broker research and Tegus expert transcripts.
- [Daloopa](https://stockmarketstack.com/tools/daloopa.md) — Filings and slide-deck KPIs, machine-extracted and dropped into your own Excel model.
- [DolphinDB](https://stockmarketstack.com/tools/dolphindb.md) — Closed-source tick database with a vector language, as-of joins and streaming engines.
- [EODHD](https://stockmarketstack.com/tools/eodhd.md) — End-of-day and fundamentals for 60+ exchanges worldwide, at a hobbyist price.
- [Financial Modeling Prep](https://stockmarketstack.com/tools/financial-modeling-prep.md) — Financial statements, ratios and filings for 70,000+ securities across 60+ exchanges.
- [FRED](https://stockmarketstack.com/tools/fred.md) — The Fed's macro database — 851,100 series, a free key and 120 requests a minute.
- [GuruFocus](https://stockmarketstack.com/tools/gurufocus.md) — Thirty years of financials, a deep screener and 13F guru portfolios, sold by region.
- [Intrinio](https://stockmarketstack.com/tools/intrinio.md) — XBRL-standardised US financials, options analytics and an MCP server.
- [IQFeed](https://stockmarketstack.com/tools/iqfeed.md) — Tick-by-tick data into a local Windows socket, with exchange fees billed on top.
- [Nasdaq Data Link](https://stockmarketstack.com/tools/nasdaq-data-link.md) — What Quandl became — Nasdaq's own exchange feeds plus a curated data catalogue.
- [OpenBB](https://stockmarketstack.com/tools/openbb.md) — One Python API, REST app and MCP server over thirty other people's data feeds.
- [ORTEX](https://stockmarketstack.com/tools/ortex.md) — Short interest estimated daily from the lending pool, with cost to borrow beside it.
- [Quantower](https://stockmarketstack.com/tools/quantower.md) — Windows order-flow terminal for 60+ connections, with an open C# API and a real free tier.
- [ROIC.ai](https://stockmarketstack.com/tools/roic-ai.md) — Forty years of global fundamentals over REST, an MCP server and Google Sheets.
- [SimFin](https://stockmarketstack.com/tools/simfin.md) — US fundamentals extracted from filings, shipped as bulk CSV datasets, not REST calls.
- [Stock Events](https://stockmarketstack.com/tools/stock-events.md) — A dividend and earnings calendar wrapped around your holdings, phone first.
- [Trading Economics](https://stockmarketstack.com/tools/trading-economics.md) — Macro data for 196 countries with its own forecasts. No free key; the API starts at $199.
- [Twelve Data](https://stockmarketstack.com/tools/twelve-data.md) — Global stocks, forex and crypto over REST and WebSocket, billed in credits per minute.
- [WhaleWisdom](https://stockmarketstack.com/tools/whalewisdom.md) — Institutional 13F holdings back to 2001, queryable from a signed REST API.
- [Wisesheets](https://stockmarketstack.com/tools/wisesheets.md) — Financials, estimates and live prices as worksheet functions in Excel and Google Sheets.
- [YCharts](https://stockmarketstack.com/tools/ycharts.md) — Advisor research and client reporting, priced by quote rather than published.

## FAQ

### What is wrong with GOOGLEFINANCE?

Nothing, for what it is. It is free, it is already in the sheet, and it covers current and historical prices for major exchanges. What it does not do is fundamentals at any depth, statements going back further than the recent past, estimates, or anything you may redistribute — the data is licensed to you for use inside Google Sheets and nowhere else. Every add-in on this page exists on the far side of one of those limits.

### Does Excel have something built in?

Yes — the STOCKHISTORY function and linked data types, on Microsoft 365. Same shape of answer as GOOGLEFINANCE — prices yes, depth no, and delayed rather than live. Add-ins plug into the same grid and bring their own provider, which is also what makes them cost money.

### Will an add-in give me real-time prices in a sheet?

Some will, on the right plan, and it is worth asking why you want it. A spreadsheet recalculating a live quote is a poll against a rate limit, and the free and low tiers here are all delayed or end-of-day. Where a vendor does serve live prices into a sheet, the exchange fees apply exactly as they would through the API.

### Are these add-ins just a wrapper around the same API?

Usually yes, and that is the point rather than a criticism — the same key works from Python and from a cell. What differs is the call budget. A sheet full of formulas recalculates far more often than a script runs, so the plan that felt generous through the API can burn through its quota in a morning of dragging fills down a column.