This workflow runs weekly to monitor portfolio risk automatically.It reads holdings from Google Sheets and validates Symbol, Sector, and Quantity.
It batches symbols to keep execution stable for larger portfolios.It pulls daily price data from Alpha Vantage and buffers requests to avoid rate limits.
It normalizes prices and returns into a consistent structure for analysis.It calculates sector concentration and flags overexposure beyond your configured limit.It calculates volatility from recent returns to surface instability.It checks cross-stock correlations and flags pairs that reduce diversification.When risk is detected, it generates a short AI explanation in simple language (not financial advice).It sends a Slack alert and stores a weekly risk snapshot back into Google Sheets.