Stock Market Dashboard
About
Stock Market Performance Dashboard (2004β2023)
Overview
This project analyzes 19 years of stock market data across
four major assets β Google (GOOG), Apple (AAPL), Microsoft
(MSFT), and the S&P 500 index (SPY) β to uncover insights
on long-term returns, risk, volatility, and the hidden
danger of market timing.
Key Findings
- AAPL delivered 35,170% total return over 19 years
- GOOG achieved 25.30% annualized return (Sharpe: 0.82)
- Missing just 10 best days cuts GOOG returns by 73%
- SPY had the lowest max drawdown at -56.5%
What This Project Covers
- Performance comparison across 4 major assets
- Risk-return analysis with Sharpe ratios and max drawdown
- Rolling 30-day volatility during market stress events
- Market timing impact: the cost of missing best days
- Buy and hold vs market timing strategy comparison
The Biggest Insight
Out of 4,857 trading days, missing just 10 of the best
days turned a $529,744 portfolio into $144,962.
Timing the market is nearly impossible β staying invested
is always the better strategy.
Tools and Technologies
Python | Pandas | NumPy | Plotly | Zerve
Dataset
Historical daily OHLCV data (2004β2023)
Sources: Yahoo Finance / Kaggle



