StockFetcher Forums · Filter Exchange · Need help with this<< >>Post Follow-up
Mansor
78 posts
msg #152020
Ignore Mansor
5/2/2020 9:22:25 AM

Can anyone correct (or make it work) the filter below, it's combination of many filters combined together that's gone haywire - thanks in advance


average volume(90) above 100000
average volume(10) above 500000
Average Volume(30) above 250000
offset is 0
draw IFT(5,9) and draw IFT(5,9) line at 0
and draw IFT(5,9) line at -.90
add column IFT(5,9)
IFT(5,9) < 0.80
add column separator
set{slope_incr, days(slope IFT(5,9) < slope of IFT(5,9) 1 day ago, 30)}
draw slope_incr
set{slope_pos, days(slope of IFT(5,9) < 0, 30)}
draw slope_pos
set{sort, slope_pos + slope_incr}
set{volcnt, count(volume above 100000, 100) }
set{volzero, count(volume equal 0, 100) }
set{x1, high - open}
set{Long_Profit, x1/open }
set{C1A, count(Long_Profit > .04 , 100)}
set{C2A, count(Long_Profit > .09, 100)}
set{C0010, C1A - C2A}
set{D1A, count(Long_Profit > .09 , 100)}
set{D2A, count(Long_Profit > .19, 100)}
set{D1020, D1A - D2A}
set{E1A, count(Long_Profit > .19 , 100)}
set{E2A, count(Long_Profit > .29, 100)}
set{E2030, E1A - E2A}
set{F1A, count(Long_Profit > .29 , 100)}
set{F2A, count(Long_Profit > .39, 100)}
set{F3040, F1A - F2A}
set{G1A, count(Long_Profit > .39 , 100)}
and add column daychg2
and add column C0010 {4_9}
and add column D1020 {10_19}
and add column E2030 {20_29}
and add column F3040 {30_39}
and add column G1A {40+}
and add column C1A {ttl}
and add column average day range(10) {adr10}
and add column average day range(30) {adr30}
sort column 6 descending
add column industry
add column sector
set{answer, count(ROC(5,1) above 5, 100)}
and add column answer
add column open-to-close gap
add column separator
draw WAIT
draw SELL
draw BUY
draw ema(13)
draw dma(25,-5)
draw ema(50)
add column BUY
add column SELL
add column WAIT
add column both{D2/T3}
add column both2{TSI6}
ADD COLUMN XOVER
ADD COLUMN CROSS
set{OVER, count(TSI(6,3,3) crossed above 0,1) *1}
set{UNDER, count(TSI(6,3,3) crossed below 0,1) * -1}
set{both2, OVER + UNDER}
set{CROSS, 1 - count(both2 equals 0,1)}
CROSS above 0
set{var1, 2 * EMA(9)}
set{var2, cema(ema(9),9)}
set{DEMA, var1 - var2}
set{TEMA, T3(7,1)}
set{xUP, count(DEMA crossed above TEMA,1) *1}
set{xDOWN, count(DEMA crossed below TEMA,1) * -1}
set{both, xUP + xDOWN}
set{xOVER, 1 - count(both equals 0,1)}
add column separator
set{pp_3, CeMA(pp,3) 1 day ago}
set{r_3, CeMA(r1,3) 1 day ago}
set{s_3, CeMA(s1,3) 1 day ago}
set{VAR3, count(close above pp_3,1)}
set{VAR4, count(close below r_3,1)}
set{WAIT, VAR3 * VAR4}
set{BUY, var3 - wait}
set{SELL, var4 - wait}
draw T3(5,0.7)
draw TEMA on plot price
draw DEMA on plot price
draw TSI(6,3,3)
and draw MACD(12,26,9)
and draw RSI(15)
add column separator
market is not etf
market is not otcbb
add column industry
add column sector

Mactheriverrat
3,135 posts
msg #152024
Ignore Mactheriverrat
5/2/2020 2:39:06 PM

