How to Prioritize U.S. Exchanges in Excel Stocks Data Types
Question details
Users want to configure Excel to prioritize U.S. stock exchanges when using the Stocks data type, falling back to international listings only when a U.S. listing is unavailable.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Retrieving financial market data using Excel's built-in Stocks linked data type for analysis and portfolio tracking.
- Observed behavior
- Excel automatically selects a non-U.S. exchange when a ticker symbol is listed on multiple international exchanges, ignoring user preference for U.S. markets.
Note that Excel's Stocks data type relies entirely on third-party data providers like Refinitiv, meaning default exchange prioritization is handled on the server side rather than through your local application settings.
Submit a Feature Request to Microsoft
Since Excel does not currently have a built-in setting to control default exchange selection, the primary official path is to submit feedback requesting this feature.
Stock information in Excel is supplied by Refinitiv. The system automatically determines the exchange based on the provided ticker, and there is no user-facing toggle in Excel to force a U.S. exchange priority across the board.
Open Microsoft Excel, navigate to the 'Help' tab on the ribbon, and click on 'Feedback' (or go to 'File' > 'Feedback').
Select 'I have a suggestion' from the feedback options.
Explain that you need a setting to prioritize U.S. exchanges for the Stocks linked data type and submit the form to the Microsoft engineering team.
Manually Specify the Exchange Prefix
You can bypass the default selection by manually specifying the specific U.S. exchange code before your ticker symbol.
Try WPS Office for Your Data Management Needs
If you frequently encounter limitations with Microsoft Excel's linked data types or are seeking a more cost-effective productivity solution, WPS Office provides a lightweight, highly compatible, and completely free alternative. Enjoy a familiar spreadsheet interface without expensive subscription fees.
- 1. Download WPS Office: Visit the official WPS website to download and install the free suite.
- 2. Open WPS Spreadsheet: Launch WPS Spreadsheet and easily open your existing Excel workbooks.
- 3. Manage Financial Data: Continue managing and analyzing your financial data with robust, compatible spreadsheet tools.
Frequently Asked Questions
Why does Excel choose a non-U.S. exchange for my stock ticker?
Excel retrieves stock data automatically from Refinitiv. If a ticker is listed on multiple global exchanges, the provider's server-side algorithm selects the default exchange. There is currently no localized setting in Excel to override this automated choice globally.
Can I change the default stock data provider in Excel?
No, Excel relies on its integrated partnership with Refinitiv to power linked data types. Users cannot switch to a different data provider, such as Yahoo Finance or Google Finance, within the native Stocks feature.
Is there a way to force a specific stock exchange for a single ticker?
Yes, you can manually force a specific exchange by typing the exchange's specific identifier code (MIC) or prefix before the ticker. For example, entering 'XNAS:AAPL' forces Excel to pull the data from the NASDAQ exchange.
How often is the stock data updated in Excel's linked data types?
Stock data in Excel is typically delayed by about 15 minutes, depending on the specific exchange and market conditions. You can refresh the data manually at any time by navigating to the Data tab and clicking 'Refresh All'.
