Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |