Subscription & data-feed pricing Class schedule

Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.

 Scan for stocks bouncing in a lateral channel Topic Rating:     Previous Topic · Next Topic Watch this topic · Print this topic ·
Bruce_L
 Posted : Thursday, July 26, 2007 7:54:53 AM  Worden Trainer

Joined: 10/7/2004
Posts: 65,138
qew,
You could add something like the following:

MAXH5 > MINL5

This would ensure the symbol has a range greater than zero for the last 5-Periods (you can adjust this number as desired).

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
 Posted : Thursday, August 23, 2007 11:30:26 PM
Registered User
Joined: 5/2/2007
Posts: 59
Well mine is a little different,i saw the original video,i wouldn't change much in there except that I'm looking for stocks already channeling BUT currently in the lower 10-30% of the channel, any suggestions?
Bruce_L
 Posted : Monday, August 27, 2007 9:26:20 AM  Worden Trainer

Joined: 10/7/2004
Posts: 65,138
You could try using Stochastics for this. If you are looking at a 40-Period Channel, you could use something like the following:

STOC40 <= 30

A 60-Period Channel would change the Stochastics Period to 60:

STOC60 <= 30

You may wish to review the following:

Understanding Stochastics
How to create a Personal Criteria Forumula (PCF)
Handy PCF example formulas to help you learn the syntax of PCFs!
PCF Formula Descriptions

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
osteon
 Posted : Wednesday, January 06, 2010 7:34:44 PM
Registered User
Joined: 1/30/2005
Posts: 46
Could you write a formula for a 10day moving average crossing a 30 day moving average in either direction.
Thanks,
Osteon
Bruce_L
 Posted : Thursday, January 07, 2010 8:00:21 AM  Worden Trainer

Joined: 10/7/2004
Posts: 65,138
osteon,
Please try one or more of the following Personal Criteria Formulas:

SMA10 crossing SMA30 (either direction):

SGN(AVGC10 - AVGC30) <> SGN(AVGC10.1 - AVGC30.1)

EMA10 crossing EMA30 (either direction):

SGN(XAVGC10 - XAVGC30) <> SGN(XAVGC10.1 - XAVGC30.1)

SMA10 crossing EMA30 (either direction):

SGN(AVGC10 - XAVGC30) <> SGN(AVGC10.1 - XAVGC30.1)

EMA10 crossing SMA30 (either direction):

SGN(XAVGC10 - AVGC30) <> SGN(XAVGC10.1 - AVGC30.1)

SMA10 xUp SMA30:

AVGC10 > AVGC30 AND AVGC10.1 <= AVGC30.1

EMA10 xUp EMA30:

XAVGC10 > XAVGC30 AND XAVGC10.1 <= XAVGC30.1

SMA10 xUp EMA30:

AVGC10 > XAVGC30 AND AVGC10.1 <= XAVGC30.1

EMA10 xUp SMA30:

XAVGC10 > AVGC30 AND XAVGC10.1 <= AVGC30.1

SMA10 xDn SMA30:

AVGC10 < AVGC30 AND AVGC10.1 >= AVGC30.1

EMA10 xDn EMA30:

XAVGC10 < XAVGC30 AND XAVGC10.1 >= XAVGC30.1

SMA10 xDn EMA30:

AVGC10 < XAVGC30 AND AVGC10.1 >= XAVGC30.1

EMA10 xDn SMA30:

XAVGC10 < AVGC30 AND XAVGC10.1 >= AVGC30.1

You may wish to review the following:

Moving Average PCF Templates
Things to check if your moving averages don't "seem right" or "seem to match"

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dmyers
 Posted : Thursday, February 11, 2010 1:02:54 PM
Registered User
Joined: 12/29/2009
Posts: 44
Hi all

I can't seem to get the watchlist PCF correct.

I created the PCF called "The Watchlist PCF"

When I attrempt to add it to the watchlist, it does not appear in the list.

-Any way to draw som liner regression trendlines on the chart?

Thanks
Bruce_L
 Posted : Thursday, February 11, 2010 1:13:56 PM  Worden Trainer

Joined: 10/7/2004
Posts: 65,138
dmyers,
The Personal Criteria Formula most likely just isn't updated yet. You can manually update your PCFs by selecting Databank | Personal Criteria Formulas | Update All Criteria.

How to create a Personal Criteria Forumula (PCF)
Customize the Information Displayed in the WatchList

You can add Linear Regressions to your Charts either as Drawing Tools or as Indicators.

Drawing Trendlines, Regressions and Writing Notes on a chart
Adding, removing and saving indicators to a chart template

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dmyers
 Posted : Thursday, February 11, 2010 4:25:49 PM
Registered User
Joined: 12/29/2009
Posts: 44
Thanks the update fixed the issue.

Is there any method of automating the keystrokes so that all of these sorts are done automatically? Perhaps in the new Stockfinder program?

How can I add a PCF or sort that.

I'd like to add a regression indicator of 10 days to the volume. And then sort to find the ones that have a uptrend.

OR

Volume that is increasing over the moving average for X out of X days.

-Don
Bruce_L
 Posted : Thursday, February 11, 2010 4:36:53 PM  Worden Trainer

Joined: 10/7/2004
Posts: 65,138
dmyers,
TeleChart and StockFinder are very different programs with their own advantages and disadvantages. Some things are easier or quicker in TeleChart and some things are easier or quicker in StockFinder.

StockFinder vs TeleChart Features
Worden Product Comparison

You can Sort based on a Personal Criteria Formula by simply selecting that PCF as the Active Sort.

Create your own stock rankings using WatchLists and Sort conditions

You can even create a Column based on your Criteria so you can just left-click on the Column Header to use it as a Sort.

Customize the Information Displayed in the WatchList

QUOTE (dmyers)
I'd like to add a regression indicator of 10 days to the volume. And then sort to find the ones that have a uptrend.

(4.5 * V + 3.5 * V1 + 2.5 * V2 + 1.5 * V3 + .5 * V4 - .5 * V5 + 1.5 * V6 - 2.5 * V7 - 3.5 * V8 - 4.5 * V9) / 82.5 > 0

