How To Load DeFi Cryptocurrencies Data In Excel
DeFi cryptocurrencies and decentralized finances become more and more popular. Let’s analyze them with Excel then.
To load DeFi cryptocurrencies into your spreadsheet first you need data source.
Go to ribbon Power Query tab and click From Web button.
Paste the url and click ok.
In the Navigator window choose what exactly needs to be loaded into your spreadsheet and click Load.
DeFi data has been pulled into your sheet. You may use it.
You may need to create a chart. I will prepare pie of pie chart based on loaded defi data. It will be DeFi market share chart.
To create DeFi chart highlight data you need and go to Insert tab and choose chart you like.
Chart needs some formatting which I prepared.
Here is how defi market capitalization pie of pie chart looks like.
