Forum menu
Historic exchange r...
 

[Closed] Historic exchange rates, automated lookup?

Posts: 2053
Free Member
Topic starter
 

I have a list of dates, and would like to get the dollar / pound exchange rate for those dates.
There's quite a few of them, and it'll take ages to look them all up manually.
Can anybody think of a way to automate the process? ๐Ÿ˜•


 
Posted : 09/05/2013 12:46 pm
Posts: 36
Free Member
 

set the date range and press download (top right corner)

http://www.oanda.com/currency/historical-rates/
EDIT: oh and then obviously use lookup functions in excel to extract the date specific data from the downloaded range.


 
Posted : 09/05/2013 12:52 pm
Posts: 2053
Free Member
Topic starter
 

Blimey, that was quick!

Thanks very very very much. 8)


 
Posted : 09/05/2013 1:08 pm
Posts: 36
Free Member
 

Ive used oanda for years for my analysis work.

Its a good site.


 
Posted : 09/05/2013 1:13 pm