You are here: Reports > Activity > Activity Flex Queries

Activity Flex Queries

The Activity Flex Queries page lets you create highly customized report templates for activity statements. Flex queries let you specify exactly which fields you want to view in your Activity Statement, the time period you want the report to cover, the order in which you want the fields to display, and the display format, TEXT or XML, in which you want to view your report.

You can create multiple Flex Queries with different fields for each statement. All of your Flex Queries are stored in Account Management, and can be easily run from the Activity Flex Queries page. An activity Flex Query is different from a customized activity statement in that you can customize a Flex Query at the field level, allowing you to include and exclude detailed field information. Customized statements only let you include and exclude sections.

The Flex Queries page lets you create a new Flex Query or edit an existing Flex Query. Existing Flex Queries are displayed in the Saved Flex Queries section of the page. You can also edit default Flex Queries for Trades and Positions, then use those queries as the basis for your own Flex Queries.

Saved Flex Queries are available for the four previous calendar years and from the start of the current calendar year.

To create an activity Flex Query

Click Reports > Activity > Flex Queries.

Do any of the following:

To create a new query, click Create New Flex Query.
To run an existing query, click Run for the query.
To edit an existing query, click Edit for the query, then make your changes to the query and click Save Query.
To delete an existing query, click Delete.
To add the Default Trades query, click Create Default Trades Query.
To add the Default Positions query, click Create Default Positions Query.

Note that when you add a default query to the list, the button disappears from the page. If you delete a default query from the list, the button re-appears.

If you clicked Create New Flex Query, a new page appears on which you create your new Flex Query.

If you have a multiple account structure such as an institution account or multiple linked accounts, use the Account Selector at the top of the page to select one or more accounts on which to report. To include activity from accounts that you have recently closed, select the Include Closed Accounts check box. If you choose to include closed accounts, those accounts appear in the Account Selector.

Make selections and set options in the General Configuration and Date Configuration sections.

In the Query Name field, enter the name of the Flex Query.
In the Output Format list, select Text or XML. If you select Text, you must also choose a delimiting character (comma, pipe or tab character), and optionally choose to include header and trailer records; column headers; and section code and line descriptors.

Select other options as required. Note that the Consolidated and All options are only available when the master account has been selected in the Account Selector.
In the Date Configuration section, select the period for the Flex Query, or enter a range of dates in the From Date and To Date fields. The following periods are available:

Last Business Day
Last Month
Last 30 Calendar Days
Last 365 Calendar Days
Month to Date
Year to Date
Last Business Week (Mon-Fri)
Last N Calendar Days (when you select this option, you must then select a number from 1 to 365 from a drop-down)
In the Date Configuration section, select a Date Format, Time Format and Date/Time Separator:

Available date formats are:

yyyyMMdd (default)
yyyy-MM-dd
MM/dd/yyyy
MM/dd/yy
dd/MM/yyyy
dd/MM/yy
dd-MMM-yy

Available time formats are:

HHmmss (default)
HH:mm:ss

Available date/time separators are:

; (semi-colon, the default)
, (comma)
'' (single-spaced)
No separator

Advisors, Money Managers and Brokers and master account users with reporting access rights who select their own master account in the Account Selector have access to client-only consolidated and concatenated statements. Select Consolidated (Clients-Only) to generate activity data for all clients combined into a single statement, or Concatenate All (Clients-Only) to generate statements for all client accounts in a single statement (multiple client statements are joined together in a single statement).

Advisors who have created models in Trader Workstation can include model information in their Activity Flex Queries. In the Models section of the page, select one of these options:

All - Include data for all models joined together. If you select this option, accounts that do not have models will also be included.
Consolidated - Include consolidated data for all models and a single account.
Select a Model - Select this check box to view available models in the Model drop-down list. Select a model from the drop-down to view a statement for a single model. Only models that have been created in Trader Workstation for the selected account(s) will appear. If you select the Independent model, accounts that do not have models will also be included.

To specify which fields in which sections to include, click each section to expand it, then select the fields to include in the Flex Query in each section by highlighting the fields in the Fields Available list, then using the green right arrow to move the fields to the Fields Included list. Use the green left arrow to move fields from the Fields Included list (and exclude the fields from the report).

Click Save Query.

The saved query will now appear in the list of saved queries on the Activity Flex Queries page.

For more information