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

20 day exp ma Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
mktwizard123
Posted : Thursday, September 21, 2006 10:27:09 AM
Registered User
Joined: 5/17/2006
Posts: 493
if I have determined a stock to be in an uptrend or downtrend, is there a way to write a pcf to catch it every time it comes back to or around its 20 period exponential moving average, i'm assuming it will take off again (in a uptrend) or be a good short candidate for those in a uptrend.
Craig_S
Posted : Thursday, September 21, 2006 10:29:59 AM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
You can sort your WatchList by this condition:

100*ABS(((H+L)/2)-XAVGC20)/XAVGC20

Sort in ASCENDING order to rank the list by how close it is to the 20ema.

- Craig
Here to Help!
mktwizard123
Posted : Thursday, September 21, 2006 10:38:57 AM
Registered User
Joined: 5/17/2006
Posts: 493
thanks craig, also, is there a way to sort by.....

ADX must be more than 30 and the +DI more than the -DI

or a pcf to help me with this?
Craig_S
Posted : Thursday, September 21, 2006 10:40:52 AM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
YOu can sort by the ADX by right-clicking it. Check out this video: Sorting by the ADX indicator

For DI PCFs check this out: PCF for Wilder's DX, and/or a CI for Wilder's ADX or PCF for Wilder's Directional Movement DMI-crossovers

- Craig
Here to Help!
mktwizard123
Posted : Thursday, September 21, 2006 10:52:14 AM
Registered User
Joined: 5/17/2006
Posts: 493
thanks craig, I have checked out the posts and I am a little confused, I get the adx but is there a pcf that shows if a stocks +DI is more than the -DI (not a crossover) and +DI less than the -DI

Bruce_L
Posted : Thursday, September 21, 2006 11:04:10 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
geargematus,
This is taken from Tanstaafl's Wednesday, December 15, 2004 7:35:09 AM ET post in PCF for Wilder's Directional Movement DMI-crossovers:

QUOTE (Tanstaafl)
Plot the following DM-difference as a Custom Indicator:
(H0-H1)*(H0-H1>L1-L0)*(H0>H1) - (L1-L0)*(H0-H1<L1-L0)*(L0<L1)

Now apply the exponential equivalent of Wilders's smoothing to it, as a part of the CI definition:
Exponential Pds = (Wilder Pds * 2) -1 = 14*2 - 1
= 27-day exponential smoothing.

Be sure to check "center zero line" when you plot it.

The resulting plotted line calculates virtually instantaneously (compared to all the other stuff, above).

Any time this line CROSSES ZERO, that's a place where the +DI and -DI lines had a crossover.

If this line is GREATER than zero, there is a BULLISH Directional Movement condition (i.e. the posDI line is above the negDI line), and vice versa for Bearish.

While it can be used to detect crossovers, the last line of the quotation seems to indicate it will do what you want. You can use Indicator Sorting to find out if +DI or -DI is higher. You may wish to review the following:

Plotting Custom Indicators with Examples
Sorting price and indicators by their Actual Value

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
mktwizard123
Posted : Thursday, September 21, 2006 11:13:04 AM
Registered User
Joined: 5/17/2006
Posts: 493
thanks bruce, ok just to be clear, I plot Custom Indicator:
(H0-H1)*(H0-H1>L1-L0)*(H0>H1) - (L1-L0)*(H0-H1<L1-L0)*(L0<L1) as a custom indicator and then I change the smoothing to 27? I guess I don't know what to do with Exponential Pds = (Wilder Pds * 2) -1 = 14*2 - 1
= 27-day exponential smoothing. I didn't know if I add that somewhere or that just reffered to inputing 27 into the smoothing?
mktwizard123
Posted : Thursday, September 21, 2006 11:21:49 AM
Registered User
Joined: 5/17/2006
Posts: 493
also, is it then possible to write a pcf when this indicator crosses the zero line up or down?
Bruce_L
Posted : Thursday, September 21, 2006 11:22:02 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
QUOTE (georgematus)
also, is it then possible to write a pcf when this indicator crosses the zero line up or down?

I didn't include this previously because you specifically said, "(not a crossover)", but I'll continue the quotation:

QUOTE (Tanstaafl)
IMHO, this is probably the "final" form necessary, since it provides an exceptionally clean, perfectly accurate, and very fast solution.

Please note two applications that are natural uses of it:
1) SortBy Value and flag for >0 or <0
2) Rewrite for some fixed daysago for backtesting

The following is the formula for the previous period:

(H1-H2)*(H1-H2>L2-L1)*(H1>H2) - (L2-L1)*(H1-H2<L2-L1)*(L1<L2)

QUOTE (georgematus)
ok just to be clear, I plot Custom Indicator: (H0-H1)*(H0-H1>L1-L0)*(H0>H1) - (L1-L0)*(H0-H1<L1-L0)*(L0<L1) as a custom indicator and then I change the smoothing to 27? I guess I don't know what to do with Exponential Pds = (Wilder Pds * 2) -1 = 14*2 - 1 = 27-day exponential smoothing. I didn't know if I add that somewhere or that just reffered to inputing 27 into the smoothing?

If your DX Period is 14, you would use a Smoothing Period of 27 because (2 * 14) - 1 = 27.
If your DX Period is 5, you would use a Smoothing Period of 9 because (2 * 5) - 1 = 9.

