Data Import & Export

How to Retrieve Stock History for Delisted Companies in Excel

Kushani Nimanthika Oct 10, 2026 868 views

Question details

The user needs to retrieve historical stock prices for a delisted or merged company using Excel, but the STOCKHISTORY function no longer pulls the data.

How to Retrieve Stock History for Delisted Companies in Excel

Product: Excel
Device & OS: not provided
Scenario: Attempting to pull historical market data for a company that is no longer actively trading on the stock exchange.
Observed behavior: Excel fails to retrieve historical data for the requested ticker through its linked data service, even though older workbooks might still display previously cached data.

Before you start

Verify the exact exchange-qualified ticker symbol previously used for the company and identify the specific date the company was delisted or merged.

Solution 1Recommended

Source Historical Data from Archival Financial Platforms

Because Excel's linked data service removes tickers for delisted companies, you must retrieve this data from specialized financial archives and import it manually.

Excel's STOCKHISTORY function relies on third-party market data providers. Once a company is delisted, acquired, or goes bankrupt, the provider typically removes the ticker from its active database, rendering the Excel function unable to fetch new or historical data for that symbol.

Identify the original ticker

Find the exact ticker symbol and the stock exchange where the delisted company originally traded.

Download data from a third-party archive

Visit a specialized financial market data provider, such as Yahoo Finance, Bloomberg, or SEC EDGAR archives. Search for the historical ticker symbol and download the historical price data as a CSV file.

Import the CSV into Excel

Open Excel, go to the 'Data' tab on the ribbon, and select 'From Text/CSV'. Locate your downloaded file and load the historical prices into your workbook.

Source Historical Data from Archival Financial Platforms

Cached Data Warning: If you see historical data for a delisted company in an older workbook, it is a cached result. Refreshing the data connection will cause an error and erase the numbers.

Solution 2

Check for Merged or Re-listed Ticker Symbols

If the company was acquired or underwent restructuring, its historical data might still be accessible under a new or modified exchange-qualified ticker.

Free Microsoft Office alternative

Manage Financial Data Seamlessly with WPS Office

While specialized connected data types like STOCKHISTORY are tied to Microsoft's specific subscription services, WPS Office offers a free, lightweight, and highly compatible spreadsheet tool. It is perfect for importing downloaded historical stock CSVs, managing financial reports, and performing complex data analysis without the burden of recurring fees.

1. Download and Install: Visit the official WPS Office website to download and install the free suite on your device.
2. Open your Financial Data: Launch WPS Spreadsheets and easily open your existing .xlsx files or import downloaded CSV files containing historical stock data.
3. Analyze and Edit: Use WPS Spreadsheets' robust formatting and formula tools to analyze your financial data seamlessly.

Fully compatible with Microsoft Excel (.xlsx) formats and CSV importsEasily import external financial data and historical stock reportsLightweight software with a familiar, easy-to-use interfaceFree alternative to costly subscription-based office suites

Frequently Asked Questions

Why does the STOCKHISTORY function return a #BLOCKED! or #VALUE! error for older companies?

This usually occurs when the company has been delisted, acquired, or the ticker symbol has changed. Excel's linked data provider no longer supplies live or historical data for inactive tickers, which breaks the formula.

Can I stop my old Excel workbook from updating and losing the delisted stock data?

Yes. You can preserve the historical data by copying the cells containing the STOCKHISTORY results, right-clicking the destination cell, and selecting 'Paste as Values'. This removes the live formula and saves the cached numbers permanently.

What is an exchange-qualified ticker and why does it matter?

An exchange-qualified ticker is a symbol that includes a specific stock exchange prefix (like XNAS for NASDAQ). It ensures Excel pulls data from the exact correct market, which is crucial for preventing errors when retrieving STOCKHISTORY results.

Excel & Data Problems