StockFetcher Forums · General Discussion · Count - doesn´t work<< >>Post Follow-up
zion
8 posts
msg #143436
Ignore zion
modified
5/3/2018 12:32:53 PM

Hello!
I´m unable to costruct the following filter properly:

count
(close < lower bollinger band (20,2) and open < lower bollinger band (20,2) and open < close and add column relative strength(^ixic,100) and sort column 5 descending and draw relative strength(^ixic,100) and add column average volume(90)
,20)

Could somebody please help me out?

Thanks!
zion


mahkoh
1,065 posts
msg #143439
Ignore mahkoh
5/3/2018 3:27:24 PM

You need to make different variables for each requirement and sum them.

zion
8 posts
msg #143458
Ignore zion
5/5/2018 12:29:39 PM

Thanks mahkoh, but I don´t get it.
What´s wrong with the following phrase:

set{zahl1, close < lower bollinger band (20,1)}
set{zahl2, open < lower bollinger band (20,1)}
set{sum, zahl1 and zahl2}
add column count(sum, 20) > 0



four
5,087 posts
msg #143459
Ignore four
modified
5/5/2018 1:19:17 PM

zion,

Please take a look at the guide https://www3.stockfetcher.com/download/sfuserguide2_0.pdf

You will see the commands you are using are basically correct; however, the formatting is not.
COUNT, p124
SUM, p136
SET, p138

Specifically, for one item in your filter, you are missing COUNT on both lines:
 set{zahl1, close < lower bollinger band (20,1)}
 set{zahl2, open < lower bollinger band (20,1)}

See this example for COUNT:
 set{var1, count(rsi(14) is below 30, 45)}
 set{var2, count(rsi(14) is above 70, 45)}
 set{sum1, var1 + var2}

StockFetcher Forums · General Discussion · Count - doesn´t work<< >>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.