AI-Powered Hourly Stock Market Summary Bot

This n8n workflow delivers automated, hourly stock market insights by first verifying U.S. market status using Alpaca's /clock API. It then fetches daily bars for a predefined list of high-profile tickers (e.g., AAPL, MSFT, NVDA) via Alpaca's /v2/stocks/bars endpoint. A Python code node computes technical indicators—RSI and MACD—to categorize each stock as Buy, Hold, or Sell based on standard thresholds.

Next, OpenAI Assistant processes the analysis into a concise, Slack-formatted markdown summary highlighting top opportunities, risks, and overall market sentiment. The result is posted directly to a designated Slack channel or user, ensuring traders and analysts receive actionable updates without manual intervention.

Benefits include significant time savings for investors, real-time decision support during trading hours, and scalability for custom ticker lists. Ideal use cases: financial firms for internal dashboards, personal trading bots, portfolio managers needing quick scans, or BI teams integrating market data into business intelligence pipelines. High reliability with error handling for closed markets or API issues.