Back

Working With Saved Searches

Contents

Introduction

Benefits of Saved Searches

Using Filters and Filter Sets

Filters

Match Criteria

Filter Sets

See Filters and Filter Sets in Action

Saved Searches in Your Workflow

Easily Accessing your Saved Searches

Role-Based Saved Searches

 

Introduction

Saved searches are a useful tool to help with your daily workflows. You create saved searches using one or more filters which look for certain account criteria, such as accounts that hold a certain security or the tax status of the account. Once you build a saved search, you can revisit it regularly to find accounts that require action, or review accounts. You can also use that saved search to filter results on several pages.

Here, we've outlined some of the common strategies you can use when building saved searches, as well as highlighted ways saved searches can be used in your daily workflow.

For more information on building saved searches, see Create, Edit, and Delete Saved Searches.

Benefits of Saved Searches

Creating saved searches can be beneficial in several ways: 

Using Filters and Filter Sets

You can create saved searches with complex, nested searching logic. You can also build simple, flat searches only using one or two search filters to find your results. To do this, you can build your searches with filters, filter sets, and logic that searches for Any or All of the filters.

Filters

Search filters define a single type of search criteria. By adding a single search filter, you're narrowing your search results to just those accounts that conform to that search filter. For example, you can use the Account Type filter to find all IRA accounts.

You can also combine filters to narrow results further. For example, you can further narrow down your search to find IRA accounts that also use the Aggressive Growth Allocation model.

Match Criteria

You can use Match and then select All to tell Tamarac Trading to search for IRA accounts and also use the Aggressive Growth Allocation model, or Any to search for accounts that are either IRA account types, use the Aggressive Growth Allocation model, or both.

Filter Sets

Filter sets allow you to embed more complicated search logic and add tiers of logic to your search. You can add search filters to a filter set using the Add Filter Set button. Then, you can add additional tiers of filter sets. By using the Any option in the Match list, you can set up different criteria and use the search to meet either types of criteria. For example, you can create a saved search to look for accounts that need to raise cash, and then you can add filter sets to establish different cash thresholds for taxable and tax-exempt accounts.

See Filters and Filter Sets in Action

You want to create a saved search looking for accounts with cash available for trading.

If the account is a Roth account, you want to set a different cash threshold because you want Roth accounts fully invested, but you'll allow for greater variation in cash amounts in all other account types. You'll use filter sets to define different cash needs for different account types.

At the top of your search, you include filters that must apply to each account in the saved search. You want to find accounts that are active and accounts with model assignments. You don't want to trade in closed accounts, nor do you want to trade in accounts without assigned models.

Next, you want to add another layer to the search so that you're finding accounts that meet one of these criteria: 

To do this, you click Add Filter Set and use the Any option in the Match list. This means that, after searching for accounts that meet the top-level criteria, Tamarac Trading will next find accounts that meet either of the criteria for cash needs outlined above.

This creates the final saved search which will find accounts that have cash available for trading using the thresholds you've set: 

Saved Searches in Your Workflow

Saved searches were designed with your daily workflow in mind. The following are ways you can incorporate the saved searches you create.

Easily Accessing your Saved Searches

Saved searches are portable and can be used on many pages within Tamarac Trading. They can also be added to the dashboard, creating an easy way to view the number of accounts that apply to a particular saved search, as well as the ability to directly link to certain pages to take action on those saved searches.

For more information on adding saved searches to your Dashboard, see Saved Searches Dashboard Widget.

Role-Based Saved Searches

Because saved searches are so versatile, they can be created and used in different ways among the various positions in your firm. The following are common saved searches you can create and use based on your role within your firm: 

Role Common Saved Searches
Analyst/First Approver
  • Accounts added in the last 30 days with no model assigned
  • Accounts created today
  • Closed accounts in groups
  • Active accounts without models assigned
  • Accounts in groups where asset location preference is none
  • Accounts with unassigned securities
  • Accounts with cash to raise
  • Accounts with cash to invest (including additional filter sets for Roth and small accounts)
  • Accounts with cash to invest/raise
  • Allocations out of tolerance
  • Unrealized losses above $X and Y%
Trader
  • Accounts with trades on hold
  • Accounts with trades on hold for today
  • Accounts with trades on hold overdue
  • Accounts on the Trade List
  • Accounts with trades approved by any user
Advisor/Final Approver
  • Accounts with unassigned securities
  • Accounts with unassigned securities, not rebalanced
  • Accounts with cash to raise
  • Accounts with cash to raise, not rebalanced
  • Accounts with cash to invest (including additional filter sets for Roth and small accounts)
  • Accounts with cash to invest, not rebalanced (including additional filter sets for Roth and small accounts)
  • Accounts with cash to invest/raise
  • Accounts with cash to invest/raise, not rebalanced
  • Allocations out of tolerance
  • Allocations out of tolerance, not rebalanced
  • Unrealized losses above $X and Y%
  • Unrealized losses above $X and Y%, not rebalanced
  • Accounts approved by level X
Compliance
  • Accounts out of tolerance, not rebalanced
  • Accounts with open orders not from today
  • Accounts with overdue trades on hold
  • Active accounts not traded in the last 180 days
  • Inactive accounts with value