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]

If i have free time slot i will try providing a solution

but today and tomorow im reallly busy so this could take some time...

[suzel404]

Frank,

Yes, I know. Thanks for your help.

U do great work.

[Frank_Hartmann]

Hi Joshua,

see attached for actualized files. you just have to adapt the three paths of the excel files inside

the module (Tools-->Edit Module).

If you have further questions or problems feel free to ask.

If this was helpful you can even mark answers as helpful:

Re: How to mark Helpful or correct reply?

hope this helps!

[suzel404]

Frank,

Again , Thanks for your job. A little modification.

I want Performance, Volatility, Fundamental at the same level.

When I select the name like SEC, Time like 18.07.2017 11:45:22 I can see all fields Perfomance, Volatility, Fundamentals) on the same table, one line.

You did a great job!

Regards,

[suzel404]

I was imagine one table like Final with :

LOAD

Row,

Time,

Name,

Acronyme,

Coins,

%_VOL,

highest,

lowest,

coefficient,

[@],

Position ,

Row,

Time,

Name,

Acronyme,

Coins_p,

%_VOL_p,

highest_p,

lowest_p,

coefficient_p,

[@],

Position _p

Row,

Time,

Name,

Acronyme,

Coins_f,

%_VOL_f,

highest_f,

lowest_f,

coefficient_f,

[@],

Position _f

FROM QVD.

Now, I can easily see the value of coins on one line.

What do you think about that ?

[suzel404]

I do some modifications, are you agree about that ?

[Frank_Hartmann]

hi, see attached.

one problem might be that some Acronyms are not available in every of the three lists. this is why there are a lot of Nulls now. If you only want to see acronyms which are available in every of the three lists just go to Presentation Tab and activate "Omit where Rows  where Field is Null" for all Fields.

[suzel404]

Excellent Work!!

How to mark Helpful or correct reply?

doesn't work...

Many thanks.

[Frank_Hartmann]

I just saw that above files script run was not successful. see attached file for mdification!

For marking threads as helpful you need to open the link to the thread:

import data from WebSite

If you are watching the thread through your Inbox the options for marking correct/helpful are not visible

[Frank_Hartmann]

i just saw that something might not be correct. need some further investigations....