Using Linear Regression vs Classical Peaks/Valleys for Divergence Analysis

QUOTE (dmyers)
Volume that is increasing over the moving average for X out of X days.

I really can't help you create PCFs without knowing the specifics of what you want to create. What is the Moving Average Period and Type (Simple or Exponential)? What are X and Y in X out of Y days?

Moving Average PCF Templates
Things to check if your moving averages don't "seem right" or "seem to match"

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Art Lindsley
 Posted : Saturday, November 13, 2010 1:44:18 PM
Registered User
Joined: 7/23/2010
Posts: 84
Could this be converted for SF5 please? I'm speaking of the original video scan please
kenhi
 Posted : Saturday, November 13, 2010 2:42:20 PM
Registered User
Joined: 6/29/2005
Posts: 18
Is the following correct in finding channeling stocks

The scan for stocks bouncing in a lateral channel is the best telechart can do for this search.
Bruce_L
 Posted : Monday, November 15, 2010 10:16:01 AM  Worden Trainer

Joined: 10/7/2004
Posts: 65,138
Art Lindsley,
You may want to take a look at the channelling stocks topic.

kenhi,
I would not characterize your statement as true. That said, a better search would require better unambiguous objective definitions from which to work.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
kenhi
 Posted : Sunday, November 28, 2010 2:57:11 AM
Registered User
Joined: 6/29/2005
Posts: 18
Hi

You keep on asking me to watch the same video.
I am not getting what I am looking for from this video

1. Can you help me find stocks in the new york and nasdaq stock exchanges that are currently in a horizontal channel.
1. The upper channel = the high price hit at least three times in the last 80 bars on a daily chart
2. The lower channel = the lowest price hit at least three times in the last 80 bars pm a daily chart
3. Give the horizontal channel a 10 % leway
4. The distance between the upper and lower channel is at least \$ 3.00

After the list of channeling stocks are found I would like to see
1. The MACD fast line either breaking above or below the slow line and if the lines are above or below the zero line.

Can you please ask me questions if you need more information or please let me know if I cannot get the results I am looking for from telechart of stockfinder 5.

Is this better to be run using telecharts or stockfinder 5

Than You
Bruce_L
 Posted : Tuesday, November 30, 2010 1:41:54 PM  Worden Trainer

Joined: 10/7/2004
Posts: 65,138
kenhi,
The video reference was for Art Lindsley. Only the request for further clarification was for you.

The following Personal Criteria Formula checks for the High Price to have been within and then moved out of the top 10% of the total Range over the most recent 80 Trading days at least 3 times, for the Low Price to have been within and then moved out of the bottom 10% of the total Range over the last 80 Trading Days at least 3 times, for the total Range over the last 80 Trading Days to be at least \$3 and for the MACD Histogram to be crossing through zero in either direction (this is the same as the fast line crossing through the slow line of the non-Histogram version of MACD).

