Add New Group

Overview
Adding an Account-Based Group
Adding a Criteria-Based Group
Using Multiple Criteria

Overview

Use the Add New Group window to create a group that is based either on accounts or on criteria. You can create an unlimited number of account and criteria groups.

Alternatively, you can import groups from another portfolio management system.

NOTE
After you have added a group, you can edit the group.

Top

Adding an Account-Based Group

Account-based groups consist of accounts that you select directly from the accounts available to you. You can add up to 2,000 accounts to an account-based group.

Select Groups. The Groups window opens.
Select the Create a New Group button. The Add New Group window opens.
Select the Group Type: Account-based.
In the Name box, enter a name for the group. A group name must be unique within your firm.
(Optional) In the Description box, enter a description for the group.
To search for accounts using one criterion, from the Find Accounts drop-down list, select a search criterion. In the adjacent text box, enter at least two characters of the account number or name, and then select the Go button.
Account #
Last Name
Custom Name
FBSI Short Name
or
To search for accounts using up to five criteria, select the Advanced Search link.
The search results window opens with the accounts that match the criterion.
Select the check box to the left of one or more accounts in the search results that you want to add individually.
or
Select the check box to the left of the Account # column header to add all accounts in the search results.
Select the Add to Group button to create the group. The selected accounts display in a list on the Add New Group window. To view contact information for an account, in the Primary Owner column, select the linked account owner name. A window opens with the account owner contact information, including e-mail, phone, and mailing address.
To delete an account from the group, in the Remove column, select the associated check box.
Select the Save button. A confirmation window opens.
Select the OK button. The Group Summary window opens for the group. The group is added to the All Groups and My Groups lists.

Top

Adding a Criteria-Based Group

You can create groups that rely on certain criteria to select the accounts.

Members of criteria-based group are defined using statements. You begin a statement by indicating whether to include or exclude a member based on the criteria. Next, you assign a field, a condition, and a value. Conditions perform like operators and include less than, equal to, greater than, or equal to, and so on. You can also select And or Or to expand your statements to include additional criteria (up to a maximum of 10). You can rely on open and close parenthesis to group the criteria statements. For more information, go to Using Multiple Criteria.

For example, select Total Account Value as the Field you want to use, >= as the Condition field, and 100000 as the Value to create the statement that defines group members as accounts with a total value greater than or equal to $100,000.

NOTE
Criteria-based groups are updated semi-hourly for changes made to custom short name, model name, custom investment objective, or one of the 10 account-level custom fields. Otherwise, the group is refreshed in the overnight batch cycle. Newly opened accounts are added in real time to the All Accounts default group. The new accounts are added to the other default groups, as appropriate, in the overnight batch cycle.

Select Groups. The Groups window opens.
Select the Create a New Group button. The Add New Group window opens.
Select the Group Type: Criteria-based.
In the Name box, enter a name for the group. A group name must be unique within your firm.
(Optional) In the Description box, enter a description for the group.
Build your statement:
From the Include/Exclude drop-down list, select one of the following:
Include Include accounts that match the specified criteria in the group
Exclude Exclude accounts that match the criteria
From the Field drop-down list, select the field you want to use to select accounts to include in the group.
From the Condition drop-down list, if available, select the operator to use with the selected Field.
From the Value drop-down list, select the value to use with the operator and the selected Field.
From the And/Or drop-down list, select And or Or.
NOTE
When an expression in the statement is followed by And, and then by another expression, an account is included in the group if it contains values that MATCH BOTH expressions. Similarly, when an expression is followed by Or and then by another expression, an account is included in the group if it contains values that MATCH EITHER expression.
To add another criterion, select the Add Criteria link.
Select the Save button. A confirmation window indicates the group was submitted and the Message Center will notify you when the group is created and available for use. The group is added to the All Groups and My Groups lists.
Select the OK button.

Top

Using Multiple Criteria

When you use multiple criteria to create a group, it can be difficult to identify the sequence in which criteria are used. You can use parentheses to determine the criterion sequence. Parentheses also facilitate creating nested conditions where a single block or set of parentheses defines a single criterion. The following examples illustrate the use of parentheses.

Use single parentheses to create a group with accounts that have a minimum market value of $1,000,000:
(Total Account Value >= 1000000)
Use single parentheses to create a group with accounts that have a minimum market value of $1,000,000 and a minimum available cash of $10,000:
(Total Account Value >= 1000000 AND Cash Available >= 10000)
Use double parentheses to create a group with accounts that have either a minimum market value of $1,000,000 and a minimum available cash of $10,000, or the account holder resides in a city with a name that starts with xyz and is at a minimum 50 years old, and the currency code is currcode:
((Total Account Value >= 1000000 AND Cash Available >= 10000) OR (City Starts With xyz AND Age >= 50)) AND (Currency Code = currcode)
Use triple parentheses to create a group with accounts that have either a minimum market value of $1,000,000 or a minimum available cash of $10,000 and the account holder is at a minimum 50 years old; or the account is associated with any model name that starts with abc and has a minimum market value of $50,000 dollars; and the account belongs to branch br.
(((Total Account Value >= 1000000 OR Cash Available >= 10000) AND (Age >= 50)) OR (Model Name Starts With abc AND Total Account Value >= 50000)) AND (Branch = br)

Top

626105.3.0
102