| PaulEarley | 
				 
				
					
					| 
						Gold User, Member, TeleChart
					 | 
				 
				
					
					| Registered User | 
				 
				
					
					 | 
				 
				
					
					 | 
				 
				
					
					 | 
				 
				
					
					 | 
				 
				
					
					| Unsure | 
				 
			 
	 | 
	
			
				
					
				 
				
					
					| Friday, August 19, 2005 | 
				 
				
					
					| Saturday, July 29, 2006 7:09:05 AM | 
				 
				
					
					5 [0.00% of all post / 0.00 posts per day] | 
				 
			 
	 | 
	
		
		
			
		 
	
		
		
			
				Thanks for the input. I worked through the equations carefully and adapted them slightly to get what I need. I have enjoyed this discussion, because it made me dig into the mathmatics more. Thanks to all Paul Earley
			 | 
		 
	
		
		
			
				I know I am on this thread on a totally different level (although I have appreciated trying to recall my statistics). When I use either formula, I get a value of about 27.6 for a test on a stock that had an upper BB at about 87.4 on the day under consideration. 
  Am I misunderstanding the use of the equation? I was trying to scan for stocks that close above their upper BB "yesterday". 
  Paul Earley
			 | 
		 
	
		
		
			
				I ensured that it was calculating against ALL STOCKS. But the formula does not seem to calculate TRUE for stocks that closed above BB. The "Test" also does not accurately depict a close above the upper BB. 
  Could you cross check it on your system if you have the time? I appreciate all the help. Paul
			 | 
		 
	
		
		
			
				Jim and Bruce: Thanks for all the great help. I am trying to refine my short selections. 
  When I apply Jim's formula to ALL stocks, I get zero items returned, despite the fact that when I review stocks I can see many closes > upper BB. Any thoughts as to what I am doing worng? (The formula tests out TRUE for IBM).
  Sorry to be such a newbie. I program for a living but can't quite get this PCF thing. Paul Earley
			 | 
		 
	
		
		
			
				Bruce: Does this mean that to write a Boolean PCF that is true if a stock closes yesterday higher than the upper Bollinger band, it would read: c1 > AVGC21+2*SQR(((C-AVGC21)^2 +(C1-AVGC21)^2 +(C2-AVGC21)^2 +(C3-AVGC21)^2 +(C4-AVGC21)^2 +(C5-AVGC21)^2 +(C6-AVGC21)^2 +(C7-AVGC21)^2 +(C8-AVGC21)^2 +(C9-AVGC21)^2 +(C10-AVGC21)^2 +(C11-AVGC21)^2 +(C12-AVGC21)^2 +(C13-AVGC21)^2 +(C14-AVGC21)^2 +(C15-AVGC21)^2 +(C16-AVGC21)^2 +(C17-AVGC21)^2 +(C18-AVGC21)^2 +(C19-AVGC21)^2 +(C20-AVGC21)^2)/20)
  Paul Earley
			 | 
		 
	
		 
	
 |