Registered User
Joined: 2/21/2007
Posts: 2
|
I have a question about the MA indicator in TC 2000 v 11
I notice you can do a quick sort or create a column and sort for price position relative to MA, but I don't see a way to set the time frame for the MA. It seems to make the time frame for the MA the actual MA, which is not what I am trying to do.
For example, I might want to sort for a stocks that are above the 30MA for the last 59, days, 60 days, 61 days, etc. This would mean they never dropped below the 30MA in that time frame. Currently it seems like it will only sort for stock above the 30 MA within the last 30 days, which is the selected MA.
It's like that's the default and you can't change the timeframe to what ever you want.
I'd like that to be a variable I have control over.
"Consecutive days above or below a specific MA" or even passing through, etc.
The consecutive days is the key.
Support told me this wasn't a feature in TC2000 but a trainter could help me build a PCF to scan for this but it would be a complex formula. Anyone know how to do this?
[
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The Time Frame is the Time Frame of the Bars being used.
There are many ways to both interpret and go about identifying symbols where Price was above the 30-Period Moving Average for say 60-Bars (Days in a Daily Time Frame). I'm going to assume "never dropped below" means that the entire Bar must above the Moving Average and not just Close of the Bar (you can replace every L in the formula with a C if this is not the case).
You could create a Personal Criteria Formula which checks each Bar individually:
L > AVGC30 AND L1 > AVGC30.1 AND L2 > AVGC30.2 AND L3 > AVGC30.3 AND L4 > AVGC30.4 AND L5 > AVGC30.5 AND L6 > AVGC30.6 AND L7 > AVGC30.7 AND L8 > AVGC30.8 AND L9 > AVGC30.9 AND L10 > AVGC30.10 AND L11 > AVGC30.11 AND L12 > AVGC30.12 AND L13 > AVGC30.13 AND L14 > AVGC30.14 AND L15 > AVGC30.15 AND L16 > AVGC30.16 AND L17 > AVGC30.17 AND L18 > AVGC30.18 AND L19 > AVGC30.19 AND L20 > AVGC30.20 AND L21 > AVGC30.21 AND L22 > AVGC30.22 AND L23 > AVGC30.23 AND L24 > AVGC30.24 AND L25 > AVGC30.25 AND L26 > AVGC30.26 AND L27 > AVGC30.27 AND L28 > AVGC30.28 AND L29 > AVGC30.29 AND L30 > AVGC30.30 AND L31 > AVGC30.31 AND L32 > AVGC30.32 AND L33 > AVGC30.33 AND L34 > AVGC30.34 AND L35 > AVGC30.35 AND L36 > AVGC30.36 AND L37 > AVGC30.37 AND L38 > AVGC30.38 AND L39 > AVGC30.39 AND L40 > AVGC30.40 AND L41 > AVGC30.41 AND L42 > AVGC30.42 AND L43 > AVGC30.43 AND L44 > AVGC30.44 AND L45 > AVGC30.45 AND L46 > AVGC30.46 AND L47 > AVGC30.47 AND L48 > AVGC30.48 AND L49 > AVGC30.49 AND L50 > AVGC30.50 AND L51 > AVGC30.51 AND L52 > AVGC30.52 AND L53 > AVGC30.53 AND L54 > AVGC30.54 AND L55 > AVGC30.55 AND L56 > AVGC30.56 AND L57 > AVGC30.57 AND L58 > AVGC30.58 AND L59 > AVGC30.59
If the Moving Average is Exponential instead of Simple, you could replace each instance of AVGC30 with XAVGC30 instead. You could also use the base formula:
L > AVGC30
As a Custom PCF % True Indicator with the Period set to 60 and the Average Type set to Simple. If you use the Custom PCF % True Indicator as a Quick Sort Based On Latest Value, any symbol returning 100% was above its Moving Average for all 60-Bars.
EasyScans and Column Sorting
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|