Submit
Fetcher[
average volume(90) above 100000
average volume(10) above 500000
Average Volume(30) above 250000
offset is 0
draw IFT(5,9) and draw IFT(5,9) line at 0
and draw IFT(5,9) line at -.90
add column IFT(5,9)
IFT(5,9) < 0.80
add column separator
set{slope_incr, days(slope IFT(5,9) < slope of IFT(5,9) 1 day ago, 30)}
draw slope_incr
set{slope_pos, days(slope of IFT(5,9) < 0, 30)}
draw slope_pos
set{sort, slope_pos + slope_incr}
set{volcnt, count(volume above 100000, 100) }
set{volzero, count(volume equal 0, 100) }
set{x1, high - open}
set{Long_Profit, x1/open }
set{C1A, count(Long_Profit > .04 , 100)}
set{C2A, count(Long_Profit > .09, 100)}
set{C0010, C1A - C2A}
set{D1A, count(Long_Profit > .09 , 100)}
set{D2A, count(Long_Profit > .19, 100)}
set{D1020, D1A - D2A}
set{E1A, count(Long_Profit > .19 , 100)}
set{E2A, count(Long_Profit > .29, 100)}
set{E2030, E1A - E2A}
set{F1A, count(Long_Profit > .29 , 100)}
set{F2A, count(Long_Profit > .39, 100)}
set{F3040, F1A - F2A}
set{G1A, count(Long_Profit > .39 , 100)}
and add column daychg2
and add column C0010 {4_9}
and add column D1020 {10_19}
and add column E2030 {20_29}
and add column F3040 {30_39}
and add column G1A {40+}
and add column C1A {ttl}
and add column average day range(10) {adr10}
and add column average day range(30) {adr30}
sort column 6 descending
add column industry
add column sector
set{answer, count(ROC(5,1) above 5, 100)}
and add column answer
add column open-to-close gap
add column separator
draw WAIT
draw SELL
draw BUY
draw ema(13)
draw dma(25,-5)
draw ema(50)
add column BUY
add column SELL
add column WAIT
add column both{D2/T3}
add column both2{TSI6}
ADD COLUMN XOVER
ADD COLUMN CROSS
set{OVER, count(TSI(6,3,3) crossed above 0,1) *1}
set{UNDER, count(TSI(6,3,3) crossed below 0,1) * -1}
set{both2, OVER + UNDER}
set{CROSS, 1 - count(both2 equals 0,1)}
CROSS above 0
set{var1, 2 * EMA(9)}
set{var2, cema(ema(9),9)}
set{DEMA, var1 - var2}
set{TEMA, T3(7,1)}
set{xUP, count(DEMA crossed above TEMA,1) *1}
set{xDOWN, count(DEMA crossed below TEMA,1) * -1}
set{both, xUP + xDOWN}
set{xOVER, 1 - count(both equals 0,1)}
add column separator
set{pp_3, CeMA(pp,3) 1 day ago}
set{r_3, CeMA(r1,3) 1 day ago}
set{s_3, CeMA(s1,3) 1 day ago}
set{VAR3, count(close above pp_3,1)}
set{VAR4, count(close below r_3,1)}
set{WAIT, VAR3 * VAR4}
set{BUY, var3 - wait}
set{SELL, var4 - wait}
draw T3(5,0.7)
draw TEMA on plot price
draw DEMA on plot price
draw TSI(6,3,3)
and draw MACD(12,26,9)
and draw RSI(15)
add column separator
market is not etf
market is not otcbb
add column industry
add column sector

]



Mansor
78 posts
msg #152041
Ignore Mansor
modified
5/3/2020 12:49:57 PM

Mac - thanks for making it clickable - have you looked at it, I believe there are errors when i tried t combine several filters.

I don't know which column (4_9)/buy/answer in descending order works to pick runners for next day. I think I had the right idea but since I am not a coder and not familiar with SF, I think I got it mixed up the wrong way here.

xarlor
562 posts
msg #152083
Ignore xarlor
5/7/2020 8:21:44 AM

Not sure what you're trying to fix, everything looks to be working correctly. If you just wanted to sort by the BUY column, then just need to change

sort column 6 descending
to
sort column 20 descending

Column 6 is a separator column, so not really sorting anything there.

