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 |

MACD _PW Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
xxlake355xx
Posted : Thursday, August 3, 2006 10:10:07 AM
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
Craig_S
Posted : Thursday, August 3, 2006 10:15:19 AM


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!
xxlake355xx
Posted : Thursday, August 3, 2006 2:07:44 PM
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 ">" ??
Craig_S
Posted : Thursday, August 3, 2006 2:40:13 PM


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!
Bruce_L
Posted : Thursday, August 3, 2006 3:14:14 PM


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
Craig_S
Posted : Thursday, August 3, 2006 3:15:53 PM


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!
xxlake355xx
Posted : Thursday, August 3, 2006 3:33:22 PM
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
Craig_S
Posted : Thursday, August 3, 2006 3:36:18 PM


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!
bustermu
Posted : Thursday, August 3, 2006 3:52:12 PM
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
Craig_S
Posted : Thursday, August 3, 2006 3:58:20 PM


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!
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.