{"product_id":"yahoo-finance-analyst-drift-tracker-via-n8n-telegram","title":"Yahoo Finance Analyst Drift Tracker via n8n + Telegram","description":"\u003ch3\u003eTrack Yahoo Finance analyst changes automatically—and get a Telegram alert only when it matters\u003c\/h3\u003e\n\u003cp\u003eThis 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 \u003cem\u003eonly\u003c\/em\u003e when targets drift beyond your threshold or ratings change.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns every weekday morning\u003c\/strong\u003e via a schedule.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSplits your comma-separated watchlist\u003c\/strong\u003e into one validated ticker per item.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads the last saved snapshot\u003c\/strong\u003e for each ticker from an n8n Data Table named \u003ccode\u003eanalyst_watch\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches analyst data\u003c\/strong\u003e (mean price target, consensus rating, analyst count, and—when needed—the current price) using \u003cstrong\u003eOpenAI with a self-hosted Yahoo Finance MCP server\u003c\/strong\u003e in HTTP mode.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates and normalizes outputs\u003c\/strong\u003e (numbers and rating vocabulary) before comparison.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects drift\u003c\/strong\u003e: flags tickers when mean targets move beyond your drift percentage or when the consensus rating changes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpserts today’s snapshot\u003c\/strong\u003e for every ticker into \u003ccode\u003eanalyst_watch\u003c\/code\u003e so future runs always have a baseline.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends one Markdown Telegram digest\u003c\/strong\u003e covering all moved tickers; if nothing drifted, it exits without posting.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eDaily monitoring for investors or analysts who want actionable changes in \u003cstrong\u003eYahoo Finance analyst targets\u003c\/strong\u003e without constant manual checking.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers setting up \u003cstrong\u003edrift-based notifications\u003c\/strong\u003e in n8n using a persistent Data Table.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators needing a lightweight, self-hosted intelligence pipeline with controlled alert noise.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/stack\u003c\/strong\u003e: OpenAI + \u003cstrong\u003eYahoo Finance MCP server\u003c\/strong\u003e, \u003cstrong\u003en8n Data Table\u003c\/strong\u003e, and \u003cstrong\u003eTelegram\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNode types used\u003c\/strong\u003e: if, set, code, no op, telegram, data table.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired setup\u003c\/strong\u003e: start the Yahoo Finance MCP server in HTTP mode (e.g., \u003ccode\u003enpx -y yahoo-finance-mcp-server@1.3.0 --http --host 0.0.0.0 --port 8931\u003c\/code\u003e) and ensure it’s reachable from n8n.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData Table schema\u003c\/strong\u003e: \u003ccode\u003eanalyst_watch\u003c\/code\u003e with columns \u003ccode\u003eticker\u003c\/code\u003e, \u003ccode\u003eseen_on\u003c\/code\u003e, \u003ccode\u003emean_target\u003c\/code\u003e, \u003ccode\u003econsensus\u003c\/code\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45962072359091,"sku":"N8N-19199","price":71.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/eoPf26ai32whHPZY1CrDK_H6CQ63z8.png?v=1788599803","url":"https:\/\/buyflowscripts.com\/products\/yahoo-finance-analyst-drift-tracker-via-n8n-telegram","provider":"N8N Commerce","version":"1.0","type":"link"}