Select Chart Template | Add Indicator | Indicator.
- Visible: Checked
- Center Zero Line: Checked
- Plot using price scale: Unchecked
- Smoothing Average: 27 (twice the DX-Period minus one)
- Average Type: Exponential
- Indicator Formula: (H0-H1)*(H0-H1>L1-L0)*(H0>H1) - (L1-L0)*(H0-H1<L1-L0)*(L0<L1)

You may wish to review the following:

How to use the Flagging feature

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
mktwizard123
Posted : Thursday, September 21, 2006 12:38:10 PM
Registered User
Joined: 5/17/2006
Posts: 493
sorry for the confusion bruce, basically instead of sorting, is there a way to write a pcf for my percent true indicator that will tell me if the above formula is above zero or below zero at that time, i'm not looking for crossovers, just above or below the zero line in a pcf

thanks

i was thinking it would be

(H1-H2)*(H1-H2>L2-L1)*(H1>H2) - (L2-L1)*(H1-H2<L2-L1)*(L1<L2)< (H0-H1)*(H0-H1>L1-L0)*(H0>H1) - (L1-L0)*(H0-H1<L1-L0)*(L0<L1)
for above the zero line and just reverse the < to > for below but I dont think thats right.
Bruce_L
Posted : Thursday, September 21, 2006 12:47:13 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
QUOTE (georgematus)
i was thinking it would be (H1-H2)*(H1-H2>L2-L1)*(H1>H2) - (L2-L1)*(H1-H2<L2-L1)*(L1<L2)< (H0-H1)*(H0-H1>L1-L0)*(H0>H1) - (L1-L0)*(H0-H1<L1-L0)*(L0<L1) for above the zero line and just reverse the < to > for below but I dont think thats right.

You are correct that this is not right. A Personal Criteria Formula version would be much longer because the Exponential Moving Average needs to be expanded manually. The size also increases dramatically with increasing DX periods. Here's one way to write a formula testing for the +DI being above the -DI based on a relatively short DX Period of 5:

((H - H1) * (H - H1 > L1 - L) * (H > H1) - (L1 - L) * (H - H1 < L1 - L) * (L < L1) + .8 * ((H1 - H2) * (H1 - H2 > L2 - L1) * (H1 > H2) - (L2 - L1) * (H1 - H2 < L2 - L1) * (L1 < L2) + .8 * ((H2 - H3) * (H2 - H3 > L3 - L2) * (H2 > H3) - (L3 - L2) * (H2 - H3 < L3 - L2) * (L2 < L3) + .8 * ((H3 - H4) * (H3 - H4 > L4 - L3) * (H3 > H4) - (L4 - L3) * (H3 - H4 < L4 - L3) * (L3 < L4) + .8 * ((H4 - H5) * (H4 - H5 > L5 - L4) * (H4 > H5) - (L5 - L4) * (H4 - H5 < L5 - L4) * (L4 < L5) + .8 * ((H5 - H6) * (H5 - H6 > L6 - L5) * (H5 > H6) - (L6 - L5) * (H5 - H6 < L6 - L5) * (L5 < L6) + .8 * ((H6 - H7) * (H6 - H7 > L7 - L6) * (H6 > H7) - (L7 - L6) * (H6 - H7 < L7 - L6) * (L6 < L7) + .8 * ((H7 - H8) * (H7 - H8 > L8 - L7) * (H7 > H8) - (L8 - L7) * (H7 - H8 < L8 - L7) * (L7 < L8) + .8 * ((H8 - H9) * (H8 - H9 > L9 - L8) * (H8 > H9) - (L9 - L8) * (H8 - H9 < L9 - L8) * (L8 < L9) + .8 * ((H9 - H10) * (H9 - H10 > L10 - L9) * (H9 > H10) - (L10 - L9) * (H9 - H10 < L10 - L9) * (L9 < L10) + .8 * ((H10 - H11) * (H10 - H11 > L11 - L10) * (H10 > H11) - (L11 - L10) * (H10 - H11 < L11 - L10) * (L10 < L11) + .8 * ((H11 - H12) * (H11 - H12 > L12 - L11) * (H11 > H12) - (L12 - L11) * (H11 - H12 < L12 - L11) * (L11 < L12) + .8 * ((H12 - H13) * (H12 - H13 > L13 - L12) * (H12 > H13) - (L13 - L12) * (H12 - H13 < L13 - L12) * (L12 < L13) + .8 * ((H13 - H14) * (H13 - H14 > L14 - L13) * (H13 > H14) - (L14 - L13) * (H13 - H14 < L14 - L13) * (L13 < L14) + .8 * ((H14 - H15) * (H14 - H15 > L15 - L14) * (H14 > H15) - (L15 - L14) * (H14 - H15 < L15 - L14) * (L14 < L15) + .8 * ((H15 - H16) * (H15 - H16 > L16 - L15) * (H15 > H16) - (L16 - L15) * (H15 - H16 < L16 - L15) * (L15 < L16) + .8 * ((H16 - H17) * (H16 - H17 > L17 - L16) * (H16 > H17) - (L17 - L16) * (H16 - H17 < L17 - L16) * (L16 < L17) + .8 * ((H17 - H18) * (H17 - H18 > L18 - L17) * (H17 > H18) - (L18 - L17) * (H17 - H18 < L18 - L17) * (L17 < L18) + .8 * ((H18 - H19) * (H18 - H19 > L19 - L18) * (H18 > H19) - (L19 - L18) * (H18 - H19 < L19 - L18) * (L18 < L19) + .8 * ((H19 - H20) * (H19 - H20 > L20 - L19) * (H19 > H20) - (L20 - L19) * (H19 - H20 < L20 - L19) * (L19 < L20) + .8 * ((H20 - H21) * (H20 - H21 > L21 - L20) * (H20 > H21) - (L21 - L20) * (H20 - H21 < L21 - L20) * (L20 < L21) + .8 * ((H21 - H22) * (H21 - H22 > L22 - L21) * (H21 > H22) - (L22 - L21) * (H21 - H22 < L22 - L21) * (L21 < L22) + .8 * ((H22 - H23) * (H22 - H23 > L23 - L22) * (H22 > H23) - (L23 - L22) * (H22 - H23 < L23 - L22) * (L22 < L23) + .8 * ((H23 - H24) * (H23 - H24 > L24 - L23) * (H23 > H24) - (L24 - L23) * (H23 - H24 < L24 - L23) * (L23 < L24) + .8 * ((H24 - H25) * (H24 - H25 > L25 - L24) * (H24 > H25) - (L25 - L24) * (H24 - H25 < L25 - L24) * (L24 < L25) + .8 * ((H25 - H26) * (H25 - H26 > L26 - L25) * (H25 > H26) - (L26 - L25) * (H25 - H26 < L26 - L25) * (L25 < L26) + .8 * ((H26 - H27) * (H26 - H27 > L27 - L26) * (H26 > H27) - (L27 - L26) * (H26 - H27 < L27 - L26) * (L26 < L27) + .8 * ((H27 - H28) * (H27 - H28 > L28 - L27) * (H27 > H28) - (L28 - L27) * (H27 - H28 < L28 - L27) * (L27 < L28) + .8 * ((H28 - H29) * (H28 - H29 > L29 - L28) * (H28 > H29) - (L29 - L28) * (H28 - H29 < L29 - L28) * (L28 < L29) + .8 * ((H29 - H30) * (H29 - H30 > L30 - L29) * (H29 > H30) - (L30 - L29) * (H29 - H30 < L30 - L29) * (L29 < L30) + .8 * ((H30 - H31) * (H30 - H31 > L31 - L30) * (H30 > H31) - (L31 - L30) * (H30 - H31 < L31 - L30) * (L30 < L31)))))))))))))))))))))))))))))))) > 0

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
mktwizard123
Posted : Thursday, September 21, 2006 12:55:45 PM
Registered User
Joined: 5/17/2006
Posts: 493
is that version showing greater than zero? if so, could you give me one with below zero? i know the pcf would be long but if you would find some extra time, could you provide me with both pcfs showing above and below zero with a 19, i would really appreciate that.

