Zum Inhalt springen
Search the hub

← All suppliers

Banking

Murex

Capital markets: trade/position/risk — aggregated exposure and P&L measures; no raw ticket free text.

Templates only — grain, filters, custom fields and ownership are firm-specific.

Copy formulas into the KPI Definition Card, then adapt grain and filters.

Example

Notional outstanding

How much notional volume is outstanding by book/product?

SUM(notionalAmount) FROM trade WHERE status = 'live'
Grain
Live trade
Fields
Trade.notionalAmount, Trade.status, Trade.bookId, Trade.productType, Trade.currency
Dimensions
book, product_type, currency

status=live; lock FX conversion for multi-currency sums.

Adapt: Optional variant: netting per counterparty.

Example

Trade count

How many trades were executed in the period?

COUNT(*) FROM trade WHERE tradeDate IN period
Grain
Trade
Fields
Trade.dealId, Trade.tradeDate, Trade.bookId, Trade.productType
Dimensions
book, product_type, counterparty_type

Do not double-count amendments/cancels as new trades.

Adapt: Optionally exclude internal book-to-book trades.

Daily P&L

What is the daily P&L per book?

SUM(pnlAmount) FROM risk_result WHERE asOfDate = :date
Grain
Risk result (book, day)
Fields
RiskResult.pnlAmount, RiskResult.bookId, RiskResult.asOfDate
Dimensions
book, product_type

Separate realized vs unrealized P&L in the definition.

Adapt: MTD/YTD rollup as an additional variant.

VaR exposure

What is the aggregated VaR contribution per book?

SUM(varContribution) FROM risk_result WHERE asOfDate = :date
Grain
Risk result (book, day)
Fields
RiskResult.varContribution, RiskResult.bookId, RiskResult.asOfDate
Dimensions
book, counterparty_type

Document the VaR model (historical vs parametric).

Adapt: Account for diversification effect when aggregating across books.

Unmatched confirmations

How many confirmations are unmatched/disputed?

COUNT(*) FROM confirmation WHERE matchStatus <> 'matched'
Grain
Confirmation
Fields
Confirmation.matchStatus, Confirmation.tradeId
Dimensions
counterparty_type

Settlement-risk proxy — add an age bucket (>T+1).

Adapt: Count disputed separately from simply pending.

Formula overview

Same formulas as a table — copy into KPI cards or SQL drafts.

Label Formula Grain Fields
Notional outstanding SUM(notionalAmount) FROM trade WHERE status = 'live' Live trade Trade.notionalAmount, Trade.status, Trade.bookId, Trade.productType, Trade.currency
Trade count COUNT(*) FROM trade WHERE tradeDate IN period Trade Trade.dealId, Trade.tradeDate, Trade.bookId, Trade.productType
Daily P&L SUM(pnlAmount) FROM risk_result WHERE asOfDate = :date Risk result (book, day) RiskResult.pnlAmount, RiskResult.bookId, RiskResult.asOfDate
VaR exposure SUM(varContribution) FROM risk_result WHERE asOfDate = :date Risk result (book, day) RiskResult.varContribution, RiskResult.bookId, RiskResult.asOfDate
Unmatched confirmations COUNT(*) FROM confirmation WHERE matchStatus <> 'matched' Confirmation Confirmation.matchStatus, Confirmation.tradeId

Tour