Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Different results using condition PCF as column Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
rwefree1
Posted : Monday, February 17, 2014 4:09:57 PM
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

Bruce_L
Posted : Tuesday, February 18, 2014 5:38:34 PM


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
rwefree1
Posted : Tuesday, February 18, 2014 6:26:22 PM
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.

Bruce_L
Posted : Tuesday, February 18, 2014 6:36:17 PM


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
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.