Uploading orders to TT
You can use the Order Upload feature to submit orders into the TT platform using a comma-separated (.csv) file.
Before uploading orders, the .csv files must be properly formatted. The Order upload .csv file format help describes the format of the order upload file and the supported order parameters.
Additionally, you must be authorized in Setup to trade with all accounts provided in the upload file.
Uploading an orders file
To upload orders from a orders .csv file:
In the Order Book, select Upload orders from the context menu.
The Upload Orders dialog appears.
In the Upload Orders dialog, either Select files to locate the desired .csv files or drag them to the dialog; then click Close.
The Order Book Import Column Mapper appears. It shows the columns that could be automatically mapped from your input file, along with columns that either could not be mapped automatically or have no values for one or more of the orders.
Map the Unused Columns to their corresponding Import Load Columns either by dragging an unused column to its corresponding import column or by clicking or by clicking a blank column and selecting the desired column from the drop-down list.
The IMPORT PREVIEW panel presents a preview of the information for the orders defined in the uploaded .csv files. The panel displays only the first ten orders; all of the orders are imported, however.
When you have finished mapping the columns, click Confirm.
Note: You do not have to map all columns. Data for unmapped columns will be ignored during the import.
Submitting uploaded orders
To submit the uploaded orders:
For each order, verify the order parameters.
If you need to update an order parameter, such as changing a price that is no longer valid or changing the order TIF, you can click in the field and change the value.
Do one or both of the following:
After the orders are submitted, they are deactivated in the Order Upload preview widget.
Select all orders you want to submit directly to the exchange, and click Submit to Exchange.
If you want to submit orders into the TT system, but not yet to the exchanges, select the desired orders and click Submit as Held.
Note: TT Order Type orders (i.e. TT Stop, TT Iceberg, etc.) cannot be submitted as held orders; they will go directly to Working state.
To give you visual cues for orders successfully submitted:
If an error occurs when submitting an order, a red triangle indicates the order needs correction.
- The row text is changed to italics.
- The check box is removed.
- A yellow gear icon is displayed in the row for orders submitted as Held; a green check mark is displayed for orders that were successfully submitted to the exchange.
Correcting errors in uploaded orders
If the uploaded file contains errors, such as missing or invalid values, the corresponding order rows are disabled and problematic order parameter values are highlighted.
- Error indicator icon
- Order parameters that need correction
To correct errors:
Hover over the error icon to display the errors related to an order.
In each of the highlighted fields for the order, click in the cell and correct the value.
Note: When you correct all errors for an order, the error icon is removed and the check box is enabled so you can submit the order.
When the errors are corrected, submit the orders by clicking Submit as Held or Submit to Exchange.
A special note about the Contract field
In row 8 of the the previous example, the Contract field for the order (ZB Dec18) is highlighted as an error with error message "Contract: Missing instrument data", even though the contract name looks correct. This error commonly occurs when using the wrong contract name. In this case, the .csv file contained the following entry for the last order.
S, 10, CME, ZB Dec18, 151'14, Day, Limit, , , 12345,,
As described in the Order upload .csv file format help, all contracts must be specified using the exhange-provided "short" contract name, which is listed in the Instrument Data dialog (Type Shift-Ctrl-X in MD Trader or Market Grid row).
Because the order entry in the .csv file identified the contract by specifying "ZB Dec18" instead of "ZBZ8", the upload identified the contract name as an error.