![]() |
|
Search Filters
Search filters allow you to build search criteria and add complexity to your saved searches. You can add these filters in layers to find the accounts you need by using additional filters and filter sets to narrow your search.
When building a saved search, you can use any of the following filters to find the accounts you need:
Filter | More Information | Available Search Types |
---|---|---|
Account Created |
Allows you to identify new accounts added to on the date you specify.
|
Accounts, Account and Group, Group, Holding |
Account Type |
Finds accounts that are assigned a particular account type.
When you select Use account group values, the search will return all groups that match the selected criteria. This option will affect the number of groups returned in the search results. |
Accounts, Account and Group, Group, Holding |
Accounts on Trade List |
Finds accounts that are on the Trade List. |
Accounts, Holding |
Accounts Rebalanced By |
Finds accounts and groups that were rebalanced by a particular user. |
Accounts, Holding |
Accounts Sent to the Trade List By |
Finds accounts and groups that were sent to the Trade List by a particular user. |
Accounts, Holding |
Accounts with Unrealized Gain/Loss in Securities |
Finds accounts containing either short- or long-term losses in a specific security in the amount you specify. For example, you can find short-term losses in security ABC greater than 1% of account value. |
Accounts, Holding |
Advisor |
Finds accounts assigned to a particular advisor. |
Accounts, Account and Group, Group, Holding |
Allocation Model |
Finds accounts and groups that are assigned to the Allocation model you specify. |
Accounts, Holding |
Allocation Model Outside Model 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. |
Accounts, Holding |
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. |
Accounts, Holding |
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. |
Accounts, Holding |
Allocation Within or Outside Tolerance |
Finds accounts or 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 group is within/outside its tolerance, all accounts in the group will be returned. For 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.
For example, let'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. |
Accounts, Holding |
Alternate Security Sets |
Finds accounts that are assigned to an alternate security set that you specify. |
Accounts, Holding |
Amortize or Accrete To |
Finds securities or holdings with the amortization or accretion value you specify. |
Holding, Security |
Annual Capital Gains Tax Budget | Finds accounts or groups where the amount of capital gains tax incurred is within a certain percentage of the capital gains tax budget. You choose what percentage of the budget and whether the budget is between, not between, greater or equal to, less or equal to, greater than, or less than the percent. | Account, Account and Group, Group, Holding |
Approved By Level |
Searches by the users that approved trades. |
Accounts, Holding |
Asset Allocation Within or Outside Tolerance |
Finds accounts that have drifted outside the target asset allocation you specified. You can choose to include or exclude groups, unmanaged assets, or SMAs. |
Accounts, Account and Group, Group, Holding |
Asset Allocation |
Finds accounts with a current asset allocation you specify. The date for this composite saved search filter is relative to the end date of the time series.
In most cases, we recommend using this search filter for secondary criteria, as this search filter requires the calculation of all holdings for all accounts and may slow down your search results. |
Accounts, Account and Group, Group, Holding |
Asset Location Preference |
Finds accounts which have been assigned to the specific Asset Location Preference label. |
Accounts, Holding |
Asset Management |
Finds either managed or unmanaged assets in the amount you specify. |
Accounts, Account and Group, Group, Holding, Security |
Assigned to a Rebalancing Group |
Finds accounts that either are assigned to a group or are not assigned to a group enabled for rebalancing. |
Accounts, Holding |
AUM Household |
When the Search type is Accounts, you'll choose a Household and this search will show all AUM-enabled accounts within that Household.
When the Search type is Household, this search shows all accounts that either enabled for AUM or not enabled for AUM, depending on the option you choose. |
Accounts, Households |
Benchmark |
Finds accounts that are assigned a particular benchmark. You can also use the following parameters:
|
Accounts, Account and Group, Group, Holding |
Billing Cycle |
Finds accounts with the billing cycle your specify. |
Accounts, Holding |
Billing Definition |
Finds accounts that are assigned the billing definition you specify. |
Accounts, Holding |
Billing Group |
Finds accounts that are assigned or not assigned to a particular billing group. You can also identify accounts that aren't assigned to any billing group. |
Accounts, Holding |
Bond Rating |
Finds securities with bond ratings for Fitch, Moody's, and S&P, filtered by ratings. |
Holding, Security |
Bond Rating Change |
Finds securities with bond rating changes for Fitch, Moody's, and S&P within a date period you specify. This search uses the Effective Date for each bond rating, and applies to the following security types:
|
Holding, Security |
Call Date |
Finds securities by the call date for Fixed Income and CDs. Manual securities are not included in the search results. |
Holding, Security |
Cash Available for Trading |
Finds accounts and 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 group has cash available for trading that meets the criteria, all accounts in the group will be returned. |
Accounts, Holding |
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 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. |
Accounts, Holding |
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. |
Accounts, Holding |
Cash Reserve Goal |
Finds accounts and 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 group.
If the group has a cash reserve goal that meets the criteria, all accounts in the group will be returned.
You can leave dates blank to find cash reserves applicable for the current day only. |
Accounts, Holding |
Cash to Raise/Raised Cash |
Finds accounts and 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 group has cash to raise/raised cash that meets the criteria, all accounts in the group will be returned. |
Accounts, Holding |
Category Outside Model Goal |
Finds accounts outside of model goal by total deviation at the category level. |
Accounts, Holding |
Category Value |
Allows you to search by a specific value, either dollar amount or percentage, for the categories you have established. These are some possible categories you might have:
|
Accounts, Holding |
Client Administrator |
Finds accounts by the client administrator assigned to a client. You can use the No Client Administrator option to find accounts without a client administrator. |
Client |
Client Type | Finds Households based on the Client Type setting you specify in the search filter. | Household |
Client View |
Finds accounts assigned to a client view you specify. |
Client |
Closed Date |
Finds accounts that have been closed in the timeframe you specify.
When you select Use account group values, the search will return all groups that match the selected criteria. This option will affect the number of groups returned in the search results. |
Accounts, Account and Group, Group, Holding |
Closing Value |
Finds accounts with a closing value you specify. |
Accounts, Account and Group, Group, Holding |
Composite Membership |
Find accounts that were or were not members of a specific composite on a certain date. Results are also available for export as a Composite Membership bulk report.
When searching groups, only groups with the Composite reporting group setting enabled will be returned as results for the Composite Membership search filter. |
Accounts, Account and Group, Group |
Compute Performance Inception Date |
Finds accounts based on whether or not that account is computing its performance inception date based on the first transaction for the account and not Performance Inception Date in the account's settings. |
Accounts, Account and Group, Group, Holding |
Created On |
Finds accounts or Households created during the time period you specify. You can use this filter to find newly created clients or audit existing ones. |
Client, Household |
Current Value |
Finds accounts that have the account value you specify.
When you select Use account group values, the search will return all groups that match the selected criteria. This option will affect the number of groups returned in the search results. |
Accounts, Account and Group, Group, Holding |
Custodian |
Finds accounts and groups assigned to the custodians you specify. |
Accounts, Holding |
Custodian Fee Schedule |
Finds accounts assigned to a specific fee schedule that you've assigned to that account. |
Accounts, Holding |
Custom Strategy Applied |
Finds accounts in which a custom strategy—used to generate trades outside of suggested buys and sells—has been created. |
Accounts, Holding |
Custody | Finds accounts based on their Custody account setting. | Accounts |
Custody Type | Finds accounts based on their Custody Type account setting. | Accounts |
Default Template |
Finds accounts that have been assigned the PDF template you specify as its default. |
Accounts, Account and Group, Group, Holding |
Directed Trades Applied |
Finds accounts with directed trades.
If the account's group has a directed trade within it, the group values are used to create the directed trade instead of the underlying account value. |
Accounts, Holding |
Discretionary Account |
Finds accounts that are marked as discretionary accounts. |
Accounts, Holding |
Domestic | Finds Households based on whether or not the Domestic setting is enabled. | Household |
Fidelity Margin Account |
Finds Fidelity margin accounts and non-Fidelity margin accounts. This search filter will only look at accounts with the Fidelity trade file format specified for equities.
|
Accounts, Holding |
FIX Flyer Equity Broker | Finds accounts by the broker assigned at the account level for institutional FIX Flyer trading. Brokers are assigned separately for equities and mutual funds, and this filter finds accounts by the equity broker assigned to the account. | Accounts, Account and Group, Group, Holding |
FIX Flyer Mutual Fund Broker | Finds accounts by the broker assigned at the account level for institutional FIX Flyer trading. Brokers are assigned separately for equities and mutual funds, and this filter finds accounts by the mutual fund broker assigned to the account. | Accounts, Account and Group, Group, Holding |
Holdings |
Finds accounts with or without holdings. |
Accounts, Holding |
Household |
Finds accounts based on the Household you select. |
Accounts, Account and Group, Group, Holding |
Inception Date |
Finds accounts with an inception date that you specify.
When you select Use account group values, the search will return all groups that match the selected criteria. This option will affect the number of groups returned in the search results. |
Accounts, Account and Group, Group, Holding |
Industry Restrictions in Violation |
Finds accounts with securities that are violating industry restrictions.
If any account in the group has an industry restriction violation, all accounts in the group will be returned. |
Accounts, Holding |
Initial Value |
Finds accounts with an initial value you specify. |
Accounts, Account and Group, Group, Holding |
Investment Discretion | Finds accounts based on the Investment Discretion account setting. | Accounts |
Investment Manager | Finds accounts based on the investment manager or managers assigned to the client's account. | Accounts |
Last Billed Date |
Finds accounts that have been billed in the date or date period you specify. |
Accounts, Account and Group, Group, Holding |
Last Login Date |
Finds accounts where the last date a client signed into his or her client portal is within the time period you specify. You can use this search to find clients that haven't signed in for a long time and then you can contact them to remind them about online access. |
Client |
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 group will be used to determine if the account or group is returned.
You can also use these parameters:
|
Accounts, Holding |
Last Reconciliation Date |
Finds accounts where the account's last reconciliation date is within the date range you specify. |
Accounts, Holding |
Last Valuation Date |
Finds accounts where a manual security has an as-of date in the date range you specify. |
Accounts, Holding, Security |
Losses in Account |
Finds accounts that have a position with short-term, long-term, or total unrealized loss lots greater than the percentage and/or dollar amount specified in the saved search filter. |
Accounts, Holding |
Losses in Model |
Finds accounts with short-term, long-term, or total losses in the specified model at the % of account or dollar amount you specify.
If the group has Security Level model losses across all accounts that match the criteria, all accounts in the group will be returned. This filter searches at the lot level to determine losses. |
Accounts, Holding |
Managed Cash |
Finds accounts based on the value of managed cash within the account that you specify. |
Accounts, Account and Group, Group, Holding |
Managed Flows |
Finds accounts based on the cash value of the accounts' managed inflows or outflows that you specify. |
Accounts, Account and Group, Group, Holding |
Maturity Date |
Finds securities based on maturity date. The search filter includes the following security types:
|
Holding, Security |
MGP Current Probability of Success |
Finds Households with a Current Probability of Success in the designated range. This search filter is only available when you have enabled the MoneyGuide integration. |
Households |
MGP Last Import Date |
Finds Households with a Last Import Date in the designated range. This search filter is only available when you have enabled the MoneyGuide integration. |
Households |
MGP Recommended Probability of Success |
Finds Households with a Recommended Probability of Success in the designated range. This search filter is only available when you have enabled the MoneyGuide integration. |
Households |
Model Min/Max Range |
Finds accounts with securities either in or out of their model min/max ranges. |
Accounts, Holding |
Negative T+1 Cash |
Finds accounts and groups that have negative T+1 cash.
If the account's group has net negative T+1 cash, all accounts in the group will be returned even if the account itself doesn't have negative T+1 cash. |
Accounts, Holding |
Net Worth |
Finds Households with a net worth you specify. |
Household |
Non-Discretionary Trade Approval |
Finds non-discretionary accounts that require trade approval. |
Accounts, Holding |
Objective |
Finds accounts that are assigned a particular objective you specify. These objectives are created in your portfolio accounting system.
When you select Use account group values, the search will return all groups that match the selected criteria. This option will affect the number of groups returned in the search results. |
Accounts, Account and Group, Group, Holding |
Open Orders |
Finds accounts and groups with open orders with a target trade date you specify.
If any account in the group has an open order, all accounts in the group will be returned. |
Accounts, Holding |
Option Expiration Date |
Finds securities with the option expiration date you specify. |
Holding, Security |
Order Amount |
Finds accounts that contain an order for a specific security within a dollar amount you specify. |
Accounts, Holding |
Order Date |
Finds accounts that contain an order for a specific security within a time period you specify. |
Accounts, Holding |
Payment Account |
Finds accounts that are assigned the payment account you specify. You can also use this filter to find direct payment accounts. |
Accounts, Holding |
Payment Status |
Finds accounts based on their billing payment status—either paid, partially paid, or unpaid—within the time period you specify. |
Accounts, Holding |
Price As Of |
Finds accounts that have price updates for the date range you specify. This filter is available when you select Security in Search type. |
Holding, Security |
Preferred Delivery Method |
Finds clients where the default reporting option is one of the following:
You can use this search filter to identify clients that still prefer paper reports. |
Client |
Primary Advisor |
Finds accounts assigned or not assigned to a particular advisor. |
Accounts, Account and Group, Group, Holding |
Prospect |
Finds accounts that either are prospects or are not prospects. |
Accounts, Holding |
Realized Gains and Losses |
Finds accounts that contain one of the following categories within the amount you specify:
If the group has a net realized gain or loss that meets the criteria, all accounts in the group will be returned. |
Accounts, Holding |
Rebalanced |
Finds accounts that have either been rebalanced or have not been rebalanced. |
Accounts, Holding |
Rebalancing Account |
Finds accounts that have been enabled or not enabled for rebalancing with the Allow Rebalancing setting on the Account Settings panel. |
Accounts, Holding |
Rebalancing Account Value |
Finds accounts and groups with a rebalancing value in the range you specify.
If the group has a rebalancing account value that meets the criteria, all accounts in the group will be returned. |
Accounts, Holding |
Rebalancing Group | Finds groups that are either enabled for rebalancing or not enabled for rebalancing. | Group |
Reconciled Trade Amount |
Finds accounts that contain a reconciled trade for a specific security within a dollar amount you specify. |
Accounts, Holding |
Reconciled Trade Date |
Finds accounts that contain a reconciled trade for a specific security within a time period you specify. |
Accounts, Holding |
Reconciliation Status |
Finds accounts where the reconciliation status is one of the following:
|
Accounts, Holding |
Relationship End Date | Finds Households that have a Relationship End Date within the boundary you set in the search filter. | Household |
Relationship Start Date | Finds Households that have a Relationship Start Date within the boundary you set in the search filter. | Household |
Reporting Group |
Finds all accounts within the group you specify. |
Accounts, Holding |
Restrict All Securities |
Finds accounts where the Restrict All Securities settings is either enabled or disabled. |
Accounts, Holding |
Restriction Violations |
Finds accounts and 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 group will be returned. |
Accounts, Holding |
Returns |
Finds accounts with a time-weighted return that you specify.
When you select Use account group values, the search will return all groups that match the selected criteria. This option will affect the number of groups returned in the search results. |
Accounts, Account and Group, Group, Holding |
Securities Excluded From Billing |
Find accounts that are assigned securities that have been excluded from billing calculations. |
Accounts, Holding |
Securities Excluded From Performance |
Find accounts that are assigned securities that have been excluded from performance calculations. |
Accounts, Holding |
Securities Globally Excluded from Billing |
Finds securities that have been globally excluded from billing calculations. This filter is available when you select Security in Search type. |
Holding, Security |
Securities Globally Excluded from Performance |
Finds securities that have been globally excluded from performance. This filter is available when you select Security in Search type. |
Holding, Security |
Securities Outside Model Goal |
Finds accounts and 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 group has securities whose sum total results in the securities meeting the criteria, all accounts in the group will be returned. |
Accounts, Holding |
Securities with 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:
|
Accounts, Account and Group, Group, Holding, Security |
Security |
Finds accounts and groups that are holding a specific security. You can use the following parameters:
|
Accounts, Holding |
Security Category |
Finds securities assigned to the category you specify. It can also be used to find securities that are unassigned to the selected category type. |
Holding, Security |
Security Created |
Finds securities within the creation date of those securities that you specify. |
Holding, Security |
Security Cross Reference |
Finds accounts that are holding a ticker you specify.
When you select Use account group values, the search will return all groups that match the selected criteria. This option will affect the number of groups returned in the search results. |
Accounts, Account and Group, Group, Holding, Security |
Security Level Model |
Finds accounts and groups that are one of the following:
|
Accounts, Holding |
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. |
Accounts, Holding |
Security Min/Max |
Finds accounts and 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 group, all accounts within the group will be returned. |
Accounts, Holding |
Security Value |
Finds accounts and groups with security values within the range you specify.
If the group has a security where the total value meets the criteria, all accounts in the group will be returned. |
Accounts, Holding |
Service Team Name |
Finds accounts, clients, and Households that are assigned or not assigned a particular Service Team. |
Accounts, Account and Group, Client, Group, Household |
Service Team Users |
Finds accounts, clients, and Households where a particular Service Team user is assigned or not assigned to a client.
For example, you use the Service Team Users filter to find all clients where the assigned CSA is Juanita Cruz. |
Accounts, Account and Group, Client, Group, Household |
Sleeve Account Type |
Finds parent accounts, sleeve groups, or sleeve accounts based on the configuration of Enable Sleeve Reporting. |
Accounts, Account and Group |
Short Name |
Finds accounts with the Short Name field within the parameters you specify. |
Accounts, Account and Group, Group, Holding |
Short-Term Gain Maturity |
Finds securities that are converting from a short-term to a long-term gain or loss in the time period you specify. |
Accounts, Holding, Security |
SMA |
Finds accounts that are separately managed accounts (SMAs).
When you select Use account group values, the search will return all groups that match the selected criteria. This option will affect the number of groups returned in the search results. |
Accounts, Holding |
SMA Description |
Finds accounts based on the SMA Description value that you specify. This field is set on the Separately Managed Account panel within the account's settings. |
Accounts, Holding |
State of Primary Residence |
Finds accounts based on the State/Prov. of Primary Residence value that you specify. This field is set on the Name/Address panel within the account's settings. |
Accounts, Holding |
Status |
Finds clients where the client portal status is one of the following:
|
Client |
Target Allocation |
Finds accounts assigned to a particular asset allocation. |
Accounts, Account and Group, Group, Holding |
Tax Status |
Finds either taxable or non-taxable accounts. |
Accounts, Holding |
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 group has a deviation from its adjusted model that meets the criteria, all accounts in the group will be returned. |
Accounts, Holding |
Trades on Hold |
Finds accounts with or without trades on hold.
If any account in the group has trades on hold, all accounts in the group will be returned. |
Accounts, Holding |
Trades on Hold Target Date |
Finds accounts and groups with trades on hold where the review date is within the date range you specify. |
Accounts, Holding |
Trading ID |
Finds accounts based on the Trading ID value that you specify. This is set on the Account Configuration panel within the account's settings. |
Accounts, Holding |
Unable to Rebalance |
Finds accounts with rebalance errors. This search filter also includes accounts that have been saved but not rebalanced. |
Accounts, Holding |
Unrealized Gains and Losses |
Finds accounts that contain one of the following categories within the amount you specify:
If the group has a net unrealized gain or loss that meets the criteria, all accounts in the group will be returned. |
Accounts, Holding |
Upload Value Verification |
Finds accounts where the account value in your portfolio account system differs from the amount Tamarac Trading calculates. You can specify the value as a dollar amount or as a percentage. |
Accounts, Holding |
Uploaded Cash |
Searches the cash that was uploaded for the account in the amount you specify. |
Accounts, Holding |
Variance |
Find accounts that have drifted from the target asset allocation. You specify the variance as a dollar amount or as a percentage. |
Accounts, Account and Group, Group, Holding |
Voting Authority | Finds accounts based on the Voting Authority account setting. | Accounts |
Without Model Assignment |
Finds accounts that have not been assigned to a model. |
Accounts, Holding |
Wrap Program | Finds accounts based on the Wrap Program account setting. | Accounts |
If you've added custom fields to your accounts, Households, or securities, you will see these custom fields as an available filter.
For example, you've added the custom field Opportunity to your accounts to classify client segmentation—using the criteria High Opportunity and Low Opportunity. You can use the Opportunity filter to find accounts that meet these criteria.
The Effective Date search filter is an additional filter for custom fields that maintains history. This setting allows you to search by the date when you set a value for the field.
For example, you can create a search to identify all clients that were upgraded from Low Opportunity to High Opportunity for a date range you specify.