topic Re: Getting currency from internet in QlikView https://community.qlik.com/t5/QlikView/Getting-currency-from-internet/m-p/588404#M685475 <HTML><HEAD></HEAD><BODY><P>Thanks, this might help the second part of my problem (:</P></BODY></HTML> Thu, 30 Jan 2014 11:26:07 GMT 2014-01-30T11:26:07Z Getting currency from internet https://community.qlik.com/t5/QlikView/Getting-currency-from-internet/m-p/588402#M685473 <HTML><HEAD></HEAD><BODY><P>Guys, good morning,</P><P></P><P>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.</P><P></P><P></P><P></P><P>Can someone help me by doing it directly on qlikview???</P><P></P><P>these are the files:</P></BODY></HTML> Thu, 30 Jan 2014 11:11:08 GMT https://community.qlik.com/t5/QlikView/Getting-currency-from-internet/m-p/588402#M685473 2014-01-30T11:11:08Z Re: Getting currency from internet https://community.qlik.com/t5/QlikView/Getting-currency-from-internet/m-p/588403#M685474 <HTML><HEAD></HEAD><BODY><P>Check enclosed example.. which might useful to you.</P></BODY></HTML> Thu, 30 Jan 2014 11:17:42 GMT https://community.qlik.com/t5/QlikView/Getting-currency-from-internet/m-p/588403#M685474 MK_QSL 2014-01-30T11:17:42Z Re: Getting currency from internet https://community.qlik.com/t5/QlikView/Getting-currency-from-internet/m-p/588404#M685475 <HTML><HEAD></HEAD><BODY><P>Thanks, this might help the second part of my problem (:</P></BODY></HTML> Thu, 30 Jan 2014 11:26:07 GMT https://community.qlik.com/t5/QlikView/Getting-currency-from-internet/m-p/588404#M685475 2014-01-30T11:26:07Z Re: Getting currency from internet https://community.qlik.com/t5/QlikView/Getting-currency-from-internet/m-p/588405#M685476 <HTML><HEAD></HEAD><BODY><P>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...</P></BODY></HTML> Fri, 31 Jan 2014 10:05:13 GMT https://community.qlik.com/t5/QlikView/Getting-currency-from-internet/m-p/588405#M685476 2014-01-31T10:05:13Z Re: Getting currency from internet https://community.qlik.com/t5/QlikView/Getting-currency-from-internet/m-p/588406#M685477 <HTML><HEAD></HEAD><BODY><P>Anyone has any tip on that to help me please?</P></BODY></HTML> Mon, 03 Feb 2014 12:41:24 GMT https://community.qlik.com/t5/QlikView/Getting-currency-from-internet/m-p/588406#M685477 2014-02-03T12:41:24Z Re: Getting currency from internet https://community.qlik.com/t5/QlikView/Getting-currency-from-internet/m-p/588407#M685478 <HTML><HEAD></HEAD><BODY><P>Have you encountered any problem with Manish solution?</P></BODY></HTML> Mon, 03 Feb 2014 13:41:32 GMT https://community.qlik.com/t5/QlikView/Getting-currency-from-internet/m-p/588407#M685478 2014-02-03T13:41:32Z Re: Getting currency from internet https://community.qlik.com/t5/QlikView/Getting-currency-from-internet/m-p/588408#M685479 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Take a look at the script under the below thread:</P><P><A _jive_internal="true" href="https://community.qlik.com/message/231010#231010">http://community.qlik.com/message/231010#231010</A></P></BODY></HTML> Mon, 03 Feb 2014 13:56:17 GMT https://community.qlik.com/t5/QlikView/Getting-currency-from-internet/m-p/588408#M685479 2014-02-03T13:56:17Z Re: Getting currency from internet https://community.qlik.com/t5/QlikView/Getting-currency-from-internet/m-p/588409#M685480 <HTML><HEAD></HEAD><BODY><P>PFA</P></BODY></HTML> Mon, 03 Feb 2014 14:13:16 GMT https://community.qlik.com/t5/QlikView/Getting-currency-from-internet/m-p/588409#M685480 Clever_Anjos 2014-02-03T14:13:16Z Re: Getting currency from internet https://community.qlik.com/t5/QlikView/Getting-currency-from-internet/m-p/588410#M685481 <HTML><HEAD></HEAD><BODY><P>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?</P><P></P><P>this thread here helped me somehow, but i need to get the brazilian currency now aswell...</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/message/231010#231010">http://community.qlik.com/message/231010#231010</A></P></BODY></HTML> Mon, 03 Feb 2014 17:04:58 GMT https://community.qlik.com/t5/QlikView/Getting-currency-from-internet/m-p/588410#M685481 2014-02-03T17:04:58Z Re: Getting currency from internet https://community.qlik.com/t5/QlikView/Getting-currency-from-internet/m-p/588411#M685482 <HTML><HEAD></HEAD><BODY><P>Please check your email. I´ve just sent you an example</P></BODY></HTML> Mon, 03 Feb 2014 17:09:30 GMT https://community.qlik.com/t5/QlikView/Getting-currency-from-internet/m-p/588411#M685482 Clever_Anjos 2014-02-03T17:09:30Z