Skip to main content

Change transaction type

Overview

In some situations, the fund’s orders should come in different types of transactions than other purchases and sales. If the sending party cannot control this (for instance, rebalancing or external connections), you can use the rule below to edit assignments.

How to get started

fa-decisiontable-transactionTypeChange.xlsx

  1. Open this Excel.

  2. Make sure that transaction types mentioned in columns 14/15 D (current one) and G (the one, that you would like to use) are matching to your case.

  3. Define a security type code or security code in 14 / 15 E or F columns.

  4. Open Dashboard called “Decision Table Management“.

  5. Upload the Excel file.

  6. Click “Reload rules from Document bank“.

2301263873.png

How the rule works

If the rule finds a trade order:

  • That has the order status mentioned in column C.

    and

  • That has the transaction type mentioned in column D.

    and

  • That has a security type / code mentioned in column E / F

    It will change the transaction type to to match the type in column G