Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I need to get currency rate from oanda.com.
How to get it?
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
(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.
Hi Rupali, Try this:
ExchangeRate:
LOAD Currency,
Code,
[USD/1 Unit],
[Units/1 USD]
FROM
(html, unicode, embedded labels, table is @2);
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.
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?