Update Crypto Values

Target Audience

• Crypto Investors: Individuals managing a portfolio of cryptocurrencies who want to track real-time prices and portfolio values.
• Financial Analysts: Professionals requiring automated updates of cryptocurrency values for analysis and reporting.
• Developers: Those looking to integrate CoinGecko and Airtable for automated financial workflows.
• Small Business Owners: Entrepreneurs involved in cryptocurrency who need to monitor their investments efficiently.

Problem Solved

This workflow addresses the challenge of manually tracking cryptocurrency prices and portfolio values. It automates the process of fetching real-time prices from CoinGecko and updating the respective values in Airtable, ensuring that investors have access to the most current information without the need for manual input. This reduces the risk of errors and saves time, allowing users to focus on strategic decisions.

Workflow Steps

1. Scheduled Trigger: The workflow is triggered every hour to ensure timely updates.
2. Get Portfolio: Retrieves the list of cryptocurrencies from the Airtable Portfolio table, specifically fetching the Symbol of each asset.
3. Fetch Prices: For each cryptocurrency symbol, the workflow calls CoinGecko to get the current market data, including the current price in USD.
4. Set Values: The workflow sets the fetched Present Price and the corresponding Id for each cryptocurrency.
5. Update Values: The current prices are updated back to the Airtable Portfolio table based on the Ids retrieved earlier.
6. Get Portfolio Values: The workflow retrieves the existing Present Value of the portfolio from Airtable.
7. Determine Total Value: A function node calculates the total portfolio value by summing up all the Present Value entries.
8. Append Portfolio Value: Finally, the total portfolio value is appended to the Airtable Portfolio Value table, allowing for historical tracking of the portfolio's worth.