1. Why are brackets important when using OR?

Using "OR" in a screener query requires caution because "AND" takes precedence over "OR". The outcome of your query can vary significantly depending on how you use brackets to group conditions.

Example with brackets: ( Net Profit TTM Growth % > 15 OR Net Profit QoQ Growth % > 20 ) AND ( ROE Annual % > 40 )

This yields 74 results, as the brackets limit the “OR” condition to just two filters: Net Profit TTM Growth% and Net Profit QoQ Growth%.

Example without brackets: Net Profit TTM Growth % > 15 OR Net Profit QoQ Growth % > 20 AND ROE Annual % > 40

This returns 1800+ results because without brackets, “OR” applies to all subsequent conditions, making them optional.

2. How do I filter for NULL values using NOT (!)?

You can use the NOT (!) operator before a parameter to identify fields that have NULL values.

Example: !Forecaster Estimates 12Mth Upside %
This query returns stocks where this field do not have available data. 

3. How do I include both matching values and NULL values in the same query?

To include stocks that either meet a condition OR have NULL values, you need to combine both using the OR operator with proper brackets.

Example: (Forecaster Estimates 12Mth Upside % > 20 OR (!Forecaster Estimates 12Mth Upside %)) 
This ensures that stocks meeting the condition, as well as those with NULL values, are included.