How to Fix Excel for Mac Selecting the Wrong Stock Exchange
Question details
Users report that the Change Data Type search pane in Excel for Mac provides unsuitable suggestions, matching stock tickers with the wrong exchanges.
- Product
- Excel for Mac
- Device & OS
- Mac
- Scenario
- Searching for and applying the Stocks data type to financial data in a spreadsheet.
- Observed behavior
- Excel suggests and selects incorrect stock exchanges for the entered tickers instead of the intended ones, an issue notably reported in versions 16.57 and 16.58.
Ensure you know the exact ticker symbol and the specific abbreviation of the intended stock exchange (e.g., NASDAQ, NYSE) before attempting to fix the mismatch.
Specify the Exchange Prefix Manually
Force Excel to pull data from the correct stock exchange by typing the exchange abbreviation directly into the cell.
Because stock tickers can be identical across different global exchanges, Excel's data provider might default to an unintended match. You can bypass the faulty search pane suggestions by explicitly stating the exchange.
Click on the cell where you want to input the stock data.
Type the standard exchange abbreviation, followed by a colon, and then the ticker symbol (for example, type 'XNAS:MSFT' for Microsoft on the NASDAQ or 'NYSE:F' for Ford on the New York Stock Exchange).
Press Enter, select the cell again, navigate to the 'Data' tab, and click on 'Stocks' to convert it. It should now lock onto the correct exchange.
Submit Bug Feedback to Microsoft
Report the incorrect matching behavior to Microsoft so they can investigate and resolve the issue with their backend data provider.
Try WPS Office for Seamless Spreadsheet Management
If bugs in Excel for Mac's data types are slowing down your workflow, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for managing your financial spreadsheets and daily tasks without the hefty subscription fees.
- 1. Download WPS Office: Visit the official WPS website and download the Mac version of WPS Office.
- 2. Open your spreadsheet: Launch WPS Spreadsheets and open your existing .xlsx financial documents directly.
- 3. Manage your data: Enjoy a smooth, bug-free experience while analyzing your financial data.
Frequently Asked Questions
Why does Excel for Mac show the wrong exchange for my stock ticker?
Excel's Stocks data type relies on a third-party data provider (like Refinitiv). Because common ticker symbols (like 'F' or 'T') exist on multiple global stock exchanges, the search pane may default to a foreign exchange if the exact region isn't specified or if there is a temporary mapping bug in the software.
How do I force Excel to use a specific stock exchange?
You can manually type the exchange's specific abbreviation followed by a colon and the ticker symbol (for example, 'NYSE:F' for the New York Stock Exchange) into the cell before applying the Stocks data type.
Are there specific Excel for Mac versions affected by this data type bug?
Yes, incorrect ticker and exchange matching was notably reported by users in Excel for Mac versions 16.57 and 16.58. However, similar issues can occasionally occur in newer versions whenever Microsoft's linked financial data provider updates its database.
