![]() |
Home > Advisor View > Reports > Dynamic and PDF Reports > Available Reports > Saved Searches > Advisor Rebalancing search filters
|
Advisor Rebalancing Search Filters
The following filters are available when using Advisor Rebalancing to create a saved search:
Search Filter | More Information |
---|---|
Account on Hold |
Finds accounts with the Account on Hold restriction, as set on the Account Settings page. |
Account Status |
Finds accounts with a status set to one of the following:
|
Account Type |
Finds accounts with a specific account type, as set on the Account Settings page. |
Accounts on Trade List |
Finds accounts that are on the Trade List. |
Accounts Rebalanced By |
Finds accounts and rebalancing groups that were rebalanced by a particular user. |
Accounts Sent to the Trade List By |
Finds accounts and rebalancing groups that were sent to the trade list by a particular user within the date range you specify. |
Accounts With OMS Orders |
Finds accounts which currently have orders in Advisor OMS. |
Accounts with OMS Trades Submitted By |
Finds accounts with Advisor OMS trades submitted by a particular user within the date range you specify. If the rebalancing group has an Advisor OMS order that meets the criteria, all accounts in the rebalancing group will be returned. |
Added Today |
Finds the newest accounts that have been added today. |
Allocation Model |
Finds accounts and rebalancing groups that are assigned to the Allocation model you specify. |
Allocation Model Outside Goal |
Finds all accounts or groups that deviate from a single Allocation model you specify by a percentage that you specify. This search filter is similar to the Security Level Model Outside Model Goal filter, but looks only for Allocation models. If the group is outside its model goal, all accounts in the group will be returned. |
Allocation Outside Model Goal |
Finds accounts either greater than or less than a Security Level model goal, using either the relative or absolute percentage outside of goal that you specify. This will return accounts and groups that are outside their model goal, regardless of Security Level model. |
Allocation to Security Level Model |
Finds accounts with allocations to a specific Security Level model you specify, in the percentage of allocation you specify. You can also use the Exclude Cash option to not consider cash as part of the allocation, to narrow your results further. |
Allocation Within or Outside Tolerance |
Finds accounts or rebalancing groups within or outside of their min/max tolerance ranges for either a Security Level Model or for any model relative to the top tier. If the rebalancing group is within/outside its tolerance, all accounts in the rebalancing group will be returned. For rebalancing groups, this search option uses the target, min, and max values based on the relation to the top-tier model to determine if the account is out of compliance. However, this search option will not return any results if a submodel is out of compliance relative to its parent and the submodel is not a Security Level model. ExampleLet’s say you set up the model below:
The account will not be considered out of compliance because BC AM and A SLM are within their min/max ranges. |
Alternate Security Sets |
Finds accounts that are assigned to an alternate security set that you specify. |
Approved By Level |
Searches by the users that approved trades. |
Asset Location Preference |
Finds accounts which have been assigned to the specific Asset Location Preference label, which is set on the Account Settings page for that account. |
Assigned to a Rebalancing Group |
Finds accounts that either are assigned to a rebalancing group or are not assigned to a rebalancing group. |
Cash Available for Trading |
Finds accounts and rebalancing groups where the cash available for trading is within the values you specify. You can specify the values as a dollar amount or a percentage. If the rebalancing group has cash available for trading that meets the criteria, all accounts in the rebalancing group will be returned. |
Cash Outside Model Goal |
Find accounts that have more or less cash than you specified as the goal for cash in the assigned model. This filter looks for cash and cash substitute values relative to the cash goal for the account or rebalancing group. This search option differs from the Cash Available for Trading search option, which only considers the difference between available cash, cash substitutes, and cash reserves, regardless of any cash that is part of the model. |
Cash Reserve Dates |
Searches for cash reserves by a starting and ending date. This saved search will make it easy for you to identify cash reserves that will start or end soon. You can search for a specific reserve category or search across all categories. |
Cash Reserve Goal |
Finds accounts and rebalancing groups where the cash reserve goal is within the values you specify. You can specify the values as a dollar amount or a percentage of the account or rebalancing group. If the rebalancing group has a cash reserve goal that meets the criteria, all accounts in the rebalancing group will be returned. You can leave dates blank to find cash reserves applicable for the current day only. |
Cash to Raise/Raised Cash |
Finds accounts and rebalancing groups with cash to raise or the amount of raised cash is between the minimum and maximum values you specify. You can specify the value as a dollar amount or percentage. If the rebalancing group has cash to raise/raised cash that meets the criteria, all accounts in the rebalancing group will be returned. |
Category Outside Model Goal |
Finds accounts outside of model goal by total deviation at the category level. |
Category Value |
Allows you to search by a specific value, either dollar amount or percentage, for one of these categories:
|
Custodian |
Finds accounts and rebalancing groups assigned to the custodians you specify. |
Custodian Fee Schedule |
Finds accounts assigned to a specific fee schedule that you've assigned to that account. Fee schedules are set on the Fee Schedules page, under Setup. |
Custom Strategy Applied |
Finds accounts in which a custom strategy to generate trades outside of suggested buys and sells has been created. |
Date Added |
Finds accounts that have been created with the date range you specify. |
Directed Trades Applied |
Finds accounts with directed trades. If the account’s rebalancing group has a directed trade within it, the rebalancing group values are used to create the directed trade instead of the underlying account value. |
Discretionary Account |
Finds accounts that are marked as discretionary accounts. |
Fidelity Margin Account |
Finds Fidelity margin accounts and non-Fidelity margin accounts in Advisor Rebalancing. This search filter will only look at accounts with the Fidelity trade file format specified for equities.
|
Group Name 1 |
Finds accounts where Group Name 1 is equal to the value you specify. |
Group Name 2 |
Finds accounts where Group Name 2 is equal to the value you specify. |
Holdings |
Finds accounts with or without holdings. |
Industry Restrictions in Violation |
Finds accounts with securities that are violating industry restrictions. If any account in the rebalancing group has an industry restriction violation, all accounts in the rebalancing group will be returned. |
Keywords |
Finds accounts that are assigned a particular keyword. |
Last Order Date |
Finds accounts that have logged trades within the date range you specify. The most recent last order date of all underlying accounts in the rebalancing group will be used to determine if the account or rebalancing group is returned. You can also use these parameters:
|
Losses in Account |
Finds accounts with short, long-term, or total losses in the account at the % of account or dollar amount you specify. This filter searches at the lot level to determine losses. |
Losses in Model |
Finds accounts with short, long-term, or total losses in the specified model at the % of account or dollar amount you specify. If the rebalancing group has security model losses across all accounts that match the criteria, all accounts in the rebalancing group will be returned. This filter searches at the lot level to determine losses. |
Master Account ID |
Finds accounts with the master account ID you specify. |
Model Min/Max Range |
Finds accounts with securities either in or out of their model min/max ranges. |
Negative T+1 Cash |
Finds accounts and rebalancing groups that have negative T+1 cash. If the account’s rebalancing group has net negative T+1 cash, all accounts in the rebalancing group will be returned even if the account itself doesn’t have negative T+1 cash. |
Non-Discretionary Trade Approval |
Finds non-discretionary accounts that require trade approval. |
OMS Broker |
Finds accounts with the Advisor OMS broker you select. The Advisor OMS broker is set on the Account Settings page. |
OMS Prime Broker |
Finds accounts with the prime Advisor OMS broker you select. The prime Advisor OMS broker is set on the Account Settings page. |
Open Orders |
Finds accounts and rebalancing groups with open orders with a target trade date you specify. If any account in the rebalancing group has an open order, all accounts in the rebalancing group will be returned. |
Order Amount |
Finds accounts that contain an order for a specific security within a dollar amount you specify. |
Order Date |
Finds accounts that contain an order for a specific security within a time period you specify. |
Prospect |
Finds accounts that either are prospects or are not prospects. |
Realized Gains and Losses |
Finds accounts that contain one of the following categories within the amount you specify:
If the rebalancing group has a net realized gain or loss that meets the criteria, all accounts in the rebalancing group will be returned. |
Rebalanced |
Finds accounts that have either been rebalanced or not been rebalanced. |
Rebalancing Account Value |
Finds accounts and rebalancing groups with rebalancing values between a range you specify. If the rebalancing group has a rebalancing account value that meets the criteria, all accounts in the rebalancing group will be returned. |
Reconciled Trade Amount |
Finds accounts that contain a reconciled trade for a specific security within a dollar amount you specify. |
Reconciled Trade Date |
Finds accounts that contain a reconciled trade for a specific security within a time period you specify. |
Restriction Violations |
Finds accounts and rebalancing groups with security restrictions that are out of compliance. Based on the criteria chosen, if any underlying account has securities that are either violating or not violating security restrictions, all accounts within the rebalancing group will be returned. |
Securities Outside Model Goal |
Finds accounts and rebalancing groups that are holding securities that are either above or below the model goal. This can be defined in absolute or relative amounts. If the rebalancing group has securities whose sum total results in the securities meeting the criteria, all accounts in the rebalancing group will be returned. |
Security |
Finds accounts and rebalancing groups that are holding a specific security. You can use the following parameters:
|
Security Level Model |
Finds accounts and rebalancing groups that are one of the following:
|
Security Level Model Outside Model Goal |
Finds all accounts and groups where the value of a single Security Level model that you specify is either above or below the model goal, as defined in either an absolute or relative percentage that you also specify. This search filter is similar to the Allocation Model Outside Model Goal filter, but looks only for Security Level models. If the group has any Security Level models that meet the criteria, all accounts in the group will be returned. |
Security Min/Max |
Finds accounts and rebalancing groups that hold a specific security and is outside of its min/max range. Based on the criteria chosen, if any underlying account has securities that are either violating or within the min/max range of the model assigned to the rebalancing group, all accounts within the rebalancing group will be returned. |
Security Unrealized Gain/Loss |
Finds accounts which hold a specific security with lot-level gain or loss at a specific dollar amount, % of security, or % of account value you specify. You can search for one of the following:
|
Security Value |
Finds accounts and rebalancing groups with security values within the range you specify. If the rebalancing group has a security whose total value meets the criteria, all accounts in the rebalancing group will be returned. |
Short Name |
Finds accounts with the Short Name field within the parameters you specify. |
Tax Status |
Finds accounts that either are taxable or are not taxable. |
Total Deviation from Adjusted Model |
Finds accounts which contains model allocations that are either a percentage greater or less than the adjusted model in the amount you specify. If the rebalancing group has a deviation from its adjusted model that meets the criteria, all accounts in the rebalancing group will be returned. |
Trades on Hold |
Finds accounts with or without trades on hold. If any account in the rebalancing group has trades on hold, all accounts in the rebalancing group will be returned. |
Trades on Hold Target Date |
Finds accounts and rebalancing groups with trades on hold where the review date is within the date range you specify. |
Unable to Rebalance |
Finds accounts with rebalance errors. This search filter also includes accounts that have been saved but not rebalanced. |
Unrealized Gains and Losses |
Finds accounts that contain one of the following categories within the amount you specify:
If the rebalancing group has a net unrealized gain or loss that meets the criteria, all accounts in the rebalancing group will be returned. |
Upload Value Verification |
Finds accounts where the account value in your portfolio account system differs from the amount Advisor Rebalancing calculates. You can specify the value as a dollar amount or as a percentage. |
Uploaded Cash |
Searches the cash that was uploaded for the account. |
Without Model Assignment |
Finds accounts that have not been assigned to a model. |