Open topic with navigation

Trade Confirmation Flex Queries

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

To create a trade confirmation flex query

1. Click Reports > Flex Queries.
   The Flex Queries screen opens.

   

2. In the Custom Flex Queries panel, click the Configure (gear) icon.

   

   The Custom Flex Queries screen opens.

   

3. Click + icon in the Trade Confirmation Flex Query Templates section.
4. In Trade Confirmation Flex Query Details, enter the name of the Flex Query and select the output format (XML or Text).
   If you select Text as the format, select additional options. Choose a default or base currency P&L format. Also select options to include canceled trades and display your account alias.

   

5. In Date Configuration, enter the period, date and time format and date/time separator.

   

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

   

7. As you select each section, a popup opens with all possible fields in the selected section.
   • Select level of detail options at the top of the popup.
   • 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.

   

8. Click CONTINUE.
9. Review your Flex Query and click Create.
   You can now run your new Flex Query.