To do this you'll need a paid Data Fetcher account. 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. You can see the total value of your portfolio in the Airtable summary bar Import Crypto Tracker Data Automatically We now have built a crypto tracker that updates when we run the request. 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.Ĭreate a lookup field called 'Price' and set it to look up the current price of your cryptocurrencies.Īdd a Number field called 'Balance' and enter in the total number of each coin you hold.Īdd a formula field called 'Value' with the formula *Balance and select 'Currency' on the formatting tab.Īdd a lookup field called 'Price Change 24h' and set it to look up the Price Change 24h for your cryptocurrencies. 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 Airtable 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 extension, 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. After the extension launches, sign up for a free Data Fetcher account by entering a password and clicking 'Sign up for free'. Install Data Fetcher from the Airtable marketplace. Using the Data Fetcher extension, 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |