Forum Discussion

minemier's avatar
minemier
Copper Contributor
Nov 25, 2024

Using Stockhistory in Excel for S&P 500 pulls data for December 25th

Hello,

 

Using stockhistory to compare some companies to the S&P 500, using the stockhistory to pull S&P 500 index always includes data for December 25th (markets are closed this day) and the value is always a super high number. Is there any way to stop it from pulling data for December 25?

 

Thanks,

excel
Formulas and Functions
  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Nov 26, 2024

    Hi

    It's always good to share/post an example of the formula you use as whatever stock symbol I used I didn't get the 25th in December 2023. That said, I don't think you tell STOCKHISTORY not to pull specific dates. However, FILTERing the returned array to exclude 1 or more dates is doable of course

    If you need help with this please share the formula you use and which date(s) you want to filter out

Resources