in

Market data of any cryptocurrency (Bitcoin, Ether, …) into Excel (Macro included)

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:

VIDEO TRANSCRIPT

COMING SOON!

Report

Ledger Nano X - The secure hardware wallet

What do you think?

Comments

Leave a Reply

Leave a Reply

Loading…

0