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:
Excel table in the video can be downloaded here:
Get ticker symbols for your cryptos on 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
Also check my open-source web app to manage your portfolio:
If you like the code and want to donate me some Satoshis, I’d be grateful: