Practical market worksheet

Partial-Fill Quantity Reconciliation

Find how much of a requested order is filled, confirmed cancelled or still unaccounted for.

Your inputsBrowser calculationCSV export

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.

What this helps you check

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.

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.

Your worksheet

No account connection required

Inputs are processed in your browser by this calculator. There is no quote lookup or file upload for the calculation. Site measurement and consent are handled separately by the site's privacy and consent controls.

CSV schema: fill_id (text), quantity (number), price (number). Header required; comma delimiter. Numeric fields use decimal points. Timestamps require Z or a numeric UTC offset. The original input remains unchanged.

Interactive calculation requires JavaScript. The method and hypothetical worked example below remain readable.

Hypothetical worked example

Check the example by hand

Filled quantity: 5base
Confirmed cancelled quantity: 0base
Open remainder: 5base
Filled share: 50%
Average fill price: 100.4USD per base

Exact example inputs

{
  "requested_quantity": "10",
  "confirmed_cancelled": "0",
  "quote_asset": "USD",
  "csv": "fill_id,quantity,price\na,3,100\nb,2,101"
}

The example is invented to demonstrate the method. It is not a current market quote, a provider's fee schedule or verified trading performance.

How the worksheet works

Fills require distinct fill IDs and positive quantities/prices.
filled=sum(quantity); open=requested_quantity-filled-confirmed_cancelled.
Reject filled+confirmed_cancelled>requested_quantity.
coverage_pct=100*filled/requested_quantity; average_fill=sum(quantity*price)/filled.

Boundaries to keep in view

A cancellation request is not a confirmed cancellation.
Do not assume partial quantity cancellation on venues that do not support it.
Average price is secondary to completeness, and no position-entry or exit R calculation is supplied.

Compare resources for this task

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.

10 Services for Auditing Partial Fills

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.