Extracting data of average monthly exchange rate from Website

[#1]

Hello Friends,

Is anyone have the sample qvw of extracting the average exchange rate month wise from the website.

Thanks in advance

Regards

Chriss

[Gysbert_Wassenaar]

See attached qvw

[#3]

Hi Gysbert,

Thanks for your sample qvw, as I am trying to extract the data from the, but I am getting the html code has a output, could you please help me, how to extract it.

URL: http://www.oanda.com/currency/average

the table format should be like, and the From Currency for USD and EUR. The To Currency for CAD, CHF and GBP

From Currency	To Currency	From Date	To date	Ex Rate

Regards

Chriss

[#4]

Hello Gysbert,

Could you please help me on this....

Regards

Chriss

[Gysbert_Wassenaar]

No, that site stinks. Too much effort to get a proper table from that. Qlikview is not a website scraper tool. Get the proper tools or find a site that publishes better tables.

[#6]

Hi Gysbert,

Thanks a lot for your efforts, I will try other websites.

Regards

Chriss

[#7]

Hello  chrismervin

     Have you found solution if yes then can u pls share it with me also because i am also searching for the same.

thank u

[#8]

Pls help it's urgent

Thank u.

[#9]

HELP

[sushil353]

Hi,

check out this video www.youtube.com/watch?v=3E1AIEoiimI

it is applied to excel.. try to use it in qlikview.

HTH

Sushil