Before You Start
- A basic understanding of ETFs and portfolio construction
- Access to your broker(s) account(s) — e.g., Trade Republic, DEGIRO, Scalable Capital
- Willingness to track your investments in EUR
- Ready to use at least one: Portfolio Performance app, Excel/Google Sheets, or your broker dashboard
- Knowledge of your ETF ISINs/tickers (e.g., VWCE, IWDA, EUNL)
Time needed: 45–90 minutes initial setup, 10–20 minutes monthly maintenance
What you'll need: Broker login(s), recent ETF transaction history, computer with internet access
Tracking your ETF performance in Europe isn’t just about seeing if you’re “up or down.” Done right, it tells you if you’re beating the market, if your broker is charging hidden fees, and if your strategy is working. This tutorial walks you through a reliable, EUR-based approach using free tools and real-world examples. By the end, you’ll know exactly how to monitor your portfolio’s growth, compare it to global benchmarks like VWCE or IWDA, and manage investments across multiple brokers — all tailored for European investors.
If you’re new to ETF investing, check out The Complete Guide to Building Wealth with European ETFs (2026 Edition) for the bigger picture.
Step 1: Gather Your ETF Portfolio Data
What to do: Collect a complete list of your ETF holdings, including:
- ISIN or ticker (e.g., IE00BK5BQT80 for VWCE, IE00B4L5Y983 for IWDA)
- Number of units/shares held
- Purchase dates and prices (in EUR)
- Dividends received (if any)
- All brokers/platforms used (e.g., Trade Republic, DEGIRO, Scalable Capital)
Why it matters: Accurate performance tracking depends on knowing exactly what you own, when you bought it, and for how much. Missing even one transaction (like a dividend or a purchase) can distort your results.
What can go wrong: If you forget to include a past transaction or only track one broker, your performance figures will be incomplete or misleading. This is especially common if you’ve transferred ETFs between brokers or use multiple accounts.
Pro Tip
Download your transaction history as a CSV from each broker to save time. For example, in DEGIRO: Go to Account → Activity → Export and select your desired date range.
Step 2: Choose Your Tracking Tool
What to do: Select a platform to track and analyze your ETF portfolio. The most popular, Europe-friendly options are:
- Portfolio Performance (free desktop app, official site)
- Excel or Google Sheets (manual but flexible)
- Broker dashboards (e.g., Trade Republic, Scalable Capital, DEGIRO)
Why it matters: Not all tools handle EUR transactions, multiple brokers, or complex return calculations. Portfolio Performance is especially strong for European investors — it supports EUR, multi-broker portfolios, and advanced metrics like time-weighted and money-weighted returns.
What can go wrong: Relying only on your broker’s dashboard often misses the full picture if you use more than one broker, or if you want to benchmark against global ETFs. Manual Excel sheets can get messy and error-prone as your transactions grow.
Pro Tip
If you’re serious about long-term tracking, Portfolio Performance is worth the setup. It’s free, open source, and trusted by thousands of European investors.
Step 3: Enter Your Portfolio Data
What to do: Input your ETF holdings and transactions into your chosen tool. Here’s how for each option:
-
Portfolio Performance app:
- Create a new portfolio file (File → New).
- Add a new security for each ETF (Securities → New Security). Enter ISIN, name (e.g., VWCE), and select EUR as the currency.
- For each ETF, enter all buy/sell transactions (Account → New Transaction → Buy), including date, amount, price, and fees.
- Input dividends (Account → New Transaction → Dividend) if your ETF is distributing.
Expected outcome: Your dashboard should now show your current ETF positions, market value in EUR, and a summary of returns.
-
Excel/Google Sheets:
- Create columns for Date, ETF Name/ISIN, Units, Buy/Sell, Price per unit (EUR), Total Cost, Fees, and Dividends.
- Enter each transaction row by row.
- Sum up units and market value with formulas.
Expected outcome: You should see your total portfolio value and a breakdown per ETF.
-
Broker dashboards:
Log in to your broker (e.g., Trade Republic). Navigate to Portfolio or Depot. Your ETF positions, value in EUR, and (often) simple performance graphs will be visible. For Trade Republic: Tap Portfolio → Savings Plan → Select ETF to see details.
Expected outcome: You’ll see your ETF holdings and their current value, but usually not advanced metrics or consolidated multi-broker data.
What can go wrong: Forgetting to enter fees or dividends will overstate your returns. Be sure to use EUR values throughout.
Step 4: Understand and Calculate Your Returns (TWR vs. MWR)
What to do: Learn the difference between time-weighted return (TWR) and money-weighted return (MWR) — and choose the right one for your goal.
- Time-weighted return (TWR): Measures how your investments performed regardless of cash flows (deposits/withdrawals). Best for comparing to benchmarks.
- Money-weighted return (MWR or IRR): Takes into account when you invested money. Reflects your personal performance including timing of buys/sells.
Why it matters: TWR is ideal if you want to know how your chosen ETFs performed versus the market. MWR is better for understanding your own actual return, especially if you add money regularly (e.g., via a monthly savings plan).
How to calculate:
- Portfolio Performance app: Shows both TWR and MWR automatically. Go to Performance → Performance Chart and select the metric in the dropdown.
- Excel: Use the
XIRRfunction for MWR. For TWR, you’ll need to simulate performance periods between each cash flow (see Investopedia guide). - Brokers: Most only show simple total return, not TWR or MWR.
Pro Tip
If you invest via a regular savings plan, your MWR will often be higher or lower than TWR depending on market timing. Don’t be alarmed if the two numbers differ.
Step 5: Benchmark Your Portfolio (VWCE, IWDA, EuroStoxx)
What to do: Compare your portfolio’s performance to a relevant benchmark. For most European ETF investors, the best benchmarks are:
- VWCE (Vanguard FTSE All-World UCITS ETF, ISIN: IE00BK5BQT80): Global, EUR-hedged, accumulating
- IWDA (iShares Core MSCI World UCITS ETF, ISIN: IE00B4L5Y983): Developed markets only, accumulating
- EuroStoxx 50 (ISIN: EU0009658145): Blue-chip eurozone stocks
Why it matters: If you’re building a global, diversified ETF portfolio, you want to know if you’re matching or beating these indices (after fees and taxes). Otherwise, you might be better off with a simple, low-cost ETF.
How to benchmark in Portfolio Performance:
- Go to Securities and add your benchmark ETF(s) as new securities (e.g., VWCE, IWDA).
- Right-click the security and select Add Benchmark.
- Select the time frame (e.g., 1 year, since inception) to compare your portfolio’s TWR to the benchmark.
How to benchmark in Excel:
- Download historical price data for your benchmark ETF (e.g., from Yahoo Finance or the ETF provider site).
- Calculate the TWR for the same period as your portfolio.
- Plot both your portfolio and the benchmark on the same chart for a visual comparison.
What can go wrong: Be sure your benchmark is measured in EUR and uses the accumulating or distributing version matching your portfolio. Comparing a distributing EuroStoxx ETF to an accumulating VWCE portfolio will distort the results.
Pro Tip
Use VWCE as your main benchmark if you’re pursuing global diversification. For more on selecting the right ETF, see How to Choose a Global Equity ETF as a European: CSPX, IWDA, VWCE Compared.
Step 6: Track Performance Across Multiple Brokers in EUR
What to do: Consolidate your ETF data from all brokers into a single tracking tool. This is crucial if you use several brokers (e.g., Trade Republic for savings plans, DEGIRO for lump sums).
- In Portfolio Performance: Create one “account” per broker, and enter transactions from each. The app will automatically aggregate performance in EUR.
- In Excel: Add a “Broker” column, and sum all transactions for each ETF across brokers.
- For broker dashboards: You’ll need to check each separately, or export data and combine manually.
Why it matters: Without consolidation, you’ll miss your true exposure and may double-count or omit investments. Tracking in EUR ensures you see your real returns, unaffected by FX swings.
What can go wrong: Mixing up base currencies (e.g., one broker in USD, another in EUR) can make your returns look artificially high or low. Always use EUR as your reporting currency.
Pro Tip
Set a monthly reminder to update your tracking tool after each new investment or dividend. Consistency is key for accurate long-term performance data.
Common Mistakes
- Ignoring fees or taxes: Omitting broker fees or withholding taxes will overstate your returns.
- Tracking only one broker: If you use multiple platforms, always consolidate your data.
- Comparing to the wrong benchmark: Use an accumulating, EUR-denominated ETF for apples-to-apples results.
- Using incorrect return metrics: Know the difference between TWR and MWR — don’t rely on “total return” alone.
- Manual data entry errors: Typos or skipped transactions can seriously skew your results. Double-check your entries.
Next Steps
- Set a calendar reminder to update your portfolio tracking tool monthly.
- Review your performance and benchmark at least once per quarter.
- Read about avoiding hidden ETF costs to ensure your real returns aren’t eaten by fees.
- If you’re just starting out, try building your first portfolio step-by-step using Trade Republic.
- For advanced strategies, revisit the Complete Guide to Building Wealth with European ETFs.
Disclaimer: This article is for educational purposes only and does not constitute financial advice. Always do your own research and consider consulting a qualified financial advisor before making investment decisions.