Google-sheets – Google Sheets – Historical Data not returning yesterday

google sheetsgoogle-finance

The formula below is been used to get the historical data until today:

=GOOGLEFINANCE("GOOG","ALL",DATE(YEAR(TODAY())-1,1,1),"12/05/2019","DAILY")

Unfortunately I don't receive today's data (until here ok, I understand why), but yesterday's data isn't passed too.

I just receive the data until 2019-12-03.

Remembering: the question was open at 2019-12-05.

Best Answer

I had the same problem. Sometime during the day, yesterday's data suddenly appeared. What I did was adding the current price to the bottom like this:

={GOOGLEFINANCE(A1,"price",date(year(A3),MONTH(A3),DAY(A3)),TODAY(),"daily");TODAY(),GOOGLEFINANCE(A1)}

Where A1 is the ticker, and A3 is a start date.

Related Topic