topic Re: Exchange Rate API in QlikView

Exchange Rate API

sifatnabil — Tue, 07 Apr 2015 01:40:06 GMT

Hi all,

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

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

Gysbert_Wassenaar — Tue, 07 Apr 2015 10:23:47 GMT

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

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

sifatnabil — Wed, 08 Apr 2015 08:11:27 GMT

Brilliant, thanks.