Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Worden Discussion Forum » Customer Training & Support » Ask a Trainer - TC2000 version 12/18 » Formula Help Please

Formula Help Please Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
JustJewels
Posted : Tuesday, August 21, 2012 8:10:55 PM
Registered User
Joined: 7/8/2008
Posts: 14

Hi - Looking for some help creating following formulas:

 

1.  I want a boolean formula for stocks closing price within 10% of 52 week high.

 

2.  Also, boolean formula for stocks within a trading range of 10% over a period of 6 weeks.

 

3.  And a formula for stocks that have increased in value by 50% or more from their 52 week low.

 

Thanks for your help,

J

 
Back to top
StockGuy
Posted : Tuesday, August 21, 2012 10:49:48 PM

Administration

Joined: 9/30/2004
Posts: 9,187

1. C > MAXC52 * .09 - make sure you set the time frame on the condition to Weekly.

2. (AVGH6 - AVGL6) / AVGC6 <= .1 - Again, set to Weekly. You could get more strict on this maybe using (MAXH6 - MINL6) / AVGC6 <= .1 That would mean the difference in the max high and min low could be no more than 10% of the average close.

3. C / MINL52 >= 1.5 - set time frame on condition to Weekly.
Back to top
JustJewels
Posted : Friday, August 24, 2012 10:01:00 AM
Registered User
Joined: 7/8/2008
Posts: 14

Thanks for the help
Back to top
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.