Use tools for list manipulation

Whether you’re combining, comparing, or filtering these lists, there are specialized tools that make the process fast and consistent. Below is a breakdown of the three key tools available for list manipulation, including what each tool is, what it's for, examples of use, and their key features.

1. Merge lists

What it is: The Merge lists tool is a tool that combines two separate lists into one, removing any duplicate entries automatically.

What it’s for: Use this when you want to merge two sets of data (such as stock tickers or names) while ensuring that no item is repeated.

Example: "Combine my watchlist stocks with these recommended stocks."

Key Features:

• Performs a logical OR (union) operation

• Eliminates duplicates from the final list

• Ideal for combining items from multiple sources (e.g., internal and external lists)

2. Intersect lists

What it is: The Intersect lists tool is a tool that returns a list of items common to both input lists—only the elements that appear in both are included in the result.

What it’s for: Use this to find overlap between two data sets, such as identifying stocks that meet two different sets of criteria.

Example: "Show me which stocks appear in both my watchlist and the recommended list."

Key features:

• Performs a logical AND operation

• Only includes items found in both lists

• Useful for narrowing down to items that meet multiple conditions

3. List difference

What it is: The List difference tool is a tool that finds items in the first list that are not present in the second list, helping you identify what's unique or excluded.

What it’s for: Use this when you want to remove certain items from a broader list—such as excluding stocks from a specific index or filter group.

Example: "Show me stocks in the Russell 1000 that aren't in the S&P 500."

Key Features:

• Performs a list subtraction operation

• Helps identify differences between universes

• Commonly used for filtering or custom universe construction