I would like to create a scan condition in which the Hull Moving Average (HMA) transfers from a negative value to a positive value.  I use a HMA15 with offset of (-1).  Can anyone direct me in how to do this?  Thanks in advance.

If it's a Hull Moving Average of price it will never be negative. Are you looking for the HMA to be moving down and then reverse and start moving up?

My apologies it is poorly worded but yes this is what I need.  I am scanning with a few different PCFs but just can't figure this one out.  I am a shorter term trader (2-5 days) and have narrowed in on the HMA15(-1) crossing certain pivot points, but if I could time it so the indicator turns from negative to postive (going down to going up) such as in the stock CI on 9/26/2017, it would greatly help me scan more efficiently.

Well you can't actually write a formula for HMA15 with an offset of -1 because that would be the HMA15 from 1 bar in the future.

But if you want to do this for the most recent point where HMA15 is plotted on the chart.

HAVGC15 > HAVGC15.1 AND HAVGC15.1 < HAVGC15.2

Thanks Bruce, and that actually makes sense.  I was just in TC2000's help page of "Boolean Logical Operators Truth Table" and kept saying it just makes sense to use this "AND" operator.  I'm taking notes and I was trying to use

HAVGC0.-1<HAVGO0.-1 AND HAVGC1.-1>HAVGO1.-1

Now that you write it like that it makes more sense.  I will input this and post once I can get some results I like!!!

I think the offset was throwing me off as I use the offset in my chart to compare it against other indicators to try and get the timing right.

Your formula worked as it has on the other posts I have read and played with, thank you very much once again!

You're welcome.