Stocks screener EMA50, Relative volume etc

• 01/01/2025 at 4:05 PM #242034
  MrMagic

  Dear ProRealCode Community,

  Happy New Year. I am looking to have a custom screener, and I would greatly appreciate your expertise. My objective is to identify stocks that meet the following criteria:

   

  1.Price and Volume Parameters:

  •Price closes above the EMA50.

  •Stock price is less than $10.

  •Relative volume is 1.5 or above

  •Total volume is 1 million or above.

   

  2.Technical Indicators:

  •MACD: Should be bullish.

  •Stochastic Oscillator:

  •Preferably about to cross over to bullish.

  •Include scenarios where there is a stochastic is bearish but moving towards bullish.

  •Highlight instances where the bullish crossover has occurred within the last two candles.

   

  I know this is quite a detailed set of criteria, but I would sincerely appreciate your help in creating this screener. Your insights and assistance would mean a lot, and I’m more than happy to provide further clarifications if needed.

   

  Thanks in advance

  

  MrMagic

  Participant

  Topics: 16

  Replies: 36

  Been thanked: 4 times
  01/01/2025 at 5:58 PM #242036
  JS

  Happy New Year.

  Check this first try:

  Screener Stochastics MACD EMA Volume

  // Screener for identifying stocks that meet the following criteria: // - Price closes above EMA50 // - Stock price is less than $10 // - Relative volume ≥ 1.5 // - Total volume ≥ 1 million // - MACD is bullish // - Stochastic Oscillator: // 1. About to cross bullish // 2. Highlight recent bullish crossover (within the last 2 candles) // Define Parameters EMA50 = Average[50,1](Close) // EMA50 RelativeVolume = Volume / Average[50](Volume) StochasticK = Stochastic[14,1](Close) xStochasticD = Average[3](StochasticK) xMACD = MACD[12,26,9](Close) - MACDLine[12,26,9](Close) // Define Conditions c1 = Close > EMA50 // Price closes above EMA50 c2 = Close < 10 // Stock price less than $10 c3 = RelativeVolume >= 1.5 // Relative volume ≥ 1.5 c4 = Volume >= 1000000 // Total volume ≥ 1 million c5 = xMACD > 0 // MACD is bullish // Stochastic Conditions isBullishCross = StochasticK[1] < xStochasticD[1] AND StochasticK > xStochasticD RecentBullishCross = isBullishCross OR (StochasticK[2] < xStochasticD[2] AND StochasticK[1] >= xStochasticD[1]) // Combine All Conditions Filter = c1 AND c2 AND c3 AND c4 AND c5 AND (isBullishCross OR recentBullishCross) // Screener Output SCREENER[Filter](Close AS "Close Price", relativeVolume AS "Rel. Vol.", Volume AS "Total Vol.")

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33

  // Screener for identifying stocks that meet the following criteria: // - Price closes above EMA50 // - Stock price is less than $10 // - Relative volume ≥ 1.5 // - Total volume ≥ 1 million // - MACD is bullish // - Stochastic Oscillator: //     1. About to cross bullish //     2. Highlight recent bullish crossover (within the last 2 candles)   // Define Parameters EMA50 = Average[50,1](Close)  // EMA50 RelativeVolume = Volume / Average[50](Volume) StochasticK = Stochastic[14,1](Close) xStochasticD = Average[3](StochasticK) xMACD = MACD[12,26,9](Close) - MACDLine[12,26,9](Close)   // Define Conditions c1 = Close > EMA50  // Price closes above EMA50 c2 = Close < 10     // Stock price less than $10 c3 = RelativeVolume >= 1.5  // Relative volume ≥ 1.5 c4 = Volume >= 1000000    // Total volume ≥ 1 million c5 = xMACD > 0              // MACD is bullish   // Stochastic Conditions isBullishCross = StochasticK[1] < xStochasticD[1] AND StochasticK > xStochasticD RecentBullishCross = isBullishCross OR (StochasticK[2] < xStochasticD[2] AND StochasticK[1] >= xStochasticD[1])   // Combine All Conditions Filter = c1 AND c2 AND c3 AND c4 AND c5 AND (isBullishCross OR recentBullishCross)   // Screener Output SCREENER[Filter](Close AS "Close Price", relativeVolume AS "Rel. Vol.", Volume AS "Total Vol.")

   

  2 users thanked author for this post.

  robertogozzi, MrMagic

  

  JS

  Participant

  Topics: 27

  Replies: 1795

  Been thanked: 855 times
  01/01/2025 at 7:03 PM #242041
  MrMagic

  Thanks for the screener. It brings up a good number of stocks but MACD remains bearish in some picks.

  

  MrMagic

  Participant

  Topics: 16

  Replies: 36

  Been thanked: 4 times
  01/01/2025 at 7:49 PM #242045
  JS

  Sometimes the differences in a screener are due to not adjusting the data after dividend, do you have this setting correct?

  (see screenshot: Historische data aanpassen)

  

  JS

  Participant

  Topics: 27

  Replies: 1795

  Been thanked: 855 times
  01/02/2025 at 1:42 AM #242060
  MrMagic

  Hi,

  Thanks for the response. Checked and correct. MACD remains bearish despite all settings changed

  

  MrMagic

  Participant

  Topics: 16

  Replies: 36

  Been thanked: 4 times
  01/02/2025 at 3:55 AM #242061
  JS

  Try this version…

  Mr Magic Screener V1.1

  // Screener for identifying stocks that meet the following criteria: // - Price closes above EMA50 // - Stock price is less than $10 // - Relative volume ≥ 1.5 // - Total volume ≥ 1 million // - MACD is bullish // - Stochastic Oscillator: // 1. About to cross bullish // 2. Highlight recent bullish crossover (within the last 2 candles) // Define Parameters EMA50 = Average[50,1](Close) // EMA50 RelativeVolume = Volume / Average[50](Volume) StochasticK = Stochastic[14,1](Close) xStochasticD = Average[3](StochasticK) xMACD = MACD[12,26,9](Close) // Define Conditions c1 = Close > EMA50 // Price closes above EMA50 c2 = Close < 10 // Stock price less than $10 c3 = RelativeVolume >= 1.5 // Relative volume ≥ 1.5 c4 = Volume >= 1000000 // Total volume ≥ 1 million c5 = xMACD > 0 // MACD is bullish // Stochastic Conditions isBullishCross = StochasticK[1] < xStochasticD[1] AND StochasticK > xStochasticD RecentBullishCross = isBullishCross OR (StochasticK[2] < xStochasticD[2] AND StochasticK[1] >= xStochasticD[1]) // Combine All Conditions Filter = c1 AND c2 AND c3 AND c4 AND c5 AND (isBullishCross OR recentBullishCross) // Screener Output SCREENER[Filter](Close AS "Close Price", relativeVolume AS "Rel. Vol.", Volume AS "Total Vol.")

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33

  // Screener for identifying stocks that meet the following criteria: // - Price closes above EMA50 // - Stock price is less than $10 // - Relative volume ≥ 1.5 // - Total volume ≥ 1 million // - MACD is bullish // - Stochastic Oscillator: //     1. About to cross bullish //     2. Highlight recent bullish crossover (within the last 2 candles)   // Define Parameters EMA50 = Average[50,1](Close)  // EMA50 RelativeVolume = Volume / Average[50](Volume) StochasticK = Stochastic[14,1](Close) xStochasticD = Average[3](StochasticK) xMACD = MACD[12,26,9](Close)   // Define Conditions c1 = Close > EMA50  // Price closes above EMA50 c2 = Close < 10     // Stock price less than $10 c3 = RelativeVolume >= 1.5  // Relative volume ≥ 1.5 c4 = Volume >= 1000000    // Total volume ≥ 1 million c5 = xMACD > 0              // MACD is bullish   // Stochastic Conditions isBullishCross = StochasticK[1] < xStochasticD[1] AND StochasticK > xStochasticD RecentBullishCross = isBullishCross OR (StochasticK[2] < xStochasticD[2] AND StochasticK[1] >= xStochasticD[1])   // Combine All Conditions Filter = c1 AND c2 AND c3 AND c4 AND c5 AND (isBullishCross OR recentBullishCross)   // Screener Output SCREENER[Filter](Close AS "Close Price", relativeVolume AS "Rel. Vol.", Volume AS "Total Vol.")

  1 user thanked author for this post.

  MrMagic

  

  JS

  Participant

  Topics: 27

  Replies: 1795

  Been thanked: 855 times
  01/03/2025 at 12:49 PM #242112
  MrMagic

  Hi,

  Thanks. Works very well. Will test it out even more and feedback.

  KR

  1 user thanked author for this post.

  JS

  

  MrMagic

  Participant

  Topics: 16

  Replies: 36

  Been thanked: 4 times
• Author
  Posts