StockFetcher Forums · General Discussion · Filter not working<< >>Post Follow-up
jjmcguire
4 posts
msg #157567
Ignore jjmcguire
9/12/2021 2:45:51 PM

Can someone please let me know why my filter show stocks where rsi71 = 0 doesn't work correctly? When rsi71 has a value of 1 in the table, I still get a record returned even though I have "show stocks where rsi71 = 0"

Fetcher[apply to symlist(ORGN)

Set{rsi71, count( rsi(7) > 50 ,1)}
add column rsi(7)
add column rsi71
draw rsi71
show stocks where rsi71 = 0

chart-time is 3 months

date offset 13
]



Thanks,
Jason

snappyfrog
415 posts
msg #157568
Ignore snappyfrog
modified
9/12/2021 2:58:40 PM

Run this and go back 1 day.

Fetcher[
apply to symlist(ORGN)

Set{rsi71, count( rsi(7) > 50 ,1)}
add column rsi(7)
add column rsi71
draw rsi71 < .99
/*show stocks where rsi71 = 0 */

chart-time is 3 months

date offset 13
]



jjmcguire
4 posts
msg #157570
Ignore jjmcguire
9/12/2021 3:18:11 PM

Thanks Snappy! It is now working. I thought that Count returned only integers but apparently not.


snappyfrog
415 posts
msg #157571
Ignore snappyfrog
9/12/2021 3:28:24 PM

" I thought that Count returned only integers but apparently not."

It does return integers, so I set it to less than 1 (.99) so as not to show anything above 0.

nibor100
818 posts
msg #157583
Ignore nibor100
9/14/2021 12:07:29 PM

I believe you guys have run into one of SF’s occasional anomalies between math symbols and English text.

If you change this line

show stocks where rsi71 = 0

To this

show stocks where rsi71 equals 0

I believe it will work as expected

Ed S.

snappyfrog
415 posts
msg #157585
Ignore snappyfrog
9/14/2021 12:21:48 PM

nibor100, you are correct again.

StockFetcher Forums · General Discussion · Filter not working<< >>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 2021 - 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.