Skip to main content

Set trade order execution method

Overview

Trade orders have the field execution method, which defines how a trade order should be executed - whether it is amount, net trade amount or gross trade amount that is kept constant.

How to get started

Note

If you are not familiar with decision tables, first familiarise yourself with how Decision Tables work. For more information, see FA Developer guide: Business rules.

fa_tradeOrder_executionMethod.xlsx

  1. Open this Excel

  2. Modify rules from row 13 downwards to match your needs. If any condition cell is left empty, the condition is not applied (for example empty column E means that the rule applies to all security types).

    1. Give a name for the rule in column A (can be picked freely)

    2. Type ORDER in column B (this limits the rule to trade orders as opposed to transactions, where this field is not used)

    3. Enter order status in column C in order to set the value once and not change it when the order moves from one status to another

    4. Transaction type code in column D

    5. Portfolio group code in column E

    6. Security type code in column F

    7. Security sub type code in column G

    8. Security code(s) to include in column H - you can define one or more codes separated by commas, if you wish to limit the rule to specific securities. For example: AAPL.US, NOKIA.HE.

    9. Security code(s) to exclude in column I - you can define one or more codes separated by commas, if you wish to exclude certain securities from the rule. For example: AAPL.US, NOKIA.HE.

    10. Execution method in column J:

      1. 1 (Not defined)

      2. 2 (Unit based)

      3. 3 (Gross trade amount based)

      4. 4 (Net trade amount based)

  3. Go to Tools → Administer → Decision tables.

  4. Upload the Excel file

  5. Click Done

How the rule works

If the rule finds a trade order matching all the conditions (A-H), it set’s the execution method as defined in column I.