1
=GoogleFinance("CURRENCY:EURUSD","all","1/23/2005","50")

The code above just fetch the close rate and leaves the other columns blank. How to fix that?

  • could you explain a bit more about your issue ? – user0 Sep 5 '18 at 18:40
  • I was trying to fetch the Open, High, Low, Close, Volume information for the Currency pair "EUROUSD", for the following 50 days of the one mentioned in the formula... But I get the Closing rate only. – Rana Sep 5 '18 at 18:48
  • oldest you can get is 2/4/2014 16:00:00 for EUR and 2/1/2007 16:00:00 for USD – user0 Sep 5 '18 at 19:07
  • @Rana Please note that comments are meant to be temporary. Salient information related to your question should be edited into your question post. – ale Sep 6 '18 at 0:11
1

to get the whole set of Open | High | Low | Close | Volume you need to use one currency per the formula:

  • =GOOGLEFINANCE("USD", "ALL", TODAY()-1)
  • =GOOGLEFINANCE("EUR", "ALL", TODAY()-1)

another drawback is historical data limitation:

  • for USD it's 2/1/2007 16:00:00
  • for EUR it's 2/4/2014 16:00:00

that can be checked with these formulas:

  • =GOOGLEFINANCE("USD", "ALL", DATE(2005, 1, 23), TODAY()-2000, "DAILY")
  • =GOOGLEFINANCE("EUR", "ALL", DATE(2005, 1, 23), TODAY()-1600, "DAILY")

here is a spreadsheet for a view: https://docs.google.com/spreadsheets/d/

enter image description here

  • That's great... but I wonder there must be a pair otherwise how do I value a currency... or how do I know which currency OHLC values are referring to? – Rana Sep 6 '18 at 6:27
  • @Rana exactly... if you will have a pair of currencies how you should know to which are OHLV data referring to... but I guess the main problem is that there are no data for 1/23/2005 nor any closer to that date you are trying to lookup – user0 Sep 6 '18 at 9:01
  • Your code works but I don't understand the base currency the USD or EUR (OHLCV) values are being displayed. Could you explain? – Rana Sep 14 '18 at 8:12

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.