Remove optionable

Screening Filters

1. Market Cap: large, mega, mid

   • Purpose: Focus on established companies (large/mega) plus add mid-caps for more ideas and growth potential.
   • Rationale: You explicitly asked to “include mid caps,” on top of your earlier interest in larger names. This keeps you in relatively stable, widely followed stocks while not missing solid mid-cap opportunities.

2. Volume ≥ 100,000 shares/day

   • Purpose: Ensure liquidity so you can enter/exit without large price impact.
   • Rationale: This is a standard liquidity floor for investors who don’t want to get stuck in thinly traded names.

3. RSI Category: overbought

   • Purpose: Find stocks with strong recent buying pressure / momentum.
   • Rationale: “Overbought” screens for names that have been moving up sharply. Combined with valuation caps, this is very restrictive: you’re asking for stocks that are hot and still only moderately valued.

4. Sector: Consumer Non-Cyclicals, Consumer Cyclicals, Healthcare, Financials, Industrials, Energy, Utilities, Real Estate, Retailers, Telecom Services

   • Purpose: Limit to a broad but defined set of sectors, excluding a few (most notably many Tech names).
   • Rationale: These sectors tend to have clearer traditional fundamentals (P/E, D/E, margins) that align with your “fundamental caps” focus. It avoids some highly speculative areas.

5. Exchange: XNYS, XNAS (NYSE & NASDAQ)

   • Purpose: Restrict to major U.S. exchanges.
   • Rationale: These venues generally offer better liquidity, transparency, and reporting standards—ideal when you’re screening on fundamentals.

6. Gross Margin ≤ 45%

   • Purpose: Cap business model “richness” and avoid ultra-high gross margin businesses that can command very high multiples.
   • Rationale: In line with your “fundamental caps” idea, this avoids extremely premium business models that might distort valuation metrics or be priced as “quality at any price.”

7. Net Margin ≤ 12%

   • Purpose: Avoid very high net-margin companies.
   • Rationale: Again, this is a cap, not a minimum. It keeps out extremely profitable firms that often trade at loftier valuations. This can help focus on more “ordinary” businesses where P/E and P/S are meaningful and not driven by very high profitability premiums.

8. Return on Equity (ROE) ≤ 15%

   • Purpose: Cap profitability/efficiency of capital.
   • Rationale: High-ROE companies often carry higher valuation multiples. By capping ROE, the screener excludes many of these “quality compounders,” keeping you in names that fit your “fundamental caps” idea.

9. Debt-to-Equity (D/E) ≤ 2.0

   • Purpose: Control balance sheet risk by limiting leverage.
   • Rationale: You first wanted tight leverage control, then asked to “allow slightly higher D/E.” This 2.0 cap reflects that relaxation: it allows more indebted companies than your earlier 1.5/1.0 limits, but still blocks very highly levered names.

10. P/E (TTM) between 16 and 22

    • Purpose: Focus on moderately valued stocks, neither too cheap nor too expensive.
    • Rationale: You asked for “p/e” as a key filter and then to “relax restrictions.” Originally you were around 18–20; now 16–22 is slightly broader but still a tight, valuation-focused band.

11. Price-to-Sales (P/S) between 1.5 and 3.5

    • Purpose: Add a second valuation check that’s less affected by accounting quirks than earnings.
    • Rationale: You also cared about P/S earlier; widening from 2–3 to 1.5–3.5 is another small relaxation while still anchoring on reasonable valuation.

12. No is_optionable filter

    • Purpose: Honor your request to “remove the ‘optionable’ filter.”
    • Rationale: Earlier runs explicitly required is_optionable = True. That constraint has now been removed, so non-optionable stocks are also included. This broadens the universe and matches your latest instruction.

Do the Filters Match Your Request?

• You wanted:
  • Focus on fundamental caps → implemented via caps on gross margin, net margin, ROE, and leverage.
  • Screening by P/E and debt-to-equity → both are central constraints.
  • Relaxed restrictions over time → wider P/E and P/S bands, higher D/E cap, slightly higher fundamental caps.
  • Include mid caps → mid-caps added.
  • Allow slightly higher D/E → D/E increased to 2.0.
  • Remove the optionable filter → is_optionable has been removed.

All requested indicators we can support are in place, and the “optionable” requirement is indeed gone.

Why No Results Were Found

The lack of results is not due to a technical issue; it’s because the combination of filters is very restrictive:

• Overbought RSI + modest valuations (P/E 16–22, P/S 1.5–3.5)
  Names that are “overbought” typically have run up so much that P/E and P/S often move above these tight ranges. You’re asking for up-trending stocks that are still only moderately priced—rare.

• Profitability caps (gross margin, net margin, ROE all capped)
  Many overbought stocks are strong because they are very profitable. Those get excluded by your caps (45% gross margin, 12% net margin, 15% ROE), shrinking the universe further.

• Leverage cap (D/E ≤ 2.0)
  Any of the remaining candidates that are highly levered are ruled out.

• Sector and exchange limits
  Excluding some growth-heavy sectors (notably much of Tech) plus restricting to NYSE/NASDAQ further cuts down the set.

All together, this makes it statistically quite unlikely that any stock fits all conditions at the same time on today’s data—hence, zero matches.

Adjusting the Filters

Would you be willing to relax one or more of these to actually get results? Common adjustments that keep your intent but increase hits:

• Momentum:

  • Remove the overbought RSI requirement, or
  • Change to a broader momentum category (e.g., “bullish” or no RSI filter).

• Valuation:

  • Broaden P/E (e.g., 12–30 or 10–35).
  • Broaden P/S (e.g., 1–5).

• Profitability caps:

  • Increase or remove caps on gross margin, net margin, or ROE so more high-quality names can pass.

• Sectors:

  • Add Technology/IT or other excluded sectors.

• Leverage:

  • If you’re comfortable, allow slightly higher D/E (e.g., 2.5–3.0), or remove the cap and filter by debt afterward.

Tell me which of these you’re most comfortable relaxing (or specify exact new ranges), and I’ll align the screener to that so we can actually surface candidates.