ABS(L > (MAXH80 + 9 * MINL80) / 10 AND L1 <= (MAXH80 + 9 * MINL80) / 10) - (L1 > (MAXH80 + 9 * MINL80) / 10 AND L2 <= (MAXH80 + 9 * MINL80) / 10) - (L2 > (MAXH80 + 9 * MINL80) / 10 AND L3 <= (MAXH80 + 9 * MINL80) / 10) - (L3 > (MAXH80 + 9 * MINL80) / 10 AND L4 <= (MAXH80 + 9 * MINL80) / 10) - (L4 > (MAXH80 + 9 * MINL80) / 10 AND L5 <= (MAXH80 + 9 * MINL80) / 10) - (L5 > (MAXH80 + 9 * MINL80) / 10 AND L6 <= (MAXH80 + 9 * MINL80) / 10) - (L6 > (MAXH80 + 9 * MINL80) / 10 AND L7 <= (MAXH80 + 9 * MINL80) / 10) - (L7 > (MAXH80 + 9 * MINL80) / 10 AND L8 <= (MAXH80 + 9 * MINL80) / 10) - (L8 > (MAXH80 + 9 * MINL80) / 10 AND L9 <= (MAXH80 + 9 * MINL80) / 10) - (L9 > (MAXH80 + 9 * MINL80) / 10 AND L10 <= (MAXH80 + 9 * MINL80) / 10) - (L10 > (MAXH80 + 9 * MINL80) / 10 AND L11 <= (MAXH80 + 9 * MINL80) / 10) - (L11 > (MAXH80 + 9 * MINL80) / 10 AND L12 <= (MAXH80 + 9 * MINL80) / 10) - (L12 > (MAXH80 + 9 * MINL80) / 10 AND L13 <= (MAXH80 + 9 * MINL80) / 10) - (L13 > (MAXH80 + 9 * MINL80) / 10 AND L14 <= (MAXH80 + 9 * MINL80) / 10) - (L14 > (MAXH80 + 9 * MINL80) / 10 AND L15 <= (MAXH80 + 9 * MINL80) / 10) - (L15 > (MAXH80 + 9 * MINL80) / 10 AND L16 <= (MAXH80 + 9 * MINL80) / 10) - (L16 > (MAXH80 + 9 * MINL80) / 10 AND L17 <= (MAXH80 + 9 * MINL80) / 10) - (L17 > (MAXH80 + 9 * MINL80) / 10 AND L18 <= (MAXH80 + 9 * MINL80) / 10) - (L18 > (MAXH80 + 9 * MINL80) / 10 AND L19 <= (MAXH80 + 9 * MINL80) / 10) - (L19 > (MAXH80 + 9 * MINL80) / 10 AND L20 <= (MAXH80 + 9 * MINL80) / 10) - (L20 > (MAXH80 + 9 * MINL80) / 10 AND L21 <= (MAXH80 + 9 * MINL80) / 10) - (L21 > (MAXH80 + 9 * MINL80) / 10 AND L22 <= (MAXH80 + 9 * MINL80) / 10) - (L22 > (MAXH80 + 9 * MINL80) / 10 AND L23 <= (MAXH80 + 9 * MINL80) / 10) - (L23 > (MAXH80 + 9 * MINL80) / 10 AND L24 <= (MAXH80 + 9 * MINL80) / 10) - (L24 > (MAXH80 + 9 * MINL80) / 10 AND L25 <= (MAXH80 + 9 * MINL80) / 10) - (L25 > (MAXH80 + 9 * MINL80) / 10 AND L26 <= (MAXH80 + 9 * MINL80) / 10) - (L26 > (MAXH80 + 9 * MINL80) / 10 AND L27 <= (MAXH80 + 9 * MINL80) / 10) - (L27 > (MAXH80 + 9 * MINL80) / 10 AND L28 <= (MAXH80 + 9 * MINL80) / 10) - (L28 > (MAXH80 + 9 * MINL80) / 10 AND L29 <= (MAXH80 + 9 * MINL80) / 10) - (L29 > (MAXH80 + 9 * MINL80) / 10 AND L30 <= (MAXH80 + 9 * MINL80) / 10) - (L30 > (MAXH80 + 9 * MINL80) / 10 AND L31 <= (MAXH80 + 9 * MINL80) / 10) - (L31 > (MAXH80 + 9 * MINL80) / 10 AND L32 <= (MAXH80 + 9 * MINL80) / 10) - (L32 > (MAXH80 + 9 * MINL80) / 10 AND L33 <= (MAXH80 + 9 * MINL80) / 10) - (L33 > (MAXH80 + 9 * MINL80) / 10 AND L34 <= (MAXH80 + 9 * MINL80) / 10) - (L34 > (MAXH80 + 9 * MINL80) / 10 AND L35 <= (MAXH80 + 9 * MINL80) / 10) - (L35 > (MAXH80 + 9 * MINL80) / 10 AND L36 <= (MAXH80 + 9 * MINL80) / 10) - (L36 > (MAXH80 + 9 * MINL80) / 10 AND L37 <= (MAXH80 + 9 * MINL80) / 10) - (L37 > (MAXH80 + 9 * MINL80) / 10 AND L38 <= (MAXH80 + 9 * MINL80) / 10) - (L38 > (MAXH80 + 9 * MINL80) / 10 AND L39 <= (MAXH80 + 9 * MINL80) / 10) - (L39 > (MAXH80 + 9 * MINL80) / 10 AND L40 <= (MAXH80 + 9 * MINL80) / 10) - (L40 > (MAXH80 + 9 * MINL80) / 10 AND L41 <= (MAXH80 + 9 * MINL80) / 10) - (L41 > (MAXH80 + 9 * MINL80) / 10 AND L42 <= (MAXH80 + 9 * MINL80) / 10) - (L42 > (MAXH80 + 9 * MINL80) / 10 AND L43 <= (MAXH80 + 9 * MINL80) / 10) - (L43 > (MAXH80 + 9 * MINL80) / 10 AND L44 <= (MAXH80 + 9 * MINL80) / 10) - (L44 > (MAXH80 + 9 * MINL80) / 10 AND L45 <= (MAXH80 + 9 * MINL80) / 10) - (L45 > (MAXH80 + 9 * MINL80) / 10 AND L46 <= (MAXH80 + 9 * MINL80) / 10) - (L46 > (MAXH80 + 9 * MINL80) / 10 AND L47 <= (MAXH80 + 9 * MINL80) / 10) - (L47 > (MAXH80 + 9 * MINL80) / 10 AND L48 <= (MAXH80 + 9 * MINL80) / 10) - (L48 > (MAXH80 + 9 * MINL80) / 10 AND L49 <= (MAXH80 + 9 * MINL80) / 10) - (L49 > (MAXH80 + 9 * MINL80) / 10 AND L50 <= (MAXH80 + 9 * MINL80) / 10) - (L50 > (MAXH80 + 9 * MINL80) / 10 AND L51 <= (MAXH80 + 9 * MINL80) / 10) - (L51 > (MAXH80 + 9 * MINL80) / 10 AND L52 <= (MAXH80 + 9 * MINL80) / 10) - (L52 > (MAXH80 + 9 * MINL80) / 10 AND L53 <= (MAXH80 + 9 * MINL80) / 10) - (L53 > (MAXH80 + 9 * MINL80) / 10 AND L54 <= (MAXH80 + 9 * MINL80) / 10) - (L54 > (MAXH80 + 9 * MINL80) / 10 AND L55 <= (MAXH80 + 9 * MINL80) / 10) - (L55 > (MAXH80 + 9 * MINL80) / 10 AND L56 <= (MAXH80 + 9 * MINL80) / 10) - (L56 > (MAXH80 + 9 * MINL80) / 10 AND L57 <= (MAXH80 + 9 * MINL80) / 10) - (L57 > (MAXH80 + 9 * MINL80) / 10 AND L58 <= (MAXH80 + 9 * MINL80) / 10) - (L58 > (MAXH80 + 9 * MINL80) / 10 AND L59 <= (MAXH80 + 9 * MINL80) / 10) - (L59 > (MAXH80 + 9 * MINL80) / 10 AND L60 <= (MAXH80 + 9 * MINL80) / 10) - (L60 > (MAXH80 + 9 * MINL80) / 10 AND L61 <= (MAXH80 + 9 * MINL80) / 10) - (L61 > (MAXH80 + 9 * MINL80) / 10 AND L62 <= (MAXH80 + 9 * MINL80) / 10) - (L62 > (MAXH80 + 9 * MINL80) / 10 AND L63 <= (MAXH80 + 9 * MINL80) / 10) - (L63 > (MAXH80 + 9 * MINL80) / 10 AND L64 <= (MAXH80 + 9 * MINL80) / 10) - (L64 > (MAXH80 + 9 * MINL80) / 10 AND L65 <= (MAXH80 + 9 * MINL80) / 10) - (L65 > (MAXH80 + 9 * MINL80) / 10 AND L66 <= (MAXH80 + 9 * MINL80) / 10) - (L66 > (MAXH80 + 9 * MINL80) / 10 AND L67 <= (MAXH80 + 9 * MINL80) / 10) - (L67 > (MAXH80 + 9 * MINL80) / 10 AND L68 <= (MAXH80 + 9 * MINL80) / 10) - (L68 > (MAXH80 + 9 * MINL80) / 10 AND L69 <= (MAXH80 + 9 * MINL80) / 10) - (L69 > (MAXH80 + 9 * MINL80) / 10 AND L70 <= (MAXH80 + 9 * MINL80) / 10) - (L70 > (MAXH80 + 9 * MINL80) / 10 AND L71 <= (MAXH80 + 9 * MINL80) / 10) - (L71 > (MAXH80 + 9 * MINL80) / 10 AND L72 <= (MAXH80 + 9 * MINL80) / 10) - (L72 > (MAXH80 + 9 * MINL80) / 10 AND L73 <= (MAXH80 + 9 * MINL80) / 10) - (L73 > (MAXH80 + 9 * MINL80) / 10 AND L74 <= (MAXH80 + 9 * MINL80) / 10) - (L74 > (MAXH80 + 9 * MINL80) / 10 AND L75 <= (MAXH80 + 9 * MINL80) / 10) - (L75 > (MAXH80 + 9 * MINL80) / 10 AND L76 <= (MAXH80 + 9 * MINL80) / 10) - (L76 > (MAXH80 + 9 * MINL80) / 10 AND L77 <= (MAXH80 + 9 * MINL80) / 10) - (L77 > (MAXH80 + 9 * MINL80) / 10 AND L78 <= (MAXH80 + 9 * MINL80) / 10) - (L78 > (MAXH80 + 9 * MINL80) / 10 AND L79 <= (MAXH80 + 9 * MINL80) / 10) - (L79 > (MAXH80 + 9 * MINL80) / 10 AND L80 <= (MAXH80 + 9 * MINL80) / 10) >= 3 AND ABS(H < (MINL80 + 9 * MAXH80) / 10 AND H1 >= (MINL80 + 9 * MAXH80) / 10) - (H1 < (MINL80 + 9 * MAXH80) / 10 AND H2 >= (MINL80 + 9 * MAXH80) / 10) - (H2 < (MINL80 + 9 * MAXH80) / 10 AND H3 >= (MINL80 + 9 * MAXH80) / 10) - (H3 < (MINL80 + 9 * MAXH80) / 10 AND H4 >= (MINL80 + 9 * MAXH80) / 10) - (H4 < (MINL80 + 9 * MAXH80) / 10 AND H5 >= (MINL80 + 9 * MAXH80) / 10) - (H5 < (MINL80 + 9 * MAXH80) / 10 AND H6 >= (MINL80 + 9 * MAXH80) / 10) - (H6 < (MINL80 + 9 * MAXH80) / 10 AND H7 >= (MINL80 + 9 * MAXH80) / 10) - (H7 < (MINL80 + 9 * MAXH80) / 10 AND H8 >= (MINL80 + 9 * MAXH80) / 10) - (H8 < (MINL80 + 9 * MAXH80) / 10 AND H9 >= (MINL80 + 9 * MAXH80) / 10) - (H9 < (MINL80 + 9 * MAXH80) / 10 AND H10 >= (MINL80 + 9 * MAXH80) / 10) - (H10 < (MINL80 + 9 * MAXH80) / 10 AND H11 >= (MINL80 + 9 * MAXH80) / 10) - (H11 < (MINL80 + 9 * MAXH80) / 10 AND H12 >= (MINL80 + 9 * MAXH80) / 10) - (H12 < (MINL80 + 9 * MAXH80) / 10 AND H13 >= (MINL80 + 9 * MAXH80) / 10) - (H13 < (MINL80 + 9 * MAXH80) / 10 AND H14 >= (MINL80 + 9 * MAXH80) / 10) - (H14 < (MINL80 + 9 * MAXH80) / 10 AND H15 >= (MINL80 + 9 * MAXH80) / 10) - (H15 < (MINL80 + 9 * MAXH80) / 10 AND H16 >= (MINL80 + 9 * MAXH80) / 10) - (H16 < (MINL80 + 9 * MAXH80) / 10 AND H17 >= (MINL80 + 9 * MAXH80) / 10) - (H17 < (MINL80 + 9 * MAXH80) / 10 AND H18 >= (MINL80 + 9 * MAXH80) / 10) - (H18 < (MINL80 + 9 * MAXH80) / 10 AND H19 >= (MINL80 + 9 * MAXH80) / 10) - (H19 < (MINL80 + 9 * MAXH80) / 10 AND H20 >= (MINL80 + 9 * MAXH80) / 10) - (H20 < (MINL80 + 9 * MAXH80) / 10 AND H21 >= (MINL80 + 9 * MAXH80) / 10) - (H21 < (MINL80 + 9 * MAXH80) / 10 AND H22 >= (MINL80 + 9 * MAXH80) / 10) - (H22 < (MINL80 + 9 * MAXH80) / 10 AND H23 >= (MINL80 + 9 * MAXH80) / 10) - (H23 < (MINL80 + 9 * MAXH80) / 10 AND H24 >= (MINL80 + 9 * MAXH80) / 10) - (H24 < (MINL80 + 9 * MAXH80) / 10 AND H25 >= (MINL80 + 9 * MAXH80) / 10) - (H25 < (MINL80 + 9 * MAXH80) / 10 AND H26 >= (MINL80 + 9 * MAXH80) / 10) - (H26 < (MINL80 + 9 * MAXH80) / 10 AND H27 >= (MINL80 + 9 * MAXH80) / 10) - (H27 < (MINL80 + 9 * MAXH80) / 10 AND H28 >= (MINL80 + 9 * MAXH80) / 10) - (H28 < (MINL80 + 9 * MAXH80) / 10 AND H29 >= (MINL80 + 9 * MAXH80) / 10) - (H29 < (MINL80 + 9 * MAXH80) / 10 AND H30 >= (MINL80 + 9 * MAXH80) / 10) - (H30 < (MINL80 + 9 * MAXH80) / 10 AND H31 >= (MINL80 + 9 * MAXH80) / 10) - (H31 < (MINL80 + 9 * MAXH80) / 10 AND H32 >= (MINL80 + 9 * MAXH80) / 10) - (H32 < (MINL80 + 9 * MAXH80) / 10 AND H33 >= (MINL80 + 9 * MAXH80) / 10) - (H33 < (MINL80 + 9 * MAXH80) / 10 AND H34 >= (MINL80 + 9 * MAXH80) / 10) - (H34 < (MINL80 + 9 * MAXH80) / 10 AND H35 >= (MINL80 + 9 * MAXH80) / 10) - (H35 < (MINL80 + 9 * MAXH80) / 10 AND H36 >= (MINL80 + 9 * MAXH80) / 10) - (H36 < (MINL80 + 9 * MAXH80) / 10 AND H37 >= (MINL80 + 9 * MAXH80) / 10) - (H37 < (MINL80 + 9 * MAXH80) / 10 AND H38 >= (MINL80 + 9 * MAXH80) / 10) - (H38 < (MINL80 + 9 * MAXH80) / 10 AND H39 >= (MINL80 + 9 * MAXH80) / 10) - (H39 < (MINL80 + 9 * MAXH80) / 10 AND H40 >= (MINL80 + 9 * MAXH80) / 10) - (H40 < (MINL80 + 9 * MAXH80) / 10 AND H41 >= (MINL80 + 9 * MAXH80) / 10) - (H41 < (MINL80 + 9 * MAXH80) / 10 AND H42 >= (MINL80 + 9 * MAXH80) / 10) - (H42 < (MINL80 + 9 * MAXH80) / 10 AND H43 >= (MINL80 + 9 * MAXH80) / 10) - (H43 < (MINL80 + 9 * MAXH80) / 10 AND H44 >= (MINL80 + 9 * MAXH80) / 10) - (H44 < (MINL80 + 9 * MAXH80) / 10 AND H45 >= (MINL80 + 9 * MAXH80) / 10) - (H45 < (MINL80 + 9 * MAXH80) / 10 AND H46 >= (MINL80 + 9 * MAXH80) / 10) - (H46 < (MINL80 + 9 * MAXH80) / 10 AND H47 >= (MINL80 + 9 * MAXH80) / 10) - (H47 < (MINL80 + 9 * MAXH80) / 10 AND H48 >= (MINL80 + 9 * MAXH80) / 10) - (H48 < (MINL80 + 9 * MAXH80) / 10 AND H49 >= (MINL80 + 9 * MAXH80) / 10) - (H49 < (MINL80 + 9 * MAXH80) / 10 AND H50 >= (MINL80 + 9 * MAXH80) / 10) - (H50 < (MINL80 + 9 * MAXH80) / 10 AND H51 >= (MINL80 + 9 * MAXH80) / 10) - (H51 < (MINL80 + 9 * MAXH80) / 10 AND H52 >= (MINL80 + 9 * MAXH80) / 10) - (H52 < (MINL80 + 9 * MAXH80) / 10 AND H53 >= (MINL80 + 9 * MAXH80) / 10) - (H53 < (MINL80 + 9 * MAXH80) / 10 AND H54 >= (MINL80 + 9 * MAXH80) / 10) - (H54 < (MINL80 + 9 * MAXH80) / 10 AND H55 >= (MINL80 + 9 * MAXH80) / 10) - (H55 < (MINL80 + 9 * MAXH80) / 10 AND H56 >= (MINL80 + 9 * MAXH80) / 10) - (H56 < (MINL80 + 9 * MAXH80) / 10 AND H57 >= (MINL80 + 9 * MAXH80) / 10) - (H57 < (MINL80 + 9 * MAXH80) / 10 AND H58 >= (MINL80 + 9 * MAXH80) / 10) - (H58 < (MINL80 + 9 * MAXH80) / 10 AND H59 >= (MINL80 + 9 * MAXH80) / 10) - (H59 < (MINL80 + 9 * MAXH80) / 10 AND H60 >= (MINL80 + 9 * MAXH80) / 10) - (H60 < (MINL80 + 9 * MAXH80) / 10 AND H61 >= (MINL80 + 9 * MAXH80) / 10) - (H61 < (MINL80 + 9 * MAXH80) / 10 AND H62 >= (MINL80 + 9 * MAXH80) / 10) - (H62 < (MINL80 + 9 * MAXH80) / 10 AND H63 >= (MINL80 + 9 * MAXH80) / 10) - (H63 < (MINL80 + 9 * MAXH80) / 10 AND H64 >= (MINL80 + 9 * MAXH80) / 10) - (H64 < (MINL80 + 9 * MAXH80) / 10 AND H65 >= (MINL80 + 9 * MAXH80) / 10) - (H65 < (MINL80 + 9 * MAXH80) / 10 AND H66 >= (MINL80 + 9 * MAXH80) / 10) - (H66 < (MINL80 + 9 * MAXH80) / 10 AND H67 >= (MINL80 + 9 * MAXH80) / 10) - (H67 < (MINL80 + 9 * MAXH80) / 10 AND H68 >= (MINL80 + 9 * MAXH80) / 10) - (H68 < (MINL80 + 9 * MAXH80) / 10 AND H69 >= (MINL80 + 9 * MAXH80) / 10) - (H69 < (MINL80 + 9 * MAXH80) / 10 AND H70 >= (MINL80 + 9 * MAXH80) / 10) - (H70 < (MINL80 + 9 * MAXH80) / 10 AND H71 >= (MINL80 + 9 * MAXH80) / 10) - (H71 < (MINL80 + 9 * MAXH80) / 10 AND H72 >= (MINL80 + 9 * MAXH80) / 10) - (H72 < (MINL80 + 9 * MAXH80) / 10 AND H73 >= (MINL80 + 9 * MAXH80) / 10) - (H73 < (MINL80 + 9 * MAXH80) / 10 AND H74 >= (MINL80 + 9 * MAXH80) / 10) - (H74 < (MINL80 + 9 * MAXH80) / 10 AND H75 >= (MINL80 + 9 * MAXH80) / 10) - (H75 < (MINL80 + 9 * MAXH80) / 10 AND H76 >= (MINL80 + 9 * MAXH80) / 10) - (H76 < (MINL80 + 9 * MAXH80) / 10 AND H77 >= (MINL80 + 9 * MAXH80) / 10) - (H77 < (MINL80 + 9 * MAXH80) / 10 AND H78 >= (MINL80 + 9 * MAXH80) / 10) - (H78 < (MINL80 + 9 * MAXH80) / 10 AND H79 >= (MINL80 + 9 * MAXH80) / 10) - (H79 < (MINL80 + 9 * MAXH80) / 10 AND H80 >= (MINL80 + 9 * MAXH80) / 10) >= 3 AND MAXH80 - MINL80 >= 3 AND SGN(XAVGC12 - XAVGC26 - XAVG(XAVGC12,9) + XAVG(XAVGC26,9)) <> SGN(XAVGC12.1 - XAVGC26.1 - XAVG(XAVGC12.1,9) + XAVG(XAVGC26.1,9))

It is probably easier to do in StockFinder than TeleChart.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Art Lindsley
 Posted : Tuesday, November 30, 2010 2:05:35 PM
Registered User
Joined: 7/23/2010
Posts: 84
Bruce don't you just know that I have got to ask how this would be done in SF5 please. Or perhaps the new TC2011 would be able to handle it better once it is released???

In the meantime if you would please tell us how to set this up in stockfinder

TIA

Art
Bruce_L
 Posted : Tuesday, November 30, 2010 2:10:34 PM  Worden Trainer

Joined: 10/7/2004
Posts: 65,138
Art Lindsley,
I may be misunderstanding your question, but I already pointed you to the channelling stocks topic in my Monday, November 15, 2010 10:16:01 AM ET response after you asked the question the originally.

If you are referring to the huge Personal Criteria Formula I provided for kenhi in my Tuesday, November 30, 2010 1:41:54 PM ET response, please ask the question again in the Ask a Trainer - StockFinder forum.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Art Lindsley
 Posted : Tuesday, November 30, 2010 2:45:45 PM
Registered User
Joined: 7/23/2010
Posts: 84
Apologies Bruce. I, somehow thought you may of come across a more efficient way with that huge pcf. The other seems to work well and I appreciate your hard work in trying to appease us all. I'd imagine the pcf above will take a long time to run as huge as it is. I say that hoping kenhi will notice that also.

