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 · Accepted solution]

Another thing. Please search this line in script:

if(num(purgechar(text(A),'#'))>196,Null(), text(A)) as Position

and replace it with:

A as Position

I was not aware that the Positions # can exceed 196.

Change it and it will be dynamically adapted

[suzel404]

I actualized. It works, well

[Frank_Hartmann]

Great to hear that its working.

If your problem is solved then please close this thread by marking the correct and helpful answers.

Qlik Community Tip: Marking Replies as Correct or Helpful

If you have more questions feel free to ask.

[suzel404]

Many Thanks for your help, Frank.

[suzel404]

Frank,

I test to update data. SYNX is at 299%. and see only 32.88.

[Frank_Hartmann]

For me it works fine and SYNX is actualized, see below:

[suzel404]

Fank,

Yes SYNX is updated but for Cryptopia Exchange not for Bittrex.

If you go to cryptoindexes/volatility and select Bittrex in Exchanges you will see the value of % volatility but not the same in the application if you select in qlikview @=Bittrex.

The value is different. did you see that ?

[Frank_Hartmann]

Hi yes i see that.

but could it be possible that the "@" changed between your call on website and your dataupdate in qlikview?

Or isnt that possible?

i checked the script one more time and the "Position" and "@" are correct in my opinion. Perhaps this was the problem of the website not QV.

[suzel404]

Yes , I think its possible @ change between call and data update.

SYNX is update to Cryptopia not to Bittrex. Possible an problem of the website.

[suzel404]

Hi Frank,

Iam very interesting by the WebSite. How can I get the same thing like pulldata for

/performance (_p)

/fundamental (_f)

I would like to get All data for volatility (prefix field _v), perfomance (prefix field _p) , fundamental (prefix field _f)

...

%_VOL_v,

%_VOL_p,

%_VOL_f,

...

Thanks again for your help.