| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 10/7/2004
Posts: 1,178
|
I am hoping you can provide me with a PCF for each of these Front-Weighted Moving Averages: 10-Period, 20-Period, 50-Period, if possible. I am looking for a price number for each one.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
10-Period Front Weighted Moving Average:
(10 * C + 9 * C1 + 8 * C2 + 7 * C3 + 6 * C4 + 5 * C5 + 4 * C6 + 3 * C7 + 2 * C8 + C9) / 55
20-Period Front Weighted Moving Average:
(20 * C + 19 * C1 + 18 * C2 + 17 * C3 + 16 * C4 + 15 * C5 + 14 * C6 + 13 * C7 + 12 * C8 + 11 * C9 + 10 * C10 + 9 * C11 + 8 * C12 + 7 * C13 + 6 * C14 + 5 * C15 + 4 * C16 + 3 * C17 + 2 * C18 + C19) / 210
50-Period Front Weighted Moving Average:
(50 * C + 49 * C1 + 48 * C2 + 47 * C3 + 46 * C4 + 45 * C5 + 44 * C6 + 43 * C7 + 42 * C8 + 41 * C9 + 40 * C10 + 39 * C11 + 38 * C12 + 37 * C13 + 36 * C14 + 35 * C15 + 34 * C16 + 33 * C17 + 32 * C18 + 31 * C19 + 30 * C20 + 29 * C21 + 28 * C22 + 27 * C23 + 26 * C24 + 25 * C25 + 24 * C26 + 23 * C27 + 22 * C28 + 21 * C29 + 20 * C30 + 19 * C31 + 18 * C32 + 17 * C33 + 16 * C34 + 15 * C35 + 14 * C36 + 13 * C37 + 12 * C38 + 11 * C39 + 10 * C40 + 9 * C41 + 8 * C42 + 7 * C43 + 6 * C44 + 5 * C45 + 4 * C46 + 3 * C47 + 2 * C48 + C49) / 1275
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 1,178
|
Thanks, Bruce. These are wonderful. Could you also provide a Front-Weighted Average Close for 200 Periods? I know this will be a long PCF.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
(200 * C + 199 * C1 + 198 * C2 + 197 * C3 + 196 * C4 + 195 * C5 + 194 * C6 + 193 * C7 + 192 * C8 + 191 * C9 + 190 * C10 + 189 * C11 + 188 * C12 + 187 * C13 + 186 * C14 + 185 * C15 + 184 * C16 + 183 * C17 + 182 * C18 + 181 * C19 + 180 * C20 + 179 * C21 + 178 * C22 + 177 * C23 + 176 * C24 + 175 * C25 + 174 * C26 + 173 * C27 + 172 * C28 + 171 * C29 + 170 * C30 + 169 * C31 + 168 * C32 + 167 * C33 + 166 * C34 + 165 * C35 + 164 * C36 + 163 * C37 + 162 * C38 + 161 * C39 + 160 * C40 + 159 * C41 + 158 * C42 + 157 * C43 + 156 * C44 + 155 * C45 + 154 * C46 + 153 * C47 + 152 * C48 + 151 * C49 + 150 * C50 + 149 * C51 + 148 * C52 + 147 * C53 + 146 * C54 + 145 * C55 + 144 * C56 + 143 * C57 + 142 * C58 + 141 * C59 + 140 * C60 + 139 * C61 + 138 * C62 + 137 * C63 + 136 * C64 + 135 * C65 + 134 * C66 + 133 * C67 + 132 * C68 + 131 * C69 + 130 * C70 + 129 * C71 + 128 * C72 + 127 * C73 + 126 * C74 + 125 * C75 + 124 * C76 + 123 * C77 + 122 * C78 + 121 * C79 + 120 * C80 + 119 * C81 + 118 * C82 + 117 * C83 + 116 * C84 + 115 * C85 + 114 * C86 + 113 * C87 + 112 * C88 + 111 * C89 + 110 * C90 + 109 * C91 + 108 * C92 + 107 * C93 + 106 * C94 + 105 * C95 + 104 * C96 + 103 * C97 + 102 * C98 + 101 * C99 + 100 * C100 + 99 * C101 + 98 * C102 + 97 * C103 + 96 * C104 + 95 * C105 + 94 * C106 + 93 * C107 + 92 * C108 + 91 * C109 + 90 * C110 + 89 * C111 + 88 * C112 + 87 * C113 + 86 * C114 + 85 * C115 + 84 * C116 + 83 * C117 + 82 * C118 + 81 * C119 + 80 * C120 + 79 * C121 + 78 * C122 + 77 * C123 + 76 * C124 + 75 * C125 + 74 * C126 + 73 * C127 + 72 * C128 + 71 * C129 + 70 * C130 + 69 * C131 + 68 * C132 + 67 * C133 + 66 * C134 + 65 * C135 + 64 * C136 + 63 * C137 + 62 * C138 + 61 * C139 + 60 * C140 + 59 * C141 + 58 * C142 + 57 * C143 + 56 * C144 + 55 * C145 + 54 * C146 + 53 * C147 + 52 * C148 + 51 * C149 + 50 * C150 + 49 * C151 + 48 * C152 + 47 * C153 + 46 * C154 + 45 * C155 + 44 * C156 + 43 * C157 + 42 * C158 + 41 * C159 + 40 * C160 + 39 * C161 + 38 * C162 + 37 * C163 + 36 * C164 + 35 * C165 + 34 * C166 + 33 * C167 + 32 * C168 + 31 * C169 + 30 * C170 + 29 * C171 + 28 * C172 + 27 * C173 + 26 * C174 + 25 * C175 + 24 * C176 + 23 * C177 + 22 * C178 + 21 * C179 + 20 * C180 + 19 * C181 + 18 * C182 + 17 * C183 + 16 * C184 + 15 * C185 + 14 * C186 + 13 * C187 + 12 * C188 + 11 * C189 + 10 * C190 + 9 * C191 + 8 * C192 + 7 * C193 + 6 * C194 + 5 * C195 + 4 * C196 + 3 * C197 + 2 * C198 + C199) / 20100
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 1,178
|
Mucho gracias!
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |