StockFetcher Forums · Filter Exchange · oops.. I did it!!<< >>Post Follow-up
MomsLegacy
34 posts
msg #64125
Ignore MomsLegacy
6/20/2008 5:52:27 PM

I made my first filter. It's exactly what I need...
I've been pulling my hair out forever, and then all of a sudden it just clicked.
Might not be much to you technical savants, but it's huge for me.

Average volume (90) is greater than 1000000
and stock is optionable
and average true range greater than 5
and atr (5) greater than 4
add column sector

I just had to tell someone... ha ha


TheRumpledOne
6,360 posts
msg #64126
Ignore TheRumpledOne
modified
6/20/2008 6:11:46 PM

Fetcher[
Average volume (90) is greater than 1000000
and stock is optionable
and average true range greater than 5
and atr (5) greater than 4

add column atr(5)
add column average true range
add column separator
add column sector
add column industry
add column separator

sort column 5 descending
]



chetron
2,817 posts
msg #64128
Ignore chetron
6/20/2008 6:35:55 PM

nice job, leg



MomsLegacy
34 posts
msg #64132
Ignore MomsLegacy
6/20/2008 9:58:26 PM

thanks chetron, and thanks for the extra columns those are helpful.. I changed the sort column to sort column 2 ascending. At those prices, I'll need the cheap ones, Didn't think to sort them like that. This is getting fun now.

TheRumpledOne
6,360 posts
msg #64147
Ignore TheRumpledOne
modified
6/21/2008 12:42:22 PM

Fetcher[
/* Basic Filter for newbies and old pros */

set{E36b,days(ema(3) is above ema(6),100)}
set{E36a,days(ema(3) is below ema(6),100)}
set{E3xE6, E36a - E36b}

set{E50200b,days(ma(50) is above ma(200),100)}
set{E50200a,days(ma(50) is below ma(200),100)}
set{M50xM200, E50200a - E50200b}

set{E1326b,days(ema(13) is above ema(26),100)}
set{E1326a,days(ema(13) is below ema(26),100)}
set{E13xE26, E1326a - E1326b}

set{CCb,days(close is above close 1 day ago,100)}
set{CCa,days(close is below close 1 day ago,100)}
set{CxC, CCa - CCb}

set{E5b,days(close is above ema(5),100)}
set{E5a,days(close is below ema(5),100)}
set{CxE5, E5a - E5b}


set{E50b,days(close is above ma(50),100)}
set{E50a,days(close is below ma(50),100)}
set{CxM50, E50a - E50b}

set{E200b,days(close is above ma(200),100)}
set{E200a,days(close is below ma(200),100)}
set{CxM200, E200a - E200b}


set{T10, count(10 day slope of the close above 0,1)}
set{T60, count(60 day slope of the close above 0,1)}
set{T200, count(200 day slope of the close above 0,1)}

Set{a1, T200 * 1}
Set{a2, T60 * 10}
Set{a3, T10 * 100}

Set{aa, a1 + a2}
Set{TREND, aa + a3}

set{v, volume 1 day ago}
set{volinc, volume - v}
set{volpc, volinc / v}
set{volpct, volpc * 100}

set{VolZ, days(volume < 1,100)}
set{VolUp, days(volume is below volume 1 day ago,100)}
set{VolDn, days(volume is above volume 1 day ago,100)}
set{VolCnt, VolUp - VolDn}

set{vck1, volume 1 day ago }
set{vck, volume / vck1 }
set{vdbl, days(vck < 2, 100)}


and add column VolCnt
and add column Vdbl
and add column VolZ

and add column Trend

and add column CxC {CxC_}
and add column CxE5 {CxE5}

and add column E3xE6 {E3xE6}
and add column E13xE26 {E13xE26}


and add column CxM50
and add column CxM200
and add column M50xM200

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

add column atr(5)
add column average true range


Average volume (90) is greater than 1000000
and stock is optionable
and average true range greater than 5
and atr (5) greater than 4

sort column 2 ascending
]



arby347
87 posts
msg #64155
Ignore arby347
6/21/2008 5:12:03 PM

leg, just a FYI: Like in Excel, you can always sort a column ascending or descending in SF by clicking the column label.

arby347
87 posts
msg #64163
Ignore arby347
6/21/2008 10:58:02 PM

My own correction. You can do the sort in SF by clicking the column label. Excel you have to highlight and choose the A-Z logo

StockFetcher Forums · Filter Exchange · oops.. I did it!!<< >>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 2016 - 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