thanks again Bruce
Bruce_L
 Posted : Tuesday, November 30, 2010 2:54:35 PM  Worden Trainer

Joined: 10/7/2004
Posts: 65,138
Art Lindsley,
You're welcome.

Large Personal Criteria Formulas can dramatically increase the time it takes to update your PCFs. I don't know that the huge PCF is currently "better" or "worse" than the technique originally presented in this topic. I suspect that if kenhi keeps refining his definition, we may be able to create something that will more closely meet kenhi's expectations however.

Converting it to StockFinder may make it more efficient as we might need to only conditionally check for entries into the 10% zones if we already know the channel is wide enough and the the MACD is crossing. In TeleChart, the calculations happen every time because we can't use AndIf and OrElse to shortcut the calculations.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
alindsley
 Posted : Monday, January 03, 2011 11:25:59 AM Registered User
Joined: 2/28/2005
Posts: 825
Bruce, FWIW, over the weekend I converted, and begin using the original video directions in the new TC2000 as an EasyScan which really works very well so far. I have incorporated my list of updated stocks that are close to or at a 52week high as my watchlist to scan. Perhaps kenhi might be better able to utilize the channel video this way. TC2000 is quite powerful and as it matures will easily replace my old TC2007 favorite....I appreciate all your hard work and patience over time. Your knowledge of your subject and ability to communicate with a vast variety of people make you a valuable asset to the Worden community. They should give you a big raise!!!I hope this new year is a fabulous one for you and your family.
cwilp
 Posted : Saturday, July 02, 2011 11:10:58 PM Registered User
