Dual-Tier Stock Research System — 3 Autonomous Workflows with Alpha Vantage + Minimax LLM

Built with n8n
1

Dual-Tier Stock Research System

A 3-workflow financial intelligence system that monitors news, tracks entity frequency, and autonomously generates two tiers of research — daily quick briefs and weekly due diligence reports.

What It Does

This system runs without manual input:

  1. Financial Analysis V2 (27 nodes) — the brain. Monitors 4 RSS feeds, sends articles to Minimax LLM for structured analysis (sector, sentiment, tickers, impact score), filters for high-signal content, and tracks company mention frequency using n8n DataTable with upsert logic.

  2. Daily Analysis (14 nodes) — triggered when any ticker crosses 3+ daily mentions. Pulls the latest 20 news articles from Alpha Vantage’s NEWS_SENTIMENT API, cleans the data, and sends it to Minimax to generate a 500–800 word brief structured as [WHAT] → [WHY] → [ACTION]. Delivered to Telegram.

  3. Weekly Analysis (9 nodes) — triggered when any ticker crosses 20+ weekly mentions. Makes parallel Alpha Vantage calls for company fundamentals (OVERVIEW: PE ratio, profit margin, market cap, 52-week range, revenue, EPS) and news sentiment (50 articles). Merges both datasets and sends to Minimax for a 1,500–2,500 word due diligence report. Delivered to Telegram.

[Financial Analysis V2 — 27 nodes]
  Schedule Trigger → 4 RSS feeds → Merge → Loop Over Items
  → Wait → Minimax HTTP Request (article analysis)
  → Filter (impact >= threshold) → Count appearance
  → DataTable upsert (daily + weekly counts)
    ├─ If daily_count >= 3  → Execute Workflow → [Daily Analysis]
    ├─ If weekly_count >= 20 → Execute Workflow → [Weekly Analysis]
    └─ Digest format → Telegram (daily summary)
  
  Dailytrigger → reset daily counts
  Weeklytrigger → reset weekly counts

[Daily Analysis — 14 nodes]
  Execute Workflow trigger → Get daily count from DataTable
  → Loop Over Items → Alpha Vantage NEWS_SENTIMENT (20 articles)
  → Cleaner → Minimax HTTP Request (brief generation)
  → Digest format → Telegram

[Weekly Analysis — 9 nodes]
  Execute Workflow trigger → Get weekly count from DataTable
  → Loop Over Items →
    ├─ Alpha Vantage OVERVIEW (company fundamentals)
    └─ Wait → Alpha Vantage NEWS_SENTIMENT (50 articles)
  → Merge → Data preparation → Minimax HTTP Request (report generation)
  → Digest format → Telegram

Video: https://youtu.be/I7l7sWZnE6E

1 Like
2

Hey, this looks real interresting. Video mentions workflow files available here in the community, but can’t seem to find them. Would love to test and provide feedback. Best, Jan