3rd Candle Close and 1st Candle Open % difference

[ARL]

Greetings! I'd like a scan where the close of the current candle is 1% less than the open of the 3rd candle back. I know the script for this is probably super simple but would appreciate having the 1 or 2 lines of code needed for this OR point me to an existing post that addresses a request like this. Thank you in advance for the help.
- Aaron

 

[Joshua]

Only the exact first and third intraday candles of the day? Or, more like a rolling thing where its always checking the recent candles as the day goes on?

 

[ARL]

To clarify, the condition is that the price difference between the current candle close and the open of the 3rd candle back is less than 1%. This would be a rolling thing always checking the current candle and the 3rd candle back on a five minute intraday chart. Thanks.

 

[Joshua]

Current candle counts as one of the three:
AbsValue((Close - Close[2]) / Close[2]) * 100 < 1

Three total completed candles behind the current candle.
With current candle not being counted one of the three:
AbsValue((Close - Close[3]) / Close[3]) * 100 < 1

The first one again, but not including the right most bar while its still forming.
Only truly finished bars:
AbsValue((Close[1] - Close[3]) / Close[3]) * 100 < 1

This will also account for the < %1 move being in either direction.
Otherwise, remove AbsValue()

This is more complicated than it sounds at first, and very dependent on the subtle details.
The answer should be in there somewhere, if not, let me know.

 

[ARL]

It's the first instance you provided that delivers the results I'm expecting. I changed it slightly so that price difference is calculated at the open of the [2] candle: AbsValue((Close - Open[2]) / Open[2]) * 100 < 1

Thank you, Joshua. This would have taken me a good chunk of time to figure out and having each subtle variation helps me understand the scripting logic much better. It also cuts down significantly the number of charts through which to process.