Order Profiles

Order Profiles Reference

About the order profile upload file

When uploading order profiles into TT, the .csv file must adhere to the following rules:

Files must be saved as plain text format.
The filename must use a .csv file extension.
Data fields must be comma delimited.
Spaces after commas (for readability) are allowed.

Sample .csv file

FCM_Customer,FCM_IsActive,FCM_Product,FCM_Exchange,FCM_Group,FCM_ProductType,FCM_Account,FCM_ExchAccount,FCM_OrdQty,FCM_MaxQty,FCM_TIF,Clearing Acct,Staged Orders
Customer3,TRUE,6B,CME,*,FUT,SonnAB,456,4,100,Day,JS-1,
Customer3,TRUE,GE,CME,*,FUT,SonnAB,456,5,100,GTC,JS-2,
Customer3,TRUE,ES,CME,*,FUT,SonnAB,456,1,100,GTC,JS-3,

File structure

The .csv file can contain a maximum of 1000 profile rows, as follows:

Row 1 contains the header column fields as follows:
- The row must contain columns for all fields used by any of the profiles.
- The header column fields should match the header names in Order Profiles, including capitalization.
- The field columns can be arranged in any order, but the data within a column must match the value expected by the column header.
Rows 2-n (up to 1003) contain the values for a single profile per row.

Order profile columns

To show the optional MiFID II columns in Order Profiles, right-click the rules panel of the widget and select the Edit Columns... option.

To filter column rows, click the right hand portion of a column header. Note: the Profile column cannot be filtered because the rule rows are already filtered based on the profile(s) selected in the Profiles panel.

When adding a rule or profile, you can set values in the following columns:

Column	Description
Profile	Order profile name.
Use	Sets whether to use a rule for submitting orders. Check the Use column to make the rule available for order entry. If multiple rules are selected, rules will be selected based on the best match, where the more specific values override wildcard "*" values.
Prod	Defines a product. The Market Explorer opens in this cell to allow you to find and select a product. Multiple products can be selected using Ctrl+click or Ctrl+Shift+click. Default product preference is * (all products). Note: The Exch and Type fields will be populated automatically based on the product selected.
Exch	Defines an exchange. The drop-down list in this cell shows exchanges assigned to your account(s). Select "Aggregator" or "Autospreader" to define an order entry rule for Aggregator or Autospreader orders. Default exchange preference is * (any exchanges, including any Autospreader and Aggregator orders). Populated automatically based on the product.
Group	Defines the exchange product group. The drop-down list in this cell shows product groups for exchanges assigned to your account(s). Default product preference is * (all available product groups).
Type	Defines a product type. Populated automatically based on the product. If you select an exchange, only product types supported by that exchange are listed. The list of product types includes the following: FUT — Futures SPRD — Spreads OPT — Options STRA — Strategies CS — Common Stock INDEX — Indexes SPOT — Spot markets TBOND — Treasury Bonds Default product type is * (all product types).
Order Qty	Sets the order quantity for the rule.
Max Qty	Sets the maximum order quantity for the rule.
TIF	Sets a time-in force (TIF) order restriction for the rule to apply to each order. Select a TIF from the drop-down list: DAY — Day orders (e.g., GTD) GTC — Good Til Cancel FOK — Fill Or Kill IOC — Immediate Or Cancel The default TIF is Day.
SL Payup	Sets the Stop-Limit order payup ticks quantity for the rule.
Disp Qty	Sets a display quantity for disclosed-quantity orders (e.g., native Iceberg) for the rule.
Account	Sets the order routing account to use for the rule. Select an account from the drop-down list.
Alt Exch Acct	Shows the value of Tag 440 sent to ICE and ICE_L exchanges. This field allows you to define the Tag 440 value and override the "Exchange Account" value configured in Setup for ICE and ICE_L.
Clearing Acct	Shows the value sent to the exchange as the clearing account.
Order Type	Sets the order type for the rule. Native order types vary by exchange. All TT order types are listed, as well as ADL algos and third party algos.
Template	Sets a TT order type template to the order.
Text A	Free text field that can be routed to the exchange.
Text B	Free text field that can be routed to the exchange.
Text C	Free text field that is not routed to the exchange, but remains on the order in the TT system.
Text TT	Free text field that is not routed to the exchange, but remains on the order in the TT system.
D.E.A	Direct Electronic Access. Sets whether or not the order is sent from direct/sponsored access, or from another source. Valid values: None (blank) Yes No
TrdgCap	Trading Capacity. Valid values: None (blank) Deal — Indication of dealing on own account Match — Indication of trading in a matched principal trading capacity Other — Indication of trading in any other trading capacity
LiqProv	Liquidity Provision. Indication of market making. Valid values: None (blank) Yes No
C.D.I.	Commodity Derivative Indicator. Indication of whether the order is for hedging purposes to reduce risk. Valid values: None (blank) Yes No
InvestDec	Investment Decision ID. Indicates the user or firm who made the trading decision. Enter a registered ID/Short Code.
ExecDec	Execution Decision ID. Indicates the user or firm that submitted the order. Enter a registered ID/Short Code.
Client ID	Client ID. The customer's legal entity identifier (LEI/Short Code).
Take-Up	Identifies who the Give-up order is allocated to.
Give-Up	Identifies the Give-up account or user.
Give-Up Type	Indicates if the Euronext wholesale trade is given up to a member trading firm or individual trader.
Staged Order	Indicates whether the order is a staged order. When this field is checked, the Stage checkbox on the Order Ticket is checked.
Execution Instructions	Order execution instructions for a staged order.
Cust Acct	The Customer Reference Account for wholesale trades.
Clearing Firm	The clearing firm identifier.
Acct Type	Account type code that defines the trader's relationship with a clearing house. The list of account types varies by exchange.
MiFID ID	MiFID II profile ID for ICE only. Required for firms who register with ICE to use a single code instead of individual MiFID order tags 9700-9706.
Client Ref	Client identifier for Euronext wholesale trades.
Order Ref	Trader or order reference identifier for Euronext wholesale trades.
O/C	Optional column which allows you to define default values for markets that support including Open and Close flags when submitting orders.
Clearing Instructions	Indicates if the Euronext wholesale trade must be posted to a specific account in the clearing system. Valid values are: Automatic Automatic and account authorization Give-up to a single firm Manual Manual and account authorization .
Offset Account	Default account used for submitting an offsetting manual fill for a care order. Valid values: "Blank" — Sets the "Offset Account" field in the Order Ticket to the same account used for staging the order. None — Sets "Offset Account" to "None". <Account> — List of accounts available to the user. The account selected appears in the "Offset Account" field.