Updating ICC Account Limits via Upload

The following instructions illustrate the process to use the upload function to manage multiple product limits for an execution firm that uses ICC.

• To update ICC Credit Controls via Upload:

1. Perform an account search and select an ICC (CME Globex) enabled account,
2. From the Services pane, select ICC (CME Globex).

3. On the Credit Control pane that appears, select the Execution Firm, deselect Show products with individual limits only, then Download the spreadsheet.

4. Open the downloaded spreadsheet (account-number-credit.xlsx), then update the maximum permissible long / short limits, for the Clearing Member Firm and/or Execution firm.
5. For all updated rows, enter X in the Action column, then save the updates.

6. On the Credit Control pane, select Upload.

Note: Account limits can also be uploaded from the Account List pageSelect Upload, ICC_Limits, Choose a File, then select Upload & Verify..

8. Choose the File, then select Upload & Verify.

Note: Uploads are limited to 20,000 records / rows per upload.

The uploaded file is evaluated and validation dialog appears:

• Success: A confirmation message lists submitted updates, fields and values for each spreadsheet row.

• Failure: An error message appears, with recommended resolution.

Example: Incorrect data, Action column not marked with X.

 

When uploading after an error, select New then choose the updated spreadsheet.

9. After receiving a successful validation message, select Submit, then select OK to close the upload dialog.

Managing ICC Credit Controls for Multiple Execution Firms

The following instructions illustrate the process to use the upload function to manage product limits for multiple execution firms, including blocking order submission for a given product.

Summary:

1. Search and download clearing firm accounts list; step 1 - 2.
2. Search for an account, then update execution firm (product) credit controls; step 3 - 5.
3. Download account - execution firm credit controls spreadsheet; to use as a template; step 6 - 7.
4. Copy execution firm details (template) to new spreadsheet rows, step 8.
5. On the new spreadsheet rows, update account and execution firm information (from clearing firm accounts spreadsheet); step 9.
6. Upload and validate credit controls spreadsheet; step 10 - 12.

• To manage multiple execution firm product limits, via upload:

1. From the Account page, perform a clearing account search, for ICC authorized accounts.

Clearing AccountSearch Criteria:
 Account Type Clearing Account Trading Account, Service CME Direct (CME Globex) Inline Credit Controls [(ICC)(CME Globex)] CME ClearPort Cross Venue Risk CME Straight Through Processing (STP), Account Number The alphanumeric identifier for ClearPort or Globex accounts. ClearPort account numbers may be up to 14 characters. Globex account numbers may be up to 12 characters., Spot FX Ref Number Optional user specified external reference number, Clearing Member Registered member clearing firm, Account Owner Specify name or Legal Entity Identifier, Execution Firm also known as, Trading Firm,Status Active / Inactive / All
ok

2. On the Accounts list that appears, select Download ().

A list of accounts, authorized for this clearing firm, is downloaded to the default download directory, as a MS Excel file (Accounts.xlsx).

Save this file for step 9.

3. From the search results, select an Account Number, then select the Service ICC (CME Globex).
4. Select an Execution Firm to use as the basis for other firms, then deselect the checkbox, Show products with individual limits only.

5. To restrict product(s), select Edit, modify the quantity, then select Save.

Example: To block order submission, set Max Qty Long / Short to zero (0).
Once confirmed the execution firm cannot submit trades for this product.

6. Download the credit control spreadsheet (account-num_credit.xlsx) for the selected account and execution firm.
7. Open the spreadsheet, right-click the ACCOUNT_NUMBER column and format to Text (Number tab).
   
   

8. Copy the row then duplicate as many times as necessary for the accounts you want to restrict.
9. Open the Accounts.xlsx spreadsheet, copy the ACCOUNT_NUMBER and EXECUTION_FIRM_ID values to the account number fields of the acct-num_credit.xlsx spreadsheet.

In the ACTION column, enter X for all updated rows.

10. Save the spreadsheet updates, select Upload (), then select an upload type.
11. Select ChooseFile, browse to the file, then select Upload & Verify.

Note: Uploads are limited to 20,000 rows. For more than 20,000, perform additional uploads.

The uploaded file is evaluated and validation dialog appears:

• Success: A confirmation message lists submitted updates, fields and values for each spreadsheet row.

• Failure: An error message appears, with recommended resolution.

When uploading after an error, select New then choose the updated spreadsheet.

12. After receiving a successful validation message, select Submit.

Upon completion of the upload, select OK, then close the Upload dialog.