Let’s explore how to use CRYPTOFINANCE
Today we are learning about a really unique Google Sheets tool called the CRYPTOFINANCE add-on. It is essentially a formula that operates as an add-on. It pulls the latest information from CoinMarketCap, which currently tracks 1900+ currencies. With CRYPTOFINANCE you can import this information into a spreadsheet which you can use to analyze and report on crypto data. You can also create a personal portfolio that only tracks the coins you own and the information you want to track. By default, CRYPTOFINANCE uses USD, but you can also use 30+ other fiat currencies to track your portfolio.
CRYPTOFINANCE offers both free and paid versions. If you like the free version, but want more seamless data updates, you can update to the paid version without having to change anything in your sheets. It is 10USD a month, and of course, you can pay in crypto.
How to access CRYPTOFINANCE
It is really simple to get add-ons for Sheets! The fastest way to get CRYPTOFINANCE is to click this link that will take you directly to the web store. Simply click the Free button and the add-on will be added to your Google Sheets account.
Alternatively, you can get the add-on by following these steps:
- Open a new or existing spreadsheet
- Click the Add-ons button in the navigation menu
- Click the Get Add-ons button
- A window will pop up for you to browse
- Type “CRYPTOFINANCE” in the search box.
- Click the Free button to get the add-on
You are ready to start using CRYPTOFINANCE!
How to use CRYPTOFINANCE
Now that you have added the CRYPTOFINANCE add-on to your Google Sheets account, it is time to give it a try.
Unlike other add-ons which have a lot of complicated steps to set up, CRYPTOFINANCE is pretty easy and straightforward. It is essentially a formula that has been made into an add-on to make your life easier. When you add CRYPTOFINANCE to your Google account, it is ready to be used on all of your sheets. However, if you want to deactivate it on other spreadsheets, you can click Add-ons → Manage add-ons. From the add-ons manager, click the MANAGEbutton and then click “Use in this document” to switch CRYPTOFINANCE on or off for individual sheets.
OK—Let’s make your crypto portfolio!
The first step is to pull in ALL the data from CoinMarketCap onto your first sheet.
All you need to do is copy and paste this formula into cell A1 of your sheet, and let the add-on go to work.
When you first enter the formula spreadsheet may need a few minutes to import all of the data. If you see an error message like the one in the picture before, don’t worry. As long as you have typed the formula into the cell correctly, the information will load!
Have a look! CRYPTOFINANCE has created 1910 new rows in the sheet → one for every cryptocurrency it has data on.
So, although it is great to have all of this data at our fingertips, no one wants to have to filter through nearly 2000 coins to find the info in their portfolio! Next, create a second spreadsheet within this Google Sheets File called “My Portfolio”.
Let’s create the header for our portfolio. In cell A1 type “Coin ID”. For cells B1-Q1 you can simply copy and paste the cell information from your data source sheet. (If you copy/paste cell A1, then the formula will be entered on the new sheet, pulling in all the data once again.) Go ahead and customize your fonts and colors of your header if viewing data this way is more comfortable for you.
Pull in data for the currencies you own or monitor
Let’s say you own Bitcoin, Ethereum, and Shadow Coin, we want your portfolio sheet to only display data for these coins. We can use the formula =sourcesheet!XX to import data. The name of our source sheet is CoinMarketCap. The XX’s represent specific cells within our CoinMarketCap spreadsheet.
So, as you can see in the screenshot below, the Bitcoin data lives on row 2 of our CoinMarketCap sheet. On our portfolio sheet, we can type in =COINMARKETCAPt!A2 into cell A2. Now all you need to do is click the blue square on cell A2 and drag it to the right over the rest of your columns. Google Sheets will autofill the rest of the information for you. Next, simply repeat for the currency you want to track. Keep in mind that these currencies are sorted by market cap, so as the market fluctuates, their order may change, and you may need to fix the formula in your portfolio to reflect the new cell location.