How to Create Realtime Crypto Portfolio Tracker with Google Sheets

How to Create Realtime Crypto Portfolio Tracker with Google Sheets

How to Make a Google Sheets Realtime Crypto Portfolio Tracker Are you someone who has invested in cryptocurrencies and wants to keep track on them on a frequent basis? You don't need any third-party software or apps to keep track of your investments. You can quickly develop your own Crypto Portfolio tracker if you use Google Sheets.

Let's get started.

Using Google Sheets, create a cryptocurrency portfolio tracker.

Google Sheets includes a plethora of capabilities for organising your daily work, including stock tracking. We've seen the greatest Google Sheets methods for tracking stock portfolios. Similarly, you may use Sheets to keep track of the value of all your crypto assets.

Step 1:Add a Cryptocurrency List

Assume you've purchased a number of cryptos (for example, Bitcoin, Ethereum, and Dogecoin) and need to keep track of their prices in order to sell them when the time comes.

Open a new Google Spreadsheet on your computer and add the following titles for columns.

– Crypto: Name of the cryptocurrency

 Symbol or identifier for the crypto.

– Quantity: Number of crypto coins

– Price: The price at which you had bought the asset

– Market value: Current price of the asset


Next, fill in the columns Crypto, Quantity, and Price by referring to your purchase transactions.


Step 2: Get the Current Cryptocurrency Value

To find the current value of cryptocurrencies, use websites such as Coinbase, Coinmarketcap, Yahoo Finance, and Google Finance.

In this example, we'll use Yahoo Finance to get the price of a cryptocurrency. Go to yahoo.finance.com and on the Home page, click Cryptocurrencies.

You may see a list of cryptocurrencies in a table here, along with details such as price, volume, market cap, and more. Now we need to get the prices for all of the cryptocurrencies listed on the Google Sheet. To do so, we need to know the crypto's Symbol. Find the symbol for each of your cryptos and enter it in the Symbol column of Google Sheet.


To obtain the cryptocurrency's price, use the following formula to concatenate the Yahoo Finance URL with the crypto symbol.

"if(isblank(B2),"",index(IMPORTHTML(CONCATENATE("https://finance.yahoo.com/quote/",B2),"table",1),1,2))"

B2 denotes the column containing the crypto symbol. No action will be made if the data in that cell is blank. Otherwise, it is concatenated with the website's URL to retrieve the value for Crypto.


Similarly, this method is applied in all cells of the Market Worth column to calculate the current value of the cryptocurrency.

Step 3: Make Data Analysis Graphs

Do you want to view a visual breakdown of your cryptocurrency investments? Using Google Sheets, you can simply build a bar graph, pie chart, or other types of charts. If you're new to graphing, have a look at our step-by-step instruction on how to create pie charts in Google Sheets.

In this example, the columns Quantity, Price, and Market Value are plotted in a Pie Chart as seen below:


This graph depicts the overall asset distribution and growth.

We hope that by following the procedures outlined above, you will be able to rapidly establish your own crypto portfolio tracker in Google Sheets to monitor your digital assets.