Forum Discussion
Stock History Open/Close Price Not Working for S&P 500
The Stock History function is not working for me when trying to find the Open/Close Price for the S&P 500 (INX). It works for other stocks during the same range, but when I try to use the S&P 500, I ...
I have no problems with S&P 500 Index for the Stock, but STOCKHISTORY() doesn't work with it
SergeiBaklan I also could not find a way to directly obtain the S&P500 historical data using STOCKHISTORY, however, the index fund IVV has a 99.976% correlation with the S&P500 over the past year so I suggest you consider using that as a work around.
Thanks for sharing. However, that's workaround. Real problem is that not all indexes are shown by STOCKHISTORY()
