The macro in the very first comment below lets you import all types of market information for any cryptocurrency/token into Excel, e.g. current price, volume, highest and lowest price in the last 24 hours, change in percent in the last 24 hours or market capitalization.
A more powerful version of this macro can be found in the reply to Has01989's comment below.
Thanks to Cryptocompare for their API and everyone involved in the development of the JSON converter.
Link to Tim Hall's JSON converter: https://github.com/VBA-tools/VBA-JSON/blob/master/JsonConverter.bas
Excel table in the video can be downloaded here:
Get ticker symbols for your cryptos on https://www.cryptocompare.com/, https://www.worldcoinindex.com or many other websites.
Values, that can be downloaded to Excel: FROMSYMBOL, TOSYMBOL, MARKET, PRICE, LASTUPDATE, LASTVOLUME, LASTVOLUMETO, LASTTRADEID, VOLUME24HOUR, VOLUME24HOURTO, OPEN24HOUR, HIGH24HOUR, LOW24HOUR,
LASTMARKET, CHANGE24HOUR, CHANGEPCT24HOUR, SUPPLY, MKTCAP
If you like the code and want to donate me some Satoshis, I'd be grateful: 13kGpAVk87XGRDm6ZscUFvGaTFyjPuKLTY