thanks
Craig_S
Posted : Thursday, September 21, 2006 1:04:41 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
To change his formula to below zero change the end of >0 to <0

- Craig
Here to Help!
Bruce_L
Posted : Thursday, September 21, 2006 1:10:04 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
georgematus,
Here's a version for a DX period of 19 (it may be long enough to lock up your system even as a Personal Criteria Formula):

((H - H1) * (H - H1 > L1 - L) * (H > H1) - (L1 - L) * (H - H1 < L1 - L) * (L < L1) + 18 / 19 * ((H1 - H2) * (H1 - H2 > L2 - L1) * (H1 > H2) - (L2 - L1) * (H1 - H2 < L2 - L1) * (L1 < L2) + 18 / 19 * ((H2 - H3) * (H2 - H3 > L3 - L2) * (H2 > H3) - (L3 - L2) * (H2 - H3 < L3 - L2) * (L2 < L3) + 18 / 19 * ((H3 - H4) * (H3 - H4 > L4 - L3) * (H3 > H4) - (L4 - L3) * (H3 - H4 < L4 - L3) * (L3 < L4) + 18 / 19 * ((H4 - H5) * (H4 - H5 > L5 - L4) * (H4 > H5) - (L5 - L4) * (H4 - H5 < L5 - L4) * (L4 < L5) + 18 / 19 * ((H5 - H6) * (H5 - H6 > L6 - L5) * (H5 > H6) - (L6 - L5) * (H5 - H6 < L6 - L5) * (L5 < L6) + 18 / 19 * ((H6 - H7) * (H6 - H7 > L7 - L6) * (H6 > H7) - (L7 - L6) * (H6 - H7 < L7 - L6) * (L6 < L7) + 18 / 19 * ((H7 - H8) * (H7 - H8 > L8 - L7) * (H7 > H8) - (L8 - L7) * (H7 - H8 < L8 - L7) * (L7 < L8) + 18 / 19 * ((H8 - H9) * (H8 - H9 > L9 - L8) * (H8 > H9) - (L9 - L8) * (H8 - H9 < L9 - L8) * (L8 < L9) + 18 / 19 * ((H9 - H10) * (H9 - H10 > L10 - L9) * (H9 > H10) - (L10 - L9) * (H9 - H10 < L10 - L9) * (L9 < L10) + 18 / 19 * ((H10 - H11) * (H10 - H11 > L11 - L10) * (H10 > H11) - (L11 - L10) * (H10 - H11 < L11 - L10) * (L10 < L11) + 18 / 19 * ((H11 - H12) * (H11 - H12 > L12 - L11) * (H11 > H12) - (L12 - L11) * (H11 - H12 < L12 - L11) * (L11 < L12) + 18 / 19 * ((H12 - H13) * (H12 - H13 > L13 - L12) * (H12 > H13) - (L13 - L12) * (H12 - H13 < L13 - L12) * (L12 < L13) + 18 / 19 * ((H13 - H14) * (H13 - H14 > L14 - L13) * (H13 > H14) - (L14 - L13) * (H13 - H14 < L14 - L13) * (L13 < L14) + 18 / 19 * ((H14 - H15) * (H14 - H15 > L15 - L14) * (H14 > H15) - (L15 - L14) * (H14 - H15 < L15 - L14) * (L14 < L15) + 18 / 19 * ((H15 - H16) * (H15 - H16 > L16 - L15) * (H15 > H16) - (L16 - L15) * (H15 - H16 < L16 - L15) * (L15 < L16) + 18 / 19 * ((H16 - H17) * (H16 - H17 > L17 - L16) * (H16 > H17) - (L17 - L16) * (H16 - H17 < L17 - L16) * (L16 < L17) + 18 / 19 * ((H17 - H18) * (H17 - H18 > L18 - L17) * (H17 > H18) - (L18 - L17) * (H17 - H18 < L18 - L17) * (L17 < L18) + 18 / 19 * ((H18 - H19) * (H18 - H19 > L19 - L18) * (H18 > H19) - (L19 - L18) * (H18 - H19 < L19 - L18) * (L18 < L19) + 18 / 19 * ((H19 - H20) * (H19 - H20 > L20 - L19) * (H19 > H20) - (L20 - L19) * (H19 - H20 < L20 - L19) * (L19 < L20) + 18 / 19 * ((H20 - H21) * (H20 - H21 > L21 - L20) * (H20 > H21) - (L21 - L20) * (H20 - H21 < L21 - L20) * (L20 < L21) + 18 / 19 * ((H21 - H22) * (H21 - H22 > L22 - L21) * (H21 > H22) - (L22 - L21) * (H21 - H22 < L22 - L21) * (L21 < L22) + 18 / 19 * ((H22 - H23) * (H22 - H23 > L23 - L22) * (H22 > H23) - (L23 - L22) * (H22 - H23 < L23 - L22) * (L22 < L23) + 18 / 19 * ((H23 - H24) * (H23 - H24 > L24 - L23) * (H23 > H24) - (L24 - L23) * (H23 - H24 < L24 - L23) * (L23 < L24) + 18 / 19 * ((H24 - H25) * (H24 - H25 > L25 - L24) * (H24 > H25) - (L25 - L24) * (H24 - H25 < L25 - L24) * (L24 < L25) + 18 / 19 * ((H25 - H26) * (H25 - H26 > L26 - L25) * (H25 > H26) - (L26 - L25) * (H25 - H26 < L26 - L25) * (L25 < L26) + 18 / 19 * ((H26 - H27) * (H26 - H27 > L27 - L26) * (H26 > H27) - (L27 - L26) * (H26 - H27 < L27 - L26) * (L26 < L27) + 18 / 19 * ((H27 - H28) * (H27 - H28 > L28 - L27) * (H27 > H28) - (L28 - L27) * (H27 - H28 < L28 - L27) * (L27 < L28) + 18 / 19 * ((H28 - H29) * (H28 - H29 > L29 - L28) * (H28 > H29) - (L29 - L28) * (H28 - H29 < L29 - L28) * (L28 < L29) + 18 / 19 * ((H29 - H30) * (H29 - H30 > L30 - L29) * (H29 > H30) - (L30 - L29) * (H29 - H30 < L30 - L29) * (L29 < L30) + 18 / 19 * ((H30 - H31) * (H30 - H31 > L31 - L30) * (H30 > H31) - (L31 - L30) * (H30 - H31 < L31 - L30) * (L30 < L31) + 18 / 19 * ((H31 - H32) * (H31 - H32 > L32 - L31) * (H31 > H32) - (L32 - L31) * (H31 - H32 < L32 - L31) * (L31 < L32) + 18 / 19 * ((H32 - H33) * (H32 - H33 > L33 - L32) * (H32 > H33) - (L33 - L32) * (H32 - H33 < L33 - L32) * (L32 < L33) + 18 / 19 * ((H33 - H34) * (H33 - H34 > L34 - L33) * (H33 > H34) - (L34 - L33) * (H33 - H34 < L34 - L33) * (L33 < L34) + 18 / 19 * ((H34 - H35) * (H34 - H35 > L35 - L34) * (H34 > H35) - (L35 - L34) * (H34 - H35 < L35 - L34) * (L34 < L35) + 18 / 19 * ((H35 - H36) * (H35 - H36 > L36 - L35) * (H35 > H36) - (L36 - L35) * (H35 - H36 < L36 - L35) * (L35 < L36) + 18 / 19 * ((H36 - H37) * (H36 - H37 > L37 - L36) * (H36 > H37) - (L37 - L36) * (H36 - H37 < L37 - L36) * (L36 < L37) + 18 / 19 * ((H37 - H38) * (H37 - H38 > L38 - L37) * (H37 > H38) - (L38 - L37) * (H37 - H38 < L38 - L37) * (L37 < L38) + 18 / 19 * ((H38 - H39) * (H38 - H39 > L39 - L38) * (H38 > H39) - (L39 - L38) * (H38 - H39 < L39 - L38) * (L38 < L39) + 18 / 19 * ((H39 - H40) * (H39 - H40 > L40 - L39) * (H39 > H40) - (L40 - L39) * (H39 - H40 < L40 - L39) * (L39 < L40) + 18 / 19 * ((H40 - H41) * (H40 - H41 > L41 - L40) * (H40 > H41) - (L41 - L40) * (H40 - H41 < L41 - L40) * (L40 < L41) + 18 / 19 * ((H41 - H42) * (H41 - H42 > L42 - L41) * (H41 > H42) - (L42 - L41) * (H41 - H42 < L42 - L41) * (L41 < L42) + 18 / 19 * ((H42 - H43) * (H42 - H43 > L43 - L42) * (H42 > H43) - (L43 - L42) * (H42 - H43 < L43 - L42) * (L42 < L43) + 18 / 19 * ((H43 - H44) * (H43 - H44 > L44 - L43) * (H43 > H44) - (L44 - L43) * (H43 - H44 < L44 - L43) * (L43 < L44) + 18 / 19 * ((H44 - H45) * (H44 - H45 > L45 - L44) * (H44 > H45) - (L45 - L44) * (H44 - H45 < L45 - L44) * (L44 < L45) + 18 / 19 * ((H45 - H46) * (H45 - H46 > L46 - L45) * (H45 > H46) - (L46 - L45) * (H45 - H46 < L46 - L45) * (L45 < L46) + 18 / 19 * ((H46 - H47) * (H46 - H47 > L47 - L46) * (H46 > H47) - (L47 - L46) * (H46 - H47 < L47 - L46) * (L46 < L47) + 18 / 19 * ((H47 - H48) * (H47 - H48 > L48 - L47) * (H47 > H48) - (L48 - L47) * (H47 - H48 < L48 - L47) * (L47 < L48) + 18 / 19 * ((H48 - H49) * (H48 - H49 > L49 - L48) * (H48 > H49) - (L49 - L48) * (H48 - H49 < L49 - L48) * (L48 < L49) + 18 / 19 * ((H49 - H50) * (H49 - H50 > L50 - L49) * (H49 > H50) - (L50 - L49) * (H49 - H50 < L50 - L49) * (L49 < L50) + 18 / 19 * ((H50 - H51) * (H50 - H51 > L51 - L50) * (H50 > H51) - (L51 - L50) * (H50 - H51 < L51 - L50) * (L50 < L51) + 18 / 19 * ((H51 - H52) * (H51 - H52 > L52 - L51) * (H51 > H52) - (L52 - L51) * (H51 - H52 < L52 - L51) * (L51 < L52) + 18 / 19 * ((H52 - H53) * (H52 - H53 > L53 - L52) * (H52 > H53) - (L53 - L52) * (H52 - H53 < L53 - L52) * (L52 < L53) + 18 / 19 * ((H53 - H54) * (H53 - H54 > L54 - L53) * (H53 > H54) - (L54 - L53) * (H53 - H54 < L54 - L53) * (L53 < L54) + 18 / 19 * ((H54 - H55) * (H54 - H55 > L55 - L54) * (H54 > H55) - (L55 - L54) * (H54 - H55 < L55 - L54) * (L54 < L55) + 18 / 19 * ((H55 - H56) * (H55 - H56 > L56 - L55) * (H55 > H56) - (L56 - L55) * (H55 - H56 < L56 - L55) * (L55 < L56) + 18 / 19 * ((H56 - H57) * (H56 - H57 > L57 - L56) * (H56 > H57) - (L57 - L56) * (H56 - H57 < L57 - L56) * (L56 < L57) + 18 / 19 * ((H57 - H58) * (H57 - H58 > L58 - L57) * (H57 > H58) - (L58 - L57) * (H57 - H58 < L58 - L57) * (L57 < L58) + 18 / 19 * ((H58 - H59) * (H58 - H59 > L59 - L58) * (H58 > H59) - (L59 - L58) * (H58 - H59 < L59 - L58) * (L58 < L59) + 18 / 19 * ((H59 - H60) * (H59 - H60 > L60 - L59) * (H59 > H60) - (L60 - L59) * (H59 - H60 < L60 - L59) * (L59 < L60) + 18 / 19 * ((H60 - H61) * (H60 - H61 > L61 - L60) * (H60 > H61) - (L61 - L60) * (H60 - H61 < L61 - L60) * (L60 < L61) + 18 / 19 * ((H61 - H62) * (H61 - H62 > L62 - L61) * (H61 > H62) - (L62 - L61) * (H61 - H62 < L62 - L61) * (L61 < L62) + 18 / 19 * ((H62 - H63) * (H62 - H63 > L63 - L62) * (H62 > H63) - (L63 - L62) * (H62 - H63 < L63 - L62) * (L62 < L63) + 18 / 19 * ((H63 - H64) * (H63 - H64 > L64 - L63) * (H63 > H64) - (L64 - L63) * (H63 - H64 < L64 - L63) * (L63 < L64) + 18 / 19 * ((H64 - H65) * (H64 - H65 > L65 - L64) * (H64 > H65) - (L65 - L64) * (H64 - H65 < L65 - L64) * (L64 < L65) + 18 / 19 * ((H65 - H66) * (H65 - H66 > L66 - L65) * (H65 > H66) - (L66 - L65) * (H65 - H66 < L66 - L65) * (L65 < L66) + 18 / 19 * ((H66 - H67) * (H66 - H67 > L67 - L66) * (H66 > H67) - (L67 - L66) * (H66 - H67 < L67 - L66) * (L66 < L67) + 18 / 19 * ((H67 - H68) * (H67 - H68 > L68 - L67) * (H67 > H68) - (L68 - L67) * (H67 - H68 < L68 - L67) * (L67 < L68) + 18 / 19 * ((H68 - H69) * (H68 - H69 > L69 - L68) * (H68 > H69) - (L69 - L68) * (H68 - H69 < L69 - L68) * (L68 < L69) + 18 / 19 * ((H69 - H70) * (H69 - H70 > L70 - L69) * (H69 > H70) - (L70 - L69) * (H69 - H70 < L70 - L69) * (L69 < L70) + 18 / 19 * ((H70 - H71) * (H70 - H71 > L71 - L70) * (H70 > H71) - (L71 - L70) * (H70 - H71 < L71 - L70) * (L70 < L71) + 18 / 19 * ((H71 - H72) * (H71 - H72 > L72 - L71) * (H71 > H72) - (L72 - L71) * (H71 - H72 < L72 - L71) * (L71 < L72) + 18 / 19 * ((H72 - H73) * (H72 - H73 > L73 - L72) * (H72 > H73) - (L73 - L72) * (H72 - H73 < L73 - L72) * (L72 < L73) + 18 / 19 * ((H73 - H74) * (H73 - H74 > L74 - L73) * (H73 > H74) - (L74 - L73) * (H73 - H74 < L74 - L73) * (L73 < L74) + 18 / 19 * ((H74 - H75) * (H74 - H75 > L75 - L74) * (H74 > H75) - (L75 - L74) * (H74 - H75 < L75 - L74) * (L74 < L75) + 18 / 19 * ((H75 - H76) * (H75 - H76 > L76 - L75) * (H75 > H76) - (L76 - L75) * (H75 - H76 < L76 - L75) * (L75 < L76) + 18 / 19 * ((H76 - H77) * (H76 - H77 > L77 - L76) * (H76 > H77) - (L77 - L76) * (H76 - H77 < L77 - L76) * (L76 < L77) + 18 / 19 * ((H77 - H78) * (H77 - H78 > L78 - L77) * (H77 > H78) - (L78 - L77) * (H77 - H78 < L78 - L77) * (L77 < L78) + 18 / 19 * ((H78 - H79) * (H78 - H79 > L79 - L78) * (H78 > H79) - (L79 - L78) * (H78 - H79 < L79 - L78) * (L78 < L79) + 18 / 19 * ((H79 - H80) * (H79 - H80 > L80 - L79) * (H79 > H80) - (L80 - L79) * (H79 - H80 < L80 - L79) * (L79 < L80) + 18 / 19 * ((H80 - H81) * (H80 - H81 > L81 - L80) * (H80 > H81) - (L81 - L80) * (H80 - H81 < L81 - L80) * (L80 < L81) + 18 / 19 * ((H81 - H82) * (H81 - H82 > L82 - L81) * (H81 > H82) - (L82 - L81) * (H81 - H82 < L82 - L81) * (L81 < L82) + 18 / 19 * ((H82 - H83) * (H82 - H83 > L83 - L82) * (H82 > H83) - (L83 - L82) * (H82 - H83 < L83 - L82) * (L82 < L83) + 18 / 19 * ((H83 - H84) * (H83 - H84 > L84 - L83) * (H83 > H84) - (L84 - L83) * (H83 - H84 < L84 - L83) * (L83 < L84) + 18 / 19 * ((H84 - H85) * (H84 - H85 > L85 - L84) * (H84 > H85) - (L85 - L84) * (H84 - H85 < L85 - L84) * (L84 < L85) + 18 / 19 * ((H85 - H86) * (H85 - H86 > L86 - L85) * (H85 > H86) - (L86 - L85) * (H85 - H86 < L86 - L85) * (L85 < L86) + 18 / 19 * ((H86 - H87) * (H86 - H87 > L87 - L86) * (H86 > H87) - (L87 - L86) * (H86 - H87 < L87 - L86) * (L86 < L87) + 18 / 19 * ((H87 - H88) * (H87 - H88 > L88 - L87) * (H87 > H88) - (L88 - L87) * (H87 - H88 < L88 - L87) * (L87 < L88) + 18 / 19 * ((H88 - H89) * (H88 - H89 > L89 - L88) * (H88 > H89) - (L89 - L88) * (H88 - H89 < L89 - L88) * (L88 < L89) + 18 / 19 * ((H89 - H90) * (H89 - H90 > L90 - L89) * (H89 > H90) - (L90 - L89) * (H89 - H90 < L90 - L89) * (L89 < L90) + 18 / 19 * ((H90 - H91) * (H90 - H91 > L91 - L90) * (H90 > H91) - (L91 - L90) * (H90 - H91 < L91 - L90) * (L90 < L91) + 18 / 19 * ((H91 - H92) * (H91 - H92 > L92 - L91) * (H91 > H92) - (L92 - L91) * (H91 - H92 < L92 - L91) * (L91 < L92) + 18 / 19 * ((H92 - H93) * (H92 - H93 > L93 - L92) * (H92 > H93) - (L93 - L92) * (H92 - H93 < L93 - L92) * (L92 < L93) + 18 / 19 * ((H93 - H94) * (H93 - H94 > L94 - L93) * (H93 > H94) - (L94 - L93) * (H93 - H94 < L94 - L93) * (L93 < L94) + 18 / 19 * ((H94 - H95) * (H94 - H95 > L95 - L94) * (H94 > H95) - (L95 - L94) * (H94 - H95 < L95 - L94) * (L94 < L95) + 18 / 19 * ((H95 - H96) * (H95 - H96 > L96 - L95) * (H95 > H96) - (L96 - L95) * (H95 - H96 < L96 - L95) * (L95 < L96) + 18 / 19 * ((H96 - H97) * (H96 - H97 > L97 - L96) * (H96 > H97) - (L97 - L96) * (H96 - H97 < L97 - L96) * (L96 < L97) + 18 / 19 * ((H97 - H98) * (H97 - H98 > L98 - L97) * (H97 > H98) - (L98 - L97) * (H97 - H98 < L98 - L97) * (L97 < L98) + 18 / 19 * ((H98 - H99) * (H98 - H99 > L99 - L98) * (H98 > H99) - (L99 - L98) * (H98 - H99 < L99 - L98) * (L98 < L99) + 18 / 19 * ((H99 - H100) * (H99 - H100 > L100 - L99) * (H99 > H100) - (L100 - L99) * (H99 - H100 < L100 - L99) * (L99 < L100) + 18 / 19 * ((H100 - H101) * (H100 - H101 > L101 - L100) * (H100 > H101) - (L101 - L100) * (H100 - H101 < L101 - L100) * (L100 < L101) + 18 / 19 * ((H101 - H102) * (H101 - H102 > L102 - L101) * (H101 > H102) - (L102 - L101) * (H101 - H102 < L102 - L101) * (L101 < L102) + 18 / 19 * ((H102 - H103) * (H102 - H103 > L103 - L102) * (H102 > H103) - (L103 - L102) * (H102 - H103 < L103 - L102) * (L102 < L103) + 18 / 19 * ((H103 - H104) * (H103 - H104 > L104 - L103) * (H103 > H104) - (L104 - L103) * (H103 - H104 < L104 - L103) * (L103 < L104) + 18 / 19 * ((H104 - H105) * (H104 - H105 > L105 - L104) * (H104 > H105) - (L105 - L104) * (H104 - H105 < L105 - L104) * (L104 < L105) + 18 / 19 * ((H105 - H106) * (H105 - H106 > L106 - L105) * (H105 > H106) - (L106 - L105) * (H105 - H106 < L106 - L105) * (L105 < L106) + 18 / 19 * ((H106 - H107) * (H106 - H107 > L107 - L106) * (H106 > H107) - (L107 - L106) * (H106 - H107 < L107 - L106) * (L106 < L107) + 18 / 19 * ((H107 - H108) * (H107 - H108 > L108 - L107) * (H107 > H108) - (L108 - L107) * (H107 - H108 < L108 - L107) * (L107 < L108) + 18 / 19 * ((H108 - H109) * (H108 - H109 > L109 - L108) * (H108 > H109) - (L109 - L108) * (H108 - H109 < L109 - L108) * (L108 < L109) + 18 / 19 * ((H109 - H110) * (H109 - H110 > L110 - L109) * (H109 > H110) - (L110 - L109) * (H109 - H110 < L110 - L109) * (L109 < L110) + 18 / 19 * ((H110 - H111) * (H110 - H111 > L111 - L110) * (H110 > H111) - (L111 - L110) * (H110 - H111 < L111 - L110) * (L110 < L111) + 18 / 19 * ((H111 - H112) * (H111 - H112 > L112 - L111) * (H111 > H112) - (L112 - L111) * (H111 - H112 < L112 - L111) * (L111 < L112) + 18 / 19 * ((H112 - H113) * (H112 - H113 > L113 - L112) * (H112 > H113) - (L113 - L112) * (H112 - H113 < L113 - L112) * (L112 < L113) + 18 / 19 * ((H113 - H114) * (H113 - H114 > L114 - L113) * (H113 > H114) - (L114 - L113) * (H113 - H114 < L114 - L113) * (L113 < L114) + 18 / 19 * ((H114 - H115) * (H114 - H115 > L115 - L114) * (H114 > H115) - (L115 - L114) * (H114 - H115 < L115 - L114) * (L114 < L115) + 18 / 19 * ((H115 - H116) * (H115 - H116 > L116 - L115) * (H115 > H116) - (L116 - L115) * (H115 - H116 < L116 - L115) * (L115 < L116) + 18 / 19 * ((H116 - H117) * (H116 - H117 > L117 - L116) * (H116 > H117) - (L117 - L116) * (H116 - H117 < L117 - L116) * (L116 < L117) + 18 / 19 * ((H117 - H118) * (H117 - H118 > L118 - L117) * (H117 > H118) - (L118 - L117) * (H117 - H118 < L118 - L117) * (L117 < L118) + 18 / 19 * ((H118 - H119) * (H118 - H119 > L119 - L118) * (H118 > H119) - (L119 - L118) * (H118 - H119 < L119 - L118) * (L118 < L119) + 18 / 19 * ((H119 - H120) * (H119 - H120 > L120 - L119) * (H119 > H120) - (L120 - L119) * (H119 - H120 < L120 - L119) * (L119 < L120) + 18 / 19 * ((H120 - H121) * (H120 - H121 > L121 - L120) * (H120 > H121) - (L121 - L120) * (H120 - H121 < L121 - L120) * (L120 < L121) + 18 / 19 * ((H121 - H122) * (H121 - H122 > L122 - L121) * (H121 > H122) - (L122 - L121) * (H121 - H122 < L122 - L121) * (L121 < L122) + 18 / 19 * ((H122 - H123) * (H122 - H123 > L123 - L122) * (H122 > H123) - (L123 - L122) * (H122 - H123 < L123 - L122) * (L122 < L123) + 18 / 19 * ((H123 - H124) * (H123 - H124 > L124 - L123) * (H123 > H124) - (L124 - L123) * (H123 - H124 < L124 - L123) * (L123 < L124) + 18 / 19 * ((H124 - H125) * (H124 - H125 > L125 - L124) * (H124 > H125) - (L125 - L124) * (H124 - H125 < L125 - L124) * (L124 < L125) + 18 / 19 * ((H125 - H126) * (H125 - H126 > L126 - L125) * (H125 > H126) - (L126 - L125) * (H125 - H126 < L126 - L125) * (L125 < L126) + 18 / 19 * ((H126 - H127) * (H126 - H127 > L127 - L126) * (H126 > H127) - (L127 - L126) * (H126 - H127 < L127 - L126) * (L126 < L127) + 18 / 19 * ((H127 - H128) * (H127 - H128 > L128 - L127) * (H127 > H128) - (L128 - L127) * (H127 - H128 < L128 - L127) * (L127 < L128))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) > 0

As Craig has already indicated, just change the > 0 to a < 0 at the end of the formula to reverse it.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
mktwizard123
Posted : Thursday, September 21, 2006 1:16:29 PM
Registered User
Joined: 5/17/2006
Posts: 493
thanks for all your help
Bruce_L
Posted : Thursday, September 21, 2006 1:17:08 PM


Worden Trainer

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

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
mktwizard123
Posted : Thursday, September 21, 2006 1:52:27 PM
Registered User
Joined: 5/17/2006
Posts: 493
bruce last question I promise, would the formula be a lot smaller if it wasn't exponential? would the dx period of 27 still stay the same due to the calculations of switching from exp to simple?

If your DX Period is 14, you would use a Smoothing Period of 27 because (2 * 14) - 1 = 27.
If your DX Period is 5, you would use a Smoothing Period of 9 because (2 * 5) - 1 = 9.
Bruce_L
Posted : Thursday, September 21, 2006 2:00:59 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
Yes, but isn't the point to match the relative positions of the +DI and -DI in the ADX indicator? A Simple Moving Average will not do this.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
waltfia
Posted : Saturday, September 23, 2006 3:22:39 PM
Registered User
Joined: 6/3/2006
Posts: 6
I am trying to build a custom indicator / percent true.
1st step, L=MINL21.1
2nd step is to use (L=MINL21.1) as a base plus 5 days, to see is the Close is
Greater than the High at (L=MINL21.1). The purpose is to find legitimate bounces off extreme lows.
The 3rd step is to add the following volume PCF’s,
(V>AVGV21) and (V>V1*2), to see if the bounce is supported with buying.
I can’t seem to tie the PCF’s together to get the desired results, where am I going wrong?
WALTFIA
Craig_S
Posted : Saturday, September 23, 2006 5:42:06 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
I am not sure what you mean by this part:
QUOTE
2nd step is to use (L=MINL21.1) as a base plus 5 days, to see is the Close is
Greater than the High at (L=MINL21.1). The purpose is to find legitimate bounces off extreme lows.


You want today's low to be the lowest low for 22 days (L=MINL21.1) and the volume today (V>V1*2) to be at least twice yesterday AND greater than the 1-month average (V>AVGV21). Correct?

Can you elaborate on step 2?

As an aside, this request has nothing to do with the topic you posted it in. New questions should be posted as new topics. Please review the following video: Learn how to use the forums: post a new topic, reply, Search existing topics

- Craig
Here to Help!
diceman
Posted : Saturday, September 23, 2006 6:53:52 PM
Registered User
Joined: 1/28/2005
Posts: 6,049
waltfia

Try this:

L5=MINL21.6ANDC>H5ANDV>AVGV21ANDV>V1*2

I would try it without the volume
first to see if the price pattern is correct:

L5=MINL21.6ANDC>H5

Then you can experiment with volume levels.

There were only 38 stock "true" for the price pattern
out of the All Stocks watchlist.
-------------------------------------------------------------------------------
I think you would get better results with something
like:

C>MAXH5.1

or:

C>MAXH10.1

with your volume screens added.

There is also this video:

Scan for stocks bouncing in a lateral channel
waltfia
Posted : Monday, September 25, 2006 12:16:47 PM
Registered User
Joined: 6/3/2006
Posts: 6
Craig, I watched the video and it was helpful. Thank you.

Diceman I will try your suggestions. Thanks
Craig_S
Posted : Monday, September 25, 2006 12:17:55 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
You are welcome

- Craig
Here to Help!
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.