Platinum Customer
Joined: 7/3/2007 Posts: 27
|
Hi. How would change these daily formulas into weekly formulas?
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)))))))))))))))
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,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))))))))))))))))
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The first formula becomes:
.40004063 * (STOC70 + .6 * (STOC70.1.5 + .6 * (STOC70.1.10 + .6 * (STOC70.1.15 + .6 * (STOC70.1.20 + .6 * (STOC70.1.25 + .6 * (STOC70.1.30 + .6 * (STOC70.1.35 + .6 * (STOC70.1.40 + .6 * (STOC70.1.45 + .6 * (STOC70.1.50 + .6 * (STOC70.1.55 + .6 * (STOC70.1.60 + .6 * (STOC70.1.65 + .6 * (STOC70.1.70 + .6 * (STOC70.1.75 + .6 * (STOC70.1.80 + .6 * (STOC70.1.85)))))))))))))))))) - .16013336 * (STOC70 + .6 * (2 * STOC70.1.5 + .6 * (3 * STOC70.1.10 + .6 * (4 * STOC70.1.15 + .6 * (5 * STOC70.1.20 + .6 * (6 * STOC70.1.25 + .6 * (7 * STOC70.1.30 + .6 * (8 * STOC70.1.35 + .6 * (9 * STOC70.1.40 + .6 * (10 * STOC70.1.45 + .6 * (11 * STOC70.1.50 + .6 * (12 * STOC70.1.55 + .6 * (13 * STOC70.1.60 + .6 * (14 * STOC70.1.65 + .6 * (15 * STOC70.1.70 + .6 * (16 * STOC70.1.75 + .6 * (17 * STOC70.1.80 + .6 * (18 * STOC70.1.85))))))))))))))))))
The second formula becomes:
.40004063 * (STOC70 + .6 * (STOC70.1.5 + .6 * (STOC70.1.10 + .6 * (STOC70.1.15 + .6 * (STOC70.1.20 + .6 * (STOC70.1.25 + .6 * (STOC70.1.30 + .6 * (STOC70.1.35 + .6 * (STOC70.1.40 + .6 * (STOC70.1.45 + .6 * (STOC70.1.50 + .6 * (STOC70.1.55 + .6 * (STOC70.1.60 + .6 * (STOC70.1.65 + .6 * (STOC70.1.70 + .6 * (STOC70.1.75 + .6 * (STOC70.1.80 + .6 * (STOC70.1.85))))))))))))))))))
The third formula becomes:
.16013336 * (STOC70 + .6 * (2 * STOC70.1.5 + .6 * (3 * STOC70.1.10 + .6 * (4 * STOC70.1.15 + .6 * (5 * STOC70.1.20 + .6 * (6 * STOC70.1.25 + .6 * (7 * STOC70.1.30 + .6 * (8 * STOC70.1.35 + .6 * (9 * STOC70.1.40 + .6 * (10 * STOC70.1.45 + .6 * (11 * STOC70.1.50 + .6 * (12 * STOC70.1.55 + .6 * (13 * STOC70.1.60 + .6 * (14 * STOC70.1.65 + .6 * (15 * STOC70.1.70 + .6 * (16 * STOC70.1.75 + .6 * (17 * STOC70.1.80 + .6 * (18 * STOC70.1.85))))))))))))))))))
The fourth formula becomes:
SGN(.40004063 * (STOC70 + .6 * (STOC70.1.5 + .6 * (STOC70.1.10 + .6 * (STOC70.1.15 + .6 * (STOC70.1.20 + .6 * (STOC70.1.25 + .6 * (STOC70.1.30 + .6 * (STOC70.1.35 + .6 * (STOC70.1.40 + .6 * (STOC70.1.45 + .6 * (STOC70.1.50 + .6 * (STOC70.1.55 + .6 * (STOC70.1.60 + .6 * (STOC70.1.65 + .6 * (STOC70.1.70 + .6 * (STOC70.1.75 + .6 * (STOC70.1.80 + .6 * (STOC70.1.85)))))))))))))))))) - .16013336 * (STOC70 + .6 * (2 * STOC70.1.5 + .6 * (3 * STOC70.1.10 + .6 * (4 * STOC70.1.15 + .6 * (5 * STOC70.1.20 + .6 * (6 * STOC70.1.25 + .6 * (7 * STOC70.1.30 + .6 * (8 * STOC70.1.35 + .6 * (9 * STOC70.1.40 + .6 * (10 * STOC70.1.45 + .6 * (11 * STOC70.1.50 + .6 * (12 * STOC70.1.55 + .6 * (13 * STOC70.1.60 + .6 * (14 * STOC70.1.65 + .6 * (15 * STOC70.1.70 + .6 * (16 * STOC70.1.75 + .6 * (17 * STOC70.1.80 + .6 * (18 * STOC70.1.85))))))))))))))))))) <> SGN(.40004063 * (STOC70.1.5 + .6 * (STOC70.1.10 + .6 * (STOC70.1.15 + .6 * (STOC70.1.20 + .6 * (STOC70.1.25 + .6 * (STOC70.1.30 + .6 * (STOC70.1.35 + .6 * (STOC70.1.40 + .6 * (STOC70.1.45 + .6 * (STOC70.1.50 + .6 * (STOC70.1.55 + .6 * (STOC70.1.60 + .6 * (STOC70.1.65 + .6 * (STOC70.1.70 + .6 * (STOC70.1.75 + .6 * (STOC70.1.80 + .6 * (STOC70.1.85 + .6 * (STOC70.1.90)))))))))))))))))) - .16013336 * (STOC70.1.5 + .6 * (2 * STOC70.1.10 + .6 * (3 * STOC70.1.15 + .6 * (4 * STOC70.1.20 + .6 * (5 * STOC70.1.25 + .6 * (6 * STOC70.1.30 + .6 * (7 * STOC70.1.35 + .6 * (8 * STOC70.1.40 + .6 * (9 * STOC70.1.45 + .6 * (10 * STOC70.1.50 + .6 * (11 * STOC70.1.55 + .6 * (12 * STOC70.1.60 + .6 * (13 * STOC70.1.65 + .6 * (14 * STOC70.1.70 + .6 * (15 * STOC70.1.75 + .6 * (16 * STOC70.1.80 + .6 * (17 * STOC70.1.85 + .6 * (18 * STOC70.1.90)))))))))))))))))))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Platinum Customer
Joined: 7/3/2007 Posts: 27
|
Thank you so much!!!!
|