Export Search 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 Reference

Attributes unique to the following markets: 1FX Link, 2BrokerTec, 3EBS 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