Prosceener Help Required

• 04/11/2017 at 1:19 PM #31718
  Raman

  Hi everyone,

  I am new to PRT and am trying to create a US stock screener (for example on Nasdaq) where I want to screen stocks based on the following conditions. I would like screener to show a list of stocks with following values. can you please help me creating this scan:

  1. Stocks with price close > 5
  2. Average Volume over the last 10 days > 1000000
  3. Price close > 50 day moving average
  4. % change over last 250 days i.e. (Close – Close[250]) / Close[250]

  Thanks for your help in advance.

  Cheers, Raman

   

   

  

  Raman

  Participant

  Topics: 1

  Replies: 4

  Been thanked: 0 times
  04/11/2017 at 6:27 PM #31758
  Nicolas

  Is the point 4 a condition or the sorting criteria?

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20830

  Been thanked: 4744 times
  04/11/2017 at 10:37 PM #31798
  Raman

  Hi Nicolas,

  Thanks a lot for your help.

  The fourth point is a sorting criteria. Basically I would like to see the following:

  Assuming there are approx 100 stocks in Nasdaq, I would like to see stocks with value over $5 and average volume (over the last 10 days) over 1 million and stock price to be above it 50 day average and then sort top 50 stocks based on their % change over 250 days ( 1 year).

  I hope above helps.

  Pl let me know if you would like any more information.

  Cheers

   

  

  Raman

  Participant

  Topics: 1

  Replies: 4

  Been thanked: 0 times
  04/12/2017 at 9:05 AM #31821
  Nicolas

  Thanks for the complete explanation, this stock screener code should do what you are looking for:

  //Stocks with price close > 5 //Average Volume over the last 10 days > 1000000 //Price close > 50 day moving average c1 = close>5 c2 = average[10](volume)>1000000 c3 = close>average[50] screener[c1 and c2 and c3] ((Close - Close[250]) / Close[250])

  1 2 3 4 5 6 7 8 9

  //Stocks with price close > 5 //Average Volume over the last 10 days > 1000000 //Price close > 50 day moving average   c1 = close>5 c2 = average[10](volume)>1000000 c3 = close>average[50]   screener[c1 and c2 and c3] ((Close - Close[250]) / Close[250])

   

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20830

  Been thanked: 4744 times
  04/14/2017 at 4:13 AM #32003
  Raman

  Thanks a lot Nicolas. I will try it today and may add another sorting criteria.

  Great help!

  Cheers

  

  Raman

  Participant

  Topics: 1

  Replies: 4

  Been thanked: 0 times
  04/19/2017 at 12:40 PM #32580
  Raman

  Hi Nicolas,

  Can you please also add percentage change over the last 120 days. By this I mean, I would like to see 120 day percentage change of these top 50 stocks (sorted based on 250 days change) ?

  Thanks in advance.

  Cheers, Raman

  

  Raman

  Participant

  Topics: 1

  Replies: 4

  Been thanked: 0 times
  04/19/2017 at 1:36 PM #32598
  Nicolas

  As a new condition? Because it is not possible to add a second sorting criteria!

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20830

  Been thanked: 4744 times
  04/19/2017 at 1:43 PM #32600
  Raman

  Yes pl, as a new condition.

  

  Raman

  Participant

  Topics: 1

  Replies: 4

  Been thanked: 0 times
  04/19/2017 at 1:48 PM #32603
  Nicolas

  So if this is a new condition, please describe it! Because “percentage change over the last 120 days” is not a condition! 🙂

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20830

  Been thanked: 4744 times
• Author
  Posts