Stock Trade Management Program

Overview

A full-stack stock trade tracker that records buy/sell transactions, computes realized and unrealized P&L by position, and supports date-range queries across the trade book. Persistence in MySQL, analysis in pandas, and Matplotlib visualizations for portfolio performance over time. First-year systems project that became the foundation for later quant work.

Highlights

• MySQL schema for accounts, holdings, and trade history with referential integrity
• Realized + unrealized P&L computed per position and rolled up to portfolio level
• Date-based filtering and slicing: P&L by week / month / arbitrary range
• Matplotlib portfolio-value charts and per-ticker performance breakdowns
• CLI-driven workflow with input validation and transactional safety