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 received a personal award!
Click here to view your Board
Do not miss the last post from @steemitboard:
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit