Create a Crypto Portfolio Tracker with Live Prices
📊 Track your crypto assets like a pro using real-time API integration!
🔍 About the Task
In this exciting hands-on task, you’ll build a Crypto Portfolio Tracker that fetches live token prices using the CoinGecko API. This is a crucial tool for crypto investors, analysts, and even blockchain developers who want to monitor wallet balances, asset values, and market changes.
You can choose to build it using Google Sheets + Apps Script (easy) or React + JavaScript (advanced). Both are beginner-friendly and simulate the type of real-world dashboards that clients or employers would love.
✅ What You’ll Do
- 🧾 Build a portfolio tracker that accepts wallet tokens or manually entered coins.
- 💸 Use the CoinGecko API to fetch real-time crypto prices.
- 📈 Display current value, price change %, and total portfolio worth.
- 🔁 Include auto-refresh, styling, and optional features like historical trends or pie charts.
🧠 Skills You’ll Gain
- API integration (GET requests, JSON parsing)
- Frontend development (React or Sheets scripting)
- Real-time data handling
- Financial UX for crypto tools
- Debugging, async logic, and token metadata handling
🛠️ Tools You’ll Use
| Tool | Use | Link |
|---|---|---|
| CoinGecko API | Fetch live crypto prices | https://www.coingecko.com/en/api |
| React.js | Build a frontend web app | https://react.dev |
| Google Sheets | Create a spreadsheet tracker | https://sheets.google.com |
| Apps Script | Script Sheets to use APIs | https://script.google.com |
| VS Code | Code editor for web apps | https://code.visualstudio.com |
💡 Extra Feature Ideas (Optional)
- 👛 Enter wallet address and auto-match tokens
- 📊 Pie chart visualization (Coin weightage)
- 🧾 Export CSV of portfolio history
- 🔔 Add price alert notifications
📁 Deliverables
- 🔹 A working crypto tracker (React app or Google Sheet)
- 🔹 Code on GitHub with API logic and UI
- 🔹 Sample wallet data (manual or real test wallet)
- 🔹 Screenshots or demo video explaining the tracker