Importing currency rate from a webpage

[emrekaya]

Hey, I am not sure whether I am in the right place to ask that question. I wonder if it is possible to add currency rate from the central bank webpage in a qliksense application. 

Thanks in advance.

[Zhandos_Shotan · Accepted solution]

Hi most banks provide curr rates data by web link in xml or html table. Use url directly or create web file connection and you can see currency tables.

Here some examples:

HTMLTable:

LOAD
"Num сode",
"Char сode",
Unit,
Currency,
"Rate"
 FROM
[https://www.cbr.ru/eng/currency_base/daily/?date_req=01.03.2019]
(html, utf8, embedded labels, table is @1)

Where Match([Char сode],'USD','EUR');

XMLTable:

LOAD
Id,
NumCode,
CharCode,
Scale,
Name,
"Rate"
FROM [http://www.nbrb.by/Services/XmlExRates.aspx?ondate=$(vDate)]
(XmlSimple, table is [DailyExRates/Currency])
Where Match(CharCode,'USD','EUR','RUB');