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
search.js