How to use CRYPTOFINANCE add-on for Google Sheets (2024)

The CRYPTOFINANCE add-on for Google Sheets is a great tool that allows users to automatically transfer the latest cryptocurrency data into their spreadsheets. CRYPTOFINANCE also allows you to analyze and create insightful reports, as well as your own personal portfolio to keep track of the currencies you own. Now part of Cryptowatch, CRYPTOFINANCE pulls real-time cryptocurrency insights from over 988 cryptocurrencies in 29 exchanges.

CRYPTOFINANCE is essentially a formula that you can use within Google Sheets to access Cryptowatch’s huge database of cryptocurrency information. To access, you must have a Cryptowatch account. There is a free and paid version of Cryptowatch, which will determine the amount of access to both live and historical data.

Let’s explore in more detail on why you should use the CRYPTOFINANCE add-on in Google Sheets and how to successfully install and use it.

Why use CRYPTOFINANCE in Google Sheets?

The CRYPTOFINANCE add-on in Google Sheets is a great way to receive all of the latest cryptocurrency data whilst turning these into useful insights easily. Here are just a few of the additional benefits of choosing to use the product:

  • Real-time insights: You can create a live connection to Cryptowatch with Google Sheets to receive all real-time data.
  • Easy-to-use interface: By monitoring cryptocurrency through the Google Sheets interface, you can make the most of a tool that you’re already familiar with, for maximum efficiency.
  • Implement analytical features of Google Sheets: Use Google Sheets’ powerful analytical tools to create visual representations of your data and calculate useful insights.

As CRYPTOFINANCE can only be accessed via Cryptowatch now, you must create an account to access the data. Cryptowatch has a number of plans that vary in price, or simply pay as you go. Every subscription is paid using credits, which you can exchange your money for. Cryptowatch does have a Fundamental package that’s free to use (offering 100 requests), and you can also get a 2 week free trial of their Derivative package which offers unlimited access to everything.

Click on this link to learn more about Cryptowatch’s pricing plans.

How to install CRYPTOFINANCE on Google Sheets

Step 1: Remove old CRYPTOFINANCE add-on

If you already have CRYPTOFINANCE installed as an add-on from its old version on Workspace, you must remove it before installing the new version.

To do this, open your spreadsheet and head to Add-ons > Manage add-ons and select Uninstall from the More options (⋮) button located on the CRYPTOFINANCE app.

Step 2: Add the script

In your Google Sheets file, select Tools > Script editor. The script editor should open in a new tab.

Delete any existing copy. Copy and paste the content of CRYPTOFINANCE.gs into the page. Don’t forget to name the script clearly.

Once pasted correctly, click the Save icon found on the top menu.

How to use CRYPTOFINANCE add-on for Google Sheets (1)

Step 3: Run the script and refresh your Google Sheet

Once saved, click the Run button located immediately to the right. Cryptofinance may require permission to access your Google account.

Head back to your Google Sheet and refresh the page. A new CRYPTOFINANCE section should appear in the toolbar.

How to use CRYPTOFINANCE add-on for Google Sheets (2)

Now that you have successfully connected the CRYPTOFINANCE tool to Google Sheets, it’s now time to learn how to use it.

How to use CRYPTOFINANCE in Google Sheets

Google Sheets is able to access Cryptofinance data by generating Cryptowatch API keys.

You must create your API keys in the Cryptowatch software before you can access it in Google Sheets.

1. Sign in/create Cryptowatch account

First, you must sign in to your Cryptowatch account. This should take you to the homepage.

2. Generate API key

In the top right-hand corner of the homepage, click on the Account dropdown and select API Access.

How to use CRYPTOFINANCE add-on for Google Sheets (3)

To generate your key, provide a title for the Key name field. Then press Generate key.

You should see two unique key codes appear. To access CRYPTOFINANCE, we only need the Public key code.

How to use CRYPTOFINANCE add-on for Google Sheets (4)

3. Connect API key to Google Sheets

Now head back to your Google Sheets file. Go to CRYPTOFINANCE > Enter Cryptowatch Public API Key and enter the unique Public key code into the field.

Once entered, press Ok.

How to use CRYPTOFINANCE add-on for Google Sheets (5)

4. Enter formula to extract data

Now that your Google Sheets is successfully connected to CRYPTOFINANCE, you can enter any formula to get the data you want.

Your formula will always start with =CRYPTOFINANCE(“name”):

=CRYPTOFINANCE(“name”)

Here are just a few examples of what you can do:

Access ALL data from Cryptowatch

To transfer all the data from Cryptowatch, enter the following formula:

=CRYPTOFINANCE(“CRYPTOWATCH”)

You should now have a new row for every cryptocurrency that Cryptowatch has data on.

How to use CRYPTOFINANCE add-on for Google Sheets (6)

Transfer specific cryptocurrency value

