0

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.

0

Keep in mind that both the time zone as well as the time pulling your request, are variables affecting your results.

As mentioned under GOOGLEFINANCE documentation page:

  • end_date|num_days - [ OPTIONAL ] - The end date when fetching historical data, or the number of days from start_date for which to return data.
  • Quotes are not sourced from all markets and may be delayed up to 20 minutes.
  • Dates passed into GOOGLEFINANCE are treated as noon UTC time. Exchanges that close before that time may be shifted by a day.

As an example: taking into account the above quotes as well as that there is a time difference with Brazil (UTC -2) the results you get would be the expected ones.

Extra: Not even changing your time zone under Spreadsheet settings will make any difference (as others tried before).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.