Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Gap that hasnt been filled Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
golfpro2301
Posted : Thursday, August 25, 2016 10:07:29 PM
Registered User
Joined: 12/23/2012
Posts: 5

Is there a way to scan for stocks that have gaps that haven't been filled say in the last 30 days. I would like to scan for this criteria on stocks that are under $10 with a float under 10 million. I would like for it to scan gap ups and downs. I have a gap scanner but that is only for the current day not history. Thanks

Bruce_L
Posted : Friday, August 26, 2016 10:10:05 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

If your gap scanner is already written as a Condition Formula then you should be able to use the following technique to check for it to have happened within the last 30 bars.

Condition True at Least Once Over x Bars

If you don't already have the base scan written as a formula for the current bar, how is the gap defined? Is the gap between the previous close and current open, between the previous high and current open or something else?



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
golfpro2301
Posted : Friday, August 26, 2016 10:34:18 AM
Registered User
Joined: 12/23/2012
Posts: 5

Would be from previous day close to open. Trying to create a scan for stocks that need their gap to fill.

Bruce_L
Posted : Friday, August 26, 2016 10:43:44 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

Then you should be able to use the technique referenced above with the following Boolean Formula in the Custom PCF % True Indicator.

C1 < L OR H < C1

You can add the resulting condition created from the Custom PCF % True Indicator to an EasyScan containing conditions for price and float.

How to Create an EasyScan and save it to the Library
Building a Scan with Multiple Conditions (7:29)

That will check for an unfilled gap on each of those individual days.

If you want an gap that has not filled since that day, you could try the following Condition Formula in your EasyScan instead (without using the technique given in my first response).

How to create and save a Condition (PCF) Formula

C1 < L OR H < C1 OR C2 < MINL2 OR MAXH2 < C2 OR C3 < MINL3 OR MAXH3 < C3 OR C4 < MINL4 OR MAXH4 < C4 OR C5 < MINL5 OR MAXH5 < C5 OR C6 < MINL6 OR MAXH6 < C6 OR C7 < MINL7 OR MAXH7 < C7 OR C8 < MINL8 OR MAXH8 < C8 OR C9 < MINL9 OR MAXH9 < C9 OR C10 < MINL10 OR MAXH10 < C10 OR C11 < MINL11 OR MAXH11 < C11 OR C12 < MINL12 OR MAXH12 < C12 OR C13 < MINL13 OR MAXH13 < C13 OR C14 < MINL14 OR MAXH14 < C14 OR C15 < MINL15 OR MAXH15 < C15 OR C16 < MINL16 OR MAXH16 < C16 OR C17 < MINL17 OR MAXH17 < C17 OR C18 < MINL18 OR MAXH18 < C18 OR C19 < MINL19 OR MAXH19 < C19 OR C20 < MINL20 OR MAXH20 < C20 OR C21 < MINL21 OR MAXH21 < C21 OR C22 < MINL22 OR MAXH22 < C22 OR C23 < MINL23 OR MAXH23 < C23 OR C24 < MINL24 OR MAXH24 < C24 OR C25 < MINL25 OR MAXH25 < C25 OR C26 < MINL26 OR MAXH26 < C26 OR C27 < MINL27 OR MAXH27 < C27 OR C28 < MINL28 OR MAXH28 < C28 OR C29 < MINL29 OR MAXH29 < C29 OR C30 < MINL30 OR MAXH30 < C30



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
golfpro2301
Posted : Tuesday, September 20, 2016 8:23:32 PM
Registered User
Joined: 12/23/2012
Posts: 5

Thanks Bruce. This returns quite a few. Is there a way to do the gaps by 10% or more up and down?

Bruce_L
Posted : Wednesday, September 21, 2016 11:02:19 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

The shorter formula can be written as follows.

(C1 <= 1.1 * O AND C1 < L) OR (H < C1 AND O <= .9 * C1)

And the longer formula can be written as follows.

