ETF and Index Fund Tracker Modello Essentials
Track ETF and index fund holdings with cost basis, current value, and performance. Designed for passive investment portfolio monitoring.
Cosa include
- 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
Anteprima
Scopri cosa contiene questo modello
Come usare questo modello 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.
Creati da Claude AI. Perfezionati da noi.
Utilizziamo Claude AI per creare ogni modello, dopo una ricerca approfondita. Poi interviene il nostro team. Miglioriamo il layout, testiamo ogni formula, correggiamo i casi limite e rifiniamo il design fino a ottenere qualcosa che useremmo noi stessi. L'AI ci porta all'80%. L'ultimo 20% è tutto giudizio umano.
Domande frequenti
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.
Come posso aprirlo in Google Sheets?
Carica il file .xlsx su Google Drive, poi aprilo con Google Sheets. Tutte le formule e la formattazione saranno conservate.
Altri modelli Essentials Investing & Trading
Cerchi modelli di fogli di calcolo premium?
I nostri modelli a pagamento includono dashboard multi-foglio avanzate, grafici nativi Excel e aggiornamenti continui.
Privato e sicuro
I tuoi dati finanziari restano sul tuo dispositivo. Non li vediamo mai.
Scopri di piu →