...
Account | Whenever comparing against a DMA platform, the account will be the PropReports Account Id (which should match the DMA platform). When comparing against the clearing firm, the PropReports Clearing Id is shown and positions are combined across one or more sub-accounts prior to comparison. Note that for all accounts in PropReports without a Clearing Id positions are combined and shown as a discrepancy with a blank account. |
Symbol | This is the ticker symbol of the security with the discrepancy. Symbols that have no execution discrepancies are not shown. |
Source Indicator | Internal source refers to the fills PropReports is reporting, externalin PropReports. External are fills at the source you are reconciling against and difference. Difference are the trades that would need to be posted in PropReports in order for that discrepancy to reconcile.
|
Side / Intention | Buy (B), Sell (S), Short (T) or Cover (C). Note that not Not all sources indicate short or cover intention. In those cases, just Buy and Sell codes are used. See Fill Intention or Side for more information. |
Quantity | Quantity traded. Note that some clearing firms bunch trades together. In those cases, the external quantity is the bunched quantity as reported by the clearing firm. |
Price | Execution price. Note that some clearing firms bunch trades together. In those cases, the external price will be the average price of the bunched trade as reported by the clearing firm. |
Order Id |
...
| Order / Ticket Id as reported by the clearing firm (external) or stored in PropReports (internal). Order Ids are not used for reconciliation. They are displayed to make it easier to locate trades causing a discrepancy. |
Here's a sample reconciliation report showing a busted trade:
| No Format |
|---|
ABC123 (123)
XYZ
Internal:
B 4,300 @ 10.543 ABC001
B 200 @ 10.541 ABC002
==========
B 4,500 @ 10.542 (TOTAL)
External:
B 4,300 @ 10.543 ABC001
B 200 @ 10.541 ABC002 CXLD
==========
B 4,300 @ 10.543 (TOTAL)
Difference:
B 200 @ 10.541 |
...