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. See the Topic Aliases table for an understanding of the topic aliases associated with each 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
Book Y N String The Book
Legal Entity Y N String The Legal Entity
Ccy Y N String The currency of P&L and VaR values
Actual PL N N Double The Actual P&L value
Hypothetical PL N N Double The Hypothetical P&L value
Theoretical PL N N Double The Risk-Theoretical P&L value
PnL N N Vector VaR P&L Vector values