Generate Stock Market Insights with Technical Analysis, AI, and Telegram Publishing
Go to Workflow
Sergey Skorobogatov
Description
📈 AI Stock Analytics & BCS "Profit" Social Network Publishing Workflow
This workflow automatically generates stock market insights for selected tickers (e.g. GAZP, SBER, LKOH) using historical data, technical indicators, and an AI model. The results are then sent to Telegram for quick moderation and publishing.
🔑 What this workflow does
Runs twice a day** on a schedule with a predefined list of tickers.
Fetches historical market data** from a broker API.
Calculates key technical indicators** (RSI, EMA/SMA, MACD, Bollinger Bands, ADX).
Generates an investment post** (title + summary) using an LLM.
Stores results** in a PostgreSQL database.
Sends a draft post to Telegram* with inline buttons *“Publish” and “Retry”.
Handles Telegram actions**: publishes the post to the final channel or re-runs the generation process.
📌 Key features
Multi-ticker support in a single run.
Automatic error handling (e.g. missing data or invalid AI JSON output).
Human-in-the-loop moderation through Telegram before publishing.
PostgreSQL integration for history and analytics storage.
Flexible structure: easy to extend with new tickers, indicators, or publishing channels.
🛠️ Nodes used
Trigger:** Schedule (twice daily) + Telegram Trigger (button callbacks).
Data:** HTTP Request (broker API), Function (technical analysis calculations).
AI:** OpenAI / OpenRouter with structured JSON output.
Storage:** PostgreSQL (analytics history).
Messaging:** Telegram (drafts and publishing).
🚀 Who is this for
Fintech startups looking to automate market content.
Investment bloggers posting daily stock analysis.
Analysts experimenting with trading strategies on real market data.