Advanced Search

An Advanced Search on Managed Investments, Open End Funds, Stocks, VA/VL Policies or Subaccounts, Closed-End Funds, College Savings Plans, ETFs, Separate Accounts/CITs, Indexes, Insurance Product Funds, Money Market Funds, Unit Investment Trusts, Bonds, and Category Average funds can be run from the Workspace tab or from the main menu under New, Basic Search.

To access this function from the Workspace tab:

To access this function from the Main menu:

You can adjust the following options:

  1. Click in the Field Name box in the first row. Click on the + next to a category to display the data points. Note: If you prefer to look for a data point by name rather than by category, click Alphabetically under the View Field Name option located below the grid.

  2. Click in the Operator and Value columns to set values related to your data point.

  3. Repeat steps 1 and 2 to further define the search criteria (click in the Field Name for each row to select an item.)

  4. Click Run Search. The number of Items Searched and Items Found matching your criteria are displayed next to the Run Search button.

  5. If no items are found, check the box next to a row’s number, then click Delete on the Search dialog box to remove that line. Continue to do this until the system can find an item to match your criteria.

  6. Click OK to view the search results in the spreadsheet.