Data Import & Export

Fix Excel Stock Symbol Missing Data Fields or Price

Huda Qurayshi Oct 13, 2026 869 views

Question details

The user is unable to retrieve complete financial data, such as prices, for recognized stock symbols when using the Stocks data type in Excel.

How to Fix Excel Stock Symbol Missing Data Fields or No Price

Product: Microsoft Excel
Device & OS: not provided
Scenario: Pulling financial metrics and stock prices for specific companies or exchanges using the built-in Stocks data type.
Observed behavior: The stock symbol is successfully identified, but critical data fields like the current price remain blank or limited. Updating the Excel software does not resolve the issue.

Before you start

Verify that your computer has an active internet connection and that you know the exact exchange abbreviation for the stock you are trying to query.

Solution 1Recommended

Specify the Exact Stock Exchange Prefix

Ensure you are querying the correct stock exchange, as data availability varies between regional exchanges for the same company.

Excel relies on third-party financial data providers like Refinitiv. A ticker symbol might be listed on multiple global exchanges, and the data provider may only supply full data fields (like price) for specific exchanges (e.g., NYSE vs. a Canadian exchange).

Format the ticker symbol

In an empty cell, type the exchange prefix followed by a colon and the ticker symbol. For example, instead of just typing 'MSFT', type 'XNYS:MSFT' to specify the New York Stock Exchange.

Apply the Stocks data type

Select the cell containing your formatted text, go to the 'Data' tab on the Excel ribbon, and click 'Stocks' in the Data Types group.

Extract the missing fields

Click the small 'Insert Data' icon that appears next to the cell. Check if previously missing fields, such as Price or 52-week High, are now available to insert.

Data Provider Limitations: If specifying the exchange does not expose the missing fields, the third-party data provider simply does not supply that specific metric for the requested security. This is not an Excel software bug.

Solution 2

Refresh Workbook Data Connections

Force Excel to establish a fresh connection with the data provider to pull the latest available fields.

Free Microsoft Office alternative

Manage Your Financial Spreadsheets with WPS Office

If you are frustrated by built-in data limitations or subscription walls in Microsoft Excel, consider switching to WPS Office. It provides a highly compatible spreadsheet tool perfect for manual data entry, importing external CSV financial data, and executing complex calculations—all in a lightweight package.

1. Download and install: Download WPS Office for free from the official website and follow the brief installation instructions.
2. Open your financial spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx or .csv portfolio files directly without any conversion.
3. Import external stock data: Use the Data import tools to easily load stock histories from external financial websites or CSV files safely and reliably.

Fully compatible with Microsoft Excel (.xlsx, .xls) files and CSV financial exports.Free and lightweight alternative for managing complex financial models and portfolios.Familiar user interface that requires zero learning curve for Excel users.Reliable performance without heavy background data-provider processes.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel stock data show a price of zero or #N/A?

This usually occurs when the financial data provider does not have current price data for that specific stock exchange, or trading for that security is halted. Specifying the exact stock exchange using a prefix (e.g., NASDAQ:AAPL) often resolves ambiguous ticker issues.

Will updating Microsoft Excel fix missing stock fields?

Typically, no. Missing stock fields are generally a limitation of the data provider (like Refinitiv) rather than a software version issue. Updating Excel will not restore data that the provider doesn't actively supply.

Can I manually add missing stock prices if the Stock data type fails?

Yes. If the automated Stocks data type fails to pull the price, you can manually type the current price into an adjacent cell and update your spreadsheet formulas to reference your manual cell instead of the missing data field.

Excel & Data Problems