The Multi-Currency Global Portfolio Tracker (Google Sheets)

Stop letting your spreadsheet lie to you. If you invest in US stocks, European ETFs, or global assets, your simple tracker is giving you a false ROI. Free spreadsheets fail when they try to convert your cost basis.

The Solution:

• 🌎 Full Multi-Currency Support: Automatically converts all stock, ETF, and dividend prices to your single Base Currency (e.g., EUR, GBP) using live and historical FX rates.
• 📈 Accurate Cost Basis: Uses the historical exchange rate on the date of your transaction to calculate your true cost, ensuring your profit/loss figures are tax-accurate.
• 📊 Reliable CAGR/ROI: Calculates your true annualized return (not a confusing XIRR error) based on the timing of your contributions and withdrawals.
• 🔒 Error-Proof Design: Features protected formulas, easy data entry with dropdowns, and a clear "System Health" alert (Green/Red).