Daily averages and stoch

• 06/07/2023 at 4:49 PM #215772
  marco7630

  Hi,

  Can you help me with following.

  I would like to see on a daily timeframe all the assets that meet the following requirements:

  1. The SMA3, SMA6, SMA9 and EMA20 are ALL green (positive) on the current day candle
  2. At least one of the above SMA’s was red (negative) yesterday
  3. The stoch RSI14 should be above 80 on the current candle OR it should be greater than 50 and increased by at least 25 compared to yesterday
  4. The average daily volume over last 7 days has to be above 1 million
  5. The price needs to be above 10 usd
  6. The bolinger bandwidth (20 2) needs to be above 0.1

  Thanks

  gr Marco

  

  marco7630

  Participant

  Topics: 47

  Replies: 109

  Been thanked: 17 times
  06/07/2023 at 6:55 PM #215777
  JC_Bywan

  Hello,

  To be tested:

  sma3 = Average[3](close) sma6 = Average[6](close) sma9 = Average[9](close) ema20= ExponentialAverage[20](close) myRSI = RSI[14](close) MinRSI = lowest[14](myrsi) MaxRSI = highest[14](myrsi) StochRSI = (myRSI-MinRSI)/(MaxRSI-MinRSI) StochRSIK = average[3](StochRSI)*100 c1 = sma3>=sma3[1] and sma6>=sma6[1] and sma9>=sma9[1] and ema20>=ema20[1] c2 = sma3[1]<sma3[2] or sma6[1]<sma6[2] or sma9[1]<sma9[2] c3 = StochRSIK>80 or (StochRSIK>50 and (StochRSIK-StochRSIK[1])>25) c4 = Average[7](volume)>1000000 c5 = close>10 c6 = BollingerBandWidth[20](close)>0.1 condition = c1 AND c2 AND c3 AND c4 AND c5 AND c6 SCREENER[condition]

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

  sma3 = Average[3](close) sma6 = Average[6](close) sma9 = Average[9](close) ema20= ExponentialAverage[20](close)   myRSI = RSI[14](close) MinRSI = lowest[14](myrsi) MaxRSI = highest[14](myrsi) StochRSI = (myRSI-MinRSI)/(MaxRSI-MinRSI) StochRSIK = average[3](StochRSI)*100   c1 = sma3>=sma3[1] and sma6>=sma6[1] and sma9>=sma9[1] and ema20>=ema20[1] c2 = sma3[1]<sma3[2] or sma6[1]<sma6[2] or sma9[1]<sma9[2] c3 = StochRSIK>80 or (StochRSIK>50 and (StochRSIK-StochRSIK[1])>25) c4 = Average[7](volume)>1000000 c5 = close>10 c6 = BollingerBandWidth[20](close)>0.1   condition = c1 AND c2 AND c3 AND c4 AND c5 AND c6   SCREENER[condition]

   

   

  

  JC_Bywan

  Moderator

  Topics: 20

  Replies: 2657

  Been thanked: 925 times
  06/08/2023 at 6:09 AM #215812
  JC_Bywan

  I forgot to add I took a smoothing of 3 for your stoch rsi as you only specified a length of 14. If you want a smoothing of 5 for example, it needs to be applied in line 10 as replacement of the [3]:

  StochRSIK = average[5](StochRSI)*100

  

  JC_Bywan

  Moderator

  Topics: 20

  Replies: 2657

  Been thanked: 925 times
  06/08/2023 at 7:48 AM #215815
  marco7630

  Thanks JC

  

  marco7630

  Participant

  Topics: 47

  Replies: 109

  Been thanked: 17 times
  06/10/2023 at 4:53 PM #215954
  marco7630

  Hi JC,

   

  Could you change the code so it fits the following:

  Hi,

  Can you help me with following.

  I would like to see on a daily timeframe all the assets that meet the following requirements:

  The SMA3, SMA6 and EMA20 are ALL green (positive) on the current day candle

  At least one of the above SMA’s was red (negative) yesterday

  The stoch RSI14 should have increased by at least 25 compared to yesterday

  The average daily volume over last 7 days has to be above 1 million

  The price needs to be above 10 usd

  The bolinger bandwidth (20 2) needs to be above 0.1

   

  Thanks for all the great work you are doing. If i can place a great review for you somewhere i am happy to do it.

  gr Marco

  

  marco7630

  Participant

  Topics: 47

  Replies: 109

  Been thanked: 17 times
  06/11/2023 at 5:36 PM #215972
  JC_Bywan

  Hi, thanks,

  OK, so in summary if I have spotted all the differences: getting rid of sma9 (impact c1 and c2), and a more simple stoch rsi14 condition (impact c3). It would give the following:

  sma3 = Average[3](close) sma6 = Average[6](close) ema20= ExponentialAverage[20](close) myRSI = RSI[14](close) MinRSI = lowest[14](myrsi) MaxRSI = highest[14](myrsi) StochRSI = (myRSI-MinRSI)/(MaxRSI-MinRSI) StochRSIK = average[3](StochRSI)*100 c1 = sma3>=sma3[1] and sma6>=sma6[1] and ema20>=ema20[1] c2 = sma3[1]<sma3[2] or sma6[1]<sma6[2] c3 = StochRSIK-StochRSIK[1])>25 c4 = Average[7](volume)>1000000 c5 = close>10 c6 = BollingerBandWidth[20](close)>0.1 condition = c1 AND c2 AND c3 AND c4 AND c5 AND c6 SCREENER[condition]

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

  sma3 = Average[3](close) sma6 = Average[6](close) ema20= ExponentialAverage[20](close)   myRSI = RSI[14](close) MinRSI = lowest[14](myrsi) MaxRSI = highest[14](myrsi) StochRSI = (myRSI-MinRSI)/(MaxRSI-MinRSI) StochRSIK = average[3](StochRSI)*100   c1 = sma3>=sma3[1] and sma6>=sma6[1] and ema20>=ema20[1] c2 = sma3[1]<sma3[2] or sma6[1]<sma6[2] c3 = StochRSIK-StochRSIK[1])>25 c4 = Average[7](volume)>1000000 c5 = close>10 c6 = BollingerBandWidth[20](close)>0.1   condition = c1 AND c2 AND c3 AND c4 AND c5 AND c6   SCREENER[condition]

   

   

  

  JC_Bywan

  Moderator

  Topics: 20

  Replies: 2657

  Been thanked: 925 times
  06/12/2023 at 3:14 PM #216006
  marco7630

  Hi JC,

   

  I get the message in attachment.

   

  gr Marco

  

  marco7630

  Participant

  Topics: 47

  Replies: 109

  Been thanked: 17 times
  06/12/2023 at 3:26 PM #216008
  marco7630

  already solved it:-)

   

  

  marco7630

  Participant

  Topics: 47

  Replies: 109

  Been thanked: 17 times
  06/12/2023 at 4:14 PM #216013
  JC_Bywan

  Sorry, yes the closing bracket ) should have been deleted and line 13 should have been:

  c3 = StochRSIK–StochRSIK[1]>25

  

  JC_Bywan

  Moderator

  Topics: 20

  Replies: 2657

  Been thanked: 925 times
  06/12/2023 at 4:55 PM #216017
  marco7630

  Hi JC,

   

  It does not seem to work. Take stock: LSCC as an example. Stoch has increased by more than 30 points compared to yesterday and all the SMA’s are green. However, it does not come up in screener.

   

  gr Marco

  

  marco7630

  Participant

  Topics: 47

  Replies: 109

  Been thanked: 17 times
  06/12/2023 at 5:11 PM #216019
  JC_Bywan

  Free end of day account?

  

  JC_Bywan

  Moderator

  Topics: 20

  Replies: 2657

  Been thanked: 925 times
  06/12/2023 at 7:59 PM #216025
  marco7630

  Sorry, do not understand you

   

  

  marco7630

  Participant

  Topics: 47

  Replies: 109

  Been thanked: 17 times
  06/12/2023 at 8:57 PM #216032
  JC_Bywan

  If your PRT account is free, with only daily or above TF, your screener is not “real time”, today’s data is only available from next session’s open, so usually when someone is asking for a screener on daily timeframe and a stock seems to not match in scrrener behaviour observed on today’s chart, first thing to check is the account type: free with a one session delay for screener results, or real-time.

  

  JC_Bywan

  Moderator

  Topics: 20

  Replies: 2657

  Been thanked: 925 times
  06/13/2023 at 1:06 PM #216113
  marco7630

  Hi JC,

   

  What line of code do i need to add if i only want to see the following assets:

  • The ATR percentage (ATR/Closing Price) needs to be between 3 and 5%

   

  gr Marco

  

  marco7630

  Participant

  Topics: 47

  Replies: 109

  Been thanked: 17 times
  06/13/2023 at 1:34 PM #216114
  marco7630

  I have a realtime account by the way

  

  marco7630

  Participant

  Topics: 47

  Replies: 109

  Been thanked: 17 times
• Author
  Posts