Then top five in percentage

Screening Filters

1. monthly_average_dollar_volume ≥ 300,000

   • Purpose: Ensure the ETFs are reasonably liquid and practical to trade.
   • Rationale: A minimum average dollar volume helps filter out very illiquid products where spreads are wide and it’s harder to enter or exit positions—especially important if you’re actually going to buy from a “top five” list.

2. themes: Canada

   • Purpose: Restrict results to Canadian-focused ETFs, matching your “in Canada” refinement.
   • Rationale: This typically captures ETFs listed on Canadian exchanges or with a Canadian focus, so you’re not seeing U.S. or global products that don’t meet your jurisdiction preference.

3. annual_dividend_yield ≥ 7%

   • Purpose: Implement the “High‑Yield” part of your original request.
   • Rationale: Using annual dividend yield as a percentage is the natural way to define “high yield.” Setting a 7% minimum ensures that the list only includes ETFs that pay comparatively high distributions, which is exactly what you need before ranking the “top five ... in percentage.”

4. expense_ratio ≤ 0.60%

   • Purpose: Avoid high-fee ETFs that could erode your net income return.
   • Rationale: High‑yield products can sometimes come with very high fees. Capping the expense ratio at 0.60% focuses on relatively cost‑efficient options, increasing the chance that the yield you see is not overly eaten up by management fees.

5. inception_date ≤ 2020‑01‑01

   • Purpose: Require that the ETF has been around for at least several years.
   • Rationale: You originally asked for high‑yield ETFs; adding a minimum age (launched on or before Jan 1, 2020) helps ensure a more established track record of paying distributions, rather than brand‑new funds with untested yields.

6. dividend_frequency: Monthly

   • Purpose: Enforce your requirement for monthly income.
   • Rationale: This directly matches “Monthly ETFs” by selecting only those that distribute dividends on a monthly schedule, excluding quarterly or semi‑annual payers.

Why Results Match:

• Your original request: “High-Yield Monthly ETFs” is addressed by:

  • annual_dividend_yield ≥ 7% (high yield),
  • dividend_frequency: Monthly (monthly income),
  • and expense_ratio ≤ 0.60% (keeps net yield more attractive).

• Your follow‑up: “in Canada” is implemented explicitly with:

  • themes: Canada, which restricts the universe to Canadian ETFs.

• Your latest refinement: “the top five ETFs in percentage based on the previous screener results” is naturally handled by:

  • Using annual_dividend_yield (a percentage) as the key metric. Once the above filters define the universe, the system can rank those ETFs by their annual dividend yield and select the top five by yield percentage.

All the filters align with your requests; there are no unsupported indicators here—just a logical narrowing of the ETF universe to Canadian, high‑yield, monthly payers that are reasonably liquid, not excessively expensive, and have some operating history, from which we can then take the top five by yield percentage.