Import Historical Currency Excahange Rates from Yahoo

[alexkurt]

Can anyone please help here?
Is it possible to import yahoo currency exchange rates from Currency Converter - Yahoo! Finance or any other reliable source for a specific date for specific currency pair (i.e. USD/EUR) ?
Thank you!!

 

[igold]

You can import for the current day with either a single pair of currencies or multiple pairs with the Yahoo API. The following will return USD/EUR for today:

http://finance.yahoo.com/d/quotes.csv?s=USDEUR=X&f=sl1d1t1

The letter codes at the end are as follows:

s = the Symbol (lookup value) queried.
l1 = the last exchange value
d1 = the last exchange date
t1 = the last exchange time

You can get currency codes here:

http://www.xe.com/iso4217.php

if you want to query multiple rates you could enter comma separated values like this:<code class="" id="code-30-8952-4"> AEDUSD=X,EURGBP=X,USDEUR=X</code>

http://finance.yahoo.com/d/quotes.csv?s=AEDUSD=X,EURGBP=X,USDEUR=X&f=sl1d1t1

I hope this helps you start.

 

[alexkurt]

That is very useful, however doesn't solve my issue.
1. is there a way to make http://finance.yahoo.com/d/quotes.csv?s=USDEUR=X&f=sl1d1t1 return the value from a specific date, say 02/18/15?
2. ultimately, I really need to extract values for historical dates (not current), say column A has the dates from 2/1/15 to 2/28/15 and column B to get imported rates.
Is that possible? Any help is much appreciated!

 

[igold]

Sorry that is all I have. When I read your question I did a quick google search and came up with what I posted. You may want to really dig in an do a more exhaustive and thorough search.

 

[alexkurt]

Thank you!
I think it is not possible to download from Yahoo.
Maybe there is another reliable source that can work?

 

[alexkurt]

Anyone?