0

The function below should be pulling back the amazon share price on 04/04/2020. The result states $11.43 which is incorrect. This has been working for the past 6 months but not today for some reason. Is this an issue with google finance ?

=GOOGLEFINANCE("amzn","price",date(2020,4,4))

Result is:

Date                    Close
06/04/2020 16:00:00     11.43
player0
  • 124,011
  • 12
  • 67
  • 124
user1438082
  • 2,740
  • 10
  • 48
  • 82

1 Answers1

2

well 04/04/2020 is Saturday so

=GOOGLEFINANCE("amzn", "price", DATE(2020, 4, 4))

will round it up to Monday 6th

enter image description here

if you want to get the latest value 11,2 (from Friday 04/03/2020) you can do:

=GOOGLEFINANCE("NASDAQ:AMZN", "price", 
 IF(TEXT(DATE(2020, 4, 4), "ddd")="Sat", DATE(2020, 4, 4)-1, 
 IF(TEXT(DATE(2020, 4, 4), "ddd")="Sun", DATE(2020, 4, 4)-2, 
 DATE(2020, 4, 4))))

enter image description here

enter image description here

player0
  • 124,011
  • 12
  • 67
  • 124
  • hi - thanks for response. the issue is the result there in your image showing 11.20 dollars. Run your query aghain and you'll see the price is different. there must of been an issue with google for that day where the numbers got messed up server side.... – user1438082 Jul 02 '20 at 19:39