topic Re: import data from WebSite in QlikView

import data from WebSite

suzel404 — Thu, 06 Jul 2017 23:03:19 GMT

Hi all,

How can I import data from the Web site : Volatility Index | CryptoIndexes.com ?

Coins , % volatilatility

Thanks for your help.

Re: import data from WebSite

Anil_Babu_Samineni — Fri, 07 Jul 2017 08:18:19 GMT

Looks like this is not share point link. I got same task when i was earlier task. That time, I realize and ask to the Owner of the Site and request to create that data in XML / JSON file. SO then, they share with me and i used the same ....

Re: import data from WebSite

Frank_Hartmann — Fri, 07 Jul 2017 14:02:50 GMT

see attached file for workaround

hope this helps

Re: import data from WebSite

suzel404 — Tue, 11 Jul 2017 13:00:21 GMT

Frank,

Thank you so much, I need more details in my application.

How can I add the lowest price and the highest price ?

And then, how can I create an incremental for this data (I want to get back data from the web Site every 2 hours) to have an historical.

Many thanks,

Re: import data from WebSite

Frank_Hartmann — Tue, 11 Jul 2017 13:54:19 GMT

i have modified the solution.

see attached file.

hope this helps

Re: import data from WebSite

Frank_Hartmann — Tue, 11 Jul 2017 14:15:02 GMT

if you also need the script to be automatically reloaded every 2 hours then try attached solution

Re: import data from WebSite

suzel404 — Wed, 12 Jul 2017 06:19:18 GMT

Thanks Frank, I encounter some issue, see attachment file (Allow Database Write and Execute statement in pref settings). I use save website.qvw to test. The incremental manually work but the field %vol give an holder value compare to the web site.

In the application I get back 19.97 for %vol but in the web site it's 32.72 and the volume doesn't match.

Many thanks for your help, great job until that.

Re: import data from WebSite

Frank_Hartmann — Wed, 12 Jul 2017 06:23:15 GMT

do you have this option in script enabled?

Re: import data from WebSite

Frank_Hartmann — Wed, 12 Jul 2017 06:25:16 GMT

and this option also has to be enabled

Re: import data from WebSite

suzel404 — Wed, 12 Jul 2017 07:26:46 GMT

I activate checkboxes. But When I launch save website.qvw I see that.

Re: import data from WebSite

Frank_Hartmann — Wed, 12 Jul 2017 07:40:27 GMT

did you open the vbs file with editor and adapt the paths

in line 4 and line 26 according your environment?

Re: import data from WebSite

Frank_Hartmann — Wed, 12 Jul 2017 07:45:47 GMT

perhaps try opening your taskmanager and shut down all the excel processes

and then try again!

Re: import data from WebSite

suzel404 — Wed, 12 Jul 2017 17:49:26 GMT

Line 4 and 26 was modify. But did you see my screenshot ?

Re: import data from WebSite

Frank_Hartmann — Wed, 12 Jul 2017 18:24:12 GMT

yes, this was one of the first uploads. i changed this and the window will no longer appear!

please try using attached "pullData" Folder with updated vbs file.

Re: import data from WebSite

suzel404 — Wed, 12 Jul 2017 21:48:20 GMT

Thanks Frank,

When I reload the new line is added. Great! But The value of %Volatility doesn't change.

Example : TRIG actual : 20.49% however on WebSite TRIG is 156.69%

Re: import data from WebSite

Frank_Hartmann — Thu, 13 Jul 2017 06:23:25 GMT

For me it works fine and i get the actual values loaded.

see attached gif

By the way, did you adapt the 5 paths in QV Script on the last 3 tabs?

Re: import data from WebSite

suzel404 — Thu, 13 Jul 2017 13:23:30 GMT

Hi Frank,

Iam at work and its work well. I try to test on my laptop this WE.

Can I ask you an other demands.

How can I add in my table :

- The Exchange : prefix "@"

- The Position of the coins : # (depend on the Exchange, some exchange has more coins than others)

- The coefficient : highest / lowest

- The acronyme of the coins (3 letters like Ripple is XRP)

Many thanks for you help.

Regards,

Re: import data from WebSite

Frank_Hartmann — Thu, 13 Jul 2017 16:09:51 GMT

Hi Joshua,

I made some further modifications on the qvw. I added the

The Exchange

The Position

The coefficient

The acronyme

Now there is also no more need to make use of the vbs file. you can omitt it now.

I have implemented the same routine in the Qlikview Module.

So now you only need the qvw the xlsx file and the qvd files for getting the new data loaded.

That means that you only have to adapt the path of the xlsx file inside Module (Tools --> Edit Module) according to your environment. If you have all files in the same folder there is even no more need to adapt anything (paths) inside the QV Skript!

If you have more questions feel free to ask

hope this helps

Re: import data from WebSite

suzel404 — Thu, 13 Jul 2017 19:16:29 GMT

Frank,

You make me so happy!! VERY good job.

Just one thing. When I reload the application the %Vol doesn't change : 21 %

Example : TRUST is at 143% on the WebSite.

Thanks for your help.

Re: import data from WebSite

Frank_Hartmann — Thu, 13 Jul 2017 19:31:04 GMT

did you go to module and adapt the path of the excel file?

for me it is working fine and the TRUST ID is getting updated.

see below: