where does excel get its stock data from Guide

This article explains where does excel get its stock data from — the providers, features (Stocks data type, STOCKHISTORY), exchange coverage, refresh behavior, licensing limits, troubleshooting and...

2025-10-15 16:00:00

By Cyber Fusion

Article rating

4.7

103 ratings

Bitget offers one-stop trading for cryptocurrencies, stocks, and gold. Trade now!

A welcome pack worth 6200 USDT for new users! Sign up now!

Where does Excel get its stock data from

where does excel get its stock data from is a common question for people who use Microsoft Excel to track markets, build dashboards or run simple portfolio models. This guide explains, in plain language, which features in Excel pull market data, which external vendors supply that data, how Excel fetches and refreshes quotes and historical prices, what instruments are covered, and common limits and troubleshooting steps. You’ll also find practical tips and when you might prefer a dedicated market-data or trading provider such as Bitget.

Built-in Excel features that use market data

Excel exposes market data through several built-in features. Each feature talks to Microsoft’s online market-data service and, behind the scenes, to licensed data vendors. The main features are:

Stocks linked data type — convert a ticker or company name to a rich, linked record with attributes such as price, change, market cap and currency.
STOCKHISTORY function — request historical series (open/high/low/close/volume) as an array for a ticker and date range.
Data-type attribute extraction — when a cell is converted to the Stocks data type you can insert columns that pull individual attributes (for example, Price or MarketCap).

Most of these features require a Microsoft 365 subscription and an active sign-in to Microsoft cloud services. Availability can also be regional and may vary by Excel client (desktop, web, mobile).

Stocks data type (linked data types)

The Stocks data type turns plain text into a linked object. When you type a ticker or company name and select Data → Stocks, Excel calls Microsoft’s service to match the text to an instrument. The returned data type contains many attributes such as current price, percent change, market cap, currency, exchange, and more.

Users can add attributes into sheet columns using the Insert Data control or by clicking the small card icon that appears in the cell. Excel provides a Data Selector dialog when a name is ambiguous, letting you choose the correct exchange or issuer. Internally the service attaches identifiers to the linked record so subsequent refreshes request updated fields for the same instrument.

STOCKHISTORY function

The STOCKHISTORY function returns historical price arrays. The function signature is used like this in Excel formulas:

=STOCKHISTORY(stock, start_date, [end_date], [interval], [headers], [properties...])

Key points about STOCKHISTORY:

stock can be a plain ticker string or a cell containing a Stocks data-type record.
It returns OHLC (open/high/low/close) and optionally volume and other properties as an array that spills into adjacent cells.
Use optional parameters to set daily/weekly/monthly intervals, include headers, and request specific fields.
To disambiguate across exchanges you can prefix a ticker with a Market Identifier Code (for example XMIL:SYMBOL) when supported.

STOCKHISTORY is a server-backed function: Excel sends the request to Microsoft’s market-data endpoints and returns the resulting array to the workbook.

Primary data providers and partnerships

Microsoft does not create market data itself for Excel. Instead, it licenses data from third-party market-data vendors and exchanges. As of June 2024, according to Microsoft documentation and Microsoft 365 product information, the principal partners named for Excel’s market feeds include LSEG Data & Analytics (Refinitiv) and Nasdaq as prominent suppliers or routing partners for equity, index and reference data.

These vendors supply price quotes, reference data and historical series to Microsoft, which then serves them into Excel’s Stocks data type and STOCKHISTORY. Provider responsibilities and the exact routing of queries may change over time. Different asset classes or exchanges can come from different vendors depending on licensing and contractual arrangements.

Because the data is licensed, returned sheets often display copyright or attribution text that reflects the vendor (for example, Refinitiv/LSEG). Users should expect the vendor attribution to appear in dialogs or returned data fields in Excel.

Exchanges covered and data timeliness

Excel’s market-data coverage depends on the vendor contracts and exchange permissioning. Coverage is exchange-specific: some exchanges and listed instruments deliver near real-time prices, while others are available as delayed or end-of-day data depending on licensing.

Typical timing characteristics you should expect:

Real-time or near-real-time feeds for many large exchanges where Microsoft or its partners have agreements (delay can be 0 seconds for certain licensed feeds).
Common delay windows of 15–30 minutes for exchanges that provide consolidated, delayed data for non-subscribers or where licensing limits apply.
End-of-day data for some instruments and markets where only daily settlement values are licensed.

Excel’s support pages and the provider attribution text in your workbook will indicate which exchanges and delay profiles apply. If you require guaranteed real-time data for trading, confirm the feed’s latency and license terms before relying on Excel for execution decisions.

Real-time vs delayed data, extended-hours and historical data

Excel returns different types of time coverage depending on the instrument and vendor permissions:

