Hi Bruce,

You previously created this PCF at my request:

Gap Percent (Up or Dn)

100 * (ABS (L > H1) * (L / H1 - 1) + ABS(H < L1) * (H / L1 - 1))

I am currently interested in broadening this PCF to show Gaps Up or Down on the one minute chart.  In other words,  for Gap Down at Open:

C1>O

And for Gap Up at Open:

C1<O

Is it possible to incorporate these ideas into a similar Gap Percent (Up or Dn)?

Thanks,

traderlady

Maybe the following?

100 * (O / C1 - 1)

This works fine!

Good morning Bruce, 

I am missing something on this post, I tried to use the formulas but the result is not what I expected. 

I am looking to create a formula for a scan wich can show stocks with gap between x% and x% gap. 

Thanks for your time and your help 

The formula as written just returns the gap as a percentage (up as + values and down as - values) between the close of the previous bar and the open of the current bar. This is an Indicator Formula designed to return a numeric value.

If you want to create a Condition Formula checking for the value to be between specific percentages, you would need to specificy those percentages and make the comparisons in the formula in order to turn this into a Condition Formula returning a Boolean (true or false) value instead.

For example, the following Condition Formula would check for the gap up to be between 2% and 5%.

2 <= 100 * (O / C1 - 1) AND 100 * (O / C1 - 1) <= 5

Thanks a lot for answering that fast Bruce, you're a beast :) 

Have a great day !

You're welcome.