Forum Discussion

Copper Contributor

Sep 10, 2017

I need Help with the web import in excel

Hallo all i need help and dont know wath to do. If i Import somthing from the in Excel i kan not use it. I can not add the Numbers ore do anithing witz it i have allways the same bug. #value! in ger...

excel

Formulas and Functions

office 365

Manuel Moser

Copper Contributor

Sep 12, 2017

Thank you so much Bro

The Only one Problem thet i have now is, the list is chance every time, so an C12 i hab now the Price of BTC and 20 min later i have on C12 the Price of ETH.

Is it posibel to stop the chance every time ? i want just the name of the Coin and the live price of it on the same place in Ecxel.

At the moment the place is chance every time. so i ca not take the NAME and the PRICE in a other Tabel.

Thank you man you help me so much !

Best regards

Manuel

SergeiBaklan

Diamond Contributor

Sep 12, 2017

Perhaps to play with API, it's free https://www.worldcoinindex.com/apiservice.

SergeiBaklan
Diamond Contributor
Sep 15, 2017
Manuel, i just seen on the site they have API which provides JSON response, and Power Query has JSON connector. Is it workable or not requires some investigation, i didn't dig.
Manuel Moser
Copper Contributor
Sep 15, 2017
Hallo sergei,

how can i input the api in Excel ?

thank you.