Hi Nicholas,
I wish I could answer your question with some authority, but I'm pretty new at this stuff and wouldn't want to lead you in the wrong direction. I'll defer to someone else to answer...
However, I use the second of the following formulas (which came from the Equis website) to create a weekly MACD Histogram using daily data. Perhaps you can modify it to fit your needs? In case you're not familiar with the "histogram", it displays only one line instead of the usual two associated with an MACD. In the histogram, when the line crosses above "0", an MACD buy signal is indicated.
MACD Histogram
rev. 03/18/98
These two formulas are for the Dr. Alexander Elder indicators.
The custom formula for the MACD Histogram is:
( Mov( C,12,E ) - Mov( C,26,E ) ) - Mov( ( Mov( C,12,E ) - Mov( C,26,E ) ),9,E )
The custom formula for the Weekly MACD Histogram utilizing daily data is:
Mov(If(DayOfWeek()=5,C,Peak(1,If(DayOfWeek()=5,C,0),1)),60,E)-
Mov(If(DayOfWeek()=5,C,Peak(1,If(DayOfWeek()=5,C,0),1)),130,E)-
Mov(Mov(If(DayOfWeek()=5,C,Peak(1,If(DayOfWeek()=5,C,0),1)),60,E)-
Mov(If(DayOfWeek()=5,C,Peak(1,If(DayOfWeek()=5,C,0),1)),130,E),45,E)
I found this, and many other formulas here:
equis.com
Hope that helps,
David Raine
Vancouver
|
