Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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);
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);
Brilliant, thanks.