Skip to main content
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). A sample file is PL_Summary. This file is loaded using the PLSummary topic. See the Topic Aliases table for an understanding of the topic aliases associated with each topic.
FieldKeyNullFieldTypeDescriptionExample
AsOfDateYNDate ‘YYYY-MM-DD’The as-of date (T-1). Timestamp (at close of business) for the data
BookYNStringThe Book
Legal EntityYNStringThe Legal Entity
CcyYNStringThe currency of P&L and VaR values
Actual PLNNDoubleThe Actual P&L value
Hypothetical PLNNDoubleThe Hypothetical P&L value
Theoretical PLNNDoubleThe Risk-Theoretical P&L value
PnLNNVectorVaR P&L Vector values