Forum Discussion

ChartObsrvr's avatar
ChartObsrvr
Copper Contributor
Nov 22, 2025

Stockhistory data integrity risk

Excel’s STOCKHISTORY function is misleading investors by using Refinitiv’s unadjusted feed. On Nov 1, 2025, DuPont (DD) spun off Qnity Electronics, reducing DD’s price by a factor of 2.3912. Every brokerage and charting provider adjusted the prior history to maintain continuity, but Excel did not—producing a broken series that invalidates returns, volatility, and backtests. This isn’t a feature request, it’s a data integrity bug. STOCKHISTORY must default to the adjusted feed or at least provide an adjusted:=TRUE option. If you rely on Excel for analysis, please upvote this so Microsoft fixes it before more users are misled.

excel

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Nov 23, 2025

    STOCKHISTORY shows price and volume on stock split

    same way as, for example, Yahoo Finance

    Don't think we need any additional parameters here, STOCKHISTORY could be wrapped into another formula when needed, that's Excel.

  • GeorgieAnne's avatar
    GeorgieAnne
    Iron Contributor
    Nov 23, 2025

    Hello ChartObsrvr​ 

    Hope you are doing well...

     

    Did you try a refresh? What if you made a whole new workbook and added the Stock history fresh???

     

    Let us know what you observe...

     

    GiGi

Resources