Bitcoin Price in Excel 365

system · May 17, 2022, 3:44pm

Originally published at: Bitcoin Price in Excel 365 - Excelbuddy.com

Learn how to quickly pull the live bitcoin price in Excel. This same method can be used to import other cryptocurrencies as well.

As of May 2022, the following cryptocurrencies are available in Excel.

Bitcoin (BTC)
Bitcoin Cash (BCH)
Litecoin (LTC)
Ripple (XRP)
Ethereum (ETH)

How to pull real-time Bitcoin Price in Excel

Start by creating a new spreadsheet.

In order to display crypto currency pricing in Excel, you must use the Cryptocurrency + Price Currency.

For example, if we want to show the Bitcoin Price in Excel, we would use: BTCUSD

Cryptocurrency-in-Excel Download

Let’s Get Started

Learn to pull Bitcoin Price in Excel

Total Time: 2 minutes

Step 1: Create a list of Cryptocurrencies

In this first step, we begin by inputting the cryptocurrency we want to track in Excel. As mentioned above, we need to use the Cryptocurrency + Price Currency. In our example, I’m showing BTC, ETH, and XRP in USD and EUR.

Step 2: Create a Table

Make sure you have a title in Cell A1. I chose “Crypto” since this example is strictly tracking crypto investments.

Highlight column “A1-A6” and go to “Insert” then “Table”

Step 3: Convert to Stocks

Once the table in created, go to “Data” then select “Stocks”

This will automatically convert the information in column A to stock formats.

Step 4: Format Crypto Tracking Results

Once the cells are formatted into stocks, Excel will pull in live data. You can add additional columns by selecting the “Add Column” box in the right hand corner.

Step 5: Add Columns to Crypto Tracking

Here is the list of Columns you can add to your table. Typically, I like to show the 52 Week Low and High. You can also insert a column to show your actual position price and shares.

Step 6: Final Result

Here is a simple way to track your Crypto investments, especially is you use multiple exchanges. Here at Excelbuddy we use Robinhood as your primary gateway for Cryptocurrency purchases.

For investing strategies, check out our Investing Discourse.