High-Frequency Execution Log Discrepancy Remediation Matrix

Role: Principal Quantitative Data Architect with twenty years specializing in low-latency electronic trading infrastructure and post-trade tick reconciliation.

Context

• Primary trading desk: {{trading_desk}}
• Raw ingestion feeds: {{raw_feed_sources}}
• Suspected anomaly types: {{suspected_anomaly_types}}
• Matching tolerance window: {{matching_tolerance_window}}
• Downstream surveillance platform: {{downstream_surveillance_system}}
• Applicable regulatory reporting standard: {{regulatory_standard}}

Task

Construct an exhaustive execution feed sanitization matrix that diagnoses malformed, drifted, or duplicate order lifecycle events across {{raw_feed_sources}} and prescribes deterministic imputation, deduplication, and normalization rules compliant with {{regulatory_standard}}.

Method

1. Profile timestamp precision disparities across {{raw_feed_sources}}, standardizing UTC offsets and sub-millisecond drift.
2. Isolate orphan execution fills lacking corresponding parent order identifiers within the {{matching_tolerance_window}}.
3. Identify synthetic duplicate trade messages generated during venue failover events across {{trading_desk}} feeds.
4. Define deterministic tie-breaking logic for conflicting execution prices on fragmented book feeds.
5. Map null, truncated, or non-standard MIC codes and broker IDs to ISO 10383 identifiers.
6. Formulate fallback imputation strategies for missing counterparty identifiers without corrupting regulatory audit trails.
7. Establish threshold parameters where unresolvable records must be quarantined prior to {{downstream_surveillance_system}} ingestion.

Constraints

• MUST maintain complete raw-to-transformed lineage for every corrected execution attribute.
• MUST NOT drop unparseable rows without assigning a standardized error quarantine code.
• Cleaning rules must preserve deterministic reproducibility for retrospective market abuse audits.
• Matrix actions must clearly distinguish between automated transformations and required quant oversight.

Output format

A comprehensive Markdown document containing: 1) Feed Ingestion Architecture Summary (max 150 words); 2) Execution Cleaning Matrix (a structured table containing Columns: Feed Source, Field Name, Anomaly Pattern, Root Cause, Transformation Rule, Preservation Logic, and Quarantine Trigger); 3) Post-Sanitization Validation Checks (numbered list of exactly 5 statistical assertions).

Self-review

• Ensure every anomaly listed in {{suspected_anomaly_types}} has a dedicated row in the matrix.
• Verify that timestamp reconciliation logic respects {{matching_tolerance_window}} constraints.
• Confirm that no destructive cleaning rules violate {{regulatory_standard}} audit mandates.