StockFetcher Forums · General Discussion · Stock Moving into Gap<< >>Post Follow-up
whmc
6 posts
msg #103267
Ignore whmc
11/8/2011 6:04:50 PM

I am trying to figure out how to do a filter (or find one) that will find a stock that has moved into a previous down gap. For example, a stock gaps down after earnings (or for any other reason) and continues down or sideways after that. Eventually it starts back up. I would like to find out when the stock has moved back into the gap. Suggestions? (I think I posted this in the wrong place to start).

TheRumpledOne
6,359 posts
msg #103271
Ignore TheRumpledOne
modified
11/9/2011 7:57:18 AM

Fetcher[

set{ GAPDOWN, count( close 1 day ago above open, 1) }

set{ INGAP, count( close above open, 1) }

set{ X, GAPDOWN * INGAP}

X ABOVE 0

sort column 2 descending

]



This is a start.

This will display stocks that gapped down TODAY and closed inside or above the gap.

But if the gap happened 1 or more days ago, this filter won't display that. Have to work on that.




Fetcher[


set{ GAPDOWN, count( close 1 day ago above open, 1) }

set{ INGAP, count( close above open, 1) }

set{ X, GAPDOWN * INGAP}

set{ GAPDAYS, days(GAPDOWN equal 1, 100 ) }

set{ Y, count( X above 0, 5) }


set{ CLOP1, count( close above open 1 DAY AGO, 1) }
set{ CLOP2, count( close above open 2 DAYS AGO, 1) }
set{ CLOP3, count( close above open 3 DAYS AGO, 1) }
set{ CLOP4, count( close above open 4 DAYS AGO, 1) }

add column separator
add column GAPDOWN
add column GAPDOWN 1 day ago {GD-1}
add column GAPDOWN 2 days ago {GD-2}
add column GAPDOWN 3 days ago {GD-3}
add column GAPDOWN 4 days ago {GD-4}
add column separator

add column GAPDAYS
add column INGAP {CLOP}
add column CLOP1 {CLOP-1}
add column CLOP2 {CLOP-2}
add column CLOP3 {CLOP-3}
add column CLOP4 {CLOP-4}
add column separator

Y ABOVE 0

sort column 12 descending

]



This second version will get you closer to what you want.

When GAPDOWN = 1, the stock gapped down. Column GD-1 is 1 when stock gapped down 1 day ago.

GAPDAYS is the number of days since the most recent gap down.

CLOP is 1 when the close is above the open. CLOP-1 is when TODAY'S CLOSE is above the open 1 DAY AGO.

So if it has been 2 days since a stock gapped down, you would look at the CLOP-2 column to check if the stock close in the gap or above it.

You could write filters to display all stocks that are in/above the gap for 1 day ago, 2 days ago, etc...



djones000buck
206 posts
msg #103273
Ignore djones000buck
11/9/2011 9:31:27 AM

Just a quick and dirty statistical filter based on your first example. Just added it to an old stat display..

Fetcher[

/* Pick a trigger, defined as variable rz10 */


set{ GAPDOWN, count( close 1 day ago above open, 1) }

set{ INGAP, count( close above open, 1) }

set{rz10, GAPDOWN * INGAP}

/* Set Trigger */
set{trigger0, count(rz10 > .9,100)}
set{trigger00, count(rz10 > .9,1)}
set{trigger1, count(rz10 one day ago > .9,1)}
set{trigger2, count(rz10 two days ago > .9,1)}
set{trigger3, count(rz10 three days ago > .9,1)}


/* Close Statements */
set{1pc1d, close 1 day ago * 1.01}

/* High Statements */
set{1phiopc1, count( high > 1pc1d,1)}

/* Trigger Statements */
set{t1p, count( trigger1 > .9,1)}
set{t1pa, t1p + 1phiopc1}
set{1pt1, count( t1pa > 1.9,1)}

/*Add variables to determine if percentages hit day 1 to day 3 */
set{1ptvar1, count(t1pa > 1.9,100)}

/*Get 1P in 1D */
set{get1p, 1ptvar1 / trigger0}


/*25 day streak*/
set{val1, count(trigger00 > .9,25)}
set{val2, count(1pt1 > .9,25)}
set{streak, val2 / val1}


add column get1p
average volume(90) > 500000
price > 2

get1p > .79
get1p one day ago > .79
trigger0 > 13
trigger00 > .9
do not draw trigger0
streak > .8
do not draw streak
and draw trigger00
and draw 1pt1
and draw get1P

]



Eman93
4,659 posts
msg #103279
Ignore Eman93
11/9/2011 7:13:08 PM

This is the whole problem with stock fetcher you can not store a price value....

For example you want to see any stock that gaped down more than 8% in last 6 months and price is above the open of the gap down day... not happening here bro...

I like the idea the vacuum is a good trade....


you just need to keep track manually and set a price alert.. so every day you run the filter to show stocks the gap down 8% then set a price alert for the open?

You would think it would be easy but SF just wants your dollars and not add anything.

TheRumpledOne
6,359 posts
msg #103285
Ignore TheRumpledOne
11/10/2011 11:30:09 AM

True, you can't store a value.

There are somethings that SF just can't do (at the moment).

Overall, IMHO, SF is the best dollar value for filtering and running reports.



whmc
6 posts
msg #103297
Ignore whmc
11/11/2011 9:07:11 AM

Thanks for the input. I will be working on them and let you know how it goes.

StockFetcher Forums · General Discussion · Stock Moving into Gap<< >>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