The most important piece of regulation on cryptocurrencies in the world thus far has arrived: I read through all 405 pages of the “Proposal for EU Regulation on Markets in Crypto-Assets” so you don’t have to. Here are my conclusions.

I present to you, the most important regulatory framework for cryptocurrencies so far: “Proposal for a Regulation Of The European Parliament and of The Council on Markets in Crypto-assets, and amending Directive (EU) 2019/1937”.

Import CoinGecko Cryptocurrency Data into Microsoft Excel

Did you know that you are able to extract data from API into Microsoft Excel using the in-built Power Query feature? CoinGecko’s API is completely free to use, and you can enjoy the full capability of it without needing to code at all.

By the end of this guide, you’ll be able to pull live prices and build a portfolio of your favorite cryptocurrencies directly onto your very own Excel spreadsheet with a bit of elbow grease!