| Registered User Joined: 12/23/2010
 Posts: 10
 
 | 
	Please help me determine the following 
	Bar 1 must be a bullish green bar - one whose range is greater than the previous 10 bars. 
	Bar 2 must be a red bar. This bar must have a range within the top 65% of Bar 1, - bar 2 must trade above the high of Bar 1. | 
	
	| Registered User Joined: 12/23/2010
 Posts: 10
 
 | 
	Correction to line 2 
	Bar 2 must be a red bar. This bar must have a range within the top 65% of Bar 1, - bar 2 must NOT trade above the high of Bar 1. | 
	
	| Registered User Joined: 12/30/2004
 Posts: 123
 
 | 
	Try this while you wait for tech support on Monday. 
	H <= H1 and L >= (L1 * .65)  and C1 > O1 and C < O and L1 > MaxH10.2 | 
	
	|  
  Worden Trainer
 
 Joined: 10/7/2004
 Posts: 65,138
 
 | 
	If by red bar you mean the current close is below the previous close and by range is greater than the previous 10-bars you mean the high minus low is greater than the high minus low of the previous 10-bars: 
	C < C1 AND .35 * L1 + .65 * H1 <= L AND H <= H1 AND C1 > C2 AND H1 - L1 > H2 - L2 AND H1 - L1 > H3- L3 AND H1 - L1 > H4- L4 AND H1 - L1 > H5- L5 AND H1 - L1 > H6- L6 AND H1 - L1 > H7- L7 AND H1 - L1 > H8- L8 AND H1 - L1 > H9- L9 AND H1 - L1 > H10- L10 AND H1 - L1 > H11 - L11 
	If by red bar you mean the current close is below the current open and by range is greater than the previous 10-bars you mean the high minus low is greater than the high minus low of the previous 10-bars: 
	C < O AND .35 * L1 + .65 * H1 <= L AND H <= H1 AND C1 > O1 AND H1 - L1 > H2 - L2 AND H1 - L1 > H3- L3 AND H1 - L1 > H4- L4 AND H1 - L1 > H5- L5 AND H1 - L1 > H6- L6 AND H1 - L1 > H7- L7 AND H1 - L1 > H8- L8 AND H1 - L1 > H9- L9 AND H1 - L1 > H10- L10 AND H1 - L1 > H11 - L11 
	If by red bar you mean the current close is below the previous close and by range is greater than the previous 10-bars you mean the low of the current bar is above the high of the previous 10-bars: 
	C < C1 AND .35 * L1 + .65 * H1 <= L AND H <= H1 AND C1 > C2 AND L1 > MAXH10.2 
	If by red bar you mean the current close is below the current open and by range is greater than the previous 10-bars you mean the low of the current bar is above the high of the previous 10-bars: 
	C < O AND .35 * L1 + .65 * H1 <= L AND H <= H1 AND C1 > O1 AND L1 > MAXH10.2 
	All definitions assume that the range being greater than the previous 10-bars is your particular definition of a "bullish bar". If you mean something else, you will need to provide additional clarification as to your intent. 
	PCF Formula DescriptionsHandy PCF example formulas to help you learn the syntax of PCFs!
 
 -Bruce
 Personal Criteria Formulas
 TC2000 Support Articles
 | 
	
	| Registered User Joined: 12/23/2010
 Posts: 10
 
 | 
	Bruce, 
	Thank you very much - this formula is the one that mneets my needs - C < O AND .35 * L1 + .65 * H1 <= L AND H <= H1 AND C1 > O1 AND H1 - L1 > H2 - L2 AND H1 - L1 > H3- L3 AND H1 - L1 > H4- L4 AND H1 - L1 > H5- L5 AND H1 - L1 > H6- L6 AND H1 - L1 > H7- L7 AND H1 - L1 > H8- L8 AND H1 - L1 > H9- L9 AND H1 - L1 > H10- L10 AND H1 - L1 > H11 - L11 
	I apologize for not being more clear - now, I see why I had so many problems in devising a workable formula by myself. 
	I greatly appreciate your assistance and quick reply - frankly, I am blown away with the efficiency - much obliged ... and 
	Best regards, 
	Lakota | 
	
	|  
  Worden Trainer
 
 Joined: 10/7/2004
 Posts: 65,138
 
 | 
	You're welcome. Our pleasure. 
 -Bruce
 Personal Criteria Formulas
 TC2000 Support Articles
 |