| Registered User Joined: 7/8/2008
 Posts: 14
 
 | 
	Hi Bruce, 
	  
	Trying to write a simple formula for price within 5% of 40d MA.   Getting an error.  Please help. 
	c<= avec40*1.05 and 
	c>= avec40*.95  
	Thanks 
	  | 
	
	|  
  Worden Trainer
 
 Joined: 10/7/2004
 Posts: 65,138
 
 | 
	The e needs to be a g: 
	.95 * AVGC40 <= C AND C <= 1.05 * AVGC40 
	This could also be written as: 
	ABS(C / AVGC40 - 1) <= .05 
 -Bruce
 Personal Criteria Formulas
 TC2000 Support Articles
 |