Excel is an awesome tool for gathering data for further analysis, and even more awesome is the fact that you can update the connected data with a simple refresh.
Today you are going to learn how to connect Excel to CoinMarketCap. We will pull both historic data and live data into a spreadsheet or a data model and keep that data up to date.
In this example I am using Excel 2013 professional plus pro. You can also use Excel 2010 or Excel 2016. If you are using Excel 2010/2013 you will need to download and/or enable the Power Query add in. If you are using Excel 2016 this is already installed on the ribbons and is known as get and transform data.
This video will form the first part in a series on How to Create a Personal Coin Tracker and Dashboard in Excel. It is common to hold multiple coins on multiple exchanges and in multiple wallet. For this reason it can be difficult to keep track of what, where and how much you have.
There are services that you can use to do this for you, but I find they don’t offer the flexibility that you can have using your own Excel Tracker.
The API address used in this video is https://api.coinmarketcap.com/v1/ticker/
If you are on Wildspark.me – I have amplified this video. Please consider viewing this video on wildspark. To share in the curator rewards you will also need to amplify (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)
https://l.wildspark.me:8000/H12OrNzhW
<iframe width="560" height="315" src="
This video is also available on LBRY, feel free to leave a tip
lbry://@aBlockofCrypto#b46c6acdb6c7b2922475e674d06eb08c602a0d96/excelcryptodashboard-part1
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
This video not yet available on DTube because of duplicate posting here on STEEMIT
As a video content creator I am happy to support and try out block chain platforms for video content creators.
Upvote, Resteem and Follow
Thanks for the tutorial. I'll have to give this a try in excel. I was able to pull in live Coinmarketcap data using Google Scripts and Google Sheets which is fantastic.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Yay! Finally meeting someone who uses Google Sheets and is on Steemit.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Congratulations! This post has been upvoted from the communal account, @minnowsupport, by paulag from the Minnow Support Project. It's a witness project run by aggroed, ausbitbank, teamsteem, theprophet0, someguy123, neoxian, followbtcnews/crimsonclad, and netuoso. The goal is to help Steemit grow by supporting Minnows and creating a social network. Please find us in the Peace, Abundance, and Liberty Network (PALnet) Discord Channel. It's a completely public and open space to all members of the Steemit community who voluntarily choose to be there.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
@OriginalWorks
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
The @OriginalWorks bot has determined this post by @paulag to be original material and upvoted it!
To call @OriginalWorks, simply reply to any post with @originalworks or !originalworks in your message!
To enter this post into the daily RESTEEM contest, upvote this comment! The user with the most upvotes on their @OriginalWorks comment will win!
For more information, Click Here!
Special thanks to @reggaemuffin for being a supporter! Vote him as a witness to help make Steemit a better place!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
@paulag Steemit is gonna change lots of lifes, it has changed mine and many others but that is just the beginning. Followed
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you for this @paulag. I worked through this on Excel 2016 in tandem with the video and I managed to do it all.
Very useful learning, thank you.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
really glad you found it of use. Get and transform data in excel 2016 is such a powerful tool. I will be doing more, so keep you eye out
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
So did I. She's a very good teacher. Easy to follow.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit