Regler
Country = US;
/* Tiered value screen: strict OR balanced OR loose */
/* Tier 1: Strict value + strong insider conviction */
(
Price >= 1 and Price <= 15
and MarketCap >= 10M and MarketCap <= 500M
and SharesFloat < 50M
and InsiderNetBuyerCount > 0
and InsiderBuySellRatio > 1
and InsiderNetBuyerCount > InsiderNetBuyerCount{90d}
and InsiderScore > 60
and PiotroskiScore >= 7
and pe > 0 and pe <= 15
and PriceToBook < 1.2
and CurrentRatio > 1.5
and Volume >= 50000
)
or
/* Tier 2: Balanced value + insider signal */
(
Price >= 0.75 and Price <= 20
and MarketCap >= 5M and MarketCap <= 1B
and SharesFloat < 100M
and InsiderNetBuyerCount >= 0
and InsiderBuySellRatio > 0.9
and InsiderScore > 45
and PiotroskiScore >= 5
and pe > 0 and pe <= 20
and PriceToBook < 1.8
and CurrentRatio > 1.2
and Volume >= 30000
)
or
/* Tier 3: Loose value with insider presence */
(
Price >= 0.5 and Price <= 25
and MarketCap >= 3M and MarketCap <= 2B
and SharesFloat < 200M
and InsiderNetBuyerCount >= 0
and InsiderBuySellRatio > 0.8
and InsiderScore > 30
and PiotroskiScore >= 3
and pe > 0 and pe <= 25
and PriceToBook < 2.5
and CurrentRatio > 1
and Volume >= 20000
);
/* Display helpful columns for review (no filtering) */
InsiderScore;
InsiderNetBuyerCount;
PiotroskiScore;
PriceToBook;
pe;
MarketCap;
/* Result management */
order by InsiderScore desc;
limit 500;
