[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [EquisMetaStock Group] Weekly MACD histogram



PureBytes Links

Trading Reference Links

Roy,

Thanks for your excellent advice. As a newbie, it's difficult for me 
to know what to believe and what not to believe on the internet.  
That's why I wish I could analyse any formula that I find - such as 
the weekly MACD in my post.

I found the weekly MACD histogram formula at:
http://www.paritech.com/education/technical/custom/indicators/macd.asp

I have already posted your reply on their Metastock forum, so 
hopefully they will remove their formula from their site, or at least 
try to justify it.

There's a fiendishly complicated formula for weekly MACD at:
www.users.bigpond.com/prominex/MetaStock/Roy-63.txt

I suspect that the Paritech formula is trying to calculate MACD for 
Friday's closing prices only. I verified this by plotting all the 
individual bits and pieces as separate indicators, because I'm too 
inexperienced to understand the formula.  (If you know anyone who 
understands the bit between the {start} and {end}, could you ask them 
to explain it.  It doesn't matter whether they agree with it or not.  
At least I'll learn something.)  I suppose it makes some sense:  the 
daily MACD formula is based on daily closing prices, so the weekly 
MACD formula is based on Friday's closing prices.  Presumably, if 
there were a monthly MACD histogram, it would be based on monthly 
closing prices.

I agree with your comment that the Paritech daily MACD is "slightly 
off".  I found this description of the daily MACD histogram in a book 
by someone called Dr. Alexander Elder (why do all conmen and shysters 
call themselves "Dr"):

Page 129:
1.  Calculate the 12-day and 26-day exponential moving averages of 
closing prices.
2.  Subtract the 26-day EMA from the 12-day EMA to obtain the fast 
MACD line.
3.  Calculate a 9-day EMA of the fast MACD line to obtain the slow 
Signal line. Plot both lines to obtain the classic MACD indicator.
4.  Subtract the Signal line from the MACD line to obtain an MACD-
Histogram.

The "MetaStock canned version", as you call it, is bound to be 
superior, because at least I've heard of Equis :-), but I've never 
heard of Dr. Alexander Elder.

Thanks for your help.

Regards,
Alan


--- In equismetastock@xxxxxxxxxxxxxxx, "Roy Larsen" <rlarsen@xxxx> 
wrote:
> Alan
> 
> 
> 
> > I found the following formulas for daily and weekly MACD:
> 
> Don't take everything you find on the net as being accurate or even 
close to what they purport to
> be. The daily MACD below is OK although slightly off the MetaStock 
canned version. The "weekly MACD"
> is not even close. Ask yourself how a weekly formula can show 5 
different values during one week,
> none of which are anywhere near accurate.
> 
> If this works for you then great, but a weekly MACD it is not.
> 
> Roy
> 
> > Daily:
> > ( Mov( {start}C{end},12,E ) - Mov( C,26,E ) ) - Mov( ( Mov( 
C,12,E ) -
> >  Mov( C,26,E ) ),9,E )
> >
> > Weekly:
> > Mov({start}If(DayOfWeek()=5,C,Peak(1,If(DayOfWeek()=5,C,0),1))
> > {end},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)
> >
> > As a newbie, I'd be grateful if someone could help me to 
understand
> > the bit of the weekly formula between the {start} and {end}
> > comments.
> >
> > I know that this will correspond to the "C" between {start} and 
{end}
> > in the daily formula.
> >
> > I understand what "Peak" does.
> >
> > I don't understand what "DayOfWeek" is doing.
> >
> > Regards,
> > Alan
> >
> >
> >
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >



------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark
Printer at MyInks.com.  Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/BefplB/TM
---------------------------------------------------------------------~->

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
     http://groups.yahoo.com/group/equismetastock/

<*> To unsubscribe from this group, send an email to:
     equismetastock-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
     http://docs.yahoo.com/info/terms/