Decomposing total P&L into realised and delta unrealised

Prev Next

You can choose to decompose total P&L for a holding into:

  • Realised P&L, which is gain/loss from transactions during a window.

  • Delta unrealised P&L, which is the change in unrealised gain/loss during a window.

Note: Alternatively, you can decompose total P&L into holding and trading gain/loss, but you shouldn’t mix the two methodologies in the same valuation report.

You can decompose total P&L in holding currency using the following metrics:

ProfitAndLoss/Total

| _

ProfitAndLoss/Total/Market

| _

ProfitAndLoss/Realised/Market

| _

ProfitAndLoss/Unrealised/Market

| _

ProfitAndLoss/Total/Other

Note: LUSID classifies P&L from carry activity, amortisation and accrual as Other. Note carry activity is only reported if transaction types have explicit Carry or CarryAsPnl movements.

You can decompose total P&L in portfolio currency using the following metrics, to understand the impact of exchange rate fluctuations between holding and portfolio currencies:

ProfitAndLoss/Total/PortfolioCcy

| _

ProfitAndLoss/Total/Market/PortfolioCcy

| _

ProfitAndLoss/Realised/Market/PortfolioCcy

| _

ProfitAndLoss/Unrealised/Market/PortfolioCcy

| _

ProfitAndLoss/Total/Fx/PortfolioCcy

| _

ProfitAndLoss/Realised/Fx/PortfolioCcy

| _

ProfitAndLoss/Unrealised/Fx/PortfolioCcy

| _

ProfitAndLoss/Total/Other/PortfolioCcy