|
PureBytes Links
Trading Reference Links
|
Zeki, the MetaStock equivalent of ISNA is the IsUndefined() function.
ISNA:=IsUndefined(BarsSince(Cross(RSI(14),25)));
Unfortunately, the null (N/A) bars are persistent in MetaStock, so
it's best to try and remove them at the source:
================
Null bar removal
================
---8<--------------------
{ Removes Null periods from condition,
but not from indicator }
condition:=Cross(RSI(14),25);
ISNA:=IsUndefined(BarsSince(condition));
Init:=Cum(IsDefined(condition))=1;
If(ISNA,0,BarsSince(condition OR Init))
---8<--------------------
jose '-)
http://www.metastocktools.com
--- In equismetastock@xxxxxxxxxxxxxxx, "Zeki Muderrisoglu"
<zmuderrisoglu@xxxx> wrote:
> I keep getting N/A in some stocks in an explorer I'm working on and
the problem is not about loaded data periods. It's just that the
criteria is not met. I'd like to know is there is a command like ISNA
or ISERROR in Metastock like excel so that I can formulate an IF
statement like this;
>
> IF(Cross(RSI(14),25)="N/A",500,BarsSince(Cross(RSI(14),25))) or
>
> IF(Cross(ISNA(RSI(14),25)),BarsSince(Cross(RSI(14),25)))
>
> Thanks for your help.
> Zeki.
------------------------ Yahoo! Groups Sponsor --------------------~-->
In low income neighborhoods, 84% do not own computers.
At Network for Good, help bridge the Digital Divide!
http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/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/
|