Partial fills: average price and net amount

An order for 100 does not establish receipt of 100

Imagine an order intended to buy 100 units. It fills 60, then another 30, and the remaining 10 are cancelled. Gross purchased quantity is 90. The unfilled 10 are not assets that were bought and then went missing. Funds reserved for that remainder must also be distinguished from money actually spent.

Check the order status and cumulative executed quantity before examining each fill. The original requested quantity, latest execution price, cumulative amount and available balance are different fields. None of them alone describes the complete purchase cost.

Weight each price by the quantity executed

In this hypothetical example, 60 units execute at 2 and 30 execute at 2.2. Total execution amount is 60 times 2 plus 30 times 2.2, which equals 186. Divide by the 90 executed units to obtain an average execution price of approximately 2.0667.

Simply averaging 2 and 2.2 gives 2.1 and ignores the larger first fill. The same weighted method works with many rows: sum execution amounts and divide by summed executed quantities. Preserve the original precision during calculation and round only the displayed result. This execution average does not necessarily include every fee.

Continue from gross execution to net receipt

If 0.09 units of the purchased asset are deducted as fees, net receipt is 89.91. Dividing spending of 186 by that quantity gives an effective unit cost of approximately 2.0687. The reduced denominator already includes the effect of the asset deduction; do not add its converted value to spending as well.

If fees instead consume a separate asset you already held, purchased quantity may remain unchanged.

Record that other asset's deduction separately. Without a stated conversion basis, do not combine its quantity directly with the payment currency. See the fee-currency guide for the different cases.

A released reservation is not necessarily a refund

Cancelling an unfilled remainder may make previously reserved funds available again. That change is not automatically a new deposit, a purchase refund or profit. Check the record type and linked order so the release is not counted both as lower spending and as new income.

If a particular payment product charged the full amount in advance, the handling of an unfilled part depends on that product's actual conditions. Do not apply the accounting behaviour of another order interface without checking the records.

Requested, executed and reserved are three separate quantities

Requested quantity describes what you intended to buy.

Executed quantity describes what has already traded. A reservation describes funds not presently available for another use. These can appear together in the account but must not be combined into a single purchased amount.

Suppose an invented order requests 200 units and has executed only 80, with 120 still waiting. Available cash can be lower because funds remain reserved for the rest. Dividing the whole reservation by the 80 executed units would not establish an unusually expensive purchase: reserved money has not necessarily all been spent.

If available cash later rises, that does not mean every completed fill was reversed. Cancelling an unfilled remainder can leave the 80 completed units intact. Use order status and cumulative execution records to identify what was cancelled, rather than inferring it from a balance movement.

Reproduce a three-fill order

This is a hypothetical execution record with no current market prices. Multiply each price by its own quantity, then sum the amounts and quantities separately.

Scroll the table sideways, or focus it and use the arrow keys.

Compare the sums with the order's cumulative fields. If quantity matches but amount differs, check available precision, missing execution rows and whether the summary amount also contains fees. A field labelled total spending may have a broader meaning than price times executed quantity.

The latest fill price of 2.20 is not the price of the entire order. Multiplying it by 100 gives 220 and overstates this example's execution amount. The last row tells you what happened last, not what happened in all preceding rows.

Continue from the example to a net acquisition

Suppose fees deducted from the purchased asset are 0.04, 0.035 and 0.025 across the three fills. They total 0.1, so net acquisition is 99.9. Dividing 208.50 by 99.9 gives approximately 2.0871 per net unit.

If the export already supplies each row's net credited quantity, sum those net quantities without subtracting the same fee again. If it supplies gross quantities and fees, calculate the net amount and verify it against the actual credit. Mixing one row's net quantity with another row that has been reduced twice breaks the calculation.

Preserve the recorded decimal precision. Rounding a fee of 0.035 to 0.04 before adding all fees changes the result. When only rounded screen values are available, state that limitation rather than inventing additional decimal places.

Fee assets can differ between execution rows

Some fees can reduce the target asset while others consume an existing fee-asset balance. Adding those quantities together creates a number without a consistent unit. Group by asset and retain the linked execution reference.

For target-asset deductions, reconcile gross and net acquisition.

For another asset, retain its original quantity and apply a stated conversion basis only if the purpose is broader economic cost. That conversion must not be described as an extra bank debit.

A missing fee-currency field should remain missing until its meaning is established. It may not prevent you from checking gross execution quantity, but it does prevent a confident claim that every fee is included. Record those two levels of completion separately.

An average cannot reconstruct missing execution details

A summary containing total amount, quantity and average price lets you check aggregate consistency within its displayed precision. It cannot uniquely reveal each fill's time, quantity and price. Many combinations share the same average.

Buying 50 units at 2 and 50 at 3 gives an average of 2.5.

Buying all 100 at 2.5 gives the same average with a different execution path. These invented examples show why a plausible average is not evidence of a particular fill sequence.

If you need to investigate a duplicated execution or a specific fee, obtain the relevant detailed record. Report the summary calculation while the detail remains unavailable; do not generate imaginary rows to make the summary look complete.

Export duplicates and summary levels need different handling

Two exports of overlapping history may contain the same execution. Prefer a unique execution identifier and record type when finding that overlap. Different real fills can have identical quantities and prices, so deleting repeated amounts can remove genuine activity.

An order summary and its executions are different levels. Keep the summary as a check and the fills as the calculation source, rather than adding both. Bank payments and execution amounts are also different stages. Preserve the source filename and original identifier while normalizing a working copy. Ambiguous rows should be reviewed instead of deleted merely to obtain a quick total.

Bridge the purchase credit to the current balance

Net execution describes what this order acquired, not what the account should hold now. Prior holdings and subsequent movements matter. With a hypothetical opening balance of 5, net acquisition of 99.9 and later outflow of 20, closing balance is 84.9 if nothing else happened.

Comparing 84.9 with an initial request for 100 and calling the difference a fee would omit the opening balance, actual net acquisition and later outflow. For multiple accounts, set the account boundary before cancelling internal transfer pairs. Removing account names from the data loses the evidence needed to make that distinction.

Record what is resolved and what remains open

This hypothetical record separates a correct asset credit from funds that remain reserved. It is not an actual Vexdu order.

Scroll the table sideways, or focus it and use the arrow keys.

For your own record, retain the asset, fee currency, order identifier and enquiry time. If the fee currency is missing, mark gross execution checked and all-in cost unresolved. Use support record preparation for files, or receipt reconciliation if the actual credit still differs from net execution.