Forum Discussion
ksidhu13
Aug 27, 2024Copper Contributor
Stockhistory function producing duplicate values
Hi, I've been using Stockhistory for some time in excel to get stock data to produce a distribution of returns. For the whole time it has worked perfectly, however in the last few days I've had i...
Repichi
Jul 28, 2025Iron Contributor
Use UNIQUE(STOCKHISTORY()) for deduplication, or clean duplicate data via Power Query.