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 ...
=SORT(STOCKHISTORY(A1,TODAY()-120,TODAY(),0,1,0,2,3,4,1,5),1,-1)
This formula will provide a descending sort of stock price historical data for the past 120 days for the symbol listed in cell "A1". The columns are: Date, Open, High, Low, Close, and Volume.
This formula will provide a descending sort of stock price historical data for the past 120 days for the symbol listed in cell "A1". The columns are: Date, Open, High, Low, Close, and Volume.