Hi.  Is there a way of taking this formula and writing a formula that shows stocks that have had crossovers for today, or one day ago, or two days ago, or three days ago or four days ago?  (In others words the stock has had a crossover in the last 5 days.)

SGN(XAVG(STOC14,4) - .400313702486715 * (XAVG(STOC14,4) + 3 / 5 * (XAVG(STOC14.1.1,4) + 3 / 5 * (XAVG(STOC14.1.2,4) + 3 / 5 * (XAVG(STOC14.1.3,4) + 3 / 5 * (XAVG(STOC14.1.4,4) + 3 / 5 * (XAVG(STOC14.1.5,4) + 3 / 5 * (XAVG(STOC14.1.6,4) + 3 / 5 * (XAVG(STOC14.1.7,4) + 3 / 5 * (XAVG(STOC14.1.8,4) + 3 / 5 * (XAVG(STOC14.1.9,4) + 3 / 5 * (XAVG(STOC14.1.10,4) + 3 / 5 * (XAVG(STOC14.1.11,4) + 3 / 5 * (XAVG(STOC14.1.12,4) + 3 / 5 * (XAVG(STOC14.1.13,4)))))))))))))))) <> SGN(XAVG(STOC14.1.1,4) - .400313702486715 * (XAVG(STOC14.1.1,4) + 3 / 5 * (XAVG(STOC14.1.2,4) + 3 / 5 * (XAVG(STOC14.1.3,4) + 3 / 5 * (XAVG(STOC14.1.4,4) + 3 / 5 * (XAVG(STOC14.1.5,4) + 3 / 5 * (XAVG(STOC14.1.6,4) + 3 / 5 * (XAVG(STOC14.1.7,4) + 3 / 5 * (XAVG(STOC14.1.8,4) + 3 / 5 * (XAVG(STOC14.1.9,4) + 3 / 5 * (XAVG(STOC14.1.10,4) + 3 / 5 * (XAVG(STOC14.1.11,4) + 3 / 5 * (XAVG(STOC14.1.12,4) + 3 / 5 * (XAVG(STOC14.1.13,4) + 3 / 5 * (XAVG(STOC14.1.14,4))))))))))))))))     

Thanks!

I would use the formula you already have as the Boolean Formula in a Custom PCF % True Indicator. Set the Period to 5 and the Average Type to Simple. Then click on the Custom PCF % True Indicator and select Create Scan Condition to create a condition for the Custom PCF % True Indicator being greater than 0.

Condition True at Least Once Over x Bars

OK, sorry, that won't work in TC2000 v7. I'll create a Condition Formula for it instead. It is quite long.

