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 |