How To Import Live Cryptocurrency Prices In Excel (Cryptosheets)
If you’re looking to import live cryptocurrency prices in Excel you’ve come to the right place, there are actually several ways to import cryptocurrency prices within Excel.
However, the easiest way to import crypto prices is by using the
Cryptosheets Addon within Excel.
The reason we like Cryptosheets is the automatic price updates it does for you and all for Free.
Most importantly, you can easily grab data for both the main cryptocurrency coins, such as BTC, ETH and also alt-coins, without any extra complex programming or web scraping.
Cryptosheets essentially does all the hard work fo you.
So, in this article, we will cover exactly how you can import live cryptocurrency prices in excel using the
Cryptosheets addon within Excel. We’ll walk you through downloading the addon all the way to getting your cryptocurrency price.
Cryptosheets is an external addon that allows you to quickly import cryptocurrency prices without the need for programming, APIs or web-scraping. Having said that it is one of the easiest way to pull live, real-time, and historical cryptocurrency data directly into a sheet within Excel.
How To Import Live Cryptocurrency Prices In Excel
Step 1: Install Cryptosheets Addon In Excel
Before we can get to the bread and butter of using Cryptosheets functions, we’ll need to firstly get the Cryptosheets addon/add-in installed into our excel spreadsheet.
Of course… you’ll need to first have Excel opened on your desktop.
To get our Cryptosheets addon we can follow these steps:
- Click on
- Click on
- Search for
- Click on
- Follow and agree to the
terms and conditions
Once you’ve successfully installed Cryptosheets it should appear as an extra header option.
Step 2: Create an account with cryptosheets
Before you can get access to Cryptosheets, you’ll then need to create an account with them, which is completely free as of writing this article.
If you skip this step or in the future, you haven’t logged into Cryptosheets, your functions may throw an error.
So this part is pretty important.
To create an account, you can follow these steps:
- Click on
- Click on
- Confirm your
Once we have now successfully created and verified our account, we can now use the cryptosheets functions.
Step 3: Import live Cryptocurrency prices
There are actually a couple of ways to get live cryptocurrency prices in cryptosheets, we’ll show you a few ways that can suit your needs.
Getting real-time crypto prices that auto-update
To get real-time cryptocurrency prices that automatically update for you, we can use the function
This function basically pulls real-time prices of cryptocurrency, and updates instantly based on the intervals that have been provided.
All you need to do is to specify the cryptocurrency coin, the fiat currency you want it to convert into and the interval time in seconds.
cs.exrate() is great for tracking real-time prices to the T, which allows you to build an interactive crypto dashboard, without manually refreshing the data.
cs.exrate(Cryptocurrency coin, Quote, Time interval)
- Cryptocurrency coin: The crypto coin you’re interested in, for example, BTC
- Quote: The price you want the crypto to be converted into, for example, USD
- Time Interval: How long you want the refresh to be in seconds, if you put 1, it’ll refresh every 1 second.
To learn more, we recommend reading cryptosheets manual on cs.exrate.
Below, we have made a simple table to get the live prices of the main cryptocurrency coins.
So in the first argument, we had
=cs.exrate(BTC,USD,1) which got us the live prices of BTC in USD currency and updated every 1 second.
As you can see the prices are automatically updating each second, this feature can be useful if you plan to make your own personalized life cryptocurrency portfolio tracker.
Getting Historical and current cryptocurrency prices using cs.price()
cs.price() function allows you to pull Current & Historical Price Data for any cryptocurrency coins across exchanges. However, it does not auto-update without manually refreshing the cell.
cs.price() is great for doing analysis on previous historical prices or current historical prices.
=cs.price(Cryptocurreny ticker, quote, time, exchange)
- Cryptocurrency Ticker: This is the crypto of interest that you want to gather, for example most common is BTC (bitcoin)
- Quote: (Optional) This allows you to convert into other crypto prices or FIAT prices, for instance ETH, if you want to convert your BTC to ETH, or USD if you want to convert BTC to USD
- Time: (Optional) This allows you to get the cryptocurrency price at a specific time in its historical price
- Exchange: (Optional) If you’d like to get a specific price from an exchange, you can put the exchange name for instance “Coinbase”
You’ll probably be using these main parameters within the
cs.price() function, there are plenty more other things you can tweak, if you’d like to learn more. I would recommend reading cryptosheet’s manual.
What are the benefits of using Cryptosheets?
There are 4 key benefits of using cryptosheets addon to get cryptocurrency prices:
- Automatically grabs crypto prices for you
- Requires no programming
- Allows you to get alt coin prices
- Automatically updates cryptocurrency prices
What are the disadvantages of using Cryptosheets?
Although, cryptosheets is a great way to easily get cryptocurrency prices for beginners and intermediate users. There is a risk invovled with this plugin, which is that you’re externally using a plugin to essentially do all the work for you.
So if you’re using cryptosheets for a big organisation and there are fatal errors (from the plugin side) you’ll need to contact the developers directly.
To wrap it up
In this article, we showed you that using cryptosheets addon within excel helps you to easily grab live cryptocurrency prices using a simple function, which skips a lot of the programming and web scraping you needed to do.
FAQ: Importing Live Crypto Prices Into Excel
The most easiest way to get live cryptocurrency prices into Excel is by using the Cryptosheets Addon and using the function cs.exreate() which allows you to get live prices that update without the need for webscraping.