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

PCF Help - 5 consecutive Green bars between C1 and C10 Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
grimmer01
Posted : Thursday, April 26, 2012 5:40:01 PM
Registered User
Joined: 2/24/2005
Posts: 58

Hello All, I am having a challenge figuring out how to write an "effecient" way to show a condition for 5 consecutive green Bars between C2 and C10.  

I realize i could write a lot of "or"s and make it lengthy, but i was hoping someone could show me a way to streamline the PCF.

 

thanks.

 

Will

grimmer01
Posted : Thursday, April 26, 2012 6:07:38 PM
Registered User
Joined: 2/24/2005
Posts: 58

this is what i came up with so far, but, I'm thinking there is a more effecient way to write the PCF: 

 

 

(C1 > C2 and C2 > C3 and C3 > C4 and C4 > C5 and C5 > C6 ) or
(C2 > C3 and C3 > C4 and C4 > C5 and C5 > C6 and C6 > C7 ) or
(C3 > C4 and C4 > C5 and C5 > C6 and C6 > C7  and C7 > C8) or
(C4 > C5 and C5 > C6 and C6 > C7  and C7 > C8 and C8 > C9) or
(C5 > C6 and C6 > C7  and C7 > C8 and C8 > C9 and C9 > C10) or
(C6 > C7  and C7 > C8 and C8 > C9 and C9 > C10 and C10 > C11) 
Bruce_L
Posted : Thursday, April 26, 2012 7:20:01 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

I cannot think of an obvious way to make it more efficient as a Condition Formula.

You could just use:

C1 > C2 and C2 > C3 and C3 > C4 and C4 > C5 and C5 > C6

And use it in a Custom PCF % True Indicator however. If you set the Period to 6 and the Average Type to Simple, you could click on it and select Create Scan Condition to check for the Custom PCF % True Indicator to be Greater Than 0.



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