Exchange Rate API

[sifatnabil]

Hi all,

Is there any way to call exchange rate data from the Quandl exchange rate API?

https://www.quandl.com/resources/api-for-currency-data

I would like to bring in historical exchange rates and apply it on the data in the load script.

[Gysbert_Wassenaar · Accepted solution]

Yes, something like this should work:

EURUSD_ExchangeRates:

LOAD date#(subfield(Data,',',1),'YYYY-MM-DD') as Date,

  num#(subfield(Data,',',-1),'#.0000') as Value;

LOAD purgechar(subfield(textbetween(replace(replace(@1,'[[','@@['),']]','}@@'),'@@','@@'),'],['),'["}') as Data

FROM

[http://www.quandl.com/api/v1/datasets/ECB/EURUSD]

(txt, codepage is 1252, no labels, delimiter is '\b', msq);

[sifatnabil]

Brilliant, thanks.