| Index | Recent Threads | Who's Online | User List | Search |
|
|
 |
Portfolio123 » List all forums » Forum: Screener » Thread: Re: FOrder question |
|
Total posts in this thread: 3 |
[Request a Feature]
[Post new Thread] [Add To My Favorites] [Watch this Thread] |
| Author |
|
|
jfking
Member
|
I am trying to run a screen that selects the top 200 stocks (no otc and above $5) with the highest 1 month % return. From that list I want to select the top 50 stocks based on trading turnover. I have used the following code in the screener but do not seem to be getting a list of 50 stocks for some reason. Is not Over-the-counter (OTC) - True Close(0)>5 Forder("((Close(0) - Close(20))/Close(20))*100",#All,#Desc,#Universe,true)<=200 Forder("(AvgVol(20)/ShsOutMR)*100",#All,#Desc,#Previous,true)<=50 Can anyone help with this issue. My understanding is that the second Forder command using #Previous would give me the top 50 stocks in trading turnover from the previous Forder list. Thanks! |
||
|
|
rharmelink
Advanced Member UNITED STATES Joined: Dec 27, 2006 Posts: 30 Status: Offline |
I would suspect it is because your first FOrder() is basing its selection on the full universe of stocks instead of those that are left from the previous two rules. |
||
|
|
DennyHalwes
Advanced Member UNITED STATES Joined: Apr 28, 2004 Posts: 1530 Status: Offline |
Justin, Try these rules: Universe(NOOTC) Close(0)>5 Forder("Close(0) / Close(20)",#All,#Desc,#Previous,true)<=200 (You don't need to convert the formula to a %, a ratio gives you the same list) Forder("(AvgVol(20)/ShsOutMR)*100",#All,#Desc,#Previous,true)<=50 Denny  ---------------------------------------- "The significant problems we face cannot be solved at the same level of thinking that we were at when we created them". Albert Einstein |
||
|
| [Show Thread Printable Version] [Post new Thread] |
Re: FOrder question
