Oanda data load

Anonymous — Wed, 09 Apr 2014 06:55:41 GMT

Hi all,

About 2 years ago, I got the following link to extract data from Oanda (a currency site) from this forum.

It has worked perfectly ever since until 01/04/2014.

I have no idea what has changed an also no idea how to adjust the link to make it work again.

Does anybody have any ideas to help me fix this?

Here you find the codes which extracts the data from Oanda:

For i = '01/01/2011' to Today()

Let dd = Date(i, 'MM/DD/YY');

tEuroRates:

LOAD

Date($(i)) As ExchangeDate,

Currency,

Code,

Evaluate([EUR/1 Unit]) As ToEUR,

Evaluate([Units/1 EUR]) As FromEUR,

Year($(i)) As Year,

Month($(i)) As Month,

Day($(i)) As Day,

Week($(i)) As Week,

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

Weekday($(i)) As WeekDay,

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

Right(year($(i)),2) & '-Q' & ceil(Month($(i))/3) As [YearQtr],

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

FROM

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

(html, codepage is 1252, embedded labels, table is @1);

Next

Store tEuroRates into D:\QlikView\QV Storage\DATA\QVD\EuroRates.QVD;

drop table tEuroRates;

Thanks!

Re: Oanda data load

Anonymous — Wed, 09 Apr 2014 16:55:47 GMT

Evelien,

Try to replace table is @1 with table is @2

Regards,

Michael

Re: Oanda data load

Anonymous — Thu, 10 Apr 2014 06:31:20 GMT

Michael,

it works fine now.

Can you explain how you know this?

Or how I can find out the next time this happens?

Thanks

Re: Oanda data load

Anonymous — Thu, 10 Apr 2014 12:17:24 GMT

Evelien,

I did not "know" this. I just tried using wizard (Web Files), and there were 5 tables. The first one returned a few empty fields, and the 2nd exactly what you wanted. Apparently they've changed the web page layout a little.

Regards,

Michael

topic Re: Oanda data load in QlikView

Oanda data load

Re: Oanda data load

Re: Oanda data load

Re: Oanda data load