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

Re: [EquisMetaStock Group] MACD smoothed TEMA indicator in Explorer - Help



PureBytes Links

Trading Reference Links

Hi Roy,
 
The formula for the "MACD (Tema smoothed)" is already there as an indicator when I installed the Metastock. The indicator formula is as following:
 
shortperiods:=Input("Enter the shorter TEMA periods:  ",3,20,12);
longperiods:=Input("Enter the longer TEMA periods:  ",21,50,26);
signal:=Input("Enter the number of signal line periods:  ",3,50,9);
Tema(C,shortperiods)-Tema(C,longperiods);
Mov(Tema(C,shortperiods) - Tema(C,longperiods),signal,E)
 
Now I am trying to reference this formula in Explorer to screen stocks where this indicator has crossed zero line from below. I am getting an error ' this function is not allowed in this type of formula'. I am a novice to using the MS formula language. I have put the above formula in ColA and the in the filter I have put the formula: cross(ColA,0). This may be a silly way of writing the formula but as I said I am a novice.
 
Kindly help. Thanks

 
On 10/7/05, Roy Larsen <rlarsen@xxxxxxxxxxxxxx> wrote:
Hi bvpr
 
 
It would help if you showed the formula that's not working. Tema and MACD both use exponential moving averages so changing the Explorer from using "Minimum Records" to using about 150 bars should correct erroneous results. Of course, that's assuming that your formula is correct and functions OK when used as an indicator, which is a good way to check and troubleshoot individual exploration columns by the way.
 
 
Regards
 
Roy
 
 
----- Original Message -----
From: bvpr1
Sent: Saturday, October 08, 2005 6:12 AM
Subject: [EquisMetaStock Group] MACD smoothed TEMA indicator in Explorer - Help

 
Hi, I would like to use MACD smoothed TEMA indicator of Equis in
explorer. I would like to list out the stocks where the indicator has
crossed the zero line from below. Can any one help please. I have tried
to use the indicator in explorer but it is not working.





YAHOO! GROUPS LINKS






SPONSORED LINKS
Business finance course Business finance online course Business finance class
Small business finance Business finance small software Business finance online


YAHOO! GROUPS LINKS