Registered User Joined: 11/2/2004 Posts: 12
|
Craig/Bruce...Your help is PRICELESS. If I'm correct PW made a video for macd where the Mid-Win had macd-hist in green and the Bot-Win had tall green^ showing bullish buys. My tab shows: %True(XAVGC12-XAVGC26)...1Period.
Could you direct me to the explanation for this PCF ? doc355
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
I need you to edit the Percent True indicator you have on your tab and give me the full formula.
Click the EDIT button on the chart then the indicator in the bottom window. You should see the full formula there.
- Craig Here to Help!
|
|
Registered User Joined: 11/2/2004 Posts: 12
|
%True Ind. Craig, my formulae may have some errors ??
(XAVGC12-XAVGC26)-(XAVG(XAVGC9,12)-XAVG(XAVGC26,9)) (XAVGC12-XAVGC26)-(XAVG(XAVGC12,9)-XAVG(XAVGC26,9)) >(XAVGC12.1-XAVGC26.1)-(XAVGC12-XAVGC26)- (XAVG(XAVGC26.1,9)) AND(XAVGC12-XAVGC26)- (XAVG(XAVGC12,9)-XAVG(XAVGC26,9))<0 AND (XAVGC12.1- XAVGC26.1)-(XAVG(XAVGC12.1,9)-XAVG(XAVGC26.1,9)) < (XAVGC12.2-XAVGC26.2)-(XAVG(XAVGC12.2,9)- XAVG(XAVGC26.2,9)) AND (XAVGC12.2-XAVGC26.2)- (XAVG(XAVGC12.2,9)- XAVG(XAVGC26.2,9))< (XAVGC12.3- XAVGC26.3)-XAVG(XAVGC12.3,9)- XAVG(XAVGC26.3,9)) AND (XAVGC12.3-XAVGC26.3)-(XAVGC12.3,9)-XAVGC26.3,9))<0
This is bullish ?? To make it bearish, would I change the "<" to ">" ??
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
Try this:
(XAVGC12-XAVGC26)-(XAVG(XAVGC12,9)-XAVG(XAVGC26,9)) >(XAVGC12.1-XAVGC26.1)-(XAVGC12-XAVGC26)- (XAVG(XAVGC26.1,9)) AND(XAVGC12-XAVGC26)- (XAVG(XAVGC12,9)-XAVG(XAVGC26,9))<0 AND (XAVGC12.1- XAVGC26.1)-(XAVG(XAVGC12.1,9)-XAVG(XAVGC26.1,9)) < (XAVGC12.2-XAVGC26.2)-(XAVG(XAVGC12.2,9)- XAVG(XAVGC26.2,9)) AND (XAVGC12.2-XAVGC26.2)- (XAVG(XAVGC12.2,9)- XAVG(XAVGC26.2,9))< (XAVGC12.3- XAVGC26.3)-XAVG(XAVGC12.3,9)- XAVG(XAVGC26.3,9)) AND (XAVGC12.3-XAVGC26.3)-(XAVGC12.3,9)-XAVGC26.3,9))<0
- Craig Here to Help!
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
lake355, I suspect your formula is designed to detect when the Exponential MACD Histogram (12,26,9) has started an upturn after being down for at least two periods while remaining below the zero line. If this is correct, you may wish to try the following instead:
XAVGC12 - XAVGC26 - XAVG(XAVGC12,9) + XAVG(XAVGC26,9) > XAVGC12.1 - XAVGC26.1 - XAVG(XAVGC12.1,9) + XAVG(XAVGC26.1,9) AND XAVGC12 - XAVGC26 - XAVG(XAVGC12,9) + XAVG(XAVGC26,9) < 0 AND XAVGC12.1 - XAVGC26.1 - XAVG(XAVGC12.1,9) + XAVG(XAVGC26.1,9) < XAVGC12.2 - XAVGC26.2 - XAVG(XAVGC12.2,9) + XAVG(XAVGC26.2,9) AND XAVGC12.2 - XAVGC26.2 - XAVG(XAVGC12.2,9) + XAVG(XAVGC26.2,9) < XAVGC12.3 - XAVGC26.3 - XAVG(XAVGC12.3,9) + XAVG(XAVGC26.3,9) AND XAVGC12.3 - XAVGC26.3 - XAVG(XAVGC12.3,9) + XAVG(XAVGC26.3,9) < 0
It is possible to simplify this somewhat (although the result is less intuitive):
3 * XAVGC26 - 17 * XAVGC12 + 14 * XAVGC9 > 3 * XAVGC26.1 - 17 * XAVGC12.1 + 14 * XAVGC9.1 AND 3 * XAVGC26 - 17 * XAVGC12 + 14 * XAVGC9 < 0 AND 3 * XAVGC26.1 - 17 * XAVGC12.1 + 14 * XAVGC9.1 < 3 * XAVGC26.2 - 17 * XAVGC12.2 + 14 * XAVGC9.2 AND 3 * XAVGC26.2 - 17 * XAVGC12.2 + 14 * XAVGC9.2 < 3 * XAVGC26.3 - 17 * XAVGC12.3 + 14 * XAVGC9.3 AND 3 * XAVGC26.3 - 17 * XAVGC12.3 + 14 * XAVGC9.3 < 0
As a trainer I can't characterize it as being either bullish or bearish, but reversing the signs should create a formula to detect when the Exponential MACD Histogram (12,26,9) has started a downturn after being up for at least two periods while remaining above the zero line:
3 * XAVGC26 - 17 * XAVGC12 + 14 * XAVGC9 < 3 * XAVGC26.1 - 17 * XAVGC12.1 + 14 * XAVGC9.1 AND 3 * XAVGC26 - 17 * XAVGC12 + 14 * XAVGC9 > 0 AND 3 * XAVGC26.1 - 17 * XAVGC12.1 + 14 * XAVGC9.1 > 3 * XAVGC26.2 - 17 * XAVGC12.2 + 14 * XAVGC9.2 AND 3 * XAVGC26.2 - 17 * XAVGC12.2 + 14 * XAVGC9.2 > 3 * XAVGC26.3 - 17 * XAVGC12.3 + 14 * XAVGC9.3 AND 3 * XAVGC26.3 - 17 * XAVGC12.3 + 14 * XAVGC9.3 > 0
You may wish to review the following:
doc355 Understanding MACD Cascades of Moving Averages PFC's for WSSS II
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
BTW, lake, these formulas do not match the PCFs given in the PW Winning Stock Selection Simplified Vol II video.
- Craig Here to Help!
|
|
Registered User Joined: 11/2/2004 Posts: 12
|
Craig...Appreciate your help. Copied your PCF and found my errors. It tested OKay. However, I do not have the tall ^"spikes" in the bottom window as I originally had. These tall^ "spikes" show the signals. Is there an explanation for this PCF somewhere ??
I thought I recall a video, but I am not sure. doc355
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
There are MACD formulas given in the video I mentioned above. If you have it, you may want to review it again.
What are you trying to find with these formulas? Does Bruce's description sound accurate?
- Craig Here to Help!
|
|
Registered User Joined: 1/1/2005 Posts: 2,645
|
QUOTE (Craig_S) Try this:
(XAVGC12-XAVGC26)-(XAVG(XAVGC12,9)-XAVG(XAVGC26,9)) >(XAVGC12.1-XAVGC26.1)-(XAVGC12-XAVGC26)- (XAVG(XAVGC26.1,9)) AND...
Craig,
My guess is that you intended the above to be the MACD Histogram moved up today. If so, it is in need of repair.
If I am correct, please delete this.
Thanks, Jim Murphy
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
All I did was remove the double line from his formula. I did not audit the forumula beyond that.
- Craig Here to Help!
|
|
Guest-1 |