Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

MACD PCF Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
Tallone
Posted : Wednesday, March 4, 2009 11:52:36 AM
Registered User
Joined: 2/7/2005
Posts: 16
Is there a PCF for MACD?
Bruce_L
Posted : Wednesday, March 4, 2009 11:57:52 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
Welcome to the forums. A very good foundation for learning how to use TeleChart can be gained by reviewing the following:

If you are new to TeleChart READ THIS FIRST!

The exact formula would depend on your MACD settings and if you are interested in the raw MACD, its Moving Average Signal Line or the MACD Histogram:

Understanding MACD

- Short: ?
- Long: ?
- Period: ?
- Average Type: Simple or Exponential?
- Plot MACD as Histogram: Checked or Unchecked?

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Tallone
Posted : Wednesday, March 4, 2009 12:10:15 PM
Registered User
Joined: 2/7/2005
Posts: 16

Hello Bruce,

Thanks for the reply.  What I am thinking I want to do is to scan for when the MACD closes above the upper Bollinger Band.  Also, one where the MACD closes below the lower Bollinger Band.  Is this possible?  These appear to be good pivot point signals.

Emmette

Bruce_L
Posted : Wednesday, March 4, 2009 12:30:50 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
Do you mean the MACD closes above a Bollinger Band of MACD or a Bollinger Band of Price? A MACD and a Bollinger Band of Price are not on the same scale and any crossovers will change with Zoom.

If you mean a Bollinger Band of MACD, the formula would still depend on all of the things mentioned in my first response, plus your Bollinger Band settings (and may or may not be too long to be practical depending on the resulting combination):

Modelling Bollinger Bands (& Standard Deviation) in a TC PCF

- Period: ?
- Width: ?

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Tallone
Posted : Wednesday, March 4, 2009 1:59:07 PM
Registered User
Joined: 2/7/2005
Posts: 16
Bruce,

I mean a Bollinger Band of MACD.  I have reviewed the info you directed me to and I can now see this is not an easy and/or simple PCF to accomplish.  Thanks for your help.  Back to school now.

Emmette
Bruce_L
Posted : Wednesday, March 4, 2009 2:14:37 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
It may be complicated, but I will do my best to help you create the Personal Criteria Formula if you provide the settings of both the MACD (including which MACD component is of interest) and the Bollinger Bands.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Tallone
Posted : Wednesday, March 4, 2009 2:21:28 PM
Registered User
Joined: 2/7/2005
Posts: 16

Hey Bruce,

You Worden guys are GREAT.  We have a TC users group here in Houston and this has been a topic of discussion.  The settings discussed are:  MACD 2,8,1 and BB 17,13

Thanks,
Emmette

 

 

Bruce_L
Posted : Wednesday, March 4, 2009 2:47:51 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
I'm going to assume you are interested in the raw MACD and not the Signal Line or Histogram based on the periods provided, but I still need to know if the MACD is Simple or Exponential.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Tallone
Posted : Wednesday, March 4, 2009 3:02:09 PM
Registered User
Joined: 2/7/2005
Posts: 16
Hi Bruce,

Please make the MACD simple and use the raw MACD.

Thanks,
Emmette
Bruce_L
Posted : Wednesday, March 4, 2009 3:06:12 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
Please try the following:

Simple raw MACD 2,8 above it own Upper BB 17,13:

AVGC2 - AVGC8 > AVG(AVGC2,17) - AVG(AVGC8,17) + 1.3 * SQR(ABS((AVGC2 - AVGC8) ^ 2 + (AVGC2.1 - AVGC8.1) ^ 2 + (AVGC2.2 - AVGC8.2) ^ 2 + (AVGC2.3 - AVGC8.3) ^ 2 + (AVGC2.4 - AVGC8.4) ^ 2 + (AVGC2.5 - AVGC8.5) ^ 2 + (AVGC2.6 - AVGC8.6) ^ 2 + (AVGC2.7 - AVGC8.7) ^ 2 + (AVGC2.8 - AVGC8.8) ^ 2 + (AVGC2.9 - AVGC8.9) ^ 2 + (AVGC2.10 - AVGC8.10) ^ 2 + (AVGC2.11 - AVGC8.11) ^ 2 + (AVGC2.12 - AVGC8.12) ^ 2 + (AVGC2.13 - AVGC8.13) ^ 2 + (AVGC2.14 - AVGC8.14) ^ 2 + (AVGC2.15 - AVGC8.15) ^ 2 + (AVGC2.16 - AVGC8.16) ^ 2 - 17 * (AVG(AVGC2,17) - AVG(AVGC8,17)) ^ 2) / 16)

Simple raw MACD 2,8 below it own Lower BB 17,13:

AVGC2 - AVGC8 < AVG(AVGC2,17) - AVG(AVGC8,17) - 1.3 * SQR(ABS((AVGC2 - AVGC8) ^ 2 + (AVGC2.1 - AVGC8.1) ^ 2 + (AVGC2.2 - AVGC8.2) ^ 2 + (AVGC2.3 - AVGC8.3) ^ 2 + (AVGC2.4 - AVGC8.4) ^ 2 + (AVGC2.5 - AVGC8.5) ^ 2 + (AVGC2.6 - AVGC8.6) ^ 2 + (AVGC2.7 - AVGC8.7) ^ 2 + (AVGC2.8 - AVGC8.8) ^ 2 + (AVGC2.9 - AVGC8.9) ^ 2 + (AVGC2.10 - AVGC8.10) ^ 2 + (AVGC2.11 - AVGC8.11) ^ 2 + (AVGC2.12 - AVGC8.12) ^ 2 + (AVGC2.13 - AVGC8.13) ^ 2 + (AVGC2.14 - AVGC8.14) ^ 2 + (AVGC2.15 - AVGC8.15) ^ 2 + (AVGC2.16 - AVGC8.16) ^ 2 - 17 * (AVG(AVGC2,17) - AVG(AVGC8,17)) ^ 2) / 16)

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Tallone
Posted : Wednesday, March 4, 2009 3:16:12 PM
Registered User
Joined: 2/7/2005
Posts: 16
Thank you Bruce.  Will give it a try.

Emmette
tcalhoun
Posted : Tuesday, September 8, 2015 1:14:21 AM
Gold Customer Gold Customer

Joined: 9/21/2014
Posts: 3

MACD help please. I am looking simply for a pcf formula of the 12,26 MACD crossing up the 9 EMA.  I have other formulas such as this C1<AVGC8.1 AND C>AVGC8 and v>avgv50 that i plot using the histogram and overlay it on my candlestick charts to visualy give me a line on the chart when it occurs. I would like to do the same with MACD crossing up the 9 EMA but can't seem to figure it out.

 

Thanks in advance

Terry

Bruce_L
Posted : Tuesday, September 8, 2015 10:06:23 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

A Condition Formula for the exponential MACD 12,26 crossing up through its own 9 period exponential moving average can be written as follows.

XAVGC12 - XAVGC26 > XAVG(XAVGC12,9) - XAVG(XAVGC26,9) AND XAVGC12.1 - XAVGC26.1 > XAVG(XAVGC12.1,9) - XAVG(XAVGC26.1,9)

Moving Average Convergence Divergence (MACD) and Histogram
Understanding MACD



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
tcalhoun
Posted : Wednesday, September 9, 2015 1:28:29 AM
Gold Customer Gold Customer

Joined: 9/21/2014
Posts: 3

Thank you for help Bruce. Excellent service as always.

 

Terry

Bruce_L
Posted : Wednesday, September 9, 2015 9:48:12 AM


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.