Registered User Joined: 3/9/2005 Posts: 10

Hi, I am a newbie
What is exactly meant by XAVG(XAVGC12,9)
thanks.


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

bull1,
It represents the 9Period Exponential Moving Average of the 12Period 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


Registered User Joined: 5/4/2006 Posts: 4

Craig, Many thanks for a very clear answer to my query


Worden Trainer
Joined: 10/1/2004 Posts: 18,819

My pleasure!
 Craig Here to Help!


Registered User Joined: 10/7/2004 Posts: 25

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


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


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


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?)


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


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


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


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


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


Guest1 