Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Can't update the PC formula ? Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
docmba
Posted : Friday, February 22, 2008 1:43:51 PM
Gold Customer 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)
Bruce_L
Posted : Friday, February 22, 2008 1:59:50 PM


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
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.