Back

Stock Market Dashboard

ak64950n
July 8, 2026

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


Related Topics

Decision-grade data work

Explore, analyze and deploy your first project in minutes