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?
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?
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")
INDEX
function to get a single field, for example INDEX(GoogleFinance(...), 2, 5)
. Documentation: support.google.com/docs/answer/3098242