| Your question | Record to open |
|---|---|
| What is still waiting? | Open orders |
| What happened to the instruction? | Order history |
| What actually traded and paid a fee? | Trade history |
A canceled order can still contain completed trades. Use the order ID to connect its fills before calculating the average price or cost.
Which history answers your question?
The official spot-activity guide distinguishes open orders, order history and trade history: active instructions, order status and completed executions. Names may vary by interface, but the concepts remain separate. A canceled order can still have fills.
Filter by product, symbol and date before concluding that a record is missing.
Map each question to the right record
- Was an instruction accepted?
- Use the order record and its status.
- Did any quantity execute?
- Use trade history or fills, not only the final order label.
- What was the actual average price?
- Calculate from fill price and fill quantity.
- Which fee was charged?
- Match each fill’s fee asset and amount with the asset statement.
- Why is money unavailable?
- Check open orders and reserved balances before assuming funds disappeared.
Use the order ID to connect the records. A timestamp or symbol alone can match several instructions, especially during active trading. Interface labels can change, so verify current filters and export fields in the signed-in account.
Read the status without losing earlier fills
- New or open: inspect side, price, time-in-force and reserved balance. There may be no fill yet.
- Partially filled: reconcile completed fills, then decide separately whether to keep or cancel the remainder.
- Filled: verify that total fill quantity equals the completed amount and reconcile all fees.
- Canceled or expired: check for earlier fills; the label describes the remainder or lifecycle, not necessarily zero execution.
- Rejected: preserve the error and entered fields. A rejected instruction should not be treated as a trade.
Conditional orders can add another layer: the trigger record and the resulting order may be separate. Check both when the interface provides them.
Use open orders to explain reserved balance
An asset can appear in total balance but remain unavailable because an active order reserves it. Match the reserved amount to open order side and remaining quantity before treating the difference as a missing transaction. After cancellation, verify the final order status and any late fill before expecting the full remainder to return.
One order can have several fills
The matching engine can execute against several counterparties or price levels. Each fill records its own price, quantity, role and fee. The average price is quantity-weighted, not a simple average of displayed prices.
Use the fill data when checking a fee calculation or tax record.
A reconciliation example without assuming a fee rate
Suppose an order requests 10 units. Trade history shows one fill of 3 units at price A and another of 4 units at price B, while 3 units remain open. The executed quantity is 7, not 10. Executed quote value is three times A plus four times B. Divide that total by 7 for the quantity-weighted average. Do not include the unfilled remainder in the denominator.
Keep each recorded fee in its native asset. If the first fill paid a fee in the received asset and the second in BNB, adding the raw quantities would be meaningless. Reconcile each deduction to its asset history, then apply a documented conversion rate only if reporting requires one. The account record, not this example, supplies the real numbers.
Keep fees in their original assets
Compare the fee field on each fill with the asset transaction statement. Fees may be charged in the received asset, paid asset or BNB depending on settings and product rules. Conversion and rounding can affect the displayed total.
Referral or campaign benefits should be verified from their own account record rather than inferred from the base fee alone.
Check the timezone and date range
Exports and screens may use different timezones or date boundaries. A fill near midnight can fall on adjacent calendar days in two views. Record the timezone shown by each source and convert timestamps before declaring a missing transaction. Also check whether the selected range is based on order creation, update time or fill time.
Product and symbol filters are equally important. Spot, margin, conversion and other services can maintain separate histories. Clear one filter at a time and keep a note of the query used, so a later export can be reproduced.
Keep the original export intact
Use the export options described in the official trading-history download guide from your signed-in account. Keep the original file unchanged and work from a copy. Record the export time, requested period, timezone, product and filters. Store it as sensitive financial data because it can reveal identifiers, balances and activity patterns.
Do not “clean” the only copy by merging rows or converting timestamps. Spreadsheet software can alter long identifiers, scientific notation and date formats. Import fields as text where necessary, and retain raw fee asset and quantity columns. For tax or legal use, follow local requirements and seek qualified advice.
Are similar rows separate fills?
Rows at the same second and price are not automatically duplicates.
Compare trade ID, order ID, quantity, commission asset and any fill identifier. One order may match multiple counterparties or price levels, and two orders can execute close together.
If a downloaded statement repeats an identifier unexpectedly, verify the raw export and the current account view before deleting anything. Preserve the suspected rows and explain the comparison in an official support case. Public spreadsheets and affiliate sites are not suitable places to upload the file.
When a balance change is not a spot trade
Not every asset change is a spot order. A conversion, recurring purchase, P2P transaction, deposit, withdrawal, distribution or internal transfer may appear in another ledger. If balances changed without a matching spot fill, identify the product first instead of forcing the event into an order-history calculation.
For each account activity, note the originating service, its transaction identifier, asset in, asset out, fee if shown, timestamp and timezone. Then reconcile the resulting wallet movement. This prevents a conversion rate from being mistaken for a spot fill price or an internal transfer from being counted as income twice.
Exports can expose different columns for different products.
Keep each original file and document how records were joined. Do not invent an order ID for an event that has none, and verify current export availability on official pages.
Describe the mismatch to official support
Provide the minimum fields needed to locate the record: product, symbol, order ID, relevant trade IDs, timestamps with timezone, status and a precise description of the mismatch. A redacted screenshot can supplement the identifiers if the official case form accepts it, but keep unrelated orders, balances and personal details out.
Never provide a password, one-time code, authenticator backup, API secret or remote-control access. If the issue concerns an API integration, identify the endpoint and response without exposing credentials or signatures. Recheck official documentation and the signed-in history because available fields can change.