Trade Confirmation Flex Queries

You create Trade Confirmation Flex Queries on the Custom Flex Queries screen.

  1. Click Performance & Reports > Flex Queries.

    • Alternatively, click Menu in the top left corner > Reporting > Flex Queries.

  2. If you manage or maintain multiple accounts, the Account Selector opens. Search for and select an account.

    The Flex Queries screen opens.

  3. Click the + icon in the Trade Confirmation Flex Query Templates section.

  4. Enter the name of the Flex Query.

  5. In Sections, click each section that you want to appear in your Flex Query.

  6. As you select each section, a pop-up opens with all possible fields in the selected section.

    • Select level of detail options at the top of the pop-up.

    • Click each field that you want to appear in the Flex Query.

    • Change the order in which the fields will appear by dragging each field to a different position by the bars symbol on the right.

    • Click Save.

  7. In Date Configuration, choose how you want the report delivered.

    • Accounts - Click Add/Edit Accounts to bring up the Account Selector
    • Models - Choose from Optional or All

    • Format - Choose from XML, CSV, Text (Pipe), Text (Tab)

    • Period - Choose from Last Business Day, Last Business Week, Last Month, Last Quarter, Last 30 Calendar Days, Last 365 Calendar Days, Last N Calendar Days, Month to Date, Quarter to Date or Year to Date

  8. In General Configuration, enter the date format, time format, and date/time separator. Select the output format (XML, CSV, or Text). If you select Text as the format, select additional options. Select options to include canceled trades, include audit trail fields, and display your account alias.

  9. Click Continue.

  10. Review your Flex Query and click Create.

    You can now run your new Flex Query.