Inspiration: We wanted transparency for ETF buyers, since the ETF providers often provide limited data about the components of the ETF. One of our members used to follow a person who broke down ETF reports, but he stopped, so our member was motivated to take matters into his own hands and create an agent breaking down ETF reports.

What it does: Our n8n AI agent takes standard ETF reports—which often lack crucial context and leave out important details—and automatically breaks them down into deeper, more comprehensive information. Instead of forcing users to dig through sparse summaries or hunt down missing metrics on their own, the agent analyzes the initial report, gathers the missing pieces, and outputs a clear, thorough breakdown that gives investors the full picture.

How we built it: We built ETF Agent Report using scheduled n8n workflows connected to a Supabase (Postgres) database and a Netlify HTML dashboard. One workflow downloads Fidelity ETF holdings (FCCL, FCCV, FCCQ, FCCM) and uses a Google Gemini AI agent to match companies to tickers, while another pulls batch stock prices from Alpha Vantage. Postgres SQL functions calculate split-adjusted returns and holding contributions (weight × return), and a second Gemini agent summarizes and compares the funds for the live dashboard.

Challenges we ran into: We were on free membership, so we couldn't get all the prices of all the stocks at once, so we had to wait until the next day to get more prices.

Accomplishments that we're proud of: None of us have a background in computer science and we were still able to put together a finished project.

What we learned: How to use node-based tools, databases, and build the structure of ai agents.

What's next for ETF Agent Report: We would like to include more ETFs so the users have more choices. Additionally, instead of using external APIs to find all the sources of the stock prices, we will let the ai agent scrape the web (for example, Yahoo Finance) to solve the problem of free APIs limiting the search queries while staying free.

Built With

Share this project:

Updates

Submission history