Do you need to quickly get crypto prices in Excel? With this blog post, you'll learn how to instantly and easily keep track of your favorite cryptocurrencies. It's a great way to stay up-to-date on the ever-changing crypto markets and make informed decisions about investing. So get ready, because now you'll be able to get crypto prices in Excel with just a few clicks!
How to Access Real-Time Cryptocurrency Prices in Excel?
For users that have an Office 365 subscription, you can use the Excel stocks feature. Just type in the crypto currency you'd like to get data for and the currency in any cell of your spreadsheet. For example BTCUSD for Bitcoin.
Once you have chosen your crypto or crypto list, you will see a square on the bottom right of the cells that you can click.
This will allow you to select the data you'd like to get, including the open, high, low, and close prices.
The main limitation is that only the following cryptocurrencies are supported:
- Bitcoin (BTC)
- Bitcoin Cash (BCH)
- Litecoin (LTC)
- Ripple (XRP)
- Ethereum (ETH)
Refresh live data
On the Excel stocks menu, you will see a refresh option you can press at any time to update the data.
To get real-time crypto prices in Excel, we recommend using the Wisesheets add-on since it is more reliable and offers data coverage for many more cryptocurrencies.
Once you have installed the Wisesheet add-on, there are two simple steps to get real-time cryptocurrency prices in Excel:
Step 1: Enter your Crypto Currency Ticker Symbol
In a cell, enter the ticker symbol of the cryptocurrency whose price you want to find. Wisesheets uses the same cryptocurrency ticker system as Yahoo Finance, just without the "-" For instance, if you wanted to find Bitcoin's price, type "BTCUSD" in a cell and press enter.
Step 2: Use the Wisesheets Crypto Price Function
Once your cryptocurrency ticker symbol is entered into a cell, you can use the Wisesheets WISEPRICE function to pull up real-time prices for that cryptocurrency. In the next cell, type =WISEPRICE(cell/s that contain tickers, "price") and press enter. For example =WISEPRICE("BTCUSD", "Price")
This will pull up the latest price for the currency of your choice. Other real-time crypto data you can access includes:
- Changes Percentage
- Day Low
- Day High
- Year High
- Year Low
- Market Cap
- Price Avg 50
- Price Avg 200
- Avg Volume
- Shares Outstanding
Refresh live data
At the top of the Wisesheets add-on, you will see a refresh button you can press at any time, automatically updating to the latest price data available.
How to get historical crypto price data in Excel?
Excel Stockhistory function
The Excel Stockhistory function allows you to pull up historical data, including a given cryptocurrency's open, high, low, volume, and close prices.
In order to use this function, you need to type in the ticker name of your selected currency followed by a period "." and then the date range.
For example, if you want to pull up Bitcoin historical close price data from January 1st, 2021, to January 10th, 2021, you would type =STOCKHISTORY("BTCUSD", "01/01/2021", "01/10/2021",0,1,0,1)
As you can see, this will give you a price chart of the currency over the chosen time period.
Wisesheets Historical Price Function
If you have the Wisesheets add-on installed on Excel, you can also use the WISEPRICE function to pull up historical price data for a given cryptocurrency. For example, if you want to get Bitcoin's prices from January 1st, 2021, to January 10th, 2021, you would type =WISEPRICE("BTCUSD", "close",, "01/01/2021", "01/10/2021")
As you can see, this will give you the same price chart as the Excel Stockhistory function but with coverage for many more cryptocurrencies.
Which Cryptocurrencies are available?
Using the Excel stocks method, you are limited to the following 5 cryptocurrencies: Bitcoin (BTC), Bitcoin Cash (BCH), Litecoin (LTC), Ripple (XRP), and Ethereum (ETH).
Using Wisesheets, you can find prices for over 3,357 cryptocurrencies which is more than enough coverage for all of the popular cryptos.
Creating Your Own Custom Cryptocurrency Portfolio Tracker with Excel
If you want to create your own custom cryptocurrency portfolio tracker, you can use a combination of the methods described above or the new Wisesheets screener. Simply enter a list of the cryptocurrecnies you are looking to get data for and the data you want, press on get data, and you will have all the data right away.
Following this method, you can quickly build a custom portfolio tracker to monitor your cryptocurrency investments and make informed decisions.
In this blog post, we've discussed how to get crypto prices in Excel with just a few clicks. We covered the Excel Stocks feature for users with an Office 365 subscription and the Wisesheets add-on, which is more reliable and offers data coverage for many more cryptocurrencies. We also showed you how to access historical cryptocurrency price data in Excel and create your own custom cryptocurrency portfolio tracker with Excel. Now you have the knowledge and tools to easily track crypto prices in Excel!
Thanks for reading, and happy tracking!