To get the latest data from specific cryptocurrencies, simply add the cryptocurrency symbol and your chosen exchange currency to the formula.

For example, let’s say I want to find the current exchange rate for Bitcoin in USD. I would enter the following formula:

=CRYPTOFINANCE(“BTC/USD”)

The value should appear as shown below:

How to use CRYPTOFINANCE add-on for Google Sheets (7)

How to create your own crypto portfolio

As long as you have a tab full of all CRYPTOFINANCE data (aka, your source sheet), you can then create your very own personal portfolio!

Use this to keep track of any cryptocurrencies you own, and keep stay up-to-date with the latest insights.

1. Create new tab

Create a new tab and name it “My portfolio”.

Copy and paste the headers you want to include in your portfolio from the source sheet.

2. Pull in data from source sheet to your portfolio

To transfer data of specific cryptocurrencies, create a formula that pulls the data of specific cryptocurrencies from your source sheet.

To do this, you first need to locate the cell of your chosen cryptocurrency.

For example, if I want to use Bitcoin, I can see that in my source sheet, it is located in cell B4.

How to use CRYPTOFINANCE add-on for Google Sheets (8)

Now, I can use a formula in My portfolio to transfer the Bitcoin data. The formula is as follows:

= ‘source sheet’ !XX

  • ‘sourcesheet’ should be substituted for the name of your source sheet
  • ‘XX’ should be substituted for the cell location of your cryptocurrency

In this example, I would enter the following formula:

=’All cryptocurrency’ !B4

Once entered, click the blue square on the cell and drag it to the right over the rest of your columns. Google Sheets will autofill the rest of the information for you.

How to use CRYPTOFINANCE add-on for Google Sheets (9)

Continue to repeat the process for each cryptocurrency until you have a complete portfolio!

An all-in-one financial management solution

If you’re looking for an automated system to control your finances, check out our spreadsheet-based solution to automate your financial management and track all your business transactions.

Editor’s note: This is a revised version of a previous post that has been updated for accuracy and comprehensiveness.

How to use CRYPTOFINANCE add-on for Google Sheets (2024)

FAQs

How to use CRYPTOFINANCE add-on for Google Sheets? ›

Google Sheets BTC Price

The simplest method to import live BTC prices into Google Sheets is by using the GOOGLEFINANCE function. This function allows you to fetch current prices for various cryptocurrencies, including Bitcoin, without needing any additional add-ons or tools.

How do I use addons in Google Sheets? ›

add-ons.
  1. Open a document or spreadsheet in the Google Docs or Sheets app.
  2. Tap More .
  3. Tap Add-ons.
  4. Tap the add-on you want to use. The app will open.

How to get crypto data in Google Sheets? ›

Google Sheets BTC Price

The simplest method to import live BTC prices into Google Sheets is by using the GOOGLEFINANCE function. This function allows you to fetch current prices for various cryptocurrencies, including Bitcoin, without needing any additional add-ons or tools.

Can you link GOOGLEFINANCE to Google Sheets? ›

The GOOGLEFINANCE function is a powerful tool in Google Sheets that lets you access current stock prices, currency conversion rates, and historical data for securities, directly inside your Google spreadsheet.

How do I use Cryptosheets in Google Sheets? ›

▶︎ General setup and integration (Googlesheets)
  1. Going to the add-ons menu from your Googlesheet.
  2. Get add-ons.
  3. Type "cryptosheets" in the search bar in GSuite Marketplace.
  4. Install.
  5. Go back to the add-ons menu.
  6. Select Launch Sidebar from the Cryptosheets menu.

How to do an add function in Google Sheets? ›

Tap the cell where you want to add the formula.
  1. To pick from a list of functions, tap Function. . Then choose a category and pick the function you want to use in your formula.
  2. To enter a function manually, enter = and the function you want to use.
  3. If the cell already has a formula in it, skip to step 5.

How do I open Google addons? ›

Launch Google Chrome. Open Customize and Control (top right, three-dot icon) Open “More Tools” and go to “Extensions” Manage the available extensions.

What is the alternative to GOOGLEFINANCE in Google Sheets? ›

=YHFINANCE is a spreadsheet formula that allows you to pull the Finance data directly into a Google Sheets spreadsheet. =YHFINANCE formula works in a similar way to =GOOGLEFINANCE for fetching current or historical securities information.

How often does GOOGLEFINANCE update in sheets? ›

Widgets powered by spreadsheets using the GOOGLEFINANCE function refresh approx. every 15 minutes.

How do I pull financial data into Google Sheets? ›

Access Google Finance data in Sheets
  1. Create a new sheet in Google Sheets 'sheets. ...
  2. To access the finance data, click on a cell and start your query by entering:=GOOGLEFINANCE(“The full query requires the following:=GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])

How do I use GOOGLEFINANCE currency in sheets? ›

