In this video you will learn how to connect Excel to Coinmarketcap data. First we will look at using the API to connect to live ticker data. Then we look connect to a historic table on the coinmarketcap website to gather historic cryptocoin pricing and volume data The API used is https://api.coinmarketcap.com/v1/ticker/ and for the historic prices we will look at the coins STEEM and BITCOIN This can be used to create a crypto currency excel tracker that will auto update. Follow me to see how you can use this data to create your own cryptocurrency holding dashboard in Excel If you are on Wildspark.me – I have amplified this video. To share in the curator rewards you will also need to amplify https://l.wildspark.me:8000/H12OrNzhW (I am one of the few to be approved as an approved content creators with wild spark and I do currently earn from this platform And is available on view.ly https://upload.view.ly/view/useruploads/4204--2017-10-04--connect-excel-to-coinmarketcap-for-live-and-historic-data If you are not yet on view.ly please consider signing up with this Affiliation link https://view.ly?a=f5917604vly11eb