Live Stock Market Assistant Dashboard

Overview

The system centralizes live ticker monitoring, portfolio performance tracking, and signal visualization into a single dashboard—eliminating manual spreadsheet workflows and enabling faster, more disciplined investment decisions.

What I Designed & Built

• Architected a modular, multi-sheet Excel system separating configuration, raw market data ingestion, and presentation layers for scalability and maintainability
• Implemented automated calculations for price movement, daily and cumulative gain/loss, and portfolio-level performance metrics
• Designed rule-based buy/hold/sell signal logic with dynamic conditional formatting to surface opportunities and risk at a glance
• Optimized layout and visual hierarchy for rapid interpretation under time-sensitive market conditions

Impact

• Replaced fragmented, manual stock tracking with a single source of truth
• Reduced analysis friction by surfacing signals visually instead of requiring formula inspection
• Demonstrates the ability to design analytical systems and decision frameworks using constrained tooling (Excel-only environment)

Why This Matters to Employers

• Shows strong analytical thinking without reliance on specialized platforms or libraries
• Demonstrates system design, data modeling, and UX judgment in a business-critical domain
• Highlights the ability to turn noisy data into executive-level insights

Tools & Domain

Tools: Excel, advanced formulas, charts, conditional formatting

Domain: Financial analytics, portfolio monitoring, decision support systems