| student 14 posts
 msg #104825
 - Ignore student
 | 2/4/2012 8:02:12 PM 
 I need to rank the stocks by the following : 100 times the ratio of (simple moving average of 10 days) /(simple moving average of 50 days).  I wrote the following, but am not getting the results. Can someone help?  Thanks.
 
 set (ratio, MA(10)/MA(50))
 set (result, ratio*100)
 add column result
 and price is above 1
 and average volume(30) is greater than 500000
 
 
 | 
| 03bsbme 20 posts
 msg #104827
 - Ignore 03bsbme
 | 2/4/2012 8:29:13 PM 
 
 
 
 You need to use { } for the set command rather than ().
 
 
 | 
| Kevin_in_GA 4,599 posts
 msg #104828
 - Ignore Kevin_in_GA
 | 2/4/2012 8:30:46 PM 
 I need to rank the stocks by the following : 100 times the ratio of (simple moving average of 10 days) /(simple moving average of 50 days). I wrote the following, but am not getting the results. Can someone help? Thanks.
 
 set (ratio, MA(10)/MA(50))
 set (result, ratio*100)
 add column result
 and price is above 1
 and average volume(30) is greater than 500000
 
 +++++++++++++++
 
 You need set rmove the space between "set" and replace the parentheses with "{}" instead
 also add
 
 sort on column 5 descending
 
 
 
 
 
 | 
| student 14 posts
 msg #104830
 - Ignore student
 | 2/4/2012 9:24:45 PM 
 Thanks guys for your help.
 
 
 |