|
Hi Investman
The problem is the Input() function. You must
remove it and substitute just the constants you want.
shortperiods:=12;
longperiods:=26;
signal:=9;
Tema(C,shortperiods)-Tema(C,longperiods);
Mov(Tema(C,shortperiods) -
Tema(C,longperiods),signal,E)
The "Signal" constant appears to be redundant so
you could probably remove that definition. Your use of column A and the Filter
is quite OK and your exploration should work once the column A formula conforms
to the rules (or in this case, more of an exception to the rules).
{Column A}
shortperiods:=12;
longperiods:=26;
signal:=9;
Tema(C,shortperiods)-Tema(C,longperiods);
Mov(Tema(C,shortperiods) -
Tema(C,longperiods),signal,E);
{Filter}
Cross(colA,0);
Don't forget to make sure the Explorer is set to
100 or more records. You'll get inaccurate results if you use the "Minimum
Records" setting. You can test the explorer results against the "Test Indicator"
results by creating the indicator below in the Indicator Builder (delete after
use). This indicator will show a binary TRUE state when the cross occurs, and
that's the condition you're looking for with the exploration. Notice that while
Input() is not an accptable function in the Explorer, colA (or b, C etc) is not
acceptable in the Indicator Builder. These exceptions to the rule that all
functions work in all tools are few and far between, but they can trip up the
unwary or newer user.
{Test Indicator}
shortperiods:=12;
longperiods:=26;
signal:=9;
Tema(C,shortperiods)-Tema(C,longperiods);
ColumnA:=Mov(Tema(C,shortperiods)
- Tema(C,longperiods),signal,E);
Cross(ColumnA,0);
Regards
Roy
----- Original Message -----
Sent: Saturday, October 08, 2005 3:30 PM
Subject: [Norton AntiSpam] Re: [EquisMetaStock Group] MACD smoothed
TEMA indicator in Explorer - Help
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 -----
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
YAHOO! GROUPS LINKS
|