Hi,

     Could you please supply a formula identifying when price is crossing up through the middle line of a 5 bar keltner channel on a daily basis. Also the reverse of when price is crossing down through middle of a 5 bar channel.

                                                                                                                           Thanks,

                                                                                                                                     Investit

When you state “ price is crossing up through the middle line of a 5 bar keltner channel “ I assume you mean the Center Line of the KeltChan.  To create a Scan Condition for Price History, since I don’t see a drop down Condition for the KeltChan Center Line, a PCF should work, there may also be other ways to write your Condition.

Pease try the following PCFs:

Price xUP KeltChan 5 (Daily Time Frame)

C > (XAVGH5 + XAVGL5 + XAVGC5) /3 AND C1 < (XAVGH5.1 + XAVGL5.1 + XAVGC5.1) /3

Price xDN KeltChan 5 (Daily Time Frame)

C < (XAVGH5 + XAVGL5 + XAVGC5) /3 AND C1 > (XAVGH5.1 + XAVGL5.1 + XAVGC5.1) /3

The centerline is also the same moving average of the same time period used in the Keltner Channel. So for example, if you are using a 5 bar keltner channel based on an exponential average, try using the 5 bar exponential moving average based on the (H + L + C) /3 and you will see it will match your center line exactly. 

Then you can easily make scan criteriea off the EMA which is the same as the middle Keltner channel line.