Report Search Criteria

The search criteria below are available for Trade Detail Report searches.

Basic Search Criteria – Description

Report Type - Type of report.

Perspective - Executing Firm or Carrying Firm.

Exchange Firm - All of the firms for CME Group, CBOT and OCC that you have authority to view. Input the 3-digit firm id into the text box or make a selection in the drop-down.

Trade Date - The date the transaction took place.

  • Equals - Specifies one trading day.
  • Month to Date - Automatically sets the beginning date to the first day of the current month and the end date to the current day.
  • Between - Specify the beginning and end dates for a date range.
  • Note - Only 2 months of data can be viewed at a time.
  • Last Month- Automatically sets the beginning and end dates to the first and last days of the previous month.
  • Two Months Ago - Automatically sets the beginning and end dates to 2 months prior to the current month.
  • Three Months Ago - Automatically sets the beginning and end dates to 3 months prior to the current month.

Profit Center - Predefined account code for the profit center.

Process Date - The date last processed.

Payment Month- The month the trade was paid.

Firm Status - If selected, test firms are included in the resulting report. (Applies to Payment History and Account Reports only).

Advanced Search Criteria – Description

The Advanced Search contains the following additional fields:

Quadrant A group of related contracts traded on a given Exchange. If selected, all contracts in that group will be displayed. Quadrant selections, by Exchange, are described below:

CME Quadrants CBOT Quadrants NYMEX/COMEX Quadrants

CMEAM: Auction Markets

AG:  Agricultural

AG:  Agricultural

AGS:  Agricultural

FIN:  Financial

COMMDTY: Commodity

INDX:  Index

INDEX:  Index

ENERGY: Energy

INT:  Interest Rate

 

FIN:  Financial

CURR: Currency

 

INDEX:  Index

 

 

METAL:  Metal

 

 

GREEN:  Green

Commodity Exchange code (2 or more bytes) used for Clearing. The commodity list will contain the commodity codes from CME, One-Chicago, and the CBOT. You may select a specific or multiple commodities (the commodity list includes the commodity code, the exchange, and the commodity name).

Fut/Opt - Futures (FUT) and / or Options (OPT).

Loc (Location) - Location: Open Outcry (PIT) and / or Electronically (ELEC).

Spread Type - Spread type.

  • D = Differential Spreads
  • L = Legged Spreads
  • S or 6 = Spread
  • P = PIT Trade

APS Ind - Average Price System (APS) Indicator.

  • A = Average Price System trade
  • G or blank = Give-Up trade

Account - Account number of the executing firm or carrying firm, depending on the perspective.

Order Number - Order number. Also known as the executing firm’s card (order number).

Put/Call - Put and / or Call.

Bill Carry Firm Indicator

  • Y = trade associated with agreement that is billable through GPS.
  • N = trade associated with a third party agreement.

Bad Records - Indicates Error or Reversed records. Error records are records that are in an error state due to a lack of either rate set or an account definition within the system. Reversal records are records submitted through GPS that reverse give-ups that were allocated or claimed in error.

PNT Indicator (Ind) - EFP (Exchange for Physical) transaction type:

  • B = Block Trade
  • E = EFP Trade (Exchange for Physical)
  • N = EFR Trade (Exchange for Risk)
  • T = EFS Trade (Exchange for Swap)
  • O = OPNT (Old Privately Negotiated Trade)
  • C = RFC (Request for Cross)

Trade Status Status. Accepted or Rejected.

Account Status Status of account. Accepted or Rejected.

Opposite Firm - The 3-digit FirmId of the executing firm or carrying firm. The perspective option drives whether this is the executing firm or the carrying firm. For example, if the perspective is Executing Firm, the opposite firm will represent the carrying firm.

Opposite Account - The perspective option drives whether this is the executing firm or the carrying firm. For example, if the perspective is Executing Firm, the opposite account will be a carrying firm account.