ETF and Index Fund Tracker Modèle Essentials
Track ETF and index fund holdings with cost basis, current value, and performance. Designed for passive investment portfolio monitoring.
Ce qui est inclus
- Dashboard with fund portfolio overview showing total invested, current market value, and overall return percentage
- Fund holdings with ticker symbol, fund name, shares owned, average cost per share, and current price per share
- Cost basis and market value tracking with automatic unrealized gain or loss per fund and for the total portfolio
- Expense ratio tracking column for each fund so you can monitor total annual fees across your passive portfolio
- Dividend and distribution logging with color-coded input cells (yellow) and auto-calculated performance (blue)
- Works in Microsoft Excel, Google Sheets, and LibreOffice Calc with no setup required
Aperçu
Découvrez le contenu de ce modèle
Comment utiliser ce modèle ETF and Index Fund Tracker
Enter fund holdings
List each ETF or index fund with the ticker, fund name, shares owned, average cost per share, and current price.
Review performance
The template calculates unrealized gain or loss per fund and for the total portfolio based on cost vs current value.
Track expense ratios
Enter the expense ratio for each fund. The template shows total annual fees across your passive portfolio.
Check the dashboard
The dashboard shows total invested, current market value, overall return, and total expense ratio exposure.
Créés par Claude AI. Perfectionnés par nos soins.
Nous utilisons Claude AI pour rédiger chaque modèle, après une recherche approfondie. Puis notre équipe prend le relais. Nous affinons la mise en page, testons chaque formule en conditions réelles, corrigeons les cas limites et peaufinons le design jusqu'à obtenir un résultat que nous utiliserions nous-mêmes. L'IA nous amène à 80 %. Les 20 % restants, c'est du jugement humain.
Questions fréquentes
What is an expense ratio?
The expense ratio is the annual fee charged by the fund, expressed as a percentage of assets. Lower ratios mean less of your return goes to fees.
Does it track dividends and distributions?
Yes. Log dividend payments in the distribution section. These can be added to your cost basis if reinvested, or tracked as income received.
Can I track both ETFs and mutual funds?
Yes. The template works for any fund with a per-share price. Enter ETFs, index mutual funds, or target-date funds the same way.
How often should I update prices?
Monthly or quarterly updates work well for passive portfolios. More frequent updates are optional but not necessary for long-term tracking.
Comment ouvrir ce fichier dans Google Sheets ?
Importez le fichier .xlsx dans Google Drive, puis ouvrez-le avec Google Sheets. Toutes les formules et la mise en forme seront conservées.
Plus de modèles Essentials Investing & Trading
Vous recherchez des modèles de tableurs premium ?
Nos modèles payants incluent des tableaux de bord multi-feuilles avancés, des graphiques Excel natifs et des mises à jour régulières.
Privé et sécurisé
Vos données financières restent sur votre appareil. Nous ne les voyons jamais.
En savoir plus →