Fix Incorrect Stock Prices in Excel Stocks Data Type
Question details
The user needs to correct an incorrect stock price returned by the Excel Stocks data type when a company name is ambiguous or misspelled.
- Product
- Microsoft Excel Stocks data type
- Device & OS
- not provided
- Scenario
- The user is looking up a stock price in Excel and the result is wrong because the company name is ambiguous or entered incorrectly.
- Observed behavior
- Excel Stocks data type returns a price that does not match the intended company or exchange listing.
Open the workbook that contains the Stocks data type cells and note the exact company name as entered, including any spelling variations or missing exchange information.
Select the Correct Exchange-Listed Company Entity in the Stocks Data Type
Use this when the Excel Stocks data type returns a price for the wrong company, an ambiguous listing, or no recognizable entity.
Excel links the stock price to the specific company entity and exchange returned by the search. If the company name is misspelled or ambiguous, the data type can bind to the wrong listing or fail to return a useful result.
Click the cell in Excel that contains the incorrect stock price or the company name you want to convert.
Go to the Data tab and click Stocks in the Data Types group. If the cell is already linked, click the small Stocks data type icon in the cell or right-click the cell and select Data Type > Change.
In the Data Selector search box, type the exact company name and, if known, the exchange code. For example, search ABBVIE INC XNYS.
From the results, select the recognized exchange-listed entity, such as ABBVIE INC on XNYS, rather than a misspelled or unrelated company name.
Check the selected cell and any linked stock fields to confirm that the stock price now reflects the intended company and exchange.
WPS Office: A Free Alternative for Spreadsheet Data Import and Analysis
The Excel Stocks data type is a Microsoft 365 feature. If you need a free, lightweight office suite that opens and edits Excel workbooks with familiar spreadsheet tools, WPS Office is a practical alternative.
- 1. Download WPS Office: Go to the WPS Office website and click Download WPS Office Free to download the installer for your device.
- 2. Install and open WPS Spreadsheets: Install WPS Office, launch it, and open WPS Spreadsheets from the home screen.
- 3. Open your Excel workbook: Click Menu > Open and select your .xlsx file to view and edit the workbook in WPS Spreadsheets.
- 4. Import data when needed: Use Data > Import Data to bring in CSV files or other supported data sources for analysis.
Frequently Asked Questions
Why does Excel Stocks show the wrong price?
It usually happens because the company name is ambiguous or misspelled, so Excel links the Stocks data type to the wrong entity or cannot find the intended listing.
How do I open the Data Selector for a Stocks cell?
Select the cell, then click the Stocks data type icon in the cell or go to Data > Stocks. If the cell is already linked, right-click the cell and select Data Type > Change.
What does XNYS mean in the stock listing?
XNYS is the exchange code for the New York Stock Exchange. Selecting an entity such as ABBVIE INC on XNYS ensures Excel uses the NYSE-listed AbbVie company.
Can WPS Office use the Excel Stocks data type?
WPS Office does not include the Microsoft 365 Stocks data type feature, but WPS Spreadsheets can open .xlsx workbooks and supports other data import methods.
Why is the stock price still not updating after I select the correct entity?
Check that the cell is linked to the Stocks data type and that any price fields reference the correct cell. Then refresh data by going to Data > Refresh All.
