Exposure-limit workbook and counterparty position export — "A counterparty limit is breached because the exposure sheet missed a same-day trade"
Why the manual spreadsheet breaks financial controls and how a deterministic workflow replaces it.
Commodity and counterparty exposure is tracked in a limit workbook refreshed from position exports, so a same-day trade can breach a limit the sheet has not seen.
A counterparty limit is breached because the exposure sheet missed a same-day trade, and the next trade still clears against a stale remaining limit.
Exposure telemetry monitor that accumulates live positions by counterparty and blocks a new trade when the remaining limit would be exceeded.
Exposure assertion: a trade cannot book if it would put counterparty or commodity exposure above the policy limit in force on the trade date.
Three-stage comparison between manual workbook reconciliation and automated rule-based execution.
A counterparty limit is breached because the sheet missed today's trade.
A counterparty limit is breached because the exposure sheet missed a same-day trade.
A trade cannot book if it would exceed the policy limit.
A trade cannot book if it would put counterparty or commodity exposure above the policy limit in force on the trade date.
Adjacent spreadsheet failure modes in the same APQC Category 9 process group.
Treasury IR-gap workbook and debt-schedule export
Hedge blotter workbook and dealer-confirmation email folder
IR-swap blotter and dealer-confirmation email folder
Scope the replacement architecture for manual tracking of commodity and counterparty exposure or combine multiple failure modes in the directory.
