StockFetcher Forums · General Discussion · a round summ filter << >>Post Follow-up
shelupinin
120 posts
msg #36404
Ignore shelupinin
6/22/2005 11:37:26 AM

Hi !

Could someone help me to create filter which will shows stock near a round price value, like near 10usd, 15usd, 20usd etc.... I guess some variables should be used and phrases like "set" but I don't know how to use them :(

thank you in advance
Alex

TheRumpledOne
6,364 posts
msg #36409
Ignore TheRumpledOne
6/22/2005 5:07:46 PM

Fetcher[
set{a1, count(close equal 5.00 ,1)}
set{a2, count(close equal 10.00 ,1)}
set{a3, count(close equal 15.00 ,1)}
set{a4, count(close equal 20.00 ,1)}
set{a5, count(close equal 25.00 ,1)}

set{b1, a1 + a2}
set{b2, a3 + a4}
set{b3, b1 + a5}
set{b4, b3 + b2}

b4 above 0

add column weekly rsi(2)

]

Crude but effective.

HEY STOCKFETCHER, WHERE'S THE ROUND FUNCTION??

MAY ALL YOUR FILLS BE COMPLETE.

TheRumpledOne
6,364 posts
msg #36410
Ignore TheRumpledOne
6/22/2005 6:07:34 PM

Whoops.. you said "near"...

Fetcher[
set{a1, count(close near 5.00 ,1)}
set{a2, count(close near 10.00 ,1)}
set{a3, count(close near 15.00 ,1)}
set{a4, count(close near 20.00 ,1)}
set{a5, count(close near 25.00 ,1)}

set{b1, a1 + a2}
set{b2, a3 + a4}
set{b3, b1 + a5}
set{b4, b3 + b2}

b4 above 0

add column weekly rsi(2)

]

"Near" seems too wide! Is 15.50 really "near" 15.00?

Would be so much easier with a ROUND FUNCTION!

MAY ALL YOUR FILLS BE COMPLETE.

TheRumpledOne
6,364 posts
msg #36411
Ignore TheRumpledOne
6/22/2005 6:10:35 PM

Still working on this...

Fetcher[
set{a, 10 / 2)
set{a1, close / a}
set{a2, close / 100}
set{LoP, close - a2}
set{HiP, close + a2}

set{b1, count(a1 equal 1,1)}
set{b2, count(a1 equal 2,1)}
set{b3, count(a1 equal 3,1)}
set{b4, count(a1 equal 4,1)}
set{b5, count(a1 equal 5,1)}

set{c1, b1 + b2}
set{c2, c1 + b3}
set{c3, c2 + b4}
set{c4, c3 + b5}

add column weekly rsi(2)

]

TheRumpledOne
6,364 posts
msg #36412
Ignore TheRumpledOne
6/22/2005 6:33:26 PM

Dang, I hate it when I accidently click Post Message!

Need an EDIT BUTTON!!

Fetcher[
set{a, 5}

set{a2, a / 100}
set{LoP, a - a2}
set{HiP, a + a2}

set{a1, close / a}

set{b1, count(a1 equal 1,1)}
set{b2, b1 * 1}
set{b3, b2 * a}
set{b4, b3 - a1}

close above LoP
close below HiP

add column LoP {Lo Price}
add column HiP {Hi Price}

add column weekly rsi(2)

]

I need to finish this...

shelupinin
120 posts
msg #36415
Ignore shelupinin
6/23/2005 3:15:18 AM

Hi !
Thank you, TheRumpledOne ! Now I understand how to use "set" function, but still unable to create filter I need :(
How to overcame lack of "or" function?
for example filter
Fetcher[
set{a, 5}
set{a2, a / 100}
set{Lo5, a - a2}
set{Hi5, a + a2}

set{b, 10}
set{b2, b/100}
set{Lo10, b - b2}
set{Hi10, b + b2}

close above Lo5
close below Hi5
or
close above Lo10
close below Hi10
]

does'nt work because "or" function not working :(((((

 MrBid16 postsmsg #36416- Ignore MrBid 6/23/2005 4:22:03 AMshelupinin, it's easy ! set{a, 5} set{a2, a / 100} set{Lo5, a - a2} set{Hi5, a + a2} set{b, 10} set{b2, b/100} set{Lo10, b - b2} set{Hi10, b + b2} set{C1a,count(close above Lo5,1)} set{C1b,count(close below Hi5,1)} set{C2a,count(close above Lo10,1)} set{C2b,count(close below Hi10,1)} set {C1, C1a * C1b} set {C2, C2a * C2b} set {C1_or_C2, C1 + C2} C1_or_C2 is above 0.99 and add column C1 and add column C2
TheRumpledOne
6,364 posts
msg #36420
Ignore TheRumpledOne
6/23/2005 9:55:22 AM

Look for my post about Boolean logic.

I show how to implement "OR", "NOT", "AND"

TheRumpledOne
6,364 posts
msg #43633
Ignore TheRumpledOne
modified
5/11/2006 3:59:25 PM

Fetcher[
set{z1, close * 2}
set{z2, z1 + .50 }

set{a, z2 / 2 }

set{a2, a / 100}
set{LoBound, a }
set{UpBound, a + 1}

set{C1a,count(close 1 day ago above LoBound, 10 )}
set{C1b,count(close 1 day ago below UpBound, 10 )}

set {C1, C1a + C1b}

set {InRange, C1 / 2 }

C1 is above 0.99

and add column InRange

and add column UpBound
and add column LoBound

close above 20
volume above 5000000
]

Work in progress

TheRumpledOne
6,364 posts
msg #49148
Ignore TheRumpledOne
modified
1/11/2007 12:15:13 PM

Fetcher[
set{xRound, round( close, 0) }

set{C1a,count(close above xRound, 1 )}
set{C1b,count(close 1 day ago below xRound, 1 )}
set {C1, C1a + C1b}

C1 equal 2

and add column close 1 day ago
and add column xRound

close above .99
volume above 50000

sort column 2 descending
]

THANKS AGAIN FOR THE ROUND FUNCTION!!

 StockFetcher Forums · General Discussion · a round summ filter << >>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.