| Welcome Guest, please  sign in  to participate in a discussion. | Search | 	Active Topics | | 
	
	
	| Registered User Joined: 2/3/2012
 Posts: 2
 
 | 
 1. todays price is within 10% of 52 week high. 
 2. todays closing price is in the top 10% of todays range. | 
	|  | 
	
	
	| Registered User Joined: 2/3/2012
 Posts: 2
 
 | 
 3. formula for stock price - 52 week high greater than 2 times 52 week low. | 
	|  | 
	
	
	|  
  Worden Trainer
 
 Joined: 10/7/2004
 Posts: 65,138
 
 | 
	 QUOTE (shers777) 1. todays price is within 10% of 52 week high. 
	You could try the following Daily Condition Formula: 
	C >= .9 * MAXH252 
	Or the following Weekly Condition Formula: 
	C >= .9 * MAXH52 
	 QUOTE (shers777) 2. todays closing price is in the top 10% of todays range. 
	You could try the following Daily Condition Formula: 
	STOC1 >= 90 
	Understanding Stochastics 
	 QUOTE (shers777) 3. formula for stock price - 52 week high greater than 2 times 52 week low. 
	You could try the following Daily Condition Formula: 
	MAXH252 > 2 * MINL252 
	Or the following Weekly Condition Formula: 
	MAXH52 > 2 * MINL52 
	PCF Formula DescriptionsHandy PCF example formulas to help you learn the syntax of PCFs!
 
 -Bruce
 Personal Criteria Formulas
 TC2000 Support Articles
 | 
	|  | 
	
	
	| Registered User Joined: 2/11/2013
 Posts: 78
 
 | 
	 QUOTE (Bruce_L) 
	 QUOTE (shers777) 2. todays closing price is in the top 10% of todays range. 
	You could try the following Daily Condition Formula: 
	STOC1 >= 90 
	Understanding Stochastics 
	 
	Wouldn't the following meet requested condition 2 better? 
	C >= ((H - L) * .9) + L | 
	|  | 
	
	
	|  
  Worden Trainer
 
 Joined: 10/7/2004
 Posts: 65,138
 
 | 
	You might want to read through the referenced topic as your version is exactly the same thing only longer. 
	It will certainly work just as well, but it isn't better or worse (other than the built in Stochastic function being a bit more efficient to both write and calculate). 
 -Bruce
 Personal Criteria Formulas
 TC2000 Support Articles
 | 
	|  | 
	
	
	| Registered User Joined: 10/7/2004
 Posts: 5
 
 | 
	How do I identify only the top 20 stocks within 10% of last 24 wwk high? | 
	|  | 
	
	
	|  
  Worden Trainer
 
 Joined: 10/7/2004
 Posts: 65,138
 
 | 
	You can determine if a stock is within 10% of its 24-Week High by using the following Weekly Condition Formula: 
	C >= .9 * MAXH24 
	I'm not sure what would constitute the "top 20 stocks", but if it is by how close they are to their 24-Week High, you could use the following Weekly Indicator Formula as WatchList Column and sort: 
	100 * (C / MAXH24 - 1) 
	It is the percentage that the current price is below the 24-bar high. 
	Adding & Editing WatchList Columns 
 -Bruce
 Personal Criteria Formulas
 TC2000 Support Articles
 | 
	|  | 
| Guest-1 |