Latest Cryptocurrency Quotes in Excel

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.

An Excel spreadsheet that downloads cryptocurrency data

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.

VBA to download bitcoin prices

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


Leave a Reply

Your email address will not be published. Required fields are marked *

What is 11 + 2 ?
Please leave these two fields as-is:
IMPORTANT! To be able to proceed, you need to solve the following simple math (so we know that you are a human) :-)