Stock Portfolio Management System

## about

Web application for managing and analyzing stock portfolios with real-time data integration and performance tracking.

This project is a database-backed portfolio tracker for investors and advisors. Users can record purchases and sales, inspect holdings, and compare historical transactions with current market prices instead of maintaining the whole picture in a spreadsheet.

The application has separate investor, advisor, and administrative workflows. That role split shaped the database and interface because each person needs a different view of the same portfolio records.

## architecture

PHP handles the server-side application logic and mediates between the browser, MySQL, and external market data. The relational model stores users, portfolios, holdings, and transaction history. Alpaca supplies market information, Chart.js renders performance views, and Cron supports work that should refresh outside a page request.

It is an educational full-stack system, not a brokerage or an investment-advice tool. The useful part of the project is the end-to-end data flow: record a transaction, maintain consistent holdings, add changing market data, and explain the result visually.

## screenshots — 4 files