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:
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...