How to convert currency in Google Sheets
  1. Launch Google Sheets and open your spreadsheet. ...
  2. Identify the currency to convert and its code. ...
  3. In a new cell, input the Google Finance function. ...
  4. Change the custom currency to reflect the conversion.
Apr 9, 2024

How do I install Cryptosheets in Excel? ›

Excel Online
  1. Login with your Microsoft credentials.
  2. Choose New Blank Workbook.
  3. Go to Insert > Office Add-ins.
  4. In the popup window, choose Store.
  5. Type Cryptosheets in the search box.
  6. Choose Cryptosheets.
  7. Take a moment to look at the Store page to familiarize yourself with the add-in.
  8. Choose Add to install the add-in.

How do you add addition in Google Sheets? ›

Using the SUM Function

The SUM function is a built-in function in Google Sheets that allows you to quickly add up a range of cells. To use the SUM function, simply select the cell where you want the sum to appear, type “=SUM(” and then select the range of cells that you want to add up.

How do I manage Google addons? ›

Manage your extensions
  1. On your computer, open Chrome.
  2. At the top right, select More Extensions. Manage extensions.
  3. Make your changes: Turn on/off: Turn the extension on or off. Allow incognito: On the extension, select Details. Turn on Allow in incognito. Fix corruptions: Find a corrupted extension and select Repair.

How do I save Gmail addons to Google Sheets? ›

How to save multiple emails to a Google spreadsheet using Gmail interface
  1. Login to your Gmail account.
  2. Use Gmail search bar to search for emails.
  3. Click on the Save to … button and select Save Emails to Google Sheets:
  4. Select spreadsheet name. ...
  5. click on the Start Backup button.

How do I use the Add command in Google Sheets? ›

Google Sheets Addition Operator
  1. Select a cell and type ( = )
  2. Select a cell.
  3. Type ( + )
  4. Select another cell.
  5. Hit enter.

Top Articles
Medicare Flex Card Scams: Find Out the Truth
What Is A 401(k) Match and How Does It Work?
Cranes For Sale in United States| IronPlanet
Canary im Test: Ein All-in-One Überwachungssystem? - HouseControllers
Affidea ExpressCare - Affidea Ireland
T Mobile Rival Crossword Clue
Aadya Bazaar
Polyhaven Hdri
Costco The Dalles Or
Wild Smile Stapleton
Free Robux Without Downloading Apps
Whiskeytown Camera
Bernie Platt, former Cherry Hill mayor and funeral home magnate, has died at 90
Thayer Rasmussen Cause Of Death
Cvs Learnet Modules
Athens Bucket List: 20 Best Things to Do in Athens, Greece
The Largest Banks - ​​How to Transfer Money With Only Card Number and CVV (2024)
Video shows two planes collide while taxiing at airport | CNN
Van Buren County Arrests.org
Fsga Golf
Jobs Hiring Near Me Part Time For 15 Year Olds
Wnem Tv5 Obituaries
The best brunch spots in Berlin
Renfield Showtimes Near Paragon Theaters - Coral Square
Vera Bradley Factory Outlet Sunbury Products
Jurassic World Exhibition Discount Code
A Man Called Otto Showtimes Near Carolina Mall Cinema
Possum Exam Fallout 76
Primerica Shareholder Account
Otis Offender Michigan
Word Trip Level 359
Scioto Post News
One Credit Songs On Touchtunes 2022
Appraisalport Com Dashboard /# Orders
Chris Provost Daughter Addie
Foolproof Module 6 Test Answers
Watchseries To New Domain
Laff Tv Passport
National Insider Threat Awareness Month - 2024 DCSA Conference For Insider Threat Virtual Registration Still Available
Craigslist Ludington Michigan
Trap Candy Strain Leafly
Indio Mall Eye Doctor
Lake Andes Buy Sell Trade
Sun Tracker Pontoon Wiring Diagram
Tricia Vacanti Obituary
3 Zodiac Signs Whose Wishes Come True After The Pisces Moon On September 16
Chubbs Canton Il
R/Gnv
Laura Houston Wbap
Acuity Eye Group - La Quinta Photos
Greg Steube Height
How to Find Mugshots: 11 Steps (with Pictures) - wikiHow
Latest Posts
Article information

Author: Rubie Ullrich

Last Updated:

Views: 6094

Rating: 4.1 / 5 (72 voted)

Reviews: 95% of readers found this page helpful

Author information

Name: Rubie Ullrich

Birthday: 1998-02-02

Address: 743 Stoltenberg Center, Genovevaville, NJ 59925-3119

Phone: +2202978377583

Job: Administration Engineer

Hobby: Surfing, Sailing, Listening to music, Web surfing, Kitesurfing, Geocaching, Backpacking

Introduction: My name is Rubie Ullrich, I am a enthusiastic, perfect, tender, vivacious, talented, famous, delightful person who loves writing and wants to share my knowledge and understanding with you.