Fetcher[

average volume(90) above 100000
average volume(10) above 500000
Average Volume(30) above 250000
offset is 0

IFT(5,9) < 0.80
draw IFT(5,9) and draw IFT(5,9) line at 0
and draw IFT(5,9) line at -.90
add column IFT(5,9)

add column separator

set{slope_incr, days(slope IFT(5,9) < slope of IFT(5,9) 1 day ago, 30)}
set{slope_pos, days(slope of IFT(5,9) < 0, 30)}
draw slope_incr
draw slope_pos

set{sort, slope_pos + slope_incr}
set{volcnt, count(volume above 100000, 100) }
set{volzero, count(volume equal 0, 100) }
set{x1, high - open}
set{Long_Profit, x1/open }
set{C1A, count(Long_Profit > .04 , 100)}
set{C2A, count(Long_Profit > .09, 100)}
set{C0010, C1A - C2A}
set{D1A, count(Long_Profit > .09 , 100)}
set{D2A, count(Long_Profit > .19, 100)}
set{D1020, D1A - D2A}
set{E1A, count(Long_Profit > .19 , 100)}
set{E2A, count(Long_Profit > .29, 100)}
set{E2030, E1A - E2A}
set{F1A, count(Long_Profit > .29 , 100)}
set{F2A, count(Long_Profit > .39, 100)}
set{F3040, F1A - F2A}
set{G1A, count(Long_Profit > .39 , 100)}
and add column daychg2
and add column C0010 {4_9}
and add column D1020 {10_19}
and add column E2030 {20_29}
and add column F3040 {30_39}
and add column G1A {40+}
and add column C1A {ttl}
and add column average day range(10) {adr10}
and add column average day range(30) {adr30}

sort column 20 descending
add column industry
add column sector
set{answer, count(ROC(5,1) above 5, 100)}
and add column answer
add column open-to-close gap
add column separator
draw WAIT
draw SELL
draw BUY
draw ema(13)
draw dma(25,-5)
draw ema(50)
add column BUY
add column SELL
add column WAIT
add column both{D2/T3}
add column both2{TSI6}
ADD COLUMN XOVER
ADD COLUMN CROSS
set{OVER, count(TSI(6,3,3) crossed above 0,1) *1}
set{UNDER, count(TSI(6,3,3) crossed below 0,1) * -1}
set{both2, OVER + UNDER}
set{CROSS, 1 - count(both2 equals 0,1)}
CROSS above 0
set{var1, 2 * EMA(9)}
set{var2, cema(ema(9),9)}
set{DEMA, var1 - var2}
set{TEMA, T3(7,1)}
set{xUP, count(DEMA crossed above TEMA,1) *1}
set{xDOWN, count(DEMA crossed below TEMA,1) * -1}
set{both, xUP + xDOWN}
set{xOVER, 1 - count(both equals 0,1)}
add column separator
set{pp_3, CeMA(pp,3) 1 day ago}
set{r_3, CeMA(r1,3) 1 day ago}
set{s_3, CeMA(s1,3) 1 day ago}
set{VAR3, count(close above pp_3,1)}
set{VAR4, count(close below r_3,1)}
set{WAIT, VAR3 * VAR4}
set{BUY, var3 - wait}
set{SELL, var4 - wait}
draw T3(5,0.7)
draw TEMA on plot price
draw DEMA on plot price
draw TSI(6,3,3)
and draw MACD(12,26,9)
and draw RSI(15)
add column separator
market is not etf
market is not otcbb
add column industry
add column sector
]



Mactheriverrat
3,135 posts
msg #152085
Ignore Mactheriverrat
5/7/2020 2:10:14 PM

@Xarlor

What Xarlor posted in his explanation of sorting by column .

Thanks

JoeyVinyl
125 posts
msg #152089
Ignore JoeyVinyl
5/7/2020 2:40:34 PM

Part of what you're using is from the Run Forest, Run filter by TheRumpledOne. To quote from TRO's post, "The "Run Forest, Run" filter shows how many times a stock ran a certain percentage over the last 100 days. Column 04_09 is the number of times high minus open is between 4% and 9%. Column 10_19 is the number of times high minus open is between 10% and 19%." I think it's a good concept but as we all know, 'past performance is not a guarantee of future success.'

Here's a link to the original post about it.
https://stockfetcher.com/forums/Filter-Exchange/Run-Forest-Run/56077

Personally, I find it helpful to know how often a stock dropped over the same time frame as well, which this filter doesn't show. If a stock gained 5% 30 days out of the last 100 that's not bad. But if it also lost 5%, say, 40 days out of the last 100 then I don't want to touch it.

One last thought. Combining filters is not necessarily a bad idea, but you have to make sure those filters don't have conflicting conditions or variable names. You've got so much going on in that combined filter that it's hard to know what to pay attention to.

Mansor
78 posts
msg #152098
Ignore Mansor
modified
5/8/2020 9:00:42 AM

Joey - you're correct, I used TRO's filter along with nikos' and someone else's. But you're right that there's too much going on & it's impossible to find the right path in these woods now.

StockFetcher Forums · Filter Exchange · Need help with this<< >>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.