Yahoo Finance Analyst Drift Tracker via n8n + Telegram

Track Yahoo Finance analyst changes automatically—and get a Telegram alert only when it matters

This n8n workflow monitors analyst mean price targets and consensus ratings from Yahoo Finance for your watchlist, compares today’s results to the last saved snapshot, and sends a Telegram digest only when targets drift beyond your threshold or ratings change.

What this workflow does

• Runs every weekday morning via a schedule.
• Splits your comma-separated watchlist into one validated ticker per item.
• Loads the last saved snapshot for each ticker from an n8n Data Table named analyst_watch.
• Fetches analyst data (mean price target, consensus rating, analyst count, and—when needed—the current price) using OpenAI with a self-hosted Yahoo Finance MCP server in HTTP mode.
• Validates and normalizes outputs (numbers and rating vocabulary) before comparison.
• Detects drift: flags tickers when mean targets move beyond your drift percentage or when the consensus rating changes.
• Upserts today’s snapshot for every ticker into analyst_watch so future runs always have a baseline.
• Sends one Markdown Telegram digest covering all moved tickers; if nothing drifted, it exits without posting.

Use cases

• Daily monitoring for investors or analysts who want actionable changes in Yahoo Finance analyst targets without constant manual checking.
• Automation engineers setting up drift-based notifications in n8n using a persistent Data Table.
• SaaS operators needing a lightweight, self-hosted intelligence pipeline with controlled alert noise.

Technical details

• Integrations/stack: OpenAI + Yahoo Finance MCP server, n8n Data Table, and Telegram.
• Node types used: if, set, code, no op, telegram, data table.
• Required setup: start the Yahoo Finance MCP server in HTTP mode (e.g., npx -y yahoo-finance-mcp-server@1.3.0 --http --host 0.0.0.0 --port 8931) and ensure it’s reachable from n8n.
• Data Table schema: analyst_watch with columns ticker, seen_on, mean_target, consensus.