How to Create an Airtable Crypto Tracker

Apr 12, 2022Rosie Threlfall

In this tutorial, we'll create a crypto tracker in Airtable. Using the Data Fetcher app, we'll import various cryptocurrency data from CoinGecko into Airtable such as the current price of coins and their price changes over 24 hours and use this data to create the crypto tracker.

Install Data Fetcher

Install Data Fetcher from the Airtable app marketplace. After the app launches, sign up for a free Data Fetcher account by entering a password and clicking 'Sign up for free'.

Create a Crypto Tracker in Airtable

Import Crypto Prices to Airtable

Requests in Data Fetcher are how you import data to or send data from your Airtable base. We will create a request to import prices from CoinGecko which we'll then use to create a crypto tracker in Airtable.

On the home screen of the Data Fetcher app, click 'Create your first request'.

Create your first request in Airtable

On the create request screen in Data Fetcher, for Application, select 'CoinGecko'.

coingecko-application-selected.png

For Endpoint, select 'Get latest market data for one or more cryptocurrencies'. This determines what data we will import from CoinGecko into Airtable in order to create a crypto tracker.

coingecko-endpoint.png

Enter a Name for your request, e.g. 'Import Crypto Prices'. Then click 'Save & Continue'.

coingecko save and continue

Select the Currency you want to get market prices in, e.g. 'USD'.

Select currencies

Select the type of Coins you want to import into your crypto tracker for, e.g. 'Bitcoin', 'Ethereum' etc. You can also search for types of cryptocurrency by typing in this box.

Choose which cryptocurrencies to import from Coingecko

Select the Output Table & View in Airtable where you want to create your crypto tracker.

Output table and View in Airtable

Click 'Save & Run'.

coingecko save run

The request will run and the Response field mapping modal will open. This is where you set which fields to import from CoinGecko and how they should map to the fields in the output table.

You can easily find the fields you want to import using the 'Find field' search bar.

We are going to import the 'Name', 'Symbol', 'Current price' and 'Price change 24h' fields into our crypto tracker.

You can choose whether to add these to existing Airtable fields or to create new ones. You can also choose the type of any new field. For 'Current price' and 'Price change 24h' we can choose the 'currency' type using the field type drop-down menu.

Click 'Save & Run'.

crypto-tracker-field-mapping.png

Data Fetcher will create any new fields that need to be created in the output table, then run the request again and import the crypto prices from Coingecko to Airtable.

coins-output-table.png

Build a Crypto Tracker in Airtable

Once we have our table of coin prices we can now build a crypto tracker in Airtable. This will track the value of our crypto portfolio based on the amount we hold plus the latest prices and their change over the past 24hrs.

Create a second table in your base called 'Portfolio'. Add a field called 'Coin' that is linked to the first table (ie the table you imported CoinGecko prices into) and add the cryptocurrencies you want to track.

crypto-tracker-coin.png

Create a lookup field called 'Price' and set it to look up the current price of your cryptocurrencies.

crypto-tracker-price.png

Add a Number field called 'Balance' and enter in the total number of each coin you hold.

crypto-tracker-balance.png

Add a formula field called 'Value' with the formula {Price}*Balance and select 'Currency' on the formatting tab.

crypto-tracker-value.png

Add a lookup field called 'Price Change 24h' and set it to look up the Price Change 24h for your cryptocurrencies.

crypto-tracker-price-change.png

We now have built a crypto tracker that updates when we run the request. You can see the total value of your portfolio in the Airtable summary bar

crypto-tracker-summary.png

Import Crypto Tracker Data Automatically

We can also use Data Fetcher's scheduled requests feature to automatically update the values in our Crypto Tracker every 15 minutes/ hour/ day etc. To do this you'll need a paid Data Fetcher account.

In Data Fetcher, scroll to Schedule and click 'Upgrade'.

Group 1(8).png

A new tab will open where you can select a plan and enter your payment details to upgrade.

Screenshot 2021-12-29 at 10.25.19.png

Return to the Data Fetcher app and click 'I've done this'.

Group 1(9).png

Click 'Add API key' in order to add your Airtable API key. You can find your Airtable API key here.

Group 11(1).png

Enter your Airtable API key and click 'Save'.

Group 1(10).png

Enable Schedule this request.

Group 1(12).png

Select how often you want the request to run, e.g. 'Every 15 mins'. Click 'Save'. The request will now run on the schedule and update our crypto tracker automatically.

Group 11(2).png

Related Posts

Import Historical Crypto Market Data in Airtable

Import Historical Crypto Market Data in Airtable

Feb 17, 2022Andy ClokeCoinGeckoCryptocurrency
Import Binance API Data to Airtable

Import Binance API Data to Airtable

Mar 23, 2021Andy ClokeCryptocurrencyBinance
Import Coinranking API data to Airtable

Import Coinranking API data to Airtable

Mar 11, 2021Andy ClokeCryptocurrency