Price moving above moving average from below

• 05/15/2021 at 2:17 AM #169721
  samd

  I was wondering how you would write a simple screener to find stocks that are crossing the 20 simple moving average from below with an average(last 50 days) daily volume of over 200k shares per day.

  

  samd

  Participant

  Topics: 6

  Replies: 6

  Been thanked: 0 times
  05/15/2021 at 4:25 AM #169723
  robertogozzi

  There you go:

  Timeframe(Daily) MyVol = average[50,0](volume) >200000 Timeframe(default) Sma20 = close CROSSES OVER average[20,0](close) Cond = MyVol AND Sma20 Screener[Cond]

  1 2 3 4 5 6

  Timeframe(Daily) MyVol = average[50,0](volume) >200000 Timeframe(default) Sma20 = close CROSSES OVER average[20,0](close) Cond = MyVol AND Sma20 Screener[Cond]

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 16510

  Been thanked: 3662 times
  05/15/2021 at 10:02 AM #169729
  samd

  That’s awesome Roberto, thank you! I was wondering can you set the date to check for example April 1st 2021 the stocks moving above the 20 day moving average?

  

  samd

  Participant

  Topics: 6

  Replies: 6

  Been thanked: 0 times
  05/15/2021 at 11:31 AM #169735
  robertogozzi

  Yes, but since ProScreener scans markets live, we have to check some days ago, from now up to April 21st. I used 30 to make sure it’s enough.

  There you go:

  Timeframe(Daily) MyVol = average[50,0](volume) >200000 Timeframe(default) Sma20 = 0 IF Date = 20210421 THEN Sma20 = close CROSSES OVER average[20,0](close) endif Cond = summation[30](MyVol AND Sma20) //scan within the last 30 bars Screener[Cond]

  1 2 3 4 5 6 7 8 9

  Timeframe(Daily) MyVol = average[50,0](volume) >200000 Timeframe(default) Sma20 = 0 IF Date = 20210421 THEN    Sma20 = close CROSSES OVER average[20,0](close) endif Cond  = summation[30](MyVol AND Sma20)       //scan within the last 30 bars Screener[Cond]

   

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 16510

  Been thanked: 3662 times
  05/15/2021 at 11:43 AM #169737
  samd

  Thank you again for the quick reply. Just wondering how far back can I go? If I wanted to see one year ago from Friday if I change the 30 to 370 and in the if statement I changed the date to 20200421 would it work? Sorry to keep bothering you.

  

  samd

  Participant

  Topics: 6

  Replies: 6

  Been thanked: 0 times
  05/15/2021 at 12:57 PM #169744
  robertogozzi

  ProScreener has a 254-bar limit (less 5o required by the average makes it a 204-bar lookback).

   

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 16510

  Been thanked: 3662 times
• Author
  Posts