Using stockhistory formula on some stocks to pull stock price for 3-months or 1-year historical. However, they never include todays stock price even a few hours after close. I checked (https://support.microsoft.com/en-us/office/about-the-stocks-financial-data-sources-98a03e23-37f6-4776-beea-c5a6c8e787e6)) which states that the delay is 15 mins for US stocks yet it wont show these values in stockhistory formula. It does work if you use STOCKCELL.price but wondering why there is a discrepancy here.

​Using stockhistory formula on some stocks to pull stock price for 3-months or 1-year historical. However, they never include todays stock price even a few hours after close. I checked (https://support.microsoft.com/en-us/office/about-the-stocks-financial-data-sources-98a03e23-37f6-4776-beea-c5a6c8e787e6)) which states that the delay is 15 mins for US stocks yet it wont show these values in stockhistory formula. It does work if you use STOCKCELL.price but wondering why there is a discrepancy here.  Read More

​