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


New account application Trading resources
Margin rates Stock & option commissions

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

PCF Formula Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
kpnicholson
Posted : Friday, January 12, 2007 3:45:54 PM
Registered User
Joined: 11/1/2005
Posts: 78
Hello,

Bruce gave me the following formula for me to use in finding out when Bill Williams Alligator lines(5,8,13) were Greater then the Previous line...

(XAVGH9.3 + XAVGL9.3) / 2 AND XAVGH9.3 + XAVGL9.3 > XAVGH15.5 + XAVGL15.5 AND XAVGH15.5 + XAVGL15.5 > XAVGH25.8 + XAVGL25.8

Can you put this in english so I can understand why you used the Expnential Average of the H and L and why the numbers used... This all works correctly... I just would like to understand...

I am trying to create another PCF to find out when the Green line crosses over the Red or blue lines... I am trying to find stocks where the Alligator's mouth is Closing...

Bruce, if you have any suggestions to determine the closing of the mouth... I would really like to understand how to do this...

Thank again for helping,
Keith Nicholson
Bruce_L
Posted : Friday, January 12, 2007 4:35:30 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
QUOTE (kpnicholson)
Bruce gave me the following formula for me to use in finding out when Bill Williams Alligator lines(5,8,13) were Greater then the Previous line...

(XAVGH9.3 + XAVGL9.3) / 2 AND XAVGH9.3 + XAVGL9.3 > XAVGH15.5 + XAVGL15.5 AND XAVGH15.5 + XAVGL15.5 > XAVGH25.8 + XAVGL25.8

I don't think I gave you that (see PCF question). The formula as posted will not do what you say. The part after the first AND should:

XAVGH9.3 + XAVGL9.3 > XAVGH15.5 + XAVGL15.5 AND XAVGH15.5 + XAVGL15.5 > XAVGH25.8 + XAVGL25.8

(XAVGH9.3 + XAVGL9.3) / 2 is the green line.
(XAVGH15.5 + XAVGL15.5) / 2 is the red line.
(XAVGH25.8 + XAVGL25.8) / 2 is the blue line.

The Alligator Lines are essentially shifted Wilder's Smoothed Moving Averages of the midpoint between the High and Low. This midpoint can be expressed as (H + L) / 2. Wilder's Smoothing is just a type of Exponential Smoothing and can be reproduced using an Exponential Moving Average with a period that is twice the Wilder's Period minus one: ((2 * Wilder's Period) - 1) = Exponential Period. The 3, 5 and 8 are just days ago parameters. There's no need to include the ()/2 portions because they are on both sides of each comparison.

QUOTE (kpnicholson)
I am trying to create another PCF to find out when the Green line crosses over the Red or blue lines...

Green crossing up through Red or Blue:

(XAVGH9.3 + XAVGL9.3 > XAVGH15.5 + XAVGL15.5 AND XAVGH9.4 + XAVGL9.4 <= XAVGH15.6 + XAVGL15.6) OR (XAVGH9.3 + XAVGL9.3 > XAVGH25.8 + XAVGL25.8 AND XAVGH9.4 + XAVGL9.4 <= XAVGH25.9 + XAVGL25.9)

Green crossing down through Red or Blue:

(XAVGH9.3 + XAVGL9.3 < XAVGH15.5 + XAVGL15.5 AND XAVGH9.4 + XAVGL9.4 >= XAVGH15.6 + XAVGL15.6) OR (XAVGH9.3 + XAVGL9.3 < XAVGH25.8 + XAVGL25.8 AND XAVGH9.4 + XAVGL9.4 >= XAVGH25.9 + XAVGL25.9)

QUOTE (kpnicholson)
I am trying to find stocks where the Alligator's mouth is Closing...

Bruce, if you have any suggestions to determine the closing of the mouth... I would really like to understand how to do this...

What constitutes closing? The lines getting closer together? If so, you may want to try something like the following:

ABS(XAVGH9 + XAVGL9 - XAVGH15.2 - XAVGL15.2) + ABS(XAVGH9 + XAVGL9 - XAVGH25.5 - XAVGL25.5) + ABS(XAVGH15.2 + XAVGL15.2 - XAVGH25.5 - XAVGL25.5) < ABS(XAVGH9.1 + XAVGL9.1 - XAVGH15.3 - XAVGL15.3) + ABS(XAVGH9.1 + XAVGL9.1 - XAVGH25.6 - XAVGL25.6) + ABS(XAVGH15.3 + XAVGL15.3 - XAVGH25.6 - XAVGL25.6)

You may wish to review the following:

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

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
kpnicholson
Posted : Friday, January 12, 2007 4:55:30 PM
Registered User
Joined: 11/1/2005
Posts: 78
Hi Bruce,

I guess I am now a little confused...

I thank you for the new PCF's... That is what I was looking for and Yes, "Closing" means getting closer together...

How do I find the email 17735...?

What I was trying to do was to have the scan keep the 3 lines greater then each other of less then each other based on Bearish or bullish... What did I do wrong in my scan... Here is the Original PCD I enter in TC2007...

Bullish:
H < H1 AND H1 < H2 AND L < L1 AND L1 < L2 AND O < C AND C > ((H + L) / 2) AND MINV50 > 10000 AND C < (XAVGH9.3 + XAVGL9.3) / 2 AND XAVGH9.3 + XAVGL9.3 < XAVGH15.5 + XAVGL15.5 AND XAVGH15.5 + XAVGL15.5 < XAVGH25.8 + XAVGL25.8 AND C >= 20 AND C <= 150

Bearish:
H > H1 AND H1 > H2 AND L > L1 AND L1 > L2 AND O > C AND C < ((H + L) / 2) AND MINV50 > 10000 AND C > (XAVGH9.3 + XAVGL9.3) / 2 AND XAVGH9.3 + XAVGL9.3 > XAVGH15.5 + XAVGL15.5 AND XAVGH15.5 + XAVGL15.5 > XAVGH25.8 + XAVGL25.8 AND C >= 20 AND C <= 150

What do I need to change...

Sorry to be not clear...

Thanks,

Keith
Bruce_L
Posted : Friday, January 12, 2007 5:09:39 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
Those Personal Criteria Formulas aren't what I said wouldn't do what you want, this was:

(XAVGH9.3 + XAVGL9.3) / 2 AND XAVGH9.3 + XAVGL9.3 > XAVGH15.5 + XAVGL15.5 AND XAVGH15.5 + XAVGL15.5 > XAVGH25.8 + XAVGL25.8

It's the (XAVGH9.3 + XAVGL9.3) / 2 AND part that doesn't make sense as seen in this formula. It's a value that's being AND'd with Boolean formula components. It also is not a part of the comparison described.

It does make sense in the formulas in your most recent post because it has a C < or C > in front of it.

The 17735 is not a reference to an email. It was supposed to be a reference to specific post by topic number, but I left out the [tid= at the front and the ] at the end. I've fixed it in the original post.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
kpnicholson
Posted : Friday, January 12, 2007 5:17:29 PM
Registered User
Joined: 11/1/2005
Posts: 78
thanks Bruce...

If I now understand your message... The Bearish and Bullish PCF that you had helped me with is correct... Sorry for leaving out the C < or C >...

I will enter your new information that you have given me...

Thanks,
Keith
Bruce_L
Posted : Friday, January 12, 2007 5:24:44 PM


Worden Trainer

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

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.