This VBA-powered spreadsheet give you live exchange rates for Bitcoin, Etherium, Monero, Dogecoin and 1500 other cryptocurrencies.
This spreadsheet interrogates the coinmarketcap.com API to download the latest data for all the most popular cryptocurrencies, and even those you’ve barely heard of.
This tool is remarkably simply to use. Start by picking one of 1523 cryptocurrencies from a drop-down menu; these include Bitcoin, Etherium, Litecoin, Dogecoin, Ripple, Cardano and more.
After you click the one and only button, the spreadsheet talks to the coinmarketcap.com API and downloaded the latest
- exchange rate in USD and equivalent value in Bitcoin.
- 24 hour trading volume in USD
- market capitalization in USD
- last updated time (Unix time stamp and the corresponding time/date)
- % change over the last 1 hour, 24 hours, and 7 days
- total supply and max supply
Clicking the button again simply replaces the existing quotes with the latest data. Doesn’t get any more complicated than that!
Under the hood, some VBA does the heavy-lifting. The code is not locked down behind a password; here’s a screengrab of the code.
Since we’re working with VBA, you have the flexibility to customize the spreadsheet and code. For example, you could script the spreadsheet so that new data is downloaded whenever you select a currency from the download (so you don’t even have to press the button). Just assign this subroutine to the drop-down menu
Sub currencyID_Change() Call cryptoCurrency End Sub |
Or you could get data for several cryptocurrencies at once!
Download the spreadsheet for free here:
Excel Spreadsheet to Download Cryptocurrency Data into Excel