Joined: 3/21/2011
Posts: 21
I would like to know how to use the criteria from the original video using TC2000v11. I can set up everything but the last 2 items. Being new to the software I am not sure how to convert the custom indicator. Do I just add it as a PCF and then put the PCF as a condition of the EasyScan? The other issue is using and sorting the Linear Regression Line - there is no option to sort by percent slope that I can find. I assume that whatever is used I can then just Quick Sort to find the stocks that meet the criteria.
cwilp
 Posted : Sunday, July 03, 2011 9:02:55 AM Registered User
Joined: 3/21/2011
Posts: 21
Actually, now that I've had time to think about it - it would be great to have a new video to cover all of the info and how to use the scan (ranks, values, etc.) in v11.
cwilp
 Posted : Sunday, July 10, 2011 10:26:33 PM Registered User
Joined: 3/21/2011
Posts: 21
OK - so I tried loading this into TC2000v11 and it seemed to work (sort of) with the 60 day formulas but got non stocks at all for 40 day stocks. Can someone post the correct formulas for the video - including how to do the sorts and how to set the ranks, etc. I think this is where I am having problems.
Bruce_L
 Posted : Monday, July 11, 2011 10:15:32 AM  Worden Trainer

Joined: 10/7/2004
Posts: 65,138
The correct formulas for the video are posted in Craig's Friday, January 07, 2005 2:20:46 PM ET post right underneath the video.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
cwilp
 Posted : Monday, July 11, 2011 11:49:45 AM Registered User
Joined: 3/21/2011
Posts: 21
Yes, but in TC2000v11 the forms used to create some of the data are different. For instance, the last one - the custom indicator that uses the linear regression line says to use the"percent slope". But there is no percent slope option on the TC2000v11 form for Quick Sort. So what do I use? There are a couple others where I am not sure of the correct entry on the form. The 5 day volume is listed in the video as being between 10 and 99. In TC2000v11 is this the default "Is Between" option on the pop down menu or do I use "Ranks" and slide the ranking to between 10 and 99? These are the things I am having an issue with for all of the formulas.
Bruce_L
 Posted : Monday, July 11, 2011 12:16:30 PM  Worden Trainer

