In this guide, you'll learn to import cryptocurrency prices to Airtable using the Coinranking API. Coinranking provides prices for all cryptocurrencies through their free API.
We'll use this API and the Data Fetcher Airtable extension to create a crypto portfolio tracker in Airtable.
Install Data Fetcher
Create Output Table

Import Coinranking API Data to Airtable

Based on the Coinranking API documentation the base URL for all API requests is 'https://api.coinranking.com/v2/'. We'll use the '/coins' endpoint to get prices for each cryptocurrency.
https://api.coinranking.com/v2/coins

Click 'Confirm'. The request will run again and update the 'Coins' table.
Click 'Advanced' to open the Advanced settings and under 'Update based on Field', choose the 'Symbol' field. The extension will use this field to ensure the coins in your base match those in Coinranking.
Click 'Save'.
By default, Coinranking gives returns 50 coins, but we can fetch more by turning on pagination.
In the Advanced settings under 'Pagination' select 'Offset'.
Set the number of pages to fetch to '3'. You can set it higher if you want to fetch more pages.
In the 'Offset parameter' input, enter 'offset'.
In the 'Limit parameter' input, enter 'limit'.
In the 'Limit value' input enter '100'. Coinranking will now return 3 pages of 100 coins.
Click 'Save' to save your request.
Click 'Run' to fetch 300 (3 pages x 100 coins per page) coins.
Build a Crypto Portfolio Tracker in Airtable
Create a table in your base called 'Portfolio'.
Change the primary field to 'Id' with type 'Autonumber'.
Add a field called 'Coin' that is linked to the 'Coins' table.
Add a field called 'Price' that is a lookup of the 'Coin' field's price.
Add a single select field called 'Exchange' with some options for the coin exchanges you use, e.g. 'Binance', 'Coinbase' e.t.c.
Add a field called 'Balance' with type 'Number'. This is how much of the coin you have in that exchange.
Add a formula field called 'Value (USD)' with the formula '{Price}*Balance' and select 'Currency' formatting with the maximum precision.

Update Coin Prices Automatically
At the moment we have to fetch prices from Coinranking's API by clicking the 'Run' button. We can use Data Fetcher's scheduled requests feature to automate this.
In Data Fetcher, scroll to 'Schedule'.
You will need a paid account to use this feature, so click the link to upgrade your account if you haven't already. After upgrading, click the 'I've done this' button.
Add your Airtable API key if you haven't already.
Turn on 'Schedule this API request'.
Set how often you want the request to run.
Click 'Save'.