Export Results

Results of queries from Orders, Fills, Aggregate Fills can be exported to CSV file format. The maximum number of exported rows is 65,000.

1. Export search results from Filters view

1. Open an Orders, Fills, or Aggregate Fills card.
2. Identify search criteria within the cards' search fields. (See Order Search, Fills Search, and Aggregate Fills Search for more details.)
3. Select the Report to File link. For large files, this may take a few minutes.
   
4. Select the downloaded CSV file to view it.
   

1. Export search results from Results view

1. Open an Orders, Fills, or Aggregate Fills card.
2. Identify search criteria within the card's search fields and select Search. (See Order Search, Fills Search, and Aggregate Fills Search for more details.)
3. Select the Report to File link.
   
4. Select the downloaded CSV file to view it. The downloaded file contains more columns than appear on the search results screen.
   

Exported Columns

Attributes unique to the following markets: ¹FX Link, ²BrokerTec, ³EBS Market

Orders

Client Order ID Orig Client Order ID Correlation Client Order Id Status Firm Session ID Account Operator ID B/S Qty Open Qty Display Qty Total Filled QTY Contract Long Name CUSIP ISIN Fractional Price Decimal Price Time In Force (TIF) Order Type

Fractional Stop Price Stop Price Reject Reason Cancelation Reason Transaction Time Self Match Prevention ID Product Group Product Type Market Segment Gateway ID Exchange Manual Ord Ind CTI Code CTI Origin Sender Location Expire Date Submitted Time Order Key Tag 1031 - Customer Order Handling

Notes On Behalf Of Average Price Indicator Average Price Group ID Clearing Trade Price Type Execution Instructions2 Execution Mode2 Executor2 Liquidity Provider2 Short Sale Type2 Managed Order2 Repo Term2 Discretion Price3 Original Order User Cancel Text

 

Fills

Client Order ID Fill ID Status Fill Time Operator ID Fill Qty Contract Long Name CUSIP ISIN Session ID B/S Account Fill Price Order Price Stop Price Time In Force (TIF) Fill Price (Dec) Order Price (Dec) Stop Price (Dec) Exchange Sender Location Self match prevention ID

Time To Expiration Firm Underlying Price Option Delta Trade Reference Number Execution Type Market Data Trade Entry Id Order Key Tag 1031 - Customer Order Handling Notes On Behalf Of Average Price Group ID Average Price Indicator Clearing Trade Price Type Fill Reason Value Date1 Base Currency Notional1 Counter Currency Notional1

Execution Instructions2 Execution Mode2 Executor2 Liquidity Provider2 Short Sale Type2 Managed Order2 Repo Term2 Discretion Price3 Trade Type3 Restatement Reason3 Benchmark Price3 Maturity Date3 Contra Gross Trade Amount3 Contra Calculated Currency Last Quantity3 Counterparty3 CTI Code

Aggregate Fills

Account Operator ID Product Code Instrument Type Quantity (Buy) Avg Price (Buy) Avg Price (Sell) Quantity (Sell) Net Position Value