ETF and Index Fund Tracker Modelo Essentials
Track ETF and index fund holdings with cost basis, current value, and performance. Designed for passive investment portfolio monitoring.
O Que Está Incluído
- 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
Pré-visualização
Veja o que tem dentro desta planilha
Como Usar Esta Planilha 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.
Criadas com Claude AI. Aperfeiçoadas por nós.
Usamos Claude AI para criar cada planilha, após uma pesquisa aprofundada. Depois, nossa equipe entra em ação. Refinamos o layout, testamos exaustivamente cada fórmula, corrigimos casos extremos e polimos o design até que pareça algo que nós mesmos usaríamos. A IA nos leva 80% do caminho. Os últimos 20% são puro julgamento humano.
Perguntas Frequentes
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.
Como abrir no Google Sheets?
Envie o arquivo .xlsx para o Google Drive e abra com o Google Sheets. Todas as fórmulas e formatações serão preservadas.
Mais modelos Essentials de Investing & Trading
Procurando planilhas premium?
Nossas planilhas pagas incluem painéis avançados com várias abas, gráficos nativos do Excel e atualizações contínuas.