Loading page
Automate Your ETF Comparison: Real-Time Data & Analysis Automate ETF research in Excel with one click. This n8n workflow pulls live data from justetf.com using ISIN codes from your Excel table, extracts key metrics (dividends, fees, 5-year performance), and updates your “Div study” sheet instantly — all triggered by a button in Excel. Perfect for dividend investors, ETF screeners, or portfolio trackers who want fresh, accurate data without manual copy-paste. --- How it works 1. Trigger: Click “Update Table” in Excel → calls n8n via webhook 2. Excel: Logs current time (GMT-2) and reads all rows from “DivComp” table 3. HTTP Request: Fetches ETF profile page from justetf.com using ISIN 4. HTML Extraction: Parses page with CSS selectors to grab dividends, fees, 5Y performance 5. Code Node: Cleans & structures data (e.g., last 5 years of dividends, yield, growth) 6. Update Excel: Writes clean values back to your table (fees, yield, performance, name) --- Setup steps 1. In Excel: Add a button → assign macro that calls your n8n webhook URL (path: /ETF) Ensure table “DivComp” has: ISIN, Dernière mise à jour, Frais, Performance depuis 5 ans, etc. 2. In n8n: Connect Microsoft Excel (OneDrive) credential Update workbook/worksheet/table references if needed Test with 1–2 ISINs first 3. Click “Update Table” → watch data refresh in real time! --- Tags: ETF, Excel, Web Scraping, Investing, Finance, Automation, justetf, Dividend Tracking
by LouisDaily Crypto AI Market Insight to Telegram This workflow generates a daily AI-powered crypto market insight and sends it to Telegram using Binance public market data, the Crypto Fear & Greed Index, and Google Gemini. It fetches BTC/USDT daily OHLCV data, calculates technical indicators, builds a structured analysis payload, asks Gemini for a buy/hold/sell confidence breakdown, and delivers the result as a clean Telegram report. It is useful for traders, builders, and crypto enthusiasts who want an automated daily technical summary without manually checking charts. Common use cases: Send a daily BTC market insight to your Telegram Monitor crypto technical indicators automatically Build a personal AI crypto analyst bot Create a lightweight daily trading signal workflow Learn how to combine market data, technical indicators, LLMs, and Telegram in n8n How it works Starts from a Schedule Trigger, which you can customize Sets the trading pair, for example BTCUSDT Fetches 300 daily OHLCV candles from Binance public API Normalizes Binance candle data into readable fields Fetches the latest market price and merges it into the latest candle Fetches the Crypto Fear & Greed Index from Alternative.me Calculates EMA(20), EMA(50), EMA(100), RSI(14), MACD histogram, ADX(14), +DI, and -DI Builds a structured technical payload Sends the payload to Google Gemini Parses Gemini’s response into structured JSON Formats the result into a Telegram message Sends the AI-generated insight to Telegram Setup steps Choose your trading pair in the Set Trading Pair node Connect your Google Gemini credentials Connect your Telegram credentials Set your Telegram chat ID in the Telegram node Adjust the Schedule Trigger if you want a different run time Test the workflow manually Activate the workflow Notes This workflow uses Binance public API data and does not require a Binance API key. The AI insight is generated only from the provided technical payload and should not be treated as financial advice. Need Help? Have questions or want to connect? Reach me on LinkedIn.
by Atha Ahsan Xavier Haris