StockFetcher Forums · General Discussion · Simple Q: How to create an individual symbol as a filter (not used as a comparison)<< >>Post Follow-up
whirl
11 posts
msg #110222
Ignore whirl
1/16/2013 12:40:13 AM

Is there a way stockfetcher can create a scan that uses another symbol as a filter? The individual symbol feature I see on stockfetcher seems to only do comparison. But I want it stand alone by itself.

For example, if I wanted to create something symbol like,

Show stocks when the SPY is above MA(200) and
show stocks when RSI(14) is below 20



This way, the scan will only show symbols if the spy is above its 200ma. I want to build something off a bunch of filters that can reference a symbol or index.



four
5,087 posts
msg #110225
Ignore four
1/16/2013 6:26:00 AM


Fetcher[

set{spc, ind(spy,close)}
set{x, count(spc > cma(spc,200),1)}

add column x equals 1
RSI(14) is below 20
draw cma(spc,200)

close > 1
avgvol(2) > 123123


]



whirl
11 posts
msg #110257
Ignore whirl
1/16/2013 12:51:15 PM

thank you. wow I was hoping there would have been something simpler built in.
perhaps something for SF to work on in the future?

stockfetcher
980 posts
msg #110258
1/16/2013 1:20:46 PM

The previous example is correct, but here is another take:

Fetcher[
ind(SPY,close) is above ind(SPY,MA(200))
and RSI(14) is below 20
]



If that does not do what you are looking for, please let us know.

StockFetcher Support

whirl
11 posts
msg #110261
Ignore whirl
1/16/2013 3:25:55 PM

thank you, will try that too

StockFetcher Forums · General Discussion · Simple Q: How to create an individual symbol as a filter (not used as a comparison)<< >>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 2022 - 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


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.