Get Crypto Prices in Excel Instantly

Get Crypto Prices in Excel Instantly

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?

Excel Stocks

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.

refresh stock data

Wisesheets add-on

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")

Crypto price data excel

This will pull up the latest price for the currency of your choice. Other real-time crypto data you can access includes:

  • Changes Percentage
  • Change
  • Day Low
  • Day High
  • Year High
  • Year Low
  • Market Cap
  • Price Avg 50
  • Price Avg 200
  • Volume
  • Avg Volume
  • Exchange
  • Open
  • 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", DATE(2023,01,01), DATE(2023,01,10),0,1,0,1)

excel stocks historical crypto data

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")

crypto historical price data excel

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.

Crypto screener excel

Following this method, you can quickly build a custom portfolio tracker to monitor your cryptocurrency investments and make informed decisions.

Conclusion

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!

Guillermo Valles
 | Website

Hello! I'm a finance enthusiast who fell in love with the world of finance at 15, devouring Warren Buffet's books and streaming Berkshire Hathaway meetings like a true fan.

I started my career in the industry at one of Canada's largest REITs, where I honed my skills analyzing and facilitating over a billion dollars in commercial real estate deals.

My passion led me to the stock market, but I quickly found myself spending more time gathering data than analyzing companies.

That's when my team and I created Wisesheets, a tool designed to automate the stock data gathering process, with the ultimate goal of helping anyone quickly find good investment opportunities.

Today, I juggle improving Wisesheets and tending to my stock portfolio, which I like to think of as a garden of assets and dividends. My journey from a finance-loving teenager to a tech entrepreneur has been a thrilling ride, full of surprises and lessons.

I'm excited for what's next and look forward to sharing my passion for finance and investing with others!

Related Posts