Importing currency rate from a webpage

emrekaya — Sat, 16 Nov 2024 21:19:19 GMT

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.

Re: Importing currency rate from a webpage

Zhandos_Shotan — Sat, 02 Mar 2019 07:36:17 GMT

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');

topic Re: Importing currency rate from a webpage in App Development

Importing currency rate from a webpage

Re: Importing currency rate from a webpage