Portfolio Value vs Investment Return: What Data Is Missing?

Snapshot value

For each position, units times current entered price times current entered FX gives the base-currency valuation. The dates matter: a stale quote or exchange rate can change the total. Our analyzer rounds each converted position once to base-currency cents, then sums those values.

Remaining cost is an entered record

Enter remaining cost already expressed in the base currency, including whichever acquisition costs your own ledger allocates to the remaining units. We subtract this amount from current value. This is a descriptive unrealized value difference, not independently verified tax basis or a statement of total return.

Why dividends and cash flows change the question

Sales, purchases, reinvestments, fees, deposits, withdrawals and received dividends need a dated transaction history. A performance ledger can distinguish cash-flow timing; a current holdings file cannot reconstruct it. Portfolio Performance describes both time-weighted and internal-rate-of-return methods, whose inputs and purposes differ. Portfolio Performance transaction, return and export workflows

FX attribution is another calculation

A holding converted at today’s entered FX and a cost entered in base currency combine several effects. Our unrealized difference does not split asset-price gains from currency changes. Historical purchase FX or a complete attribution model would be required for that analysis.