Partial-Fill Quantity Reconciliation Resources
Find how much of a requested order is filled, confirmed cancelled or still unaccounted for.
An order can produce several executions before its requested quantity is complete. This worksheet adds distinct fill records, calculates their weighted average price, and reconciles filled plus explicitly confirmed cancelled quantity against the original request. An unaccounted remainder stays visible.
Partial-Fill Quantity Reconciliation
Audit requested, executed and confirmed-cancelled quantities while keeping open remainder visible.
A hypothetical request for 10 base units has fills of 3 units at 100 USD and 2 at 101 USD. The file accounts for 5 filled units, a 50% filled share and a weighted average of 100.4 USD per base. With no confirmed cancellation, the open remainder is 5 units.
Open the worksheet10 Services for Auditing Partial Fills
Partial-fill review depends on distinguishing order identity from execution identity and on having a complete record range. Provider order explanations, exports and manual worksheets can support reconciliation in different ways.
Compare documented roles using execution rows, order versus fill identity, requested quantity, confirmed cancellation, history coverage. The Telegram channel we promote is disclosed in the first entry.
Read the comparisonPrepare useful inputs
Enter requested quantity and only the quantity confirmed cancelled. Supply one row per fill with a distinct fill ID, positive base quantity and positive quote-per-base price. Do not infer cancelled quantity from a missing export row or treat an order ID as a unique execution ID.
Read results in their proper scope
Open remainder is the amount not accounted for by these supplied fills and confirmed cancellation. It is not a live venue order status. The tool rejects a file where filled plus confirmed cancelled exceeds the request instead of showing a misleading negative remainder.
The worked example and method can be read without JavaScript. Running the calculator requires JavaScript; its form values remain in the browser, with no account connection or quote lookup for calculation.
Official sources and scope
The sources document formats, mechanisms or record workflows. The arithmetic and editorial comparison on this page use the supplied worksheet definitions.
- Coinbase Advanced order management
Filled quantity, order states and cancellation of unfilled remainder.
Reference checked 2026-10-01. Consult the source for current product rules. - TraderSync managing executions
Manual trade and execution records, including multiple executions.
Reference checked 2026-10-01. Consult the source for current product rules. - TradeZella generic CSV
Execution-based and trade-history templates, column mapping and crypto category.
Reference checked 2026-10-01. Consult the source for current product rules.