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.
