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, 2018 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, 2018 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, 2018 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, 2018 at 0:11

1 Answer 1


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


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, 2018 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, 2018 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, 2018 at 8:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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