| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
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 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
|
|
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
|
|
|
Guest-1 |