Preparing Trading Desk Risk Reports

Preparing Trading Desk Risk Reports

When To Use

• End-of-day or intraday risk reporting for a trading desk (equities, fixed income, FX, commodities, derivatives)
• P&L attribution requests from desk heads, risk managers, or front-office management
• Limit utilization monitoring and breach escalation reporting
• Preparing risk summaries for morning risk meetings, CRO briefings, or regulatory snapshots
• Ad hoc position analysis following significant market moves or unusual trading activity

Inputs To Gather

• Position data: Current holdings by instrument, asset class, and strategy book — include notional, quantity, and market value
• P&L feeds: Realized P&L, unrealized (mark-to-market) P&L, and any adjustments (e.g., reserve releases, valuation adjustments like XVA)
• Risk sensitivities: Greeks (delta, gamma, vega, theta) for options desks; DV01/CS01 for fixed income; beta and factor exposures for equity desks
• Limit framework: Approved risk limits (VaR, notional, concentration, stop-loss, Greeks) and current utilization levels
• Market data: Relevant benchmarks, index levels, yield curves, implied vol surfaces as of the reporting timestamp
• Prior-day report: Previous desk risk report for comparison and trend analysis
• Desk parameters: Desk name, reporting currency, books covered, reporting date/time, any desk-specific conventions

Workflow

1. Validate source data

   • Confirm position and P&L feeds are complete for all books in scope
   • Reconcile total P&L to independent sources (finance feed, prime broker statements)
   • Check for stale prices, missing marks, or broken instrument links — flag with [VERIFY] if unresolved

2. Build position summary

   • Aggregate positions by asset class, sector/issuer, currency, and strategy book
   • Identify top 10 positions by notional and by risk contribution
   • Highlight new positions entered since prior report and positions closed out
   • Note any concentrated positions exceeding single-name or sector thresholds [VERIFY: confirm desk-specific concentration limits]

3. Prepare P&L attribution

   • Break P&L into components: market moves (delta/duration), carry/roll-down, theta/time decay, volatility (vega), new trade P&L, and residual/unexplained
   • For each component, show the contribution in reporting currency and as percentage of total P&L
   • Compare day-over-day and MTD/YTD figures against prior report
   • Flag any unexplained P&L exceeding the desk's materiality threshold — typically >5-10% of total daily P&L [VERIFY: desk-specific materiality policy]

4. Compile limit utilization

   • For each risk limit (VaR, stress VaR, notional, Greeks, stop-loss), report: limit amount, current usage, utilization percentage, headroom remaining
   • Color-code or tier utilization: green (<75%), amber (75-90%), red (>90%), breach (>100%)
   • For any amber/red/breach status, include: cause of elevated utilization, whether a temporary limit exception is in place, and proposed remediation or timeline to reduce
   • Track cumulative stop-loss triggers (MTD realized loss vs. stop-loss limit) [VERIFY: stop-loss policy reset frequency — daily, weekly, monthly]

5. Add risk commentary

   • Summarize the desk's directional bias and key risk drivers in 3-5 sentences
   • Note upcoming events that may affect the book (earnings, central bank decisions, economic releases, option expirations)
   • Reference any relevant stress test or scenario analysis results if available
   • If VaR back-testing exceptions have occurred recently, note the count and status

6. Format and finalize

   • Structure the report with consistent section headings: Executive Summary, Position Overview, P&L Attribution, Limit Utilization, Risk Commentary
   • Use tables for position and limit data; keep narrative sections concise
   • Stamp with as-of date/time, reporting currency, and desk identifier
   • Ensure figures reconcile across sections (e.g., total P&L in attribution matches executive summary)

Output

A structured trading desk risk report containing:

• Executive summary: 3-5 line snapshot of net P&L, largest risk drivers, and limit status
• Position summary table: Top positions by notional and risk, with asset class and sector breakdowns
• P&L attribution table: Component-level breakdown (delta, carry, theta, vega, new trade, residual) with day, MTD, YTD columns
• Limit utilization dashboard: Each limit with usage, headroom, and RAG status
• Risk commentary: Narrative on directional exposure, upcoming catalysts, and any escalation items

Quality Checks

• Total P&L in attribution section ties to executive summary and position-level P&L roll-up (zero tolerance for mismatch)
• All limit figures reference the correct approved limit amount — cross-check against the limit management system or latest limit memo
• No stale or missing marks remain without a [VERIFY] flag
• Unexplained P&L is quantified and does not exceed desk materiality threshold without commentary
• Reporting timestamp and currency are clearly stated and consistent throughout
• Any limit breach or amber status includes an explanation and remediation note
• Greek/sensitivity totals at the desk level equal the sum of book-level components
• Report is ready for distribution by the desk's reporting deadline [VERIFY: confirm specific cutoff time for the desk]