Joined: 10/7/2004
Posts: 65,138
You want Trend/Consolidate set to Ranks 0 to 50 in the EasyScan.

You want Directional Move set to Is Between something near 1 (Craig suggests .8 to 1.2).

You will want to sort the Linear Regression Line of the Custom Indicator by a 1-Period Percent Change in Ascending order.

The WatchList Tab PCF is just used as a WatchList Column.

EasyScans and Column Sorting

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
ppeake
 Posted : Wednesday, December 21, 2011 7:41:37 PM
Registered User
Joined: 5/18/2010
Posts: 3

Please provide instructions for Rolling Channeling stocks in TC 2000 version 12.

If instructions are  not available please note TC 2000 version 12 does not have feature to sort linear regression by the percentage of slope. Please provide or create formula for the percentage of the slope of linear regression line.

Bruce_L
 Posted : Thursday, December 22, 2011 11:27:06 AM  Worden Trainer

Joined: 10/7/2004
Posts: 65,138
I can create and post a formula for the Net Change of the 40-Period Linear Regression Line over its entire run for the 40-Period version of the Custom Indicator (ABS((MAXH20 - MAXH20.20) / MAXH20.20) * ABS((MINL20 - MINL20.20) / MINL20.20)):

15 * (39 * (ABS(MAXH20 / MAXH20.20 - 1) * ABS(MINL20 / MINL20.20 - 1) - ABS(MAXH20.39 / MAXH20.59 - 1) * ABS(MINL20.39 / MINL20.59 - 1)) + 37 * (ABS(MAXH20.1 / MAXH20.21 - 1) * ABS(MINL20.1 / MINL20.21 - 1) - ABS(MAXH20.38 / MAXH20.58 - 1) * ABS(MINL20.38 / MINL20.58 - 1)) + 35 * (ABS(MAXH20.2 / MAXH20.22 - 1) * ABS(MINL20.2 / MINL20.22 - 1) - ABS(MAXH20.37 / MAXH20.57 - 1) * ABS(MINL20.37 / MINL20.57 - 1)) + 33 * (ABS(MAXH20.3 / MAXH20.23 - 1) * ABS(MINL20.3 / MINL20.23 - 1) - ABS(MAXH20.36 / MAXH20.56 - 1) * ABS(MINL20.36 / MINL20.56 - 1)) + 31 * (ABS(MAXH20.4 / MAXH20.24 - 1) * ABS(MINL20.4 / MINL20.24 - 1) - ABS(MAXH20.35 / MAXH20.55 - 1) * ABS(MINL20.35 / MINL20.55 - 1)) + 29 * (ABS(MAXH20.5 / MAXH20.25 - 1) * ABS(MINL20.5 / MINL20.25 - 1) - ABS(MAXH20.34 / MAXH20.54 - 1) * ABS(MINL20.34 / MINL20.54 - 1)) + 27 * (ABS(MAXH20.6 / MAXH20.26 - 1) * ABS(MINL20.6 / MINL20.26 - 1) - ABS(MAXH20.33 / MAXH20.53 - 1) * ABS(MINL20.33 / MINL20.53 - 1)) + 25 * (ABS(MAXH20.7 / MAXH20.27 - 1) * ABS(MINL20.7 / MINL20.27 - 1) - ABS(MAXH20.32 / MAXH20.52 - 1) * ABS(MINL20.32 / MINL20.52 - 1)) + 23 * (ABS(MAXH20.8 / MAXH20.28 - 1) * ABS(MINL20.8 / MINL20.28 - 1) - ABS(MAXH20.31 / MAXH20.51 - 1) * ABS(MINL20.31 / MINL20.51 - 1)) + 21 * (ABS(MAXH20.9 / MAXH20.29 - 1) * ABS(MINL20.9 / MINL20.29 - 1) - ABS(MAXH20.30 / MAXH20.50 - 1) * ABS(MINL20.30 / MINL20.50 - 1)) + 19 * (ABS(MAXH20.10 / MAXH20.30 - 1) * ABS(MINL20.10 / MINL20.30 - 1) - ABS(MAXH20.29 / MAXH20.49 - 1) * ABS(MINL20.29 / MINL20.49 - 1)) + 17 * (ABS(MAXH20.11 / MAXH20.31 - 1) * ABS(MINL20.11 / MINL20.31 - 1) - ABS(MAXH20.28 / MAXH20.48 - 1) * ABS(MINL20.28 / MINL20.48 - 1)) + 15 * (ABS(MAXH20.12 / MAXH20.32 - 1) * ABS(MINL20.12 / MINL20.32 - 1) - ABS(MAXH20.27 / MAXH20.47 - 1) * ABS(MINL20.27 / MINL20.47 - 1)) + 13 * (ABS(MAXH20.13 / MAXH20.33 - 1) * ABS(MINL20.13 / MINL20.33 - 1) - ABS(MAXH20.26 / MAXH20.46 - 1) * ABS(MINL20.26 / MINL20.46 - 1)) + 11 * (ABS(MAXH20.14 / MAXH20.34 - 1) * ABS(MINL20.14 / MINL20.34 - 1) - ABS(MAXH20.25 / MAXH20.45 - 1) * ABS(MINL20.25 / MINL20.45 - 1)) + 9 * (ABS(MAXH20.15 / MAXH20.35 - 1) * ABS(MINL20.15 / MINL20.35 - 1) - ABS(MAXH20.24 / MAXH20.44 - 1) * ABS(MINL20.24 / MINL20.44 - 1)) + 7 * (ABS(MAXH20.16 / MAXH20.36 - 1) * ABS(MINL20.16 / MINL20.36 - 1) - ABS(MAXH20.23 / MAXH20.43 - 1) * ABS(MINL20.23 / MINL20.43 - 1)) + 5 * (ABS(MAXH20.17 / MAXH20.37 - 1) * ABS(MINL20.17 / MINL20.37 - 1) - ABS(MAXH20.22 / MAXH20.42 - 1) * ABS(MINL20.22 / MINL20.42 - 1)) + 3 * (ABS(MAXH20.18 / MAXH20.38 - 1) * ABS(MINL20.18 / MINL20.38 - 1) - ABS(MAXH20.21 / MAXH20.41 - 1) * ABS(MINL20.21 / MINL20.41 - 1)) + ABS(MAXH20.19 / MAXH20.39 - 1) * ABS(MINL20.19 / MINL20.39 - 1) - ABS(MAXH20.20 / MAXH20.40 - 1) * ABS(MINL20.20 / MINL20.40 - 1)) / 82