Real-time (last trade) data where a live feed is licensed by Microsoft and the exchange allows distribution.
Delayed data (typically 15 or 30 minutes) when real-time distribution is not licensed for general users.
Extended-hours (pre/post-market) quotes when the vendor supports those times and Microsoft surfaces them; availability varies by exchange and instrument.
Historical series via STOCKHISTORY — daily/weekly/monthly OHLC and volume where the vendor’s historical database is accessible to the Excel service.

Always check the returned metadata (for example, LastTradeTime or an exchange-specific timestamp field) to determine the freshness of the values shown in your sheet.

How Excel retrieves and refreshes data

Mechanically, when you convert text to the Stocks data type or call STOCKHISTORY, Excel sends a request to Microsoft’s online market-data service. The service resolves identifiers and fetches the licensed data from the underlying vendors. The resulting values are returned to Excel and cached in the workbook.

Refresh behavior to note:

Linked data types remain connected to Microsoft’s service and can update automatically.
Many recent Excel versions enable automatic background refresh; a common default is every 5 minutes but your client or tenant policy may change this interval.
Manual refresh is available via Data → Refresh All when you want an immediate update.
Workbook-specific refresh settings can be configured, and large workbooks or queries can be throttled by service-side limits.

Errors and status indicators appear in cells or as banners (for example, temporary service errors or #BUSY!-style indicators) when the back-end is unavailable or a refresh fails. If you see repeated errors, check sign-in status, subscription, and Microsoft service health dashboards in your tenant.

Supported instruments (scope)

The Stocks data type and related Excel features cover a range of instrument classes depending on vendor coverage and licensing. Typical supported classes include:

Public equities listed on supported exchanges.
Major market indices and index constituents.
Exchange-traded funds (ETFs) and mutual funds where data is available.
Some fixed-income reference data (limited) and bond identifiers.
Currency pairs (forex) and reference FX quotes.
Certain cryptocurrencies or crypto reference prices where vendor coverage exists.

Coverage can differ by region and asset type. For programmatic or high-fidelity needs you may need a dedicated vendor or API.

Identifiers, exchanges and disambiguation

Tickers are not unique globally. Excel uses ticker strings, company names and market identifiers to disambiguate instruments. Market Identifier Codes (MICs) or exchange prefixes (for example, prefixing a ticker with an exchange code) help ensure Excel requests the intended listing.

If you enter an unqualified ticker that exists on multiple exchanges, Excel’s Data Selector will prompt you to choose which listing you mean. To avoid ambiguity, specify the exchange code in your input where supported. Using a Stocks data-type cell also preserves the instrument identity so subsequent STOCKHISTORY calls refer to the same instrument.

Licensing, copyright and usage restrictions

Market data in Excel is licensed from vendors and exchanges. This means:

Returned data may include copyright or attribution lines naming the vendor (for example LSEG Data & Analytics/Refinitiv).
Redistribution of vendor data outside Microsoft’s permitted contexts is typically restricted without explicit vendor consent.
Excel’s market data is provided for informational purposes and is not guaranteed for trading or regulatory compliance unless you have a direct-license feed designed for that use.

Review the Microsoft 365 Service Agreement and the data-attribution text in Excel for the authoritative license specifics related to the content delivered to your workbook.

Common limitations and troubleshooting

Users commonly run into a handful of constraints. If you encounter problems, check these items first:

Microsoft 365 subscription and sign-in: many features require an active Office 365/Microsoft 365 account.
Regional rollout: features may become available later in some markets or Office channels.
Ambiguous tickers: use the Data Selector or explicit market codes to pick the correct instrument.
Rate or usage limits: large sheets with many linked data-type cells can be throttled; use batching and consider STOCKHISTORY for historical arrays rather than many individual calls.
Errors during refresh: check service health, network connectivity, and credential status. Look for in-sheet indicators or refresh error banners.
Data not updating as frequently as needed: confirm refresh interval settings and whether the feed for that exchange is delayed by license.

If errors persist, sign out and sign back in, test on Excel for the web, or contact Microsoft support with screenshots and service timestamps.

Alternatives and third‑party data options

If Excel’s built-in coverage, timeliness or licensing does not meet your needs, you can consider alternatives:

Power Query (Get Data → From Web) to pull pages or CSVs from public sources and vendor APIs.
Third‑party APIs and add-ins that expose market data (many require API keys and separate licenses).
Direct, licensed data feeds for professional trading and compliance use cases — these include higher-cost, low-latency solutions.

For users who need a trading venue or crypto spot and derivatives liquidity alongside market data, consider Bitget for integrated services and Bitget Wallet for custody or self-custody workflows. Bitget also offers APIs and market data endpoints suitable for programmatic access where permitted.

Practical examples and usage tips

Here are short, actionable tips when working with Excel’s market data:

To answer where does excel get its stock data from in your sheet, check the data attribution and the Stocks card for the vendor name.
When a ticker is ambiguous, add the exchange prefix or use the Data Selector to pick the right listing.
Use STOCKHISTORY for efficient retrieval of historical arrays instead of many individual date queries.
If you need frequent updates, verify the automatic refresh interval in your Excel client and confirm the exchange’s delay policy — do not assume real-time without checking.
For redistribution, dashboards or commercial use, validate vendor licensing rules before sharing or embedding data externally.

Example STOCKHISTORY use (conceptual):

=STOCKHISTORY("MSFT", "2023-01-01", "2023-12-31", 0, 1, 0, 1, 2, 3, 4)

This asks for daily OHLCV for MSFT between the dates. If you converted the ticker cell to a Stocks data type, you could replace the string with the cell reference.

Security and privacy considerations

When Excel requests market data it does so via Microsoft cloud services. Consider these points:

Requests go to Microsoft endpoints and may include identifiers for the workbook, tenant or user session.
Authentication is typically required for full feature access; follow organizational policies for connecting Office applications to online services.
Do not paste sensitive credentials into workbook cells. Use secure storage and API keys for third-party integrations outside Excel’s built-in flows.

Change log and vendor updates

Provider relationships, coverage and feature behavior evolve. Microsoft periodically updates which vendors supply which instruments and may announce new partnerships. As of June 2024, Microsoft documentation continues to reference major market-data vendors such as LSEG Data & Analytics (Refinitiv) and Nasdaq among sources used to deliver market data into Excel.

Check Microsoft support pages and official Excel product updates for the latest provider and exchange information. If precise vendor identity or latency guarantees matter to your workflow, monitor those pages and Microsoft’s product release notes.

References and further reading

Authoritative sources to consult for detail and updates (search these in your browser or Microsoft documentation):

Microsoft Support: documentation on data types and the Stocks data type (includes vendor attribution details).
Microsoft 365 and Excel blog posts announcing feature rollouts and partnerships.
Excel Tech Community posts and knowledge-base articles about STOCKHISTORY behavior and refresh mechanics.
Microsoft 365 Service Agreement and Office licensing pages for legal terms and usage restrictions.

Notes on sources used (timing and authority)

As of June 2024, according to Microsoft documentation and public product information, Excel’s market data is delivered by licensed vendors such as LSEG Data & Analytics (Refinitiv) and via relationships with exchanges. Specific provider routing and exchange coverage are described in Microsoft support pages. Vendor lists and routing may be updated by Microsoft and partners over time.

Quantifiable guidance: typical feed delays for many exchanges when not covered by a real-time license commonly fall in the 15–30 minute window. Automatic background refresh intervals in Excel clients are commonly configured around a 5-minute cadence in recent updates, though tenant settings can override this. These timing figures are general ranges; always verify the feed metadata and provider attribution in your workbook for precise latency and licensing details.

Common questions: quick answers

Q: where does excel get its stock data from — one line answer?

A: Excel pulls market data from licensed third-party vendors and exchanges (for example, LSEG/Refinitiv and Nasdaq via Microsoft’s service). The exact vendor and latency depend on instrument and contract.

Q: Can I use Excel data for trading?

A: Excel’s data is intended for informational use. For live trading, use a licensed low-latency feed or an exchange-approved trading gateway. Verify licensing restrictions before using or redistributing data.

Further steps and recommended actions

If you rely on Excel for market monitoring or portfolio reports:

Check the Stocks card or returned data for vendor attribution to confirm where Excel is sourcing a given instrument.
Confirm refresh cadence and exchange delays before using prices for decisions.
For trading, liquidity or custody needs consider Bitget for integrated trading services and Bitget Wallet for custody options.

Want to explore market-data APIs or direct trading integrations? Evaluate Bitget’s API offerings and data services for programmatic access that complements Excel-based workflows.

Final practical checklist

Confirm you are signed in to Microsoft 365 and that Stocks and STOCKHISTORY features are available in your region.
Use the Data Selector or exchange prefixes to disambiguate tickers.
Check returned metadata for vendor attribution and timestamp to understand latency.
Use STOCKHISTORY to pull historical arrays instead of many individual calls.
For production or trading uses, switch to dedicated licensed feeds or Bitget services as appropriate.

Further explore Bitget for trading and Bitget Wallet for custody if you need integrated market access beyond Excel’s informational feeds. Explore more Bitget features to connect Excel-based analysis with robust trading and data APIs.

Reported context: As of June 2024, according to Microsoft product documentation and Microsoft 365 support information, Excel’s Stocks data type and STOCKHISTORY pull data from licensed vendors including LSEG Data & Analytics (Refinitiv) and established exchanges. Vendor relationships and coverage are subject to change by Microsoft and its partners.