Refresh and Search / Export

Trade Blotter options:

  • Refresh to view new trades and other data changes. Trade status changes are automatically updated in the Trade Blotter. 
  • Browse pages of data if more than 400 records are available, as indicated by page number links or a Next link available to the right of the Refresh button.
  • Search to perform an advanced search of records and view trades cleared within a specific date range. The trades shown can be narrowed by the selection of additional filter options. Depending on user privileges, available filter fields may vary.
  • Export trade data to Excel.

 

Search Trade Blotter

 

 

  1. To search trades by a specific or range of dates:
  1. From the Trade Blotter screen, click the Search link. The search criteria pop-up box opens.

The following table defines all the available search fields:

 

Field Description

Account

Executing account mnemonic as agreed between the broker and the clearing member firm.

Aged

Select Yes or No if the Original Trade Date is prior to the current date.

Buyer

The Principal company that is Buying the product.

Clearing Date

This field becomes active if the Top Day check box is unchecked. This is the date the transaction commences.

Client Order ID

Exchange/Clearing Organization where the trade was executed.

Exchange

Exchange/Clearing Organization where the trade was executed.

Group

The product group name.

Price

Price (Percent of Par) per individual unit in the contract.

Principal

The legal entity acting as Buyer or Seller to an agreed transaction with counterparty.

Product

The product code being traded.

Query For Submit Date

Allows a search based on the trade submit date.

Red Code

Product identifier of 6 bytes for Red Code or 9 bytes for Pair Clip.

Refresh

Refresh the blotter with the current trade information.

Search

Retrieves trades for the specified dates.

Seller

The Principal company that is Selling the product.

Set Range

Enables the calendar field, allowing for entry of the transaction termination date.

Source

System used to enter the trade. The sources are:

  • Http V 1.2 - transaction entered through an API version. 
  • Http V 2.0 - transaction entered through an API version.
  • MQ - transaction entered through an API version.
  • gui - transaction entered through CME ClearPort front end interface

Status

The status of the transaction. They are classified as:

Unmatched, Canceled, Alleged, Declined, Expired, Pending Clearing, Partially Cleared, Cleared w Rejects, Cleared, Reject, Void.

Strike Price

Strike price if the product is an option.

Top Trade

Click to clear this box to search a set date range.

Trade ID

The Exchange’s internal ID number assigned to the transaction.

Trade Type

Type of trade executed.

User

User name related to an account or a trade.

Cleared USI (Unique Swap Identifier)

Assigned after trade has been cleared (Status = Cleared). As allocations are cleared, Cleared USI is assigned. OPNT trades only.

Bilateral USI (Unique Swap Identifier)

Bilateral unique swap identifier for OPNT Trades or EFR/EOO Trades which are reported to the CME SDR.

Block USI (Unique Swap Identifier)

A trade/leg level identifier used to tie together allocations of the same Bunched Order.

 

  1. Set applicable search criteria using the drop-down, text boxes, and check boxes, then click Search.

OR

  • Click Clear to remove all selected search criteria. 
  • Click Close to close the pop-up box without setting search criteria.

The trades that match the filter options appear in the Blotter.

Strategy or Combination Transactions that include more than one leg will contain a summary section and a row for each leg beneath the summary. For Strips, Packs, Bundles, and strategies, by default, only the first and last legs are displayed. Click the right arrow to show all legs of a spread.

Note: For Strips, Packs, or Bundles, each contract is displayed separately (similar to how legs of a spread are displayed), although they are entered as a single transaction.


Export Trade Blotter to Excel CSV

 

Note: Help text displays on cursor rollover of Excel icon.

 

  1. To export all trade information in Trade Blotter to an Excel CSV:
  2. Click the Excel icon. File Download dialog box displays.

  1. Do one of the following:
  • Click Open to open all trade blotter rows in an excel spreadsheet.
  • Click Save to save file. Select a directory and file name in the Save As dialog box, and click Save.