=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 ?– user0Sep 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.– RanaSep 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– user0Sep 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.– aleSep 6, 2018 at 0:11
Add a comment
|
1 Answer
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
USDit's2/1/2007 16:00:00 - for
EURit's2/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/
-
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?– RanaSep 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– user0Sep 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?– RanaSep 14, 2018 at 8:12