Data Import & Export

Fix Missing 52-Week Low Stock Data in Excel

Steven ParkerSteven Parker Nov 18, 2026 869 views

Question details

Find out why 52-week low and other Refinitiv stock data fields are unavailable for some Danish companies in Excel.

Fix Missing 52-Week Low Stock Data in Excel
Product
Microsoft Excel and Refinitiv stock data
Device & OS
not provided
Scenario
The user is retrieving stock data for Danish companies, including Carlsberg and Novo Nordisk, in Excel.
Observed behavior
Some fields are unavailable for Carlsberg and multiple other Danish companies, while they remain available for Novo Nordisk. The issue appears to be worsening.
Before you start

Identify whether the workbook uses Excel's Stocks data type or a Refinitiv add-in, and note the affected ticker, exchange, and missing field names. Keep an unaffected security such as Novo Nordisk available for comparison.

Solution 1Recommended

Check the Stock Listing and Refresh Excel Data

Use this method to rule out an incorrect security match or stale linked data.

1
Check the matched security

Select the affected stock cell in Excel and open its data card, if available. Confirm that the company name, ticker, exchange, and listing match the security you need.

2
Select the correct listing

If Excel matched the wrong security, right-click the stock cell and choose Data Type > Change, then select the correct listing in the Data Selector.

3
Refresh the data

Choose Data > Refresh All in Excel, or use the refresh command in your Refinitiv add-in if the workbook gets its data through that add-in. Check the 52-week low field again.

4
Compare another stock

Check the same field for an unaffected company such as Novo Nordisk, using the same data source and workbook method. This helps establish whether the problem affects specific securities.

Check the Stock Listing and Refresh Excel Data
Refresh may not restore unavailable fields: If the provider does not supply a field for a particular listing, refreshing Excel cannot create that value.
Free Microsoft Office alternative

Work With Stock Spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Excel format compatibility for an easier move between office suites. It does not fix missing Refinitiv fields or provider permissions.

Review and organize stock data in WPS SpreadsheetsOpen and edit Microsoft Excel XLSX filesUse a familiar spreadsheet interfaceWork with a lightweight office suite for free
microsoft office alternative - wps office

Frequently Asked Questions

Why is the 52-week low available for one stock but not another?

Availability can differ by security, exchange, listing, field coverage, or account permissions. Compare the affected listing and field in Refinitiv Workspace or another supported interface.

How do I refresh stock data in Excel?

Choose Data > Refresh All. If the workbook uses a Refinitiv add-in instead of Excel's Stocks data type, use the add-in's refresh command.

How can I correct an incorrectly matched stock in Excel?

For an Excel Stocks data type cell, right-click the cell and choose Data Type > Change. Select the intended company and exchange in the Data Selector.

Can WPS Office restore missing Refinitiv data?

No. WPS Office can open and edit Excel-format spreadsheets, but it cannot restore fields missing from Refinitiv or change your provider permissions. Check linked-data and add-in compatibility before moving a workbook that depends on them.