Find Stocks who move less then x% in the last few days

• 07/05/2020 at 10:12 AM #138438
  Enjeru

  Hi,

  I try to screen for stocks who move less than x% each day.

  I tried the following:

  CL = Close CL1 = Close [1] Perc1 = CL/CL1*100-100 //(I also tried CL1/CL) Con1 = Perc1 <= 3 SCREENER[Con1]

  1 2 3 4 5

  CL = Close CL1 = Close [1] Perc1 = CL/CL1*100-100 //(I also tried CL1/CL) Con1 = Perc1 <= 3 SCREENER[Con1]

   

  I still get stocks that moved 4% for example,

  Thx for the help 🙂

  

  Enjeru

  Participant

  Topics: 1

  Replies: 3

  Been thanked: 0 times
  07/05/2020 at 10:51 AM #138444
  Vonasi

  Try this (not tested):

  CL = Close CL1 = Close[1] Perc1 = (((max(CL,CL1)/(min(CL,CL1))*100)-100 Con1 = Perc1 <= 3 SCREENER[Con1]

  1 2 3 4 5

  CL = Close CL1 = Close[1] Perc1 = (((max(CL,CL1)/(min(CL,CL1))*100)-100 Con1 = Perc1 <= 3 SCREENER[Con1]

  Please re-read the forum rules before posting again and always use the ‘Insert PRT Code’ button when posting code. I will edit and tidy up your post.

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1811 times
  07/05/2020 at 11:04 AM #138445
  Enjeru

  Hi,

  First of all, thank you very much.

  I tried but I keep getting an error on this line:

  Perc1 = (((max(CL,CL1)/(min(CL,CL1))*100)-100

  1	Perc1 = (((max(CL,CL1)/(min(CL,CL1))*100)-100

  “Syntx error: line 3, character 43

  Please complete the syntax of this line.”

  Thx alot.

  

  Enjeru

  Participant

  Topics: 1

  Replies: 3

  Been thanked: 0 times
  07/05/2020 at 2:52 PM #138467
  Enjeru

  Hi,

  Fixed it, was missing a )) at the end.

  Thank you very much.

  

  Enjeru

  Participant

  Topics: 1

  Replies: 3

  Been thanked: 0 times
  07/05/2020 at 3:00 PM #138468
  Vonasi

  Sorry – unequal amount of ()

  Change it to:

  Perc1 = ((max(CL,CL1)/min(CL,CL1))*100) -100

  1	Perc1 = ((max(CL,CL1)/min(CL,CL1))*100) -100

   

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1811 times
  07/05/2020 at 3:54 PM #138472
  Vonasi

  I think my head has been out in the Greek sun too much! This is the calculation you should be using:

  Perc1 = ((abs(close-open)/open)*100)

  1	Perc1 = ((abs(close-open)/open)*100)

   

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1811 times
  07/05/2020 at 4:41 PM #138479
  Enjeru

  Perc1 = ((abs(close-open)/open)*100)

  1	Perc1 = ((abs(close-open)/open)*100)

  Doesn’t work.

  Shouldn’t I compare the closing of the last two candles?

  

  Enjeru

  Participant

  Topics: 1

  Replies: 3

  Been thanked: 0 times
  07/05/2020 at 5:35 PM #138481
  Vonasi

  If you want to include any gaps then just change OPEN to CLOSE[1]

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1811 times
• Author
  Posts