SGN(XAVG(STOC14,4) - .4003137 * (XAVG(STOC14,4) + .6 * (XAVG(STOC14.1.1,4) + .6 * (XAVG(STOC14.1.2,4) + .6 * (XAVG(STOC14.1.3,4) + .6 * (XAVG(STOC14.1.4,4) + .6 * (XAVG(STOC14.1.5,4) + .6 * (XAVG(STOC14.1.6,4) + .6 * (XAVG(STOC14.1.7,4) + .6 * (XAVG(STOC14.1.8,4) + .6 * (XAVG(STOC14.1.9,4) + .6 * (XAVG(STOC14.1.10,4) + .6 * (XAVG(STOC14.1.11,4) + .6 * (XAVG(STOC14.1.12,4) + .6 * (XAVG(STOC14.1.13,4)))))))))))))))) <> SGN(XAVG(STOC14.1.1,4) - .4003137 * (XAVG(STOC14.1.1,4) + .6 * (XAVG(STOC14.1.2,4) + .6 * (XAVG(STOC14.1.3,4) + .6 * (XAVG(STOC14.1.4,4) + .6 * (XAVG(STOC14.1.5,4) + .6 * (XAVG(STOC14.1.6,4) + .6 * (XAVG(STOC14.1.7,4) + .6 * (XAVG(STOC14.1.8,4) + .6 * (XAVG(STOC14.1.9,4) + .6 * (XAVG(STOC14.1.10,4) + .6 * (XAVG(STOC14.1.11,4) + .6 * (XAVG(STOC14.1.12,4) + .6 * (XAVG(STOC14.1.13,4) + .6 * (XAVG(STOC14.1.14,4)))))))))))))))) OR SGN(XAVG(STOC14.1.1,4) - .4003137 * (XAVG(STOC14.1.1,4) + .6 * (XAVG(STOC14.1.2,4) + .6 * (XAVG(STOC14.1.3,4) + .6 * (XAVG(STOC14.1.4,4) + .6 * (XAVG(STOC14.1.5,4) + .6 * (XAVG(STOC14.1.6,4) + .6 * (XAVG(STOC14.1.7,4) + .6 * (XAVG(STOC14.1.8,4) + .6 * (XAVG(STOC14.1.9,4) + .6 * (XAVG(STOC14.1.10,4) + .6 * (XAVG(STOC14.1.11,4) + .6 * (XAVG(STOC14.1.12,4) + .6 * (XAVG(STOC14.1.13,4) + .6 * (XAVG(STOC14.1.14,4)))))))))))))))) <> SGN(XAVG(STOC14.1.2,4) - .4003137 * (XAVG(STOC14.1.2,4) + .6 * (XAVG(STOC14.1.3,4) + .6 * (XAVG(STOC14.1.4,4) + .6 * (XAVG(STOC14.1.5,4) + .6 * (XAVG(STOC14.1.6,4) + .6 * (XAVG(STOC14.1.7,4) + .6 * (XAVG(STOC14.1.8,4) + .6 * (XAVG(STOC14.1.9,4) + .6 * (XAVG(STOC14.1.10,4) + .6 * (XAVG(STOC14.1.11,4) + .6 * (XAVG(STOC14.1.12,4) + .6 * (XAVG(STOC14.1.13,4) + .6 * (XAVG(STOC14.1.14,4) + .6 * (XAVG(STOC14.1.15,4)))))))))))))))) OR SGN(XAVG(STOC14.1.2,4) - .4003137 * (XAVG(STOC14.1.2,4) + .6 * (XAVG(STOC14.1.3,4) + .6 * (XAVG(STOC14.1.4,4) + .6 * (XAVG(STOC14.1.5,4) + .6 * (XAVG(STOC14.1.6,4) + .6 * (XAVG(STOC14.1.7,4) + .6 * (XAVG(STOC14.1.8,4) + .6 * (XAVG(STOC14.1.9,4) + .6 * (XAVG(STOC14.1.10,4) + .6 * (XAVG(STOC14.1.11,4) + .6 * (XAVG(STOC14.1.12,4) + .6 * (XAVG(STOC14.1.13,4) + .6 * (XAVG(STOC14.1.14,4) + .6 * (XAVG(STOC14.1.15,4)))))))))))))))) <> SGN(XAVG(STOC14.1.3,4) - .4003137 * (XAVG(STOC14.1.3,4) + .6 * (XAVG(STOC14.1.4,4) + .6 * (XAVG(STOC14.1.5,4) + .6 * (XAVG(STOC14.1.6,4) + .6 * (XAVG(STOC14.1.7,4) + .6 * (XAVG(STOC14.1.8,4) + .6 * (XAVG(STOC14.1.9,4) + .6 * (XAVG(STOC14.1.10,4) + .6 * (XAVG(STOC14.1.11,4) + .6 * (XAVG(STOC14.1.12,4) + .6 * (XAVG(STOC14.1.13,4) + .6 * (XAVG(STOC14.1.14,4) + .6 * (XAVG(STOC14.1.15,4) + .6 * (XAVG(STOC14.1.16,4)))))))))))))))) OR SGN(XAVG(STOC14.1.3,4) - .4003137 * (XAVG(STOC14.1.3,4) + .6 * (XAVG(STOC14.1.4,4) + .6 * (XAVG(STOC14.1.5,4) + .6 * (XAVG(STOC14.1.6,4) + .6 * (XAVG(STOC14.1.7,4) + .6 * (XAVG(STOC14.1.8,4) + .6 * (XAVG(STOC14.1.9,4) + .6 * (XAVG(STOC14.1.10,4) + .6 * (XAVG(STOC14.1.11,4) + .6 * (XAVG(STOC14.1.12,4) + .6 * (XAVG(STOC14.1.13,4) + .6 * (XAVG(STOC14.1.14,4) + .6 * (XAVG(STOC14.1.15,4) + .6 * (XAVG(STOC14.1.16,4)))))))))))))))) <> SGN(XAVG(STOC14.1.4,4) - .4003137 * (XAVG(STOC14.1.4,4) + .6 * (XAVG(STOC14.1.5,4) + .6 * (XAVG(STOC14.1.6,4) + .6 * (XAVG(STOC14.1.7,4) + .6 * (XAVG(STOC14.1.8,4) + .6 * (XAVG(STOC14.1.9,4) + .6 * (XAVG(STOC14.1.10,4) + .6 * (XAVG(STOC14.1.11,4) + .6 * (XAVG(STOC14.1.12,4) + .6 * (XAVG(STOC14.1.13,4) + .6 * (XAVG(STOC14.1.14,4) + .6 * (XAVG(STOC14.1.15,4) + .6 * (XAVG(STOC14.1.16,4) + .6 * (XAVG(STOC14.1.17,4)))))))))))))))) OR SGN(XAVG(STOC14.1.4,4) - .4003137 * (XAVG(STOC14.1.4,4) + .6 * (XAVG(STOC14.1.5,4) + .6 * (XAVG(STOC14.1.6,4) + .6 * (XAVG(STOC14.1.7,4) + .6 * (XAVG(STOC14.1.8,4) + .6 * (XAVG(STOC14.1.9,4) + .6 * (XAVG(STOC14.1.10,4) + .6 * (XAVG(STOC14.1.11,4) + .6 * (XAVG(STOC14.1.12,4) + .6 * (XAVG(STOC14.1.13,4) + .6 * (XAVG(STOC14.1.14,4) + .6 * (XAVG(STOC14.1.15,4) + .6 * (XAVG(STOC14.1.16,4) + .6 * (XAVG(STOC14.1.17,4)))))))))))))))) <> SGN(XAVG(STOC14.1.5,4) - .4003137 * (XAVG(STOC14.1.5,4) + .6 * (XAVG(STOC14.1.6,4) + .6 * (XAVG(STOC14.1.7,4) + .6 * (XAVG(STOC14.1.8,4) + .6 * (XAVG(STOC14.1.9,4) + .6 * (XAVG(STOC14.1.10,4) + .6 * (XAVG(STOC14.1.11,4) + .6 * (XAVG(STOC14.1.12,4) + .6 * (XAVG(STOC14.1.13,4) + .6 * (XAVG(STOC14.1.14,4) + .6 * (XAVG(STOC14.1.15,4) + .6 * (XAVG(STOC14.1.16,4) + .6 * (XAVG(STOC14.1.17,4) + .6 * (XAVG(STOC14.1.18,4))))))))))))))))

Thank you!  I will try that,

You're welcome.