Trading Operations & Middle Office

From execution to settlement every stage a trade passes through and where it can break.

• ▸Execution, booking, confirmation, settlement
• ▸Front-to-back data flow
• ▸Where breaks typically originate

How settlement works, why trades fail, and how operations resolves fails.

• ▸Settlement cycles and instructions
• ▸Common causes of fails
• ▸Resolution and escalation paths

Matching internal records against external sources and investigating the differences.

• ▸Matching keys and tolerances
• ▸Classifying break types
• ▸Root-cause investigation

How PnL is produced and checked in the middle office, and what drives daily moves.

• ▸Mark-to-market and accruals
• ▸Explaining a day's move
• ▸Common PnL break sources

Reliable spreadsheet workflows for blotters, recs and checks that scale.

• ▸Lookups, pivots and validation
• ▸Reusable reconciliation sheets
• ▸Reducing manual error

Querying trade, settlement and reference data to answer operational questions.

• ▸Joins across trade and static data
• ▸Filtering for fails and breaks
• ▸Aggregating exposure and status

Using pandas to match two records sets and surface differences quickly.

• ▸Merge/indicator to find breaks
• ▸Tolerance-based matching
• ▸Summarising break reasons

The shell tooling that makes log and file investigation fast.

• ▸grep, awk and pipelines
• ▸Parsing and summarising logs
• ▸Safe handling of data files

Trade Blotter Completion

Complete booking fields and flag rows that fail validation against the rules provided.

Reconciliation Break Matching

Match internal and broker records, classify the breaks and propose a resolution.

Trade Settlement Query Set

Write a query set that reports settlement status and isolates failing trades.

Failed Trades Log Parsing

Parse settlement logs with shell tooling to extract failed trades and summarise reasons.

Cash & Nostro Reconciliation

Reconcile an internal cash ledger to the nostro statement, classify the cash-specific breaks and tie out to the balance difference.