Workflow overview
Why this workflow matters
Potentially useful as a reusable automation building block.
Automate Your ETF Comparison: Real-Time Data & Analysis Automate ETF research in Excel with one click. This AlekSystem 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 Trigger: Click “Update Table” in Excel → calls AlekSystem via webhook Excel: Logs current time (GMT-2) and reads all rows from “DivComp” table HTTP Request: Fetches ETF profile page from justetf.com using ISIN HTML Extraction: Parses page with CSS selectors to grab dividends, fees, 5Y performance Code Node: Cleans & structures data (e.g., last 5 years of dividends, yield, growth) Update Excel: Writes clean values back to your table (fees, yield, performance, name) Setup steps In Excel: Add a button → assign macro that calls your AlekSystem webhook URL (path: /ETF) Ensure table “DivComp” has: ISIN, Dernière mise à jour, Frais, Performance depuis 5 ans, etc. In AlekSystem: Connect Microsoft Excel (OneDrive) credential Update workbook/worksheet/table references if needed Test with 1–2 ISINs first Click “Update Table” → watch data refresh in real time! Tags: ETF, Excel, Web Scraping, Investing, Finance, Automation, justetf, Dividend Tracking
Best fit
Categories
Services
Use cases
Need another direction?