Order Import

Orders can be imported from an Excel spreadsheet. Once orders are imported using the Import button, they can be checked in the Order Import view and selected orders can be submitted into the market by selecting the Submit option from the right-click menu.

To correctly set the delimiters, the Windows language settings must be the same as the user’s web
browser language settings.

Order Import view example

The spreadsheet needs to contain the correct column headings. The column heading names map to those used in the Order Entry view. You could create a template with the correct column headings using the Export data to CSV button in the Order Import or My Orders view.

Order Import Excel Spreadsheet example

Click on the Import button. A Windows Open dialog box will open and the Excel file containing the
orders data can be selected for import.

Order Import view - Imported Orders example

If there are errors, the cells containing the erroneous, or missing, data will be displayed in red. Incorrect or missing data can be amended in the view by typing directly in the cells or selecting from drop-down
lists

Order Import view – Error Fixing example

Alternatively, remove all the orders by clicking on the Clear button. Modify the Excel spreadsheet and import the orders again by clicking on the Import button.

To submit the orders to the Orderbooks, select the orders to be submitted, right-click and select Submit.

Order Import – Submit Orders example

If the orders are successfully submitted to the Orderbooks, the Status will change to Submitted.

Order Import – Orders Submitted example