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 5Periods (you can adjust this number as desired).
Bruce Personal Criteria Formulas TC2000 Support Articles


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 1030% of the channel, any suggestions?


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

1btrader, You could try using Stochastics for this. If you are looking at a 40Period Channel, you could use something like the following:
STOC40 <= 30
A 60Period 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


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


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


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


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


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.
Thanks in advance
Don


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


Registered User Joined: 7/23/2010 Posts: 84

Could this be converted for SF5 please? I'm speaking of the original video scan please


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.


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


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


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


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


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


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


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


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.


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.


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.


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.


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


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.


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 1Period 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


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.


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

I can create and post a formula for the Net Change of the 40Period Linear Regression Line over its entire run for the 40Period 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 60Period Linear Regression Line over its entire run for the 60Period 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


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.


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 rightclick Copy or ctrlc.
 Paste the formula into the Edit PCF window using ctrlv.
 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


Registered User Joined: 5/18/2010 Posts: 3

Please provide the formula for calculating the 40 day linear regression line in ascending order.


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

I already did provide the formula for the Net Change of the 40Period Linear Regression Line over its entire run for the 40Period 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 40Period 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 rightend point of the 40Period 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


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.


Guest1 