How to Fix Excel Stocks Data Not Updating for Specific Tickers Like GARE11
Question details
The user is experiencing an issue where the Excel Stocks data type successfully updates most assets, but a specific ticker (GARE11) fails to update or refresh.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Refreshing stock market data using the built-in Stocks data type to track a portfolio of financial assets.
- Observed behavior
- More than 50 assets update correctly in the spreadsheet, but the GARE11 entry remains unchanged despite manual refresh attempts.
Ensure you have an active internet connection and are signed in with a valid Microsoft 365 account, as the Stocks data type requires these to fetch live market data from external exchanges.
Verify and Update the Ticker Format
Use an exchange-qualified ticker or the full company name to help Excel properly identify and link the financial asset.
Often, a standard ticker symbol might overlap with assets in other regions, or Excel's data provider might require a specific prefix to identify the correct stock exchange.
Click on the cell containing 'GARE11' that is failing to update.
If Excel flags the cell with a question mark icon indicating an unrecognized ticker, click the icon to open the Data Selector pane on the right side of the screen.
In the search bar of the Data Selector, try typing the exchange-qualified ticker. For example, for Brazilian assets on the B3 exchange, try formatting it as 'XBSP:GARE11' or 'BVMF:GARE11'.
Review the search results provided in the sidebar and click on the correct asset to link it to your cell.
Force Refresh the Stocks Data Type
Manually trigger a data refresh to force Excel to ping the data provider for the latest information on the specific cell.
Check Data Provider Availability
Confirm whether the specific asset is currently supported by Excel's financial data provider.
Import Live Stock Data Using WPS Spreadsheet
If you are struggling with unreliable built-in data types, WPS Spreadsheet allows you to import live financial data directly from your preferred financial websites without relying on locked-in data providers.
- 1. Open WPS Spreadsheet: Launch WPS Office and open your financial tracking workbook.
- 2. Navigate to the Data tools: Click on the 'Data' tab in the top ribbon and select 'Import Data'.
- 3. Set up a Web Query: Choose 'Import External Data' and paste the URL of a financial website that tracks the GARE11 price.
- 4. Select the data table: Highlight the specific table on the webpage containing the stock price and click 'Import'.
- 5. Configure refresh settings: Right-click the imported data in your spreadsheet, select 'Data Range Properties', and set it to refresh automatically upon opening the file.
Frequently Asked Questions
Why does Excel say my stock ticker is not found?
Excel may fail to find a stock ticker if it lacks the proper exchange prefix, if the company recently changed its symbol, or if Microsoft's financial data provider (such as Refinitiv) does not track that specific regional asset.
How do I find the correct exchange prefix for international stocks in Excel?
You can usually find the correct prefix by searching the company's full name in the Excel Stocks Data Selector pane. The search results will show the asset with its required prefix. Alternatively, check MSN Money to see how the ticker is formatted for that specific exchange.
Can I manually enter stock prices if the data type fails?
Yes. If the automatic Stocks data type fails for a specific asset like GARE11, you can right-click the cell, select Data Type > Convert to Text, and manually enter the price, or use a web query to pull the data from an alternative source.
Does the Stocks data type update automatically in real-time?
No, Excel Stocks data is typically delayed (usually by 15 to 20 minutes depending on the exchange) and does not update continuously in the background. You must manually click 'Refresh All' on the Data tab to fetch the latest available prices.
