import data from WebSite

[suzel404]

Hi all,

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

Coins , % volatilatility

Thanks for your  help.

[Frank_Hartmann]

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

in line 4 and line 26 according your environment?

[Frank_Hartmann]

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

and then try again!

[suzel404]

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

[Frank_Hartmann]

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.

[suzel404]

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%

[Frank_Hartmann]

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?

[suzel404]

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,

[Frank_Hartmann]

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

[suzel404]

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.

[Frank_Hartmann]

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: