PL Summary
Download sample file: PL_Summary.csv
The desk-level P&L and VaR values. The P&L values represent the EOD valuations. The VaR values are the prediction for the next day.
This PL Summary file type is identified using the pattern: **/PL_Summary*.csv (as specified by pl.summary.file-pattern
).
This file is loaded using the PLSummary topic.
Field | Key | Null | FieldType | Description | Example |
---|---|---|---|---|---|
AsOfDate | Y | N | Date ‘YYYY-MM-DD’ | The as-of date (T-1). Timestamp (at close of business) for the data. | |
Desk | Y | N | String | The desk ID, or “All-IMA” for company-wide. | |
Currency | Y | N | String | The currency of P&L and VaR values. | |
Actual PL | N | Y | Double | The Actual P&L value | |
Hypothetical PL | N | Y | Double | The Hypothetical P&L value | |
Theoretical PL | N | Y | Double | The Risk-Theoretical P&L value | |
VaR99 | N | Y | Double | VaR at 99% confidence level | |
VaR975 | N | Y | Double | VaR at 97.5% confidence level | |
p-value Actual | N | Y | Double | p-value of Actual PL | |
p-value Hypothetical | N | Y | Double | p-value of Hypothetical PL |