But I cannot post a similar version for the Net Change of the 60-Period Linear Regression Line over its entire run for the 60-Period version of the Custom Indicator (ABS((MAXH30 - MAXH30.30) / MAXH30.30) * ABS((MINL30 - MINL30.30) / MINL30.30) as the resulting formula is Very Slow.

It should be noted that I used a Net Change instead of a Percent Slope for very good mathematical reasons. The Custom Formula is already multiplying the Percent Difference between Maximum values by the Percent Difference between minimum values over the period (so the resulting formula is already the square of a percentage). More importantly, this Percent Difference can approach and even equal zero. You should not normally calculate percentages on indicators which can equal zero.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
ppeake
 Posted : Thursday, December 22, 2011 11:50:12 PM
Registered User
Joined: 5/18/2010
Posts: 3
Please provide detailed instructions how to sort the direction of the 40 day linear regression line in ascending order.
Bruce_L
 Posted : Friday, December 23, 2011 4:55:09 AM  Worden Trainer

Joined: 10/7/2004
Posts: 65,138
In TC2000 version 12:

- Select Indicators | New Indicator Formula.
- Copy the formula from the forums using right-click Copy or ctrl-c.
- Paste the formula into the Edit PCF window using ctrl-v.
- Give the formula a name and select OK.
- Select Add Column and choose your new Indicator Formula from the list.

You could instead use the formula as a Custom PCF Indicator and then use the indicator as a Sort.

Indicators, Sorting & Scanning

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
ppeake
 Posted : Friday, December 23, 2011 4:09:54 PM
Registered User
Joined: 5/18/2010
Posts: 3
Please provide the formula for calculating the 40 day linear regression line in ascending order.
Bruce_L
 Posted : Saturday, December 24, 2011 7:26:27 AM  Worden Trainer

Joined: 10/7/2004
Posts: 65,138

I already did provide the formula for the Net Change of the 40-Period Linear Regression Line over its entire run for the 40-Period version of the Custom Indicator (ABS((MAXH20 - MAXH20.20) / MAXH20.20) * ABS((MINL20 - MINL20.20) / MINL20.20)) in my Thursday, December 22, 2011 11:27:06 AM ET post (which is what you should use for the sort).

If you mean the slope of the 40-Period Linear Regression of Price History instead:

(19.5 * C + 18.5 * C1 + 17.5 * C2 + 16.5 * C3 + 15.5 * C4 + 14.5 * C5 + 13.5 * C6 + 12.5 * C7 + 11.5 * C8 + 10.5 * C9 + 9.5 * C10 + 8.5 * C11 + 7.5 * C12 + 6.5 * C13 + 5.5 * C14 + 4.5 * C15 + 3.5 * C16 + 2.5 * C17 + 1.5 * C18 + 0.5 * C19 - 0.5 * C20 - 1.5 * C21 - 2.5 * C22 - 3.5 * C23 - 4.5 * C24 - 5.5 * C25 - 6.5 * C26 - 7.5 * C27 - 8.5 * C28 - 9.5 * C29 - 10.5 * C30 - 11.5 * C31 - 12.5 * C32 - 13.5 * C33 - 14.5 * C34 - 15.5 * C35 - 16.5 * C36 - 17.5 * C37 - 18.5 * C38 - 19.5 * C39) / 5330

If you mean the right-end point of the 40-Period Linear Regression Line of Price History:

AVGC40 + 19.5 * (19.5 * C + 18.5 * C1 + 17.5 * C2 + 16.5 * C3 + 15.5 * C4 + 14.5 * C5 + 13.5 * C6 + 12.5 * C7 + 11.5 * C8 + 10.5 * C9 + 9.5 * C10 + 8.5 * C11 + 7.5 * C12 + 6.5 * C13 + 5.5 * C14 + 4.5 * C15 + 3.5 * C16 + 2.5 * C17 + 1.5 * C18 + 0.5 * C19 - 0.5 * C20 - 1.5 * C21 - 2.5 * C22 - 3.5 * C23 - 4.5 * C24 - 5.5 * C25 - 6.5 * C26 - 7.5 * C27 - 8.5 * C28 - 9.5 * C29 - 10.5 * C30 - 11.5 * C31 - 12.5 * C32 - 13.5 * C33 - 14.5 * C34 - 15.5 * C35 - 16.5 * C36 - 17.5 * C37 - 18.5 * C38 - 19.5 * C39) / 5330

Using Linear Regression vs Classical Peaks/Valleys for Divergence Analysis

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
cwilp
 Posted : Monday, January 30, 2012 12:20:53 PM Registered User
Joined: 3/21/2011
Posts: 21
Actually, it would be great if someone would redo the video for v12. I am sure many of the old videos need to be updated.
Users browsing this topic
Guest-1
 3 pages: 1 2 

 Forum Jump Customer Training & Support - Ask a Trainer - TC2000 version 12/18 - Ask a Trainer - TC2000 version 7 - Ask a Trainer - StockFinder 5.0 - PCFs, EasyScan and Custom Indicators General Discussions - Stock and Market Talk - TC2000 version 12 or 18 - TC2000 version 7 - StockFinder 5.0 - RealCode for StockFinder 5.0 Tutorial Videos - TC2000 version 12 tutorial videos - TC2000 version 7 tutorial videos 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.