Registered User Joined: 11/5/2009 Posts: 4
|
Using the following formula as a condition in a scan and also as condition in column. I'm getting check marks in the column that stock was up 20% even though my custom indicator spike says NO and chart says NO.. Indicator formula is C>=1.20*C1
Any help?
C >= 1.20 * C1 OR C1 >= 1.20 * C2 OR C2 >= 1.20 * C3 OR C3 >= 1.20 * C4 OR C4 >= 1.20 * C5 OR C5 >= 1.20 * C6 OR C6 >= 1.20 * C7 OR C7 >= 1.20 * C8 OR C8 >= 1.20 * C9 OR C9 >= 1.20 * C10 OR C10 >= 1.20 * C11 OR C11 >= 1.20 * C12 OR C12 >= 1.20 * C13 OR C13 >= 1.20 * C14 OR C14 >= 1.20 * C15 OR C15 >= 1.20 * C16 OR C16 >= 1.20 * C17 OR C17 >= 1.20 * C18 OR C18 >= 1.20 * C19 OR C19 >= 1.20 * C20 OR C20 >= 1.20 * C21 OR C21 >= 1.20 * C22 OR C22 >= 1.20 * C23 OR C23 >= 1.20 * C24 OR C24 >= 1.20 * C5 OR C25 >= 1.20 * C26 OR C26 >= 1.20 * C27 OR C27 >= 1.20 * C28 OR C28 >= 1.20 * C29 OR C29 >= 1.20 * C30 OR C30 >= 1.20 * C31 OR C31 >= 1.20 * C32 OR C32 >= 1.20 * C33 OR C33 >= 1.20 * C34 OR C34 >= 1.20 * C35 OR C35 >= 1.20 * C36 OR C36 >= 1.20 * C37 OR C37 >= 1.20 * C38 OR C38 >= 1.20 * C39 OR C39 >= 1.20 * C40 OR C40 >= 1.20 * C41 OR C41 >= 1.20 * C42 OR C42 >= 1.20 * C43 OR C43 >= 1.20 * C44 OR C44 >= 1.20 * C45 OR C45 >= 1.20 * C46 OR C46 >= 1.20 * C47 OR C47 >= 1.20 * C48 OR C48 >= 1.20 * C49 OR C49 >= 1.20 * C50 OR C50 >= 1.20 * C51 OR C51 >= 1.20 * C52 OR C52 >= 1.20 * C53 OR C53 >= 1.20 * C54 OR C54 >= 1.20 * C55 OR C55 >= 1.20 * C56 OR C56 >= 1.20 * C57 OR C57 >= 1.20 * C58 OR C58 >= 1.20 * C59 OR C59 >= 1.20 * C60 OR C60 >= 1.20 * C61 OR C61 >= 1.20 * C62 OR C62 >= 1.20 * C63 OR C63 >= 1.20 * C64 OR C64 >= 1.20 * C65 OR C65 >= 1.20 * C66 OR C66 >= 1.20 * C67 OR C67 >= 1.20 * C68 OR C68 >= 1.20 * C69 OR C69 >= 1.20 * C70 OR C70 >= 1.20 * C71 OR C71 >= 1.20 * C72 OR C72 >= 1.20 * C73 OR C73 >= 1.20 * C74 OR C74 >= 1.20 * C75 OR C75 >= 1.20 * C76 OR C76 >= 1.20 * C77 OR C77 >= 1.20 * C78 OR C78 >= 1.20 * C79 OR C79 >= 1.20 * C80 OR C80 >= 1.20 * C81 OR C81 >= 1.20 * C82 OR C82 >= 1.20 * C83 OR C83 >= 1.20 * C84 OR C84 >= 1.20 * C85 OR C85 >= 1.20 * C86 OR C86 >= 1.20 * C87 OR C87 >= 1.20 * C88 OR C88 >= 1.20 * C89 OR C89 >= 1.20 * C90
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I haven't found it, but I'm guessing there has to be a typo in there somewhere as it does not match the results of a 90-Period Simple Custom PCF % True Indicator using your formula.
That said, when I replace it with an almost identical formula which I created on my own, the results of the Condition Formula match the results of a 90-Period Simple Custom PCF % True Indicator.
C >= 1.2 * C1 OR C1 >= 1.2 * C2 OR C2 >= 1.2 * C3 OR C3 >= 1.2 * C4 OR C4 >= 1.2 * C5 OR C5 >= 1.2 * C6 OR C6 >= 1.2 * C7 OR C7 >= 1.2 * C8 OR C8 >= 1.2 * C9 OR C9 >= 1.2 * C10 OR C10 >= 1.2 * C11 OR C11 >= 1.2 * C12 OR C12 >= 1.2 * C13 OR C13 >= 1.2 * C14 OR C14 >= 1.2 * C15 OR C15 >= 1.2 * C16 OR C16 >= 1.2 * C17 OR C17 >= 1.2 * C18 OR C18 >= 1.2 * C19 OR C19 >= 1.2 * C20 OR C20 >= 1.2 * C21 OR C21 >= 1.2 * C22 OR C22 >= 1.2 * C23 OR C23 >= 1.2 * C24 OR C24 >= 1.2 * C25 OR C25 >= 1.2 * C26 OR C26 >= 1.2 * C27 OR C27 >= 1.2 * C28 OR C28 >= 1.2 * C29 OR C29 >= 1.2 * C30 OR C30 >= 1.2 * C31 OR C31 >= 1.2 * C32 OR C32 >= 1.2 * C33 OR C33 >= 1.2 * C34 OR C34 >= 1.2 * C35 OR C35 >= 1.2 * C36 OR C36 >= 1.2 * C37 OR C37 >= 1.2 * C38 OR C38 >= 1.2 * C39 OR C39 >= 1.2 * C40 OR C40 >= 1.2 * C41 OR C41 >= 1.2 * C42 OR C42 >= 1.2 * C43 OR C43 >= 1.2 * C44 OR C44 >= 1.2 * C45 OR C45 >= 1.2 * C46 OR C46 >= 1.2 * C47 OR C47 >= 1.2 * C48 OR C48 >= 1.2 * C49 OR C49 >= 1.2 * C50 OR C50 >= 1.2 * C51 OR C51 >= 1.2 * C52 OR C52 >= 1.2 * C53 OR C53 >= 1.2 * C54 OR C54 >= 1.2 * C55 OR C55 >= 1.2 * C56 OR C56 >= 1.2 * C57 OR C57 >= 1.2 * C58 OR C58 >= 1.2 * C59 OR C59 >= 1.2 * C60 OR C60 >= 1.2 * C61 OR C61 >= 1.2 * C62 OR C62 >= 1.2 * C63 OR C63 >= 1.2 * C64 OR C64 >= 1.2 * C65 OR C65 >= 1.2 * C66 OR C66 >= 1.2 * C67 OR C67 >= 1.2 * C68 OR C68 >= 1.2 * C69 OR C69 >= 1.2 * C70 OR C70 >= 1.2 * C71 OR C71 >= 1.2 * C72 OR C72 >= 1.2 * C73 OR C73 >= 1.2 * C74 OR C74 >= 1.2 * C75 OR C75 >= 1.2 * C76 OR C76 >= 1.2 * C77 OR C77 >= 1.2 * C78 OR C78 >= 1.2 * C79 OR C79 >= 1.2 * C80 OR C80 >= 1.2 * C81 OR C81 >= 1.2 * C82 OR C82 >= 1.2 * C83 OR C83 >= 1.2 * C84 OR C84 >= 1.2 * C85 OR C85 >= 1.2 * C86 OR C86 >= 1.2 * C87 OR C87 >= 1.2 * C88 OR C88 >= 1.2 * C89 OR C89 >= 1.2 * C90
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 11/5/2009 Posts: 4
|
Thanks Bruce, I'll rework it 10 days at a time and see if I can find the typo.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I'm not sure if it will help or not, but I think it is missing a character. It appears to be one character shorter than I think your version should be.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|