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,411 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 rsi(2)
add column weekly rsi(2)

]



Crude but effective.

HEY STOCKFETCHER, WHERE'S THE ROUND FUNCTION??

MAY ALL YOUR FILLS BE COMPLETE.





TheRumpledOne
6,411 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 rsi(2)
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,411 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 a

add column c4

add column LoP
add column HiP

add column rsi(2)
add column weekly rsi(2)



]




TheRumpledOne
6,411 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 b1
add column b2
add column b3
add column b4

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

add column rsi(2)
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 :(((((


MrBid
16 posts
msg #36416
Ignore MrBid
6/23/2005 4:22:03 AM

shelupinin, 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,411 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,411 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,411 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.


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.