(C1 <= 1.1 * O AND C1 < L) OR (H < C1 AND O <= .9 * C1) OR (C2 <= 1.1 * O1 AND C2 < MINL2) OR (MAXH2 < C2 AND O1 <= .9 * C2) OR (C3 <= 1.1 * O2 AND C3 < MINL3) OR (MAXH3 < C3 AND O2 <= .9 * C3) OR (C4 <= 1.1 * O3 AND C4 < MINL4) OR (MAXH4 < C4 AND O3 <= .9 * C4) OR (C5 <= 1.1 * O4 AND C5 < MINL5) OR (MAXH5 < C5 AND O4 <= .9 * C5) OR (C6 <= 1.1 * O5 AND C6 < MINL6) OR (MAXH6 < C6 AND O5 <= .9 * C6) OR (C7 <= 1.1 * O6 AND C7 < MINL7) OR (MAXH7 < C7 AND O6 <= .9 * C7) OR (C8 <= 1.1 * O7 AND C8 < MINL8) OR (MAXH8 < C8 AND O7 <= .9 * C8) OR (C9 <= 1.1 * O8 AND C9 < MINL9) OR (MAXH9 < C9 AND O8 <= .9 * C9) OR (C10 <= 1.1 * O9 AND C10 < MINL10) OR (MAXH10 < C10 AND O9 <= .9 * C10) OR (C11 <= 1.1 * O10 AND C11 < MINL11) OR (MAXH11 < C11 AND O10 <= .9 * C11) OR (C12 <= 1.1 * O11 AND C12 < MINL12) OR (MAXH12 < C12 AND O11 <= .9 * C12) OR (C13 <= 1.1 * O12 AND C13 < MINL13) OR (MAXH13 < C13 AND O12 <= .9 * C13) OR (C14 <= 1.1 * O13 AND C14 < MINL14) OR (MAXH14 < C14 AND O13 <= .9 * C14) OR (C15 <= 1.1 * O14 AND C15 < MINL15) OR (MAXH15 < C15 AND O14 <= .9 * C15) OR (C16 <= 1.1 * O15 AND C16 < MINL16) OR (MAXH16 < C16 AND O15 <= .9 * C16) OR (C17 <= 1.1 * O16 AND C17 < MINL17) OR (MAXH17 < C17 AND O16 <= .9 * C17) OR (C18 <= 1.1 * O17 AND C18 < MINL18) OR (MAXH18 < C18 AND O17 <= .9 * C18) OR (C19 <= 1.1 * O18 AND C19 < MINL19) OR (MAXH19 < C19 AND O18 <= .9 * C19) OR (C20 <= 1.1 * O19 AND C20 < MINL20) OR (MAXH20 < C20 AND O19 <= .9 * C20) OR (C21 <= 1.1 * O20 AND C21 < MINL21) OR (MAXH21 < C21 AND O20 <= .9 * C21) OR (C22 <= 1.1 * O21 AND C22 < MINL22) OR (MAXH22 < C22 AND O21 <= .9 * C22) OR (C23 <= 1.1 * O22 AND C23 < MINL23) OR (MAXH23 < C23 AND O22 <= .9 * C23) OR (C24 <= 1.1 * O23 AND C24 < MINL24) OR (MAXH24 < C24 AND O23 <= .9 * C24) OR (C25 <= 1.1 * O24 AND C25 < MINL25) OR (MAXH25 < C25 AND O24 <= .9 * C25) OR (C26 <= 1.1 * O25 AND C26 < MINL26) OR (MAXH26 < C26 AND O25 <= .9 * C26) OR (C27 <= 1.1 * O26 AND C27 < MINL27) OR (MAXH27 < C27 AND O26 <= .9 * C27) OR (C28 <= 1.1 * O27 AND C28 < MINL28) OR (MAXH28 < C28 AND O27 <= .9 * C28) OR (C29 <= 1.1 * O28 AND C29 < MINL29) OR (MAXH29 < C29 AND O28 <= .9 * C29) OR (C30 <= 1.1 * O29 AND C30 < MINL30) OR (MAXH30 < C30 AND O29 <= .9 * C30)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.