How to Use Google Sheets to Track Cryptocurrency Prices
Originally published: 24/01/2018 15:54
Publication number: ELQ-59269-1
View all versions & Certificate

How to Use Google Sheets to Track Cryptocurrency Prices

A comprehensive guide on how to use Google Sheets to track cryptocurrency prices.


One of the biggest obstacles that people face when trying to get into cryptocurrency trading is having an efficient way to track the value of the coins that they hold. While there are several premium software options available to track cryptocurrency prices, most come with a premium price tag attached to them. To make matters worse, the software solutions that are available rarely include cryptocurrencies themselves. This forces most users, who need cryptocurrencies added, to incur even further charges paying to have custom plug-ins created for the software that they purchased.

Being that the majority of the people who are just getting into trading do not have a large budget to begin with, most come up with personalized solutions utilizing applications and software that they already own. In most cases this includes Microsoft Office, Google documents, and a variety of other applications from various vendors and software developers. While this undoubtedly works for many, it takes an extremely large amount of time to get the personalized solution created, developed, set up and ready to run. As changes are needed, updates are made, more time is taken. A solution that is both efficient and provides the information that the user needs has left the hole in the industry that no one has attempted to fill. Until now.

As was mentioned above, many people utilize Google documents, namely Google sheets in order to create a spreadsheet that gives them the flexibility that spreadsheets offer these type of situations, along with Google’s excellent API environment. While the solution is not a built-in part of Google sheets, the third-party add-on, is both free and easy to use. Using Google sheets, and the CryptoFinance add-on, you can track current Cryptocurrency prices, in real time all from one page. Not only that, the page can be set up to be dynamic, refreshing at the interval of your choosing, and can feature only those coins that you wish to know the price of. The CryptoFinance add-on makes it very simple and easy to get all of your Cryptocurrency prices quickly and efficiently, finally filling the gap for a much-needed solution to the problem.

  • Step n°1 |

    CryptoFinance Add-On for Google Sheets

    The CryptoFinance add-on for Google sheets specifically designed to get the current Cryptocurrency prices from the Coinmarketcap API. While it does have the ability to tie into other exchanges as well, no other exchange offers the sheer quantity of cryptocurrencies available. With over 1200 Cryptocurrency prices and other real-time data, all available in real time, Coinmarketcap is by far most all-inclusive source of information on the subject.

    The ability to get Cryptocurrency prices in real time, through the CryptoFinance add-on in Google sheets, was created by a man named Julian Buty. Julian, or JButy, which is a screen name developed CryptoFinance for Google sheets because he faced the same problem that many others at face before him. However, unlike most software developers, he decided to give this away for free. There is no charge at all to add this to your Google sheets, and there are no upsell attempts, in app purchases, or other monetization efforts made while using the CryptoFinance add-on. It is simply free. Plain and simple. You can now get your Cryptocurrency prices, as well as other data, all for free utilizing the CryptoFinance add-on in Google sheets.

    How to Use Google Sheets to Track Cryptocurrency Prices image
  • Step n°2 |

    Using Google Sheets for Cryptocurrency Prices

    In order to utilize the CryptoFinance add-on in Google sheets, you obviously have to have a Google account. If you do not have a Google account as of yet, simply had to and sign up for free email box. With Google, one login will log you into all of their services. Once you have gotten the Gmail email address, simply had to the right, upper section of your inbox, next to the initials of your name that appear in the colored circle. To the left of these initials, you will see 2 icons, one a circle and the other a square shape. If you click on the squared shape made up of several smaller squares, it will open a drop-down that will allow you to navigate 2 different Google services that are available.

    If it is not listed within the drop-down, there will be a more link, at the bottom clicking this will bring you to another section of the same drop-down and you are looking to find “Docs”. Once you click on the dots icon, a new window will open up to Google Documents in the upper left-hand side you will see the ever present 3 lines that tell you there is a menu available clicking this menu will open up the left sidebar and you will see the 2nd option sheets, clicking on sheets will open Google sheets.

    How to Use Google Sheets to Track Cryptocurrency Prices image
add_shopping_cartContinue reading for free (70% left)


  • Be the first to review this How-To Method

    Write a review


Any questions on How To Use Google Sheets To Track Cryptocurrency Prices?

The user community and author are here to help. Go ahead!

0.0 / 5 (0 votes)

please wait...