PLTrades store holds profit and loss data used for P&L attribution and backtesting.
| Store Field | Key | CanBeNull | Type | Cube Field | Description |
|---|---|---|---|---|---|
| TradeId | String | TradeId | The Trade Id. | ||
| TradeKey | Y | String | This field is for internal usage only | The field contains the tradeID for full data or Book#LegalEntity for summary data | |
| Currency | String | Currency | The currency of the trade. | ||
| ActualPL | Double | This field is a measure and does not appear in any cube | The Actual P&L value | ||
| HypotheticalPL | Double | This field is a measure and does not appear in any cube | The Hypothetical P&L value | ||
| TheoreticalPL | Double | This field is a measure and does not appear in any cube | The Risk-Theoretical P&L value | ||
| PnL | Double Vector | This field is a measure and does not appear in any cube | The VaR PL Vector | ||
| AsOfDate | Y | LOCALDATE[yyyy-mm-dd] | See field in referencing store (IMATrades) | Timestamp (at close of business) for the data. |