Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
evelien_morel
New Contributor

Oanda data load

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_RU...]

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

1 Solution

Accepted Solutions
mov
Esteemed Contributor III

Re: Oanda data load

Evelien,

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

Regards,

Michael

3 Replies
mov
Esteemed Contributor III

Re: Oanda data load

Evelien,

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

Regards,

Michael

evelien_morel
New Contributor

Re: Oanda data load

Michael,

it works fine now.

Can you explain how you know this?

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

Thanks

mov
Esteemed Contributor III

Re: Oanda data load

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

Community Browser