|
PureBytes Links
Trading Reference Links
|
Hi Roy,It worked like magic.Thanks a ton.
Regards
On 10/8/05, Roy Larsen <rlarsen@xxxxxxxxxxxxxx> wrote:
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
SPONSORED LINKS
YAHOO! GROUPS LINKS
|