Extracting coinmarketcap.com info into Microsoft Excel
Many of us just like myself are great Excel users and prefer to plot the data into Excel before performing analysis. Coinmarketcap.com is an excellent source for that.
There is a way that allows you to extract Coinmarketcap data (prices, trends and caps) into Microsoft Excel and get a live data feed from the source when hitting the refresh.
Simple steps to take:
- Copy https://coinmarketcap.com/ link to the clipboard (Ctrl+C)
- Open new excel worksheet and Select -> Data -> From Web
- Paste the https://coinmarketcap.com/ link in the Address field on the top and press "Go".
It takes some seconds to load the data. Proceed with pressing the "Import" in the bottom of the dialog box after data load from website has been finished.
All you have to do is to choose the destination cell, press OK and apply your own formatting.
If you want to refresh the data from Coinmarketcap.com you can simply press "Refresh all" in the Microsoft Excel Data Ribbon and MS Excel will insert the latest data from https://coinmarketcap.com/
This is an excellent tool for analyzing movements between ranks for Cryptos, comparing increases in price and market caps over time and identifying emerging coins.
Congratulations @edgarsk, you have decided to take the next big step with your first post! The Steem Network Team wishes you a great time among this awesome community.
The proven road to boost your personal success in this amazing Steem Network
Do you already know that @originalworks will get great profits by following these simple steps, that have been worked out by experts?
Congratulations @edgarsk! You received a personal award!
Click here to view your Board
Do not miss the last post from @steemitboard:
Congratulations @edgarsk! You received a personal award!
You can view your badges on your Steem Board and compare to others on the Steem Ranking
Vote for @Steemitboard as a witness to get one more award and increased upvotes!