topic Re: currency rate from oanda.com in QlikView

currency rate from oanda.com

Wed, 06 Aug 2014 10:30:40 GMT

Hello all,

I need to get currency rate from oanda.com.

How to get it?

Re: currency rate from oanda.com

Mon, 11 Aug 2014 08:58:04 GMT

any help please....

I am currently using following code to get the currency rate.

[HisCurrency]:

LOAD

Date($(i),'DD/MM/YY') As [End Date],

[Units/1 USD] as [USD/KES],

Year($(i)) As Year,

Month($(i)) As Month,

Day($(i)) As Day,

Week($(i)) As Week,

WeekYear($(i)) & '-' & Num(Week(Today()-$(i)),'00') As RollingWeek,

Weekday($(i)) As WeekDay,

Date(MonthStart($(i)),'YYYY-MM') As RollingMonth,

Right(year(Today()),2) & '-Q' & ceil(Month(Today())/3) as [YearQtr],

'Q' & Ceil(Month($(i))/3) As Quarter

FROM [http://www.oanda.com/convert/fxdaily?date=$(dd)&date_fmt=us&exch=USD&lang=en&sel_list=KES&value=1&format=HTML&redirected=1]

(html, codepage is 1252, embedded labels, table is HRMS_PreLoad (2).qvw

But then using above code I am getting the ask rate.

But I need midpoint rate.

Please guide how to get it.

Re: currency rate from oanda.com

marthacano01 — Mon, 11 Aug 2014 21:36:44 GMT

Hi Rupali, Try this:

ExchangeRate:

LOAD Currency,

Code,

[USD/1 Unit],

[Units/1 USD]

FROM

[http://www.oanda.com/currency/table?date=08/11/14&date_fmt=us&exch=USD&sel_list=KES&value=1&format=HTML&redirected=1]

(html, unicode, embedded labels, table is @2);

Re: currency rate from oanda.com

Tue, 12 Aug 2014 05:36:08 GMT

Hello Martho,

This is giving me ask rate.

I need midpoint rate.

Is there any way to send additional parameter to the url to tell that we need midpoint rate.

Re: currency rate from oanda.com

Anonymous — Tue, 12 Aug 2014 05:39:28 GMT

I don't think this is a QlikView question, this is a question of what parameters to use to get the right information from Oanda. Perhaps they have a community forum you can ask?