StockFetcher Forums · Filter Exchange · need help with this--my problem is the set{op, count line<< >>Post Follow-up
hmsb4494
69 posts
msg #143554
Ignore hmsb4494
5/14/2018 7:07:31 PM

when I run this as is I get x number of matches

when I replace the 1.0 in the set{op, count > 1.0, 14} with dt where dt is set{dt, 1.0} I get a different number of matches.

what am I missing???



Fetcher[
show stocks where price is between 1 and 25

set{r, volume(20)}
set{PRxAV, close * r}
add column PRxAV {liquidity}
add column separator


set{a, high - close 1 day ago}
set{b, a / close 1 day ago}
set{c, b * 100}
add column a {dollar gain opportunity}
add column c {percentage gain opportunity}
add column separator
set{dt, 1.0}
set{op, count(c > 1.0, 14)}/*why does replacing 1.0 with "dt" from line above change results?*/
add column op {how many times out of 14 dollar gain hit desired input}
op > 13

sort on column 2 ascending
PRxAV > 1000000

do not draw prxav
do not draw op
]



four
5,087 posts
msg #143594
Ignore four
modified
5/17/2018 7:31:07 PM

changed the variable names | removed decimal place. how does it work? filter below...

Fetcher[

show stocks where price is between 1 and 25

set{r, volume(20)}
set{PRxAV, close * r}
add column PRxAV {liquidity}
add column separator

set{a, high - close 1 day ago}
set{b, a / close 1 day ago}
set{c, b * 100}
add column a {dollar gain opportunity}
add column c {percentage gain opportunity}
add column separator
set{dzt, 1}
set{opn, count(c > dzt, 14)}/*why does replacing 1.0 with dt from line above change results?*/
add column op {how many times out of 14 dollar gain hit desired input}
op > 13
add column dzt
add column opn
sort on column 2 ascending
PRxAV > 1000000

do not draw prxav
do not draw op
]



hmsb4494
69 posts
msg #143617
Ignore hmsb4494
5/21/2018 1:10:41 AM

Thsnks four. Works grest. Dt must be something that is reserved by sf.

four
5,087 posts
msg #143624
Ignore four
5/21/2018 7:09:51 PM

welcome

StockFetcher Forums · Filter Exchange · need help with this--my problem is the set{op, count line<< >>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 2018 - 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