Registered User Joined: 3/15/2008 Posts: 45 
	 | 
	
		I'm looking to analyze price bar spreads and want to know if you can write a pcf for: 
 
today's price bar is at least 50% longer than the price bars for previous 5 days. 
 
Thanks 
 
	 | 
	
	
		 
   Worden Trainer
  Joined: 10/7/2004 Posts: 65,138 
	 | 
	
		If you want it to be 50% larger than the average range, please try the following: 
 
H - L >= 1.5 * (AVGH5.1 - AVGL5.1) AND H > L 
 
If you want it to be 50% larger than the maximum range, please try the following instead: 
 
H - L >= 1.5 * (H1 - L1) AND H - L >= 1.5 * (H2 - L2) AND H - L >= 1.5 * (H3 - L3) AND H - L >= 1.5 * (H4 - L4) AND H - L >= 1.5 * (H5 - L5) AND H > L 
 
You may wish to review the following: 
 
PCF Formula Descriptions 
How to create a Personal Criteria Forumula (PCF) 
Handy PCF example formulas to help you learn the syntax of PCFs!
  -Bruce Personal Criteria Formulas TC2000 Support Articles
	 |