Stock Portfolio & Historical Data Browser
A dynamic, data-driven web application designed to manage fictional portfolios and analyze real-world historical stock data.
Project Overview
Technologies: PHP, PHP Data Objects (PDO), SQLite, SQL, CSS
This project involved developing a full-stack web application that allows users to interact with financial data in real-time. I used PHP Data Objects (PDO) to ensure secure communication with an SQLite database, protecting the application's data integrity.
Key technical features of this application include:
- Complex SQL Engineering: I engineered advanced queries utilizing INNER JOINs and aggregate functions to calculate historical statistics and real-time portfolio values.
- Responsive Design: I designed a multi-page interface from scratch using custom CSS to ensure the data is accessible and readable across all devices.
- Data Management: The system efficiently handles fictional user portfolios alongside real-world historical data points.
← Back to Projects