Excel STOCKHISTORY Function Inconsistency for Netflix (NFLX) Following November 2025 Stock Split

Question

Hello,

I am using the STOCKHISTORY function in Excel to retrieve historical stock data. The function works correctly for most tickers, but not for Netflix (NFLX).

The historical data returned by STOCKHISTORY for NFLX does not appear to be adjusted for the recent 10-for-1 stock split. The current price displayed by Excel's "Stocks" data type (and the most recent historical data) is split-adjusted.

Stock: NFLX (Netflix)

Split Details: 10-for-1 forward stock split, effective for split-adjusted trading starting November 17, 2025.

For example, when using the formula to retrieve daily historical data:

=STOCKHISTORY("NFLX", DATE(2025, 1, 1), DATE(2025, 11, 15))

The closing prices returned for dates prior to November 17, 2025, are the pre-split prices (e.g., around $1000+), and they have not been divided by 10 to reflect the current, split-adjusted share count.

Question:

Is this a known issue or bug with how STOCKHISTORY processes stock splits?

Or is there an argument or setting within the STOCKHISTORY formula that needs to be toggled to force the historical price provider to deliver fully split-adjusted historical data for NFLX?

Any guidance on how to consistently retrieve historical data that matches the current split-adjusted price would be greatly appreciated. Thank you!

Answer 1

The issue you are experiencing with the STOCKHISTORY function in Excel not returning split-adjusted historical data for Netflix (NFLX) following the November 2025 stock split may be related to how the function processes stock splits. Currently, there is no documented argument or setting within the STOCKHISTORY function that allows users to toggle for fully split-adjusted historical data.

It is possible that this is a known limitation or bug with the STOCKHISTORY function, particularly for specific tickers like NFLX. Users have reported inconsistencies in the historical data returned by this function, especially around significant corporate actions such as stock splits.

For the most accurate and up-to-date information, I recommend checking Microsoft's official documentation or support channels regarding the STOCKHISTORY function to see if there have been any updates or fixes related to this issue.

If you require consistent retrieval of split-adjusted historical data, you might need to manually adjust the pre-split prices or consider using alternative data sources or methods for obtaining historical stock data that accounts for stock splits.