StockFetcher Forums · Filter Exchange · Filter help<< >>Post Follow-up
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

Fetcher[
set {ratio, MA(10)/MA(50)}
set {result, ratio*100}
add column MA(10)
add column MA(50)
add column result
sort by column 7 descending
and price is above 1
and average volume(30) is greater than 500000
]



You need to use { } for the set command rather than ().

Kevin_in_GA
4,553 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

Fetcher[

set{ratio, MA(10)/MA(50)}
set{result, ratio*100}
add column result
sort on column 5 descending
and price is above 1
and average volume(30) is greater than 500000
]



student
14 posts
msg #104830
Ignore student
2/4/2012 9:24:45 PM

Thanks guys for your help.

StockFetcher Forums · Filter Exchange · Filter help<< >>Post Follow-up

*** Disclaimer *** StockFetcher.com does not endorse or suggest any of the securities which are returned in any of the searches or filters. They are provided purely for informational and research purposes. StockFetcher.com does not recommend particular securities. StockFetcher.com, Vestyl Software, L.L.C. and involved content providers shall not be liable for any errors or delays in the content, or for any actions taken based on the content.


Copyright 2016 - Vestyl Software L.L.C.Terms of Service | License | Questions or comments? Contact Us
EOD Data sources: DDFPlus & CSI Data Quotes delayed during active market hours. Delay times are at least 15 mins for NASDAQ, 20 mins for NYSE and Amex. Delayed intraday data provided by DDFPlus