Registered User Joined: 7/28/2013 Posts: 31
|
I'd like the TRIX 9 CROSS UP OR DOWN its' simple moving average of 1, offset -1. Can this be done? thanks.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following Condition Formula:
SGN((C + .8 * (3 * C1 + .8 * (6 * C2 + .8 * (10 * C3 + .8 * (15 * C4 + .8 * (21 * C5 + .8 * (28 * C6 + .8 * (36 * C7 + .8 * (45 * C8 + .8 * (55 * C9 + .8 * (66 * C10 + .8 * (78 * C11 + .8 * (91 * C12 + .8 * (105 * C13 + .8 * (120 * C14 + .8 * (136 * C15 + .8 * (153 * C16 + .8 * (171 * C17 + .8 * (190 * C18 + .8 * (210 * C19 + .8 * (231 * C20 + .8 * (253 * C21 + .8 * (276 * C22 + .8 * (300 * C23 + .8 * (325 * C24 + .8 * (351 * C25 + .8 * (378 * C26 + .8 * (406 * C27 + .8 * (435 * C28 + .8 * (465 * C29 + .8 * (496 * C30 + .8 * (528 * C31 + .8 * (561 * C32 + .8 * (595 * C33 + .8 * (630 * C34 + .8 * (666 * C35 + .8 * (703 * C36 + .8 * (741 * C37 + .8 * (780 * C38 + .8 * (820 * C39 + .8 * (861 * C40 + .8 * (903 * C41 + .8 * (946 * C42 + .8 * (990 * C43 + .8 * (1035 * C44 + .8 * (1081 * C45 + .8 * (1128 * C46 + .8 * (1176 * C47 + .8 * (1225 * C48 + .8 * (1275 * C49)))))))))))))))))))))))))))))))))))))))))))))))))) / (C1 + .8 * (3 * C2 + .8 * (6 * C3 + .8 * (10 * C4 + .8 * (15 * C5 + .8 * (21 * C6 + .8 * (28 * C7 + .8 * (36 * C8 + .8 * (45 * C9 + .8 * (55 * C10 + .8 * (66 * C11 + .8 * (78 * C12 + .8 * (91 * C13 + .8 * (105 * C14 + .8 * (120 * C15 + .8 * (136 * C16 + .8 * (153 * C17 + .8 * (171 * C18 + .8 * (190 * C19 + .8 * (210 * C20 + .8 * (231 * C21 + .8 * (253 * C22 + .8 * (276 * C23 + .8 * (300 * C24 + .8 * (325 * C25 + .8 * (351 * C26 + .8 * (378 * C27 + .8 * (406 * C28 + .8 * (435 * C29 + .8 * (465 * C30 + .8 * (496 * C31 + .8 * (528 * C32 + .8 * (561 * C33 + .8 * (595 * C34 + .8 * (630 * C35 + .8 * (666 * C36 + .8 * (703 * C37 + .8 * (741 * C38 + .8 * (780 * C39 + .8 * (820 * C40 + .8 * (861 * C41 + .8 * (903 * C42 + .8 * (946 * C43 + .8 * (990 * C44 + .8 * (1035 * C45 + .8 * (1081 * C46 + .8 * (1128 * C47 + .8 * (1176 * C48 + .8 * (1225 * C49 + .8 * (1275 * C50)))))))))))))))))))))))))))))))))))))))))))))))))) - (C1 + .8 * (3 * C2 + .8 * (6 * C3 + .8 * (10 * C4 + .8 * (15 * C5 + .8 * (21 * C6 + .8 * (28 * C7 + .8 * (36 * C8 + .8 * (45 * C9 + .8 * (55 * C10 + .8 * (66 * C11 + .8 * (78 * C12 + .8 * (91 * C13 + .8 * (105 * C14 + .8 * (120 * C15 + .8 * (136 * C16 + .8 * (153 * C17 + .8 * (171 * C18 + .8 * (190 * C19 + .8 * (210 * C20 + .8 * (231 * C21 + .8 * (253 * C22 + .8 * (276 * C23 + .8 * (300 * C24 + .8 * (325 * C25 + .8 * (351 * C26 + .8 * (378 * C27 + .8 * (406 * C28 + .8 * (435 * C29 + .8 * (465 * C30 + .8 * (496 * C31 + .8 * (528 * C32 + .8 * (561 * C33 + .8 * (595 * C34 + .8 * (630 * C35 + .8 * (666 * C36 + .8 * (703 * C37 + .8 * (741 * C38 + .8 * (780 * C39 + .8 * (820 * C40 + .8 * (861 * C41 + .8 * (903 * C42 + .8 * (946 * C43 + .8 * (990 * C44 + .8 * (1035 * C45 + .8 * (1081 * C46 + .8 * (1128 * C47 + .8 * (1176 * C48 + .8 * (1225 * C49 + .8 * (1275 * C50)))))))))))))))))))))))))))))))))))))))))))))))))) / (C2 + .8 * (3 * C3 + .8 * (6 * C4 + .8 * (10 * C5 + .8 * (15 * C6 + .8 * (21 * C7 + .8 * (28 * C8 + .8 * (36 * C9 + .8 * (45 * C10 + .8 * (55 * C11 + .8 * (66 * C12 + .8 * (78 * C13 + .8 * (91 * C14 + .8 * (105 * C15 + .8 * (120 * C16 + .8 * (136 * C17 + .8 * (153 * C18 + .8 * (171 * C19 + .8 * (190 * C20 + .8 * (210 * C21 + .8 * (231 * C22 + .8 * (253 * C23 + .8 * (276 * C24 + .8 * (300 * C25 + .8 * (325 * C26 + .8 * (351 * C27 + .8 * (378 * C28 + .8 * (406 * C29 + .8 * (435 * C30 + .8 * (465 * C31 + .8 * (496 * C32 + .8 * (528 * C33 + .8 * (561 * C34 + .8 * (595 * C35 + .8 * (630 * C36 + .8 * (666 * C37 + .8 * (703 * C38 + .8 * (741 * C39 + .8 * (780 * C40 + .8 * (820 * C41 + .8 * (861 * C42 + .8 * (903 * C43 + .8 * (946 * C44 + .8 * (990 * C45 + .8 * (1035 * C46 + .8 * (1081 * C47 + .8 * (1128 * C48 + .8 * (1176 * C49 + .8 * (1225 * C50 + .8 * (1275 * C51))))))))))))))))))))))))))))))))))))))))))))))))))) <> SGN((C1 + .8 * (3 * C2 + .8 * (6 * C3 + .8 * (10 * C4 + .8 * (15 * C5 + .8 * (21 * C6 + .8 * (28 * C7 + .8 * (36 * C8 + .8 * (45 * C9 + .8 * (55 * C10 + .8 * (66 * C11 + .8 * (78 * C12 + .8 * (91 * C13 + .8 * (105 * C14 + .8 * (120 * C15 + .8 * (136 * C16 + .8 * (153 * C17 + .8 * (171 * C18 + .8 * (190 * C19 + .8 * (210 * C20 + .8 * (231 * C21 + .8 * (253 * C22 + .8 * (276 * C23 + .8 * (300 * C24 + .8 * (325 * C25 + .8 * (351 * C26 + .8 * (378 * C27 + .8 * (406 * C28 + .8 * (435 * C29 + .8 * (465 * C30 + .8 * (496 * C31 + .8 * (528 * C32 + .8 * (561 * C33 + .8 * (595 * C34 + .8 * (630 * C35 + .8 * (666 * C36 + .8 * (703 * C37 + .8 * (741 * C38 + .8 * (780 * C39 + .8 * (820 * C40 + .8 * (861 * C41 + .8 * (903 * C42 + .8 * (946 * C43 + .8 * (990 * C44 + .8 * (1035 * C45 + .8 * (1081 * C46 + .8 * (1128 * C47 + .8 * (1176 * C48 + .8 * (1225 * C49 + .8 * (1275 * C50)))))))))))))))))))))))))))))))))))))))))))))))))) / (C2 + .8 * (3 * C3 + .8 * (6 * C4 + .8 * (10 * C5 + .8 * (15 * C6 + .8 * (21 * C7 + .8 * (28 * C8 + .8 * (36 * C9 + .8 * (45 * C10 + .8 * (55 * C11 + .8 * (66 * C12 + .8 * (78 * C13 + .8 * (91 * C14 + .8 * (105 * C15 + .8 * (120 * C16 + .8 * (136 * C17 + .8 * (153 * C18 + .8 * (171 * C19 + .8 * (190 * C20 + .8 * (210 * C21 + .8 * (231 * C22 + .8 * (253 * C23 + .8 * (276 * C24 + .8 * (300 * C25 + .8 * (325 * C26 + .8 * (351 * C27 + .8 * (378 * C28 + .8 * (406 * C29 + .8 * (435 * C30 + .8 * (465 * C31 + .8 * (496 * C32 + .8 * (528 * C33 + .8 * (561 * C34 + .8 * (595 * C35 + .8 * (630 * C36 + .8 * (666 * C37 + .8 * (703 * C38 + .8 * (741 * C39 + .8 * (780 * C40 + .8 * (820 * C41 + .8 * (861 * C42 + .8 * (903 * C43 + .8 * (946 * C44 + .8 * (990 * C45 + .8 * (1035 * C46 + .8 * (1081 * C47 + .8 * (1128 * C48 + .8 * (1176 * C49 + .8 * (1225 * C50 + .8 * (1275 * C51)))))))))))))))))))))))))))))))))))))))))))))))))) - (C2 + .8 * (3 * C3 + .8 * (6 * C4 + .8 * (10 * C5 + .8 * (15 * C6 + .8 * (21 * C7 + .8 * (28 * C8 + .8 * (36 * C9 + .8 * (45 * C10 + .8 * (55 * C11 + .8 * (66 * C12 + .8 * (78 * C13 + .8 * (91 * C14 + .8 * (105 * C15 + .8 * (120 * C16 + .8 * (136 * C17 + .8 * (153 * C18 + .8 * (171 * C19 + .8 * (190 * C20 + .8 * (210 * C21 + .8 * (231 * C22 + .8 * (253 * C23 + .8 * (276 * C24 + .8 * (300 * C25 + .8 * (325 * C26 + .8 * (351 * C27 + .8 * (378 * C28 + .8 * (406 * C29 + .8 * (435 * C30 + .8 * (465 * C31 + .8 * (496 * C32 + .8 * (528 * C33 + .8 * (561 * C34 + .8 * (595 * C35 + .8 * (630 * C36 + .8 * (666 * C37 + .8 * (703 * C38 + .8 * (741 * C39 + .8 * (780 * C40 + .8 * (820 * C41 + .8 * (861 * C42 + .8 * (903 * C43 + .8 * (946 * C44 + .8 * (990 * C45 + .8 * (1035 * C46 + .8 * (1081 * C47 + .8 * (1128 * C48 + .8 * (1176 * C49 + .8 * (1225 * C50 + .8 * (1275 * C51)))))))))))))))))))))))))))))))))))))))))))))))))) / (C3 + .8 * (3 * C4 + .8 * (6 * C5 + .8 * (10 * C6 + .8 * (15 * C7 + .8 * (21 * C8 + .8 * (28 * C9 + .8 * (36 * C10 + .8 * (45 * C11 + .8 * (55 * C12 + .8 * (66 * C13 + .8 * (78 * C14 + .8 * (91 * C15 + .8 * (105 * C16 + .8 * (120 * C17 + .8 * (136 * C18 + .8 * (153 * C19 + .8 * (171 * C20 + .8 * (190 * C21 + .8 * (210 * C22 + .8 * (231 * C23 + .8 * (253 * C24 + .8 * (276 * C25 + .8 * (300 * C26 + .8 * (325 * C27 + .8 * (351 * C28 + .8 * (378 * C29 + .8 * (406 * C30 + .8 * (435 * C31 + .8 * (465 * C32 + .8 * (496 * C33 + .8 * (528 * C34 + .8 * (561 * C35 + .8 * (595 * C36 + .8 * (630 * C37 + .8 * (666 * C38 + .8 * (703 * C39 + .8 * (741 * C40 + .8 * (780 * C41 + .8 * (820 * C42 + .8 * (861 * C43 + .8 * (903 * C44 + .8 * (946 * C45 + .8 * (990 * C46 + .8 * (1035 * C47 + .8 * (1081 * C48 + .8 * (1128 * C49 + .8 * (1176 * C50 + .8 * (1225 * C51 + .8 * (1275 * C52)))))))))))))))))))))))))))))))))))))))))))))))))))
Cascades of Moving Averages
-Bruce Personal Criteria Formulas TC2000 Support Articles
|