Function Problems

How to Fix Excel STOCKHISTORY Not Adjusted for Stock Splits

Emma Brown Oct 8, 2026 869 views

Question details

Users are finding that the Excel STOCKHISTORY function returns historical prices that are not adjusted for stock splits for certain securities, leading to inconsistent analysis.

How to Fix Excel STOCKHISTORY Data Not Adjusted for Stock Splits

Product: Microsoft Excel
Device & OS: not provided
Scenario: Pulling historical stock prices using the STOCKHISTORY function for financial modeling or analysis.
Observed behavior: The function returns unadjusted historical prices for specific securities after a stock split, creating inconsistent and inaccurate data sets compared to live tracking.

Before you start

Verify that your Microsoft 365 subscription is active and that your internet connection is stable, as STOCKHISTORY requires premium data types to fetch accurate market data.

Solution 1Recommended

Cross-Reference Data and Report to Microsoft

Since the data comes from a third-party market data provider, the most effective approach is to report the specific affected ticker symbols and use an alternative verified source temporarily.

The STOCKHISTORY function retrieves its data from a third-party market-data provider rather than calculating it locally in your worksheet. If a specific ticker symbol (like XTSE:CM) is missing split adjustments, it is usually a discrepancy at the data provider level.

Verify the data discrepancy

Compare the historical prices returned by Excel with a reliable external financial data source, such as Yahoo Finance or the official exchange website.

Report the affected ticker

Open Excel, navigate to 'Help' > 'Feedback' or visit the Microsoft Feedback Portal online. Report the exact ticker symbol experiencing the unadjusted data issue.

Import from a verified source

Until the provider corrects the STOCKHISTORY feed, temporarily import historical data from another verified adjusted-price source using the 'Get Data' (Power Query) feature in Excel.

Provider Updates May Take Time: Once Microsoft passes the feedback to their data provider, it may take some time for the historical data feeds to be corrected and fully split-adjusted.

Free Microsoft Office alternative

Try WPS Office for Your Financial Data Analysis

If you are frustrated by subscription-only features and third-party data glitches in Excel, consider switching to WPS Office. It is a free, lightweight alternative that provides excellent compatibility with Microsoft Office formats, allowing you to manage your financial spreadsheets efficiently without heavy subscription fees.

1. Download and install WPS Office: Visit the official WPS website to download and install the free software suite on your device.
2. Open your existing workbook: Launch WPS Spreadsheets and open your existing .xlsx financial workbook directly.
3. Continue your analysis: Use WPS's comprehensive financial formulas and data import tools to continue your work without interruption.

Analyze financial data with powerful built-in spreadsheet functionsFully compatible with Microsoft Excel (.xlsx) formatsFamiliar user interface for seamless and quick migrationFree and lightweight Microsoft Office alternative

Frequently Asked Questions

Why does the STOCKHISTORY function return incorrect prices?

The STOCKHISTORY function relies on third-party market data providers. If a stock recently underwent a split and the provider hasn't updated their historical database to reflect the adjustment, Excel will pull the raw, unadjusted prices.

Can I manually adjust the STOCKHISTORY data for stock splits in Excel?

Yes, you can manually adjust the data by setting up an auxiliary column in your worksheet and dividing the historical prices prior to the split date by the official split ratio.

Which versions of Excel support the STOCKHISTORY function?

The STOCKHISTORY function is available exclusively for Microsoft 365 subscribers. It is not supported in standalone, non-subscription versions like Excel 2019 or Excel 2021.

Excel & Data Problems