Getting currency from internet

[#1]

Guys, good morning,

I need to get currency exchange at the internet. For this I use an Excel file that generates the URL final part, to get everything until today, and then I go to the site and get the .xls file. After I get the file and the BR currency I do the inverse (1/value I get), and then I load it in the script. Also, some of the days it's blank the space, because either it's weekends, or holidays. So, I need that to be repeated the last number in those blank fields.

Can someone help me by doing it directly on qlikview???

these are the files:

[MK_QSL]

Check enclosed example.. which might useful to you.

[#3]

Thanks, this might help the second part of my problem (:

[#4]

Anyone can help me with that?? Any solution is good for me, as long as I press reload button and gets from internet, no matter which site...

[#5]

Anyone has any tip on that to help me please?

[#6]

Have you encountered any problem with Manish solution?

[#7]

Hi,

Take a look at the script under the below thread:

http://community.qlik.com/message/231010#231010

[Clever_Anjos · Accepted solution]

PFA

[#9]

Problem is that I need to get the real currencies from the internet, with no manual step of extracting any data... Do you know how can we do that?

this thread here helped me somehow, but i need to get the brazilian currency now aswell...

http://community.qlik.com/message/231010#231010

[Clever_Anjos]

Please check your email. I´ve just sent you an example