graph LR
Start(["`Start`"])
1["`<strong>set</strong><br>config`"]
2["`<strong>binance</strong><br>fetch current price`"]
3["`<strong>set</strong><br>merge monitoring data`"]
4["`<strong>CodeBox</strong><br>store monitoring data`"]
5["`<strong>notion</strong><br>query recent records`"]
6["`<strong>CodeBox</strong><br>analyze trend`"]
7["`<strong>telegram</strong><br>send daily report`"]
Start ---> 1
1 ---> 2
2 ---> 3
3 ---> 4
4 ---> 5
5 ---> 6
6 ---> 7
Stablecoin Historical Data Storage and Trend Analysis
Stores stablecoin monitoring data in Notion and performs trend analysis on historical records to identify price trends, average deviations, and maximum deviations over time.
Who is this for?
This workflow is designed for data analysts, researchers, and risk managers who want to build a historical database of stablecoin monitoring data and analyze trends over time to identify patterns, average deviations, and maximum risk periods.
What problem is this workflow solving? / Use case
While real-time monitoring provides immediate alerts, understanding long-term trends requires historical data analysis. This workflow automatically stores monitoring data in Notion, queries historical records, and performs trend analysis to help you understand how stablecoin stability has changed over time, identify patterns, and make data-driven risk assessments.
What this workflow does
- Fetches current stablecoin price and trading volume from the exchange
- Retrieves historical price data (7 days of hourly candles) for tracking error calculation
- Calculates current price metrics (price, deviation, volume, tracking error)
- Stores monitoring data in Notion database with timestamp for historical tracking
- Queries recent records from Notion to analyze trends
- Performs trend analysis to determine price direction (UP/DOWN), average deviation, and maximum deviation
- Sends a comprehensive daily report via Telegram with current metrics and trend analysis results
Setup
- Configure the Stablecoin Symbol in the config node (default: USDT/USD)
- Select the Exchange (binance or okx) and Market Type (spot or perpetual) in the config node
- Enter your Notion API Key in the config node (get it from notion.so/developers)
- Provide the Notion Database ID where monitoring data will be stored (create a database with fields: Timestamp, Stablecoin, Price, Deviation, Volume, Tracking Error)
- The Telegram Chat ID will be automatically injected at runtime
Nodes in Use
-
Binance - Get Ticker Price: Fetches current ticker price for a specific symbol from Binance spot or perpetual markets
-
Binance - Get OHLCV Data: Fetches historical OHLCV (Open, High, Low, Close, Volume) data for technical analysis
-
System - Code Box (Sandbox Execution): Executes JavaScript code in a secure sandbox. Can combine existing nodes to implement complex logic
-
Notion - Create Database Record: Creates a new record in a Notion database with specified properties
-
Notion - Query Database Records: Queries records from a Notion database with optional filters and sorting
-
Telegram - Send Telegram Message: Sends text messages through Telegram's bot API using _chatId, message, and optional parameters
Tip: This executable workflow was automatically generated by SeamFlux Bot. To use it, create an execution and test it with your data to ensure it meets your needs.
Ready to get started?
to run this template or create a scheduled task, and ask AI about detailed node execution steps.
Run Locally — download this workflow as a ZIP or run it via Seamflux CLI in your terminal; use the "Run Locally" button above to choose.
Build a workflow from scratch using AI chat. No complex parameter configuration or flowchart dragging needed.
