🚀 CryptoAPI – Live Cryptocurrency Dashboard

A real-time crypto tracking dashboard built with Streamlit, CoinGecko API, and MYSQL. This project fetches live cryptocurrency prices, 24h changes, market caps, and visualizes them using interactive charts and auto-refreshing metrics.

Stay updated with the crypto market in a clean and beautifully designed dashboard.

⚡ Key Features

✔ Live Price Fetching (CoinGecko API) ✔ Auto-Refreshing Dashboard (every 60 seconds) ✔ Adding rows in MYSQL in every 120 seconds ✔ Interactive Charts with Plotly ✔ Real-time Metrics Cards for top coins ✔ 24h Performance Leaderboard ✔ One-Click Data Refresh & Reset ✔ Clean, modern UI using Streamlit

🖼️ Dashboard Preview

MySQL

SQlite

🛠️ Tech Stack

Component	Technology
Data API	CoinGecko
Frontend	Streamlit
Backend	Python
Database	MySQL
Visualization	Plotly
Data Handling	Pandas

📦 Installation & Setup

1️⃣ Clone the Repository

git clone https://github.com/swapitsneil/cryptoapi.git
cd cryptoapi

2️⃣ Install Dependencies

pip install -r requirements.txt

3️⃣ Run the Streamlit App

streamlit run app.py

streamlit link - https://appdeploypy-wvt9bjqbrn2j9war4zu2ea.streamlit.app/

📡 How It Works

🔄 Live Data Fetching

Dashboard pulls fresh crypto data directly from CoinGecko:

• Price (USD)
• 24h Change %
• Market Cap
• 24h Volume
• Timestamped entries
• 10 major cryptocurrencies

💾 Historical Storage

MYSQL crypto_db └── crypto_prices 📊 Visual Insights

• Real-time line charts
• Sorted performance table
• Coin-wise filtering
• Auto refresh + manual refresh

📁 Project Structure

cryptoapi/
│
├── app.py                     → Main Streamlit application (MySQL version)
├── appdeploy.py               → SQLite deployment version
├── liveapicrypto.ipynb        → Jupyter notebook for crypto analysis
├── liveapidash.pbix           → Power BI dashboard
├── requirements.txt           → Dependencies for Streamlit Cloud
└── README.md                  → Project documentation

⭐ Why This Project Stands Out

• Uses live API, not static CSV
• Lightweight, fast, and deployable anywhere
• Beautiful analytics dashboard
• Beginner-friendly + production-ready
• Perfect for portfolio or data engineering showcase

🚀 Future Improvements

• Add more coins dynamically
• Add alerts for price spikes/drops
• Build separate admin panel
• Integrate prediction models (ARIMA/LSTM)
• Add email notifications

🤝 Contributions

Pull requests are welcome! If you want to improve charts, add APIs, or optimize code—jump in.

💬 Author

Swapnui Nicolson For collaboration or suggestions: feel free to reach out!