 Gold Customer
Joined: 10/7/2004
Posts: 17
|
Hi,
I have designed a PC formula .When i checked it for syntax ,it was ok .HOwever it wont update ?
Belw is the formula .PLease check syntax and see if you can udate the formula .
Thankyou,
Dr Silverhardt
Here is the original message i sent to support@worden.com .:
From Dr Silverhardt
(phone and user numbers removed by moderator)
RE: Updating TC Funds Personal Criteria
Hi ,
I have designed a personal criteria for TC funds which is part of this email ..below this message.
Here is the Problem:
when I completed this personal criteria formula and tested it , there were no errors .
But when I tried to update it , an error message appeared .PLease fix this problem so i can update this personal criteria formula and use it.(see below ):
Thankyou,
Dr Silverhardt
AVGC200 - 2 * SQR(((C * C + C1 * C1 + C2 * C2 + C3 * C3 + C4 * C4 + C5 * C5 + C6 * C6 + C7 * C7 + C8 * C8 + C9 * C9 + C10 * C10 + C11 * C11 + C12 * C12 + C13 * C13 + C14 * C14 + C15 * C15 + C16 * C16 + C17 * C17 + C18 * C18 + C19 * C19 + C20 * C20 + C21 * C21 + C22 * C22 + C23 * C23 + C24 * C24 + C25 * C25 + C26 * C26 + C27 * C27 + C28 * C28 + C29 * C29 + C30 * C30 + C31 * C31 + C32 * C32 + C33 * C33 + C34 * C34 + C35 * C35 + C36 * C36 + C37 * C37 + C38 * C38 + C39 * C39 + C40 * C40 + C41 * C41 + C42 * C42 + C43 * C43 + C44 * C44 + C45 * C45 + C46 * C46 + C47 * C47 + C48 * C48 + C49 * C49 + C50 * C50 + C51 * C51 + C52 * C52 + C53 * C53 + C54 * C54 + C55 * C55 + C56 * C56 + C57 * C57 + C58 * C58 + C59 * C59 + C60 * C60 + C61 * C61 + C62 * C62 + C63 * C63 + C64 * C64 + C65 * C65 + C66 * C66 + C67 * C67 + C68 * C68 + C69 * C69 + C70 * C70 + C71 * C71 + C72 * C72 + C73 * C73 + C74 * C74 + C75 * C75 + C76 * C76 + C77 * C77 + C78 * C78 + C79 * C79 + C80 * C80 + C81 * C81 + C82 * C82 + C83 * C83 + C84 * C84 + C85 * C85 + C86 * C86 + C87 * C87 + C88 * C88 + C89 * C89 + C90 * C90 + C91 * C91 + C92 * C92 + C93 * C93 + C94 * C94 + C95 * C95 + C96 * C96 + C97 * C97 + C98 * C98 + C99 * C99 + C100 * C100 + C101 * C101 + C102 * C102 + C103 * C103 + C104 * C104 + C105 * C105 + C106 * C106 + C107 * C107 + C108 * C108 + C109 * C109 + C110 * C110 + C111 * C111 + C112 * C112 + C113 * C113 + C114 * C114 + C115 * C115 + C116 * C116 + C117 * C117 + C118 * C118 + C119 * C119 + C120 * C120 + C121 * C121 + C122 * C122 + C123 * C123 + C124 * C124 + C125 * C125 + C126 * C126 + C127 * C127 + C128 * C128 + C129 * C129 + C130 * C130 + C131 * C131 + C132 * C132 + C133 * C133 + C134 * C134 + C135 * C135 + C136 * C136 + C137 * C137 + C138 * C138 + C139 * C139 + C140 * C140 + C141 * C141 + C142 * C142 + C143 * C143 + C144 * C144 + C145 * C145 + C146 * C146 + C147 * C147 + C148 * C148 + C149 * C149 + C150 * C150 + C151 * C151 + C152 * C152 + C153 * C153 + C154 * C154 + C155 * C155 + C156 * C156 + C157 * C157 + C158 * 158 + C159 * * C159 + C160 * C160 + C161 * C161 + C162 * C162 + C163 * C163 + C164 * C164 + C165 * C165 + C166 * C166 + C167 * C167 + C168 * C168 + C169 * C169 + C170 * C170 + C171 * C171 + C172 * C172 + C173 * C173 + C174 * C174 + C175 * C175 + C176 * C176 + C177 * C177 + C178 * C178 + C179 * C179 + C180 * C180 + C181 * C181 + C182 * C182 + C183 * C183 + C184 * C184 + C185 * C185 + C186 * C186 + C187 * C187 + C188 * C188 + C189 * C189 + C190 * C190 + C191 * C191 + C192 * C192 + C193 * C193 + C194 * C194 + C195 * C195 + C196 * C196 + C197 * C197 + C198 * C198 + C199 * C199) - (200 * AVGC200 * AVGC200)) / 199)
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I get an Error in Formula Syntax when I test your formula. I'm not going through it to find out where the error might be. Please try the following instead (it is shorter and does not have any syntax errors):
AVGC200 - 2 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 + C21 ^ 2 + C22 ^ 2 + C23 ^ 2 + C24 ^ 2 + C25 ^ 2 + C26 ^ 2 + C27 ^ 2 + C28 ^ 2 + C29 ^ 2 + C30 ^ 2 + C31 ^ 2 + C32 ^ 2 + C33 ^ 2 + C34 ^ 2 + C35 ^ 2 + C36 ^ 2 + C37 ^ 2 + C38 ^ 2 + C39 ^ 2 + C40 ^ 2 + C41 ^ 2 + C42 ^ 2 + C43 ^ 2 + C44 ^ 2 + C45 ^ 2 + C46 ^ 2 + C47 ^ 2 + C48 ^ 2 + C49 ^ 2 + C50 ^ 2 + C51 ^ 2 + C52 ^ 2 + C53 ^ 2 + C54 ^ 2 + C55 ^ 2 + C56 ^ 2 + C57 ^ 2 + C58 ^ 2 + C59 ^ 2 + C60 ^ 2 + C61 ^ 2 + C62 ^ 2 + C63 ^ 2 + C64 ^ 2 + C65 ^ 2 + C66 ^ 2 + C67 ^ 2 + C68 ^ 2 + C69 ^ 2 + C70 ^ 2 + C71 ^ 2 + C72 ^ 2 + C73 ^ 2 + C74 ^ 2 + C75 ^ 2 + C76 ^ 2 + C77 ^ 2 + C78 ^ 2 + C79 ^ 2 + C80 ^ 2 + C81 ^ 2 + C82 ^ 2 + C83 ^ 2 + C84 ^ 2 + C85 ^ 2 + C86 ^ 2 + C87 ^ 2 + C88 ^ 2 + C89 ^ 2 + C90 ^ 2 + C91 ^ 2 + C92 ^ 2 + C93 ^ 2 + C94 ^ 2 + C95 ^ 2 + C96 ^ 2 + C97 ^ 2 + C98 ^ 2 + C99 ^ 2 + C100 ^ 2 + C101 ^ 2 + C102 ^ 2 + C103 ^ 2 + C104 ^ 2 + C105 ^ 2 + C106 ^ 2 + C107 ^ 2 + C108 ^ 2 + C109 ^ 2 + C110 ^ 2 + C111 ^ 2 + C112 ^ 2 + C113 ^ 2 + C114 ^ 2 + C115 ^ 2 + C116 ^ 2 + C117 ^ 2 + C118 ^ 2 + C119 ^ 2 + C120 ^ 2 + C121 ^ 2 + C122 ^ 2 + C123 ^ 2 + C124 ^ 2 + C125 ^ 2 + C126 ^ 2 + C127 ^ 2 + C128 ^ 2 + C129 ^ 2 + C130 ^ 2 + C131 ^ 2 + C132 ^ 2 + C133 ^ 2 + C134 ^ 2 + C135 ^ 2 + C136 ^ 2 + C137 ^ 2 + C138 ^ 2 + C139 ^ 2 + C140 ^ 2 + C141 ^ 2 + C142 ^ 2 + C143 ^ 2 + C144 ^ 2 + C145 ^ 2 + C146 ^ 2 + C147 ^ 2 + C148 ^ 2 + C149 ^ 2 + C150 ^ 2 + C151 ^ 2 + C152 ^ 2 + C153 ^ 2 + C154 ^ 2 + C155 ^ 2 + C156 ^ 2 + C157 ^ 2 + C158 ^ 2 + C159 ^ 2 + C160 ^ 2 + C161 ^ 2 + C162 ^ 2 + C163 ^ 2 + C164 ^ 2 + C165 ^ 2 + C166 ^ 2 + C167 ^ 2 + C168 ^ 2 + C169 ^ 2 + C170 ^ 2 + C171 ^ 2 + C172 ^ 2 + C173 ^ 2 + C174 ^ 2 + C175 ^ 2 + C176 ^ 2 + C177 ^ 2 + C178 ^ 2 + C179 ^ 2 + C180 ^ 2 + C181 ^ 2 + C182 ^ 2 + C183 ^ 2 + C184 ^ 2 + C185 ^ 2 + C186 ^ 2 + C187 ^ 2 + C188 ^ 2 + C189 ^ 2 + C190 ^ 2 + C191 ^ 2 + C192 ^ 2 + C193 ^ 2 + C194 ^ 2 + C195 ^ 2 + C196 ^ 2 + C197 ^ 2 + C198 ^ 2 + C199 ^ 2 - 200 * AVGC200 ^ 2) / 199)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|