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

Understanding MACD Topic Rating:
Previous Topic · Next Topic Watch this topic · Print this topic ·
bull1
Posted : Sunday, April 13, 2008 4:29:06 AM
Registered User
Joined: 3/9/2005
Posts: 10
Hi, I am a newbie
What is exactly meant by   XAVG(XAVGC12,9)
thanks.
Bruce_L
Posted : Sunday, April 13, 2008 2:10:28 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
bull1,
It represents the 9-Period Exponential Moving Average of the 12-Period Exponential Moving Average of the Close in TeleChart's Personal Criteria Formula Language. You may wish to review the following:

PCF Formula Descriptions

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
tyro
Posted : Tuesday, August 5, 2008 12:52:18 PM
Registered User
Joined: 5/4/2006
Posts: 4
Craig, Many thanks for a very clear answer to my query
Craig_S
Posted : Tuesday, August 5, 2008 3:06:07 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
My pleasure!

- Craig
Here to Help!
bboisky
Posted : Saturday, February 7, 2009 2:41:10 PM
Registered User
Joined: 10/7/2004
Posts: 25

THANKS FOR A GREAT JOB ON MACD AND THE PCF'S!!! BBOISKY

BullHorn
Posted : Tuesday, May 19, 2009 10:05:08 PM
Registered User
Joined: 10/7/2004
Posts: 35
So how would I use a PCF to show a Histogram of MACD of 3,8,10 that is below zero but moving above its Exp. MA 4 of this MACD 3,8,10 ?
With all I've read I just cant figure this one out...
Bruce_L
Posted : Wednesday, May 20, 2009 9:10:31 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
BullHorn,
The basic problem would be that the following formula isn't valid because you can't put a formula or another function inside an XAVG() function.

XAVGC3 - XAVGC8 - XAVG(XAVGC3,10) + XAVG(XAVGC8,10) < 0 AND XAVGC3 - XAVGC8 - XAVG(XAVGC3,10) + XAVG(XAVGC8,10) > XAVG(XAVGC3,4) - XAVG(XAVGC8,4) - XAVG(XAVG(XAVGC3,10),4) + XAVG(XAVG(XAVGC8,10),4) AND XAVGC3.1 - XAVGC8.1 - XAVG(XAVGC3.1,10) + XAVG(XAVGC8.1,10) <= XAVG(XAVGC3.1,4) - XAVG(XAVGC8.1,4) - XAVG(XAVG(XAVGC3.1,10),4) + XAVG(XAVG(XAVGC8.1,10),4)

Since none of the Moving Average Periods match, we can uncascade the Moving Averages using the techniques described in Cascades of Moving Averages to come up with the following equivalent but simplified formula however:

2 * XAVGC3 + 5 * XAVGC10 < 7 * XAVGC8 AND 24 * XAVGC3 + 21 * XAVGC8 > 35 * XAVGC4 + 10 * XAVGC10 AND 24 * XAVGC3.1 + 21 * XAVGC8.1 <= 35 * XAVGC4.1 + 10 * XAVGC10.1

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
mohtc
Posted : Saturday, July 25, 2009 9:36:58 PM
Registered User
Joined: 3/20/2005
Posts: 78
This is all great stuff, thanks guys!  : )
I was going to ask how to find the minimum and maximum values of the Exponential MACD Histogram, but you answered that already; thanks.

However I have a question that I did not see answered above.

Is it possible to use the High price instead of the Close?  And the Low price?

Is there some way to use the High price when the stock price is above average, and use the Low price when the stock price is below average (I use linear regression to 'eyeball' above and below average; 15 bars for all of my charts, and one month, two month, etc... linear regression lines in some of my charts).  In other words, I am trying to make the Exponential MACD fit a little better with the stock's actual realtime action but do it on a daily chart.  The stock may reach a new high on a given day, but have a lower close than the prior day, which shifts the MACD that uses Close instead of High.  In some cases it makes the highest bar of the exponential MACD sit under a different daily price bar than the one with the highest high.  (Have I muddied the waters enough, or should I try to explain myself further by getting into the dips in price where the lowest low is not always on the day with the lowest close?)
Bruce_L
Posted : Tuesday, July 28, 2009 10:39:13 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
mohtc,
It would be theoretically possible to do so by manually expanding the Moving Averages and testing if the Price was above or below the Linear Regression at any given point. That said, the resulting formulas would be too long to be practical.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
julian98
Posted : Friday, January 22, 2010 3:35:36 PM
Registered User
Joined: 3/29/2005
Posts: 9

how can one run a scan to find those stocks moving above or below  the macd 0 line change in direction are ther any formulas preset

StockGuy
Posted : Friday, January 22, 2010 3:50:58 PM

Administration

Joined: 9/30/2004
Posts: 9,187
Assuming MACD parameters of 12 and 26, you could use:


Crossing up through 0

AVGC12.1 - AVGC26.1 < 0 and  AVGC12 - AVGC26 > 0

Crossing down through 0

AVGC12.1 - AVGC26.1 > 0 and AVGC12 - AVGC26 < 0
hklala
Posted : Thursday, August 5, 2010 11:38:41 AM
Registered User
Joined: 4/7/2010
Posts: 12
Did we get to the bottom of this issue listed above difference of formula and actual histogram...
Bruce_L
Posted : Thursday, August 5, 2010 11:50:34 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
hklala,
There is no difference between the Personal Criteria Formulas given and the raw MACD, Moving Average Signal Line or MACD Histogram they are designed to represent.

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