11. Capstone: Stock Analyst

Task: Market Analysis

Goal: Analyze 5 years of S&P 500 data to find opportunities.

1. Load: Read 500 CSV files into one DataFrame.
2. Clean: Handle missing trading days (Bank Holidays).
3. Calculate:
   • Moving Averages (50d, 200d).
   • Volatility (Standard Deviation).
   • Daily Returns (pct_change).
4. Visualize: Plot the "Golden Cross" (When 50d crosses 200d).

Good luck, Engineer.