Stocks above/below opening prices

• 07/06/2020 at 3:14 PM #138564
  revstrat

  Hi all,

  I have been trying to make this work for over a month and bashing my head until I’ve just decided to ask for help. I would like to screen for stocks that are trading above/below opening prices for the Hour, Day, Week, Month, Quarter and Year. The most I have been able to do is create an indicator that plots all the opening prices after filtering out stocks above/below daily and weekly opening prices and then manually looking at the closing price relative to the others using the indicator.

  Screener for stocks above/below Daily & Weekly Opening Prices

  // The following code is related to this timescale:daily TIMEFRAME(daily) c1 = (close < open) // The following code is related to this timescale:weekly TIMEFRAME(weekly) c2 = (close < open) // The following code is related to this timescale:1 hour //TIMEFRAME(1 hour) //c3 = (close < open) // The following code is related to this timescale:daily TIMEFRAME(daily) c4 = (close > 0.2) // The following code is related to this timescale:daily TIMEFRAME(daily) criteria = volume c5 = volume > 300 // The following code is related to this timescale:DEFAULT TIMEFRAME(DEFAULT) SCREENER[c1 AND c2 AND c4 AND c5](criteria AS "Volume")

  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

  // The following code is related to this timescale:daily TIMEFRAME(daily) c1 = (close < open)   // The following code is related to this timescale:weekly TIMEFRAME(weekly) c2 = (close < open)   // The following code is related to this timescale:1 hour //TIMEFRAME(1 hour) //c3 = (close < open)   // The following code is related to this timescale:daily TIMEFRAME(daily) c4 = (close > 0.2)   // The following code is related to this timescale:daily TIMEFRAME(daily) criteria = volume c5 = volume > 300   // The following code is related to this timescale:DEFAULT TIMEFRAME(DEFAULT)   SCREENER[c1 AND c2 AND c4 AND c5](criteria AS "Volume")

  I have tried using the “Insert Function” to call the indicator but the screener never picks up any of the values. I tested with ONLY the Yearly Open and the screen isn’t able to get that value. Below is the code for the indicator.

  Opening Prices Indicator

  //defparam drawonlastbaronly = true if openyear <> openyear[1] then //yearly yearindex = yearindex + 1 //yearhigh = 0 //yearlow = close yearopen = open //yearclose = close endif if openmonth <> openmonth[1] and (openmonth = 1 or openmonth = 4 or openmonth = 7 or openmonth = 10) then //quarterly quarterindex = quarterindex + 1 //quarterhigh = 0 //quarterlow = close quarteropen = open //quarterclose = close endif if openmonth <> openmonth[1] then //monthly monthindex = monthindex + 1 //monthhigh = 0 //monthlow = close monthopen = open //monthclose = close endif if opendayofweek < opendayofweek[1] then //weekly weekindex = weekindex + 1 //weekhigh = 0 //weeklow = close weekopen = open //weekclose = close endif if openday <> openday[1] then //daily dayindex = dayindex + 1 //dayhigh = 0 //daylow = close dayopen = open //dayclose = close endif if dayindex < 1 then dayopen = undefined endif if weekindex < 1 then weekopen = undefined endif return yearopen as "Year Open", monthopen as "Month Open", quarteropen as "Quarter Open", weekopen as "Week Open", dayopen coloured(100,149,237) as "Day Open", close coloured(255,128,0) as "Last"

  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 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51

  //defparam drawonlastbaronly = true   if openyear <> openyear[1] then //yearly yearindex = yearindex + 1 //yearhigh = 0 //yearlow = close yearopen = open //yearclose = close endif   if openmonth <> openmonth[1] and (openmonth = 1 or openmonth = 4 or openmonth = 7 or openmonth = 10) then                              //quarterly quarterindex = quarterindex + 1 //quarterhigh = 0 //quarterlow = close quarteropen = open //quarterclose = close endif   if openmonth <> openmonth[1] then //monthly monthindex = monthindex + 1 //monthhigh = 0 //monthlow = close monthopen = open //monthclose = close endif   if opendayofweek < opendayofweek[1] then //weekly weekindex = weekindex + 1 //weekhigh = 0 //weeklow = close weekopen = open //weekclose = close endif   if openday <> openday[1] then //daily dayindex = dayindex + 1 //dayhigh = 0 //daylow = close dayopen = open //dayclose = close endif   if dayindex < 1 then dayopen = undefined endif   if weekindex < 1 then weekopen = undefined endif   return yearopen as "Year Open", monthopen as "Month Open", quarteropen as "Quarter Open", weekopen as "Week Open", dayopen coloured(100,149,237) as "Day Open", close coloured(255,128,0) as "Last"

  Can someone please help me out and/or suggest some tips? It would be greatly appreciated. Thank you.

  

  revstrat

  Participant

  Topics: 4

  Replies: 9

  Been thanked: 1 time
  07/07/2020 at 7:40 AM #138605
  Nicolas

  You should group all the same timeframe code below the same TIMEFRAME instruction.

  The indicator doesn’t return anything because it uses instructions not compatible with ProScreener (all instructions that begin with Open: OpenWeek, ..).

  To get the monthly Close try this (in daily imeframe):

  If Month<>Month[1] then monthlyClose = Close[1] endif

  1 2 3

  If Month<>Month[1] then monthlyClose = Close[1] endif

  Quarterly Close price, example in this code snippet (uses to get the quarterly pivot point): https://www.prorealcode.com/topic/formule-points-pivots-quarterly/#post-51188

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20864

  Been thanked: 4777 times
  07/08/2020 at 12:30 PM #138736
  revstrat

  Thank you so much Nicolas. Works like a charm.

  

  revstrat

  Participant

  Topics: 4

  Replies: 9

  Been thanked: 1 time
• Author
  Posts