Investment Portfolio Tracker Excel — Lot-Level Cost Basis, XIRR True Return & Currency Exposure

Track every holding by individual purchase lot for accurate realized/unrealized gains. Calculates true annualized return using XIRR (not simple averages), handles multi-currency exposure with FX rates, and includes a realized sales log with automatic short-term/long-term holding period classification for tax purposes.