| Welcome Guest, please  sign in  to participate in a discussion. | 	Search | 	Active Topics |  | 
	
	
	
	
		Registered User Joined: 9/20/2010 Posts: 16 
	 | 
	
		 
	How do I create a PCF for: 
	Number = ((Upper BB Value - Lower BB Value)/(Lower BB Value)) * 100  
	  
	Thanks 
	 | 
	 | 
	
	
	
		  Administration
  Joined: 9/30/2004 Posts: 9,187 
	 | 
	
		 
	I don't know the formula but if you add Bollinger Bandwidth to your chart you can click and select "Create Scan Conition" if you want to use in a scan or "Show Values in Watchlist" if you want to use as a sort column. 
	 | 
	 | 
	
	
	
		Registered User Joined: 9/20/2010 Posts: 16 
	 | 
	
		 
	I did not communicate clearly about the PCF. What I want is PCF for : 
	(Upper BB Value - Lower BB Value)/Lower BB Value 
	  
	I appreciate you taking the time, 
	  
	Thanks, 
	  
	Yazz 
	 | 
	 | 
	
	
	
		 
   Worden Trainer
  Joined: 10/7/2004 Posts: 65,138 
	 | 
	
		 
	We would need to know the Period and Std Dev settings of your Bollinger Bands to create an Indicator Formula for this. For example, if you have a Period of 20 and a Std Dev of 2.00, the first formula would be: 
	100 * ((AVGC20 + 2 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 - 20 * AVGC20 ^ 2) / 20)) / (AVGC20 - 2 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 - 20 * AVGC20 ^ 2) / 20)) - 1) 
	And the second formula would be: 
	((AVGC20 + 2 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 - 20 * AVGC20 ^ 2) / 20)) / (AVGC20 - 2 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 - 20 * AVGC20 ^ 2) / 20)) - 1) 
	Modelling Bollinger Bands (& Standard Deviation) in a TC PCF 
  -Bruce Personal Criteria Formulas TC2000 Support Articles
	 | 
	 | 
	
	
	
		Registered User Joined: 9/20/2010 Posts: 16 
	 | 
	
		 
	Bruce, 
	Thank you for your help. 
	  
	yazz 
	 | 
	 | 
	
	
	
		 
   Worden Trainer
  Joined: 10/7/2004 Posts: 65,138 
	 | 
	
		 
	You're welcome. 
  -Bruce Personal Criteria Formulas TC2000 Support Articles
	 | 
	 | 
| 
Guest-1 |