You can choose to decompose total P&L for a holding into:
Realised P&L, which is gain/loss from transactions during a window.
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. These different methodologies are not intended to be mixed in the same valuation report.
Holding currency
You can decompose total P&L in holding currency using the following metrics:
ProfitAndLoss/TotalProfitAndLoss/Total/MarketProfitAndLoss/Realised/MarketProfitAndLoss/Unrealised/Market
ProfitAndLoss/Total/Other
Note the following:
LUSID classifies P&L from carry activity, amortisation and accrual as
Other.Carry activity is only reported if transaction types have explicit
CarryorCarryAsPnlmovements.
Portfolio currency
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/PortfolioCcyProfitAndLoss/Total/Market/PortfolioCcyProfitAndLoss/Realised/Market/PortfolioCcyProfitAndLoss/Unrealised/Market/PortfolioCcy
ProfitAndLoss/Total/Fx/PortfolioCcyProfitAndLoss/Realised/Fx/PortfolioCcyProfitAndLoss/Unrealised/Fx/PortfolioCcy
ProfitAndLoss/Total/Other/PortfolioCcy
Note the following:
FX rates between holding and portfolio currencies are required for the trade dates of each contributing transaction (to calculate holding cost) and for the valuation date (to calculate PV).
Market gain/loss includes cross gain/loss.
Report currency
You can decompose total P&L in report currency using the following metrics where specified in a valuation request:
ProfitAndLoss/Total/ReportCcyProfitAndLoss/Total/Market/ReportCcyProfitAndLoss/Realised/Market/ReportCcyProfitAndLoss/Unrealised/Market/ReportCcy
ProfitAndLoss/Total/Other/ReportCcy
Note the following:
An FX rate is required from holding to report currency for just the valuation date. This means holding cost in report currency is calculated more naively than holding cost in portfolio currency.
The following metrics are also available but do not contribute to the total in report currency:
ProfitAndLoss/Total/Fx/ReportCcy,ProfitAndLoss/Realised/Fx/ReportCcyandProfitAndLoss/Unrealised/Fx/ReportCcy. A FX rate from portfolio to report currency is required for the valuation date.