This script is basically a quant finance data pipeline that:
-
Pulls 5 years of monthly stock prices (using yfinance)
-
Calculates monthly returns for each ticker
-
Computes beta, correlation, volatility, etc. versus the S&P 500
-
Exports results into Excel (via xlwings) with proper formatt