Back

Search Filters

Contents

Introduction

Available Search Filters

Saved Searches Filters and Custom Fields

 

Introduction

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.

Available Search Filters

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:

 

  • B AM and C AM have a min value of 45% and a max value of 55%.

  • B AM has a current value of 40% and C AM has a current value of 60%.

  • BC AM and A SLM both have current values at 50%.

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: 

 

  • To find accounts that have not been assigned a benchmark, choose None.

  • 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
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:

 

  • CDs

  • Commercial Paper

  • Fixed Income

  • Mortgage-Backed

  • T-Bills

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:  

 

  • Asset Class

  • Sector

  • Subsector

  • Region

  • Security Type

  • Market Cap

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.

 

  • Fidelity margin accounts.Tamarac Trading will identify the accounts where you've set Mark as Margin Account in Trade File for Equities/ETFs to Yes on Account Configuration within the account's settings.

  • Fidelity NON-margin accounts.Tamarac Trading will identify the accounts where you've set Mark as Margin Account in Trade File for Equities/ETFs to No on Account Configuration within the account's settings.

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: 

 

  • If you want to find accounts without any logged orders, use the Before search option and specify today's date.

  • When you use the Within the last or Not within the last search options for less than 31 days, the search will use market days instead of calendar days.

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:

 

  • CDs

  • Commercial Paper

  • Unit Trusts

  • T-Bills

  • Fixed Income

  • Mortgage-Backed

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: 

 

  • Download

  • Post

  • Download and Post

 

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: 

 

  • Realized Short Term Gains

  • Realized Long Term Gains

  • Realized Short Term Losses

  • Realized Long Term Losses

 

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: 

 

  • Closed

  • Closed and Linked

  • Manual

  • Missing

  • Reconciled

  • Unreconciled

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:

 

  • Short Term Gains

  • Long Term Gains

  • Total Gains

  • Short Term Losses

  • Long Term Losses

  • Total Losses

Accounts, Account and Group, Group, Holding, Security
Security

Finds accounts and groups that are holding a specific security. You can use the following parameters: 

 

  • If you want to search for accounts that are not holding a particular security, use the Holding less than search option and specify $.0001 for the amount.

  • If the sum total of security holdings for the group level meets the criteria, all accounts in the group are returned.

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:

  • Assigned directly to one or more Security Level models you specify.

  • Associated to one or more Security Level models you specify via an Allocation model.

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: 

  • Any Status

  • Active

  • Pending

  • Inactive

  • Update Required

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: 

  • Unrealized Short Term Gains

  • Unrealized Long Term Gains

  • Unrealized Short Term Losses

  • Unrealized Long Term Losses

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

 

Saved Searches Filters and Custom Fields

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.