ETF Comparison Analyzer
Les investisseurs individuels et conseillers financiers utilisent ce prompt pour choisir entre deux ou plusieurs ETFs couvrant apparemment le même segment de marché. Il met en évidence les différences significatives en matière de coût, qualité de réplication, concentration et liquidité que les supports marketing masquent.
Prompts
You are an ETF analyst helping a [INVESTOR PROFILE] evaluate and compare exchange-traded funds. I want to compare the following ETFs: [ETF TICKERS]. My primary investment goal is [INVESTMENT GOAL] with a [TIME HORIZON] time horizon. For each ETF provided, research or use the data below to analyze the following dimensions: ETF Data: [ETF DATA — expense ratios, AUM, inception date, benchmark index, sector weights, holdings] 1. **Cost Analysis** Compare expense ratios across all ETFs. Calculate the cumulative cost drag over [TIME HORIZON] on a $[INVESTMENT AMOUNT] investment assuming 7% annual gross return. Flag any hidden costs — bid-ask spreads, securities lending income offset, or tax inefficiency. 2. **Tracking Quality** Assess benchmark tracking error over the most recent three-year period. Note the tracking difference (annual return versus index) as distinct from tracking error (volatility of that gap). Identify which ETF has been most faithful to its benchmark. 3. **Portfolio Concentration and Overlap** List the top-ten holdings of each ETF and calculate overlap percentage between funds. Flag any ETFs where the top-ten holdings represent more than 40% of total assets. Identify concentration risk at the single-stock or single-sector level. 4. **Sector and Geographic Exposure** Build a side-by-side sector allocation table. For international ETFs, include regional breakdown. Note any significant tilt toward cyclical sectors, defensive sectors, or factor exposures (value, growth, momentum, quality). 5. **Liquidity Assessment** Compare average daily trading volume and AUM. Flag any ETF with AUM below $500 million as a potential liquidity or closure risk. Assess bid-ask spreads as a transaction cost for the expected trade size. 6. **Historical Performance Context** Present annualized total returns for one, three, and five-year periods alongside the stated benchmark. Note performance gaps and any periods of significant underperformance. Remind the reader that past performance is not a guarantee of future results. 7. **Best-Fit Recommendation** Based on all dimensions above, recommend the single best ETF for [INVESTOR PROFILE] pursuing [INVESTMENT GOAL]. Justify the choice in three sentences covering cost, quality, and fit. Flag if a two-ETF combination would better serve the investor's goal. Format the core analysis as comparison tables where possible. Write the recommendation section in plain prose.
Variables du Prompt
Remplacez chaque placeholder par vos informations spécifiques :
[INVESTOR PROFILE][ETF TICKERS][INVESTMENT GOAL][TIME HORIZON][ETF DATA — expense ratios, AUM, inception date, benchmark index, sector weights, holdings][INVESTMENT AMOUNT]Ce que vous obtiendrez
Calculs comparatifs de coût cumulatif sur l'horizon d'investissement, comparaison de l'erreur de suivi et de l'écart de suivi, analyse du chevauchement des participations avec signaux de concentration, tableau des allocations sectorielles, évaluation de la liquidité, résumé des performances historiques et recommandation du fonds le plus adapté.
💡 Conseil d'Expert
Répétez cette comparaison annuellement — les émetteurs d'ETF réduisent périodiquement les frais de gestion ou modifient les méthodologies d'indice. Un ETF optimal il y a trois ans peut avoir été dépassé par un concurrent moins coûteux répliquant un indice identique.
Outils IA Compatibles
Claude
Ideal for structured comparison tables and nuanced best-fit reasoning. Paste ETF fact sheet data or holdings lists directly. Claude handles up to five or six ETFs simultaneously and produces well-organized comparison output.
ChatGPT
GPT-4o with browsing can fetch current expense ratios and holdings for major ETFs. Use Data Analysis to run the cost-drag calculation and produce formatted tables. Works best when you provide tickers and ask it to pull its own data.
Perplexity
Best for sourcing current ETF data before running the comparison. Ask Perplexity for the latest expense ratio, AUM, top holdings, and sector weights for each ticker, then feed those figures to Claude or ChatGPT for the structured analysis.
Gemini
Useful when ETF data is stored in a Google Sheet. Gemini can reference the sheet and run the comparison in context. Its built-in Search grounding helps verify AUM and performance data for lesser-known ETFs.