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.Ĭreate a second table in your base called 'Portfolio'. Once we have our table of coin prices we can now build a crypto tracker in Airtable. For 'Current price' and 'Price change 24h' we can choose the 'currency' type using the field type drop-down menu.ĭata 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. You can also choose the type of any new field. You can choose whether to add these to existing Airtable fields or to create new ones. We are going to import the 'Name', 'Symbol', 'Current price' and 'Price change 24h' fields into our crypto tracker. You can easily find the fields you want to import using the ' Find field' search bar. This is where you set which fields to import from CoinGecko and how they should map to the fields in the output table. The request will run and the Response field mapping modal will open. Select the Output Table & View in Airtable where you want to create your crypto tracker. You can also search for types of cryptocurrency by typing in this box. Select the type of Coins you want to import into your crypto tracker for, e.g. Select the Currency you want to get market prices in, e.g. This determines what data we will import from CoinGecko into Airtable in order to create a crypto tracker.Įnter a Name for your request, e.g. On the create request screen in Data Fetcher, for Application, select 'CoinGecko'.įor Endpoint, select 'Get latest market data for one or more cryptocurrencies'. On the home screen of the Data Fetcher app, click 'Create your first request'. We will create a request to import prices from CoinGecko which we'll then use to create a crypto tracker in Airtable. Requests in Data Fetcher are how you import data to or send data from your Airtable base.
Cryptocurrency portfolio bar password#
After the app launches, sign up for a free Data Fetcher account by entering a password and clicking 'Sign up for free'.
Cryptocurrency portfolio bar install#
Install Data Fetcher from the Airtable app marketplace. 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. In this tutorial, we'll create a crypto tracker in Airtable.
0 kommentar(er)
