Logo
Full Logo

Real-time portfolio risk from one data platform

An investment firm replaced overnight spreadsheet risk reports with real-time risk calculations across all asset classes.

At a glance

Client
An investment management firmName withheld for confidentiality
Industry
Banking
Scope
Risk data platform, calculation engine and dashboards

The challenge

Risk data for equities, fixed income and derivatives lived in separate systems. Analysts built Value at Risk reports overnight in spreadsheets, so risk managers always looked at yesterday's positions.

During volatile markets, the firm could not see its combined exposure when it mattered most.

Our approach

  1. Model risk data once

    Positions, market data and reference data were brought into one consistent model.

  2. Stream changes

    Trades and market moves flow into the platform as they happen.

  3. Calculate continuously

    A scalable engine recalculates VaR and exposures across all asset classes.

  4. Show it clearly

    Dashboards let risk managers drill from firm level down to individual positions.

The solution

Risk managers now see firm-wide exposure and Value at Risk updated throughout the day, across every asset class, from one trusted source.

The overnight spreadsheet process has been retired, and the same data feeds regulatory reporting.

Results

  • One source of truth for positions and market data
  • Intraday risk instead of overnight reports
  • Drill-down from firm level to single positions
  • Spreadsheet-based risk reporting retired

Technology used

  • Kafka
  • Apache Spark
  • Python
  • Cloud data warehouse
  • Risk dashboards

Facing a similar challenge?

Tell us what you are working on. We will walk you through how we would approach it, with no obligation.

All case studies