This project involved creating a Google Sheets file that fetches real-time price information for various cryptocurrencies. The primary goal was to enable the user to track their investment portfolio across different cryptocurrency exchanges.

Real-time Price Data: The Google Sheets file dynamically retrieves price data for selected cryptocurrencies from supported exchanges using formulas.

Portfolio Visualization: The user can input their investment details, including the amount and type of cryptocurrency held on each exchange. The sheet then generates a graphical representation (pie charts) showcasing the percentage allocation of each investment.

Total Estimated Value: Based on the real-time price data, the sheet calculates and displays the total estimated value of the user's cryptocurrency portfolio.

Comprehensive Tracking: Users can conveniently monitor their investments across multiple exchanges in one centralized location.

Decision Making: Access to real-time price data facilitates informed decision-making regarding portfolio management and investment strategies.

Customization: The Google Sheets file can be customized to add additional features or support for new cryptocurrencies and exchanges based on user requirements.

Overall, the Real-time Cryptocurrency Portfolio Tracker provides users with a convenient and efficient tool for managing their cryptocurrency investments effectively.

The client gave me full permission to share the images here. Big thanks to her!