Unable to return currency data for a specific date or period with yahoo
1 view (last 30 days)
I am unable to return currency (e.g. EURUSD=X) data for a specific date or period with yahoo. It works for stocks (e.g. IBM).
Any ideas what is going on? Help much appreciated.
>> fetch(yahoo,'EURUSD=X','03-Jun-2014') Error using yahoo/fetch (line 314) Unable to return data for given security and date.
0.7358 0.0002 0.0002 0.0002 0.0002 2.5171 0.0002
Supreeth Subbaraya on 14 Aug 2014
Edited: Supreeth Subbaraya on 14 Aug 2014
You can only access the present currency data using the yahoo fetch command.
This returns the fields as shown below
Apart from that there is no feature currently to obtain the data from previous dates.
Instead you can use other service providers from the Datafeed Toolbox to obtain historical currency data.
For example, the FRED data server from the Federal Reserve offers free historical currency exchange data for some currencies. The following website lists the daily exchange rates available from the FRED server:
You can obtain the data for June 3 using the following lines of code:
>> connect = fred;
>> d = fetch(connect, 'DEXUSEU', '06/3/2014')
Title: ' U.S. / Euro Foreign Exchange Rate'
SeriesID: ' DEXUSEU'
Source: ' Board of Governors of the Federal Reserve System'
Release: ' H.10 Foreign Exchange Rates'
SeasonalAdjustment: ' Not Seasonally Adjusted'
Frequency: ' Daily'
Units: ' U.S. Dollars to One Euro'
DateRange: ' 1999-01-04 to 2014-08-08'
LastUpdated: ' 2014-08-11 3:46 PM CDT'
Notes: ' Noon buying rates in New York City for cable transfers payable in foreign currencies.'
Data: [735812 1.3436]
You can access the currency from the Data field in the structure