ETF and Index Fund Tracker Plantilla Essentials
Track ETF and index fund holdings with cost basis, current value, and performance. Designed for passive investment portfolio monitoring.
Qué incluye
- 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
Vista previa
Mira qué contiene esta plantilla
Cómo usar esta plantilla de 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.
Creadas por Claude AI. Perfeccionadas por nosotros.
Usamos Claude AI para crear el borrador de cada plantilla, después de una investigación profunda. Luego nuestro equipo interviene. Refinamos el diseño, probamos cada fórmula a fondo, corregimos casos especiales y pulimos el diseño hasta que se siente como algo que realmente usaríamos nosotros mismos. La IA nos lleva al 80%. El último 20% es criterio humano.
Preguntas frecuentes
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.
¿Cómo abro esto en Google Sheets?
Sube el archivo .xlsx a Google Drive y luego ábrelo con Google Sheets. Todas las fórmulas y el formato se conservarán.
Más plantillas Essentials de Investing & Trading
¿Buscas plantillas premium?
Nuestras plantillas de pago incluyen paneles avanzados con múltiples hojas, gráficos nativos de Excel y actualizaciones continuas.