I use this formula to get the currency:
=GoogleFinance("CURRENCY:EURUSD", "price", DATE(2006,10,2))
But when I enter a date before 2006-10-2 I get an error.
Is there any way to get older data when it comes to currencies?
-
1It is reproducible if you enter a date before 2000 something, then there is no result coming.– KungWazAug 28, 2017 at 11:04
-
Yeah, I was not specific enough in my question from the start. So the answer is correct if you look at my question, but then I made a comment about it under the answer. That I wanted to get even older data.– KungWazAug 30, 2017 at 6:21
Add a comment
|
1 Answer
I thought that there might be a cap on historical data, based on some variant of ten years, e.g. rolling quarterly, since your last available date was 1 October 2006.
I checked for myself, for the same forex pair mentioned, Euro to $US. Using this formula in Google Spreadsheet, I had no problem retrieving pre-2006 data (50 historical data points for Euro to $US, in chronological order:
=GoogleFinance("CURRENCY:EURUSD";"all";"1/23/2005";"50")
-
2Ok, so I have a followup question, how do I get only one data entry. When I change "50" to "1" I get an error. And when I set the value "2" I get 1/24/2005 as the single response, and not 1/23/2005 as I entered.– KungWazMar 17, 2015 at 14:51
-
And with this formula the history ends at 3/1/2000, so still not all the way back. I actually need 90's as well (not for EUR but for other currencies).– KungWazMar 17, 2015 at 14:55
-
1Yes, I'm also trying to get a single date, without headers. Any way to do that?– d0gMar 18, 2016 at 10:56
-
1@Ze'ev you can use
INDEXfunction to get a single field, for exampleINDEX(GoogleFinance(...), 2, 5). Documentation: support.google.com/docs/answer/3098242– EnricoSep 18, 2018 at 15:37