| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 2/7/2005
Posts: 16
|
Is there a PCF for MACD?
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
Registered User
Joined: 2/7/2005
Posts: 16
|
Hi Bruce,
Please make the MACD simple and use the raw MACD.
Thanks,
Emmette
|
|
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
|
|
Registered User
Joined: 2/7/2005
Posts: 16
|
Thank you Bruce. Will give it a try.
Emmette
|
|
 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
|
|
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
|
|
Gold Customer
Joined: 9/21/2014
Posts: 3
|
Thank you for help Bruce. Excellent service as always.
Terry
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |