Prosceener Help Required

Viewing 9 posts - 1 through 9 (of 9 total)

Author

Posts
04/11/2017 at 1:19 PM #31718 quote
Raman
Participant

New
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
04/11/2017 at 6:27 PM #31758 quote

Nicolas
Keymaster

Legend

Is the point 4 a condition or the sorting criteria?

04/11/2017 at 10:37 PM #31798 quote

Raman
Participant

New

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

04/12/2017 at 9:05 AM #31821 quote
Nicolas
Keymaster

Legend
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])
```
04/14/2017 at 4:13 AM #32003 quote

Raman
Participant

New

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

Great help!

Cheers

04/19/2017 at 12:40 PM #32580 quote

Raman
Participant

New

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

04/19/2017 at 1:36 PM #32598 quote

Nicolas
Keymaster

Legend

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

04/19/2017 at 1:43 PM #32600 quote

Raman
Participant

New

Yes pl, as a new condition.

04/19/2017 at 1:48 PM #32603 quote

Nicolas
Keymaster

Legend

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

Posts