How to build a simple Bitcoin and Ethereum dashboard in Google Data Studio

In this post I’ll show you how to make a simple dashboard that lets you monitor the price of two of the most popular Cryptocurrencies; Bitcoin and Ethereum.

All you need is;

Below is the actual dashboard.

Step 1: Building a Google Sheet for your data

So for our Google Sheet we’re going to keep it simple with three columns;

For column one type into cell A1 “Date”. This will be the name of the column.

Next type in the formula =TODAY() into cell A2. Below in cell A3 type the formula =A2-1. Drag this formula downwards until you get to cell A1000.

For the BTC column use the formula =index(GoogleFinance( “Currency:BTCUSD” , “close” , $A2),2,2). This will give you the price of BTC in USD for the date specified in cell A2. You can also drag this formula down so it gives you the price for each of the previous days in column A.

This will ideally ensure that we have the current date and the thousand days prior.

For your ETH column simply use the same formula and replace BTC with ETH so your formula is =index(GoogleFinance( “Currency:ETHUSD” , “close” , $A2),2,2).

Now we have our three finished columns as shown below. We’re ready to build out the report in Google Data Studio.

Step 2: Building the Google Data Studio dashboard

The first step is to add your data to the report. Choose the Google Sheets data connector and then the appropriate spreadsheet with your Bitcoin and Ethereum data.

Change the data Type to Currency USD or the currency you’ve chosen to display the price in.

The data source being added to google data studio. the data source contains Bitcoin and Ethereum prices.

The main component of the dashboard is a time series chart that shows BTC and ETH price over time.

Choose date as your dimension. Enable drill down to be able to drill up and done into smaller or larger unites of measuring time. Choose BTC and ETH as your metrics. Enable Optional metrics in order to be able to view each independently if you so wish.

a chart showing the prices of Bitcoin and Ethereum over time in google data studio dashboard.

At the top of the dashboard we’d like to have the latest prices for Bitcoin and Ethereum. So we need to set the Default date range from Auto to Custom and select Today as the value as shown below. We can also add in a comparison date range for the previous period which will give us the previous day’s price.

Displaying the latest price of Bitcoin and Ethereum in USD in Google Data Studio.

For our final graph we want to take a longer look back at the historical price of BTC and ETH so we create another time series chart with a custom date range looking at data 1000 days prior.

My Other Blog Posts

Thank you for reading this blog post. You might enjoy the previous ones I’ve written.

Michael Howe-Ely