Cryptocurrencies have become very popular as an alternative store of value. Cryptocurrencies have different uses and they tend to respond differently to events or demand. Running a cryptocurrency comparison can help you understand the correlation between different cryptocurrencies, and hedge your portfolio accordingly. If your portfolio consists of multiple cryptocurrencies that move very close to each other, you might be at a higher risk in the case of a downturn.

Using spreadsheets makes it easy to run analysis and build models for financial decision-making. Thanks to recent updates in Excel you can pull almost-live cryptocurrency data directly into your workbooks. You will not have to keep updating your workbooks or use third-party services for this anymore.

What we have created here is a cryptocurrency comparison template that can help you compare up to 5 cryptocurrencies side-by-side. You can enter up to 5 currency with 4 base currencies and select a metric, like opening price, closing price, or trading volume for the selected securities. The chart in the center will update when you enter a valid ticker. Finally, select the Data Type and the Period you would like to plot the data.

Note that the tickers table are not case sensitive (i.e., “BTC:USD” and “btc:usd” will give the same result). Bitcoin (BTC), Ethereum (ETH), Litecoin (LTC), Bitcoin Cash (BCH), and Ripple (XRP) are supported cryptocurrencies in Excel and this cryptocurrency comparison template.

You can download the Excel template by pressing the button below.

Try SpreadsheetWeb for free.