Platinum Customer
Joined: 7/3/2007 Posts: 27
|
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!
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
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))))))))))))))))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|