Hi all,
Searched the forum but couldn't find a tutorial how to add coinmarketcap in excel, so here i go.
What you needMS Excel 2007/2013
MS Power Query
https://www.microsoft.com/en-us/download/details.aspx?id=39379Set up excelWhen you finished setting up power query in excel you should see this icon:
If the new tab is in excel we can start with setting up the coinmarket API in excel:
Start with going to the new power query tab and click on from web
In the next screen copy and paste this link:
https://api.coinmarketcap.com/v1/ticker/?limit=0
you'll get something like this and press ok:
After pressing ok, you'll get the following screen:
Now that the API has loaded in press the button "to table"
now press "ok" and than press the left filter button as shown here:
After you press ok you can change colum name like you prefer, or even delete colums you don't need
After you done renaming colums press "Close & Load' and you are good to go:
TIPIf you want your data to refresh every X minute set the mouse on a cel -> go to Design and press connection properties
Now you can change how fast/slow you want the coinmarketcap data to be refresh as seen below:
HelpFeel free to ask in this topic if you need help in setting up this live coinmarketcap API in excel.
If you find this topic to be helpful you can always buy me a beer:
BTC: 13mVkBy6HVwKuNovaWzYdF27FB6pLqoJtr