📈 Stock Portfolio Management System (SPMS) - Database Project

---

📌 Overview

SPMS is a web-based application designed to simplify and enhance stock portfolio management. It enables users to track personal or client investments, analyze real-time market data, and generate financial insights through a clean, user-friendly interface.

---

🚀 Key Features

• 🔍 Portfolio Tracking – Manage holdings, monitor gains/losses, and track stock performance over time.
• 💸 Transaction Management – Log buy/sell actions with real-time price updates.
• 📊 Analytics & Reporting – Visualize trends, compare stocks, and generate investment reports.
• 🔐 Role-Based Access – Support for investors, financial advisors, and administrators.
• 🌐 Real-Time Market Integration – API-driven stock and market data analysis.

---

🖼️ Demo Gallery

• Login Page
  

• Investor Dashboard
  

• Investor Dashboard • Stock Overview
  

• Investor Portfolio Management
  

• Advisor Overview
  

---

🛠️ Tech Stack

• Frontend: JavaScript, HTML, CSS
• Backend: PHP
• Database: MySQL
• Visualization: Chart.js
• Market Data: External financial APIs

---

📊 Database Design

---

👥 Target Users

• 📈 Individual Investors
• 🧠 Financial Advisors
• 🏢 Investment Firms
• 💼 Market Enthusiasts

---

🎯 Project Goals

• Automate portfolio tracking
• Minimize human error
• Provide data-driven investment insights
• Bridge the gap between big data and everyday investors