currency rate from oanda.com

[#1]

Hello all,

I need to get currency rate from oanda.com.

How to get it?

[#2]

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&fo...]

     (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.

[marthacano01]

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=H...]

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

[#4]

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.

[Anonymous]

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?