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.

No RepliesBe the first to reply

Resources