Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

want new formulas Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
shers777
Posted : Wednesday, April 3, 2013 9:42:51 AM
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.

shers777
Posted : Wednesday, April 3, 2013 10:01:39 AM
Registered User
Joined: 2/3/2012
Posts: 2

3. formula for stock price - 52 week high greater than 2 times 52 week low.

Bruce_L
Posted : Wednesday, April 3, 2013 10:16:39 AM


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 Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
esc952
Posted : Friday, April 5, 2013 1:31:54 AM
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

Bruce_L
Posted : Friday, April 5, 2013 7:35:17 AM


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
clyd
Posted : Monday, April 8, 2013 11:26:02 AM
Registered User
Joined: 10/7/2004
Posts: 5

How do I identify only the top 20 stocks within 10% of last 24 wwk high?

Bruce_L
Posted : Monday, April 8, 2013 11:32:04 AM


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
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.