|
PureBytes Links
Trading Reference Links
|
Harry
This is exactly the situation that a properly implemented IsDefined()
function would solve. Unfortunately the implementation is half baked and
therefore of no use at all, other than simplifying procedures that already
worked in 6.52.
Sorry I can't be more help.
Roy
----- Original Message -----
From: "bex1210" <hmw3@xxxxxxxxxxxxxx>
To: <equismetastock@xxxxxxxxxxxxxxx>
Sent: Saturday, June 28, 2003 5:21 AM
Subject: [EquisMetaStock Group] IF () statement question
> I am in the process of creating a Diffusion Index for Fidelity Select
Funds. I am using a weekly period. (I have Metastock 8.01 EOD) The formula
is a series of IF () statements, using the Security () function to reference
each of the specific funds. It simply sums the results. That is, if today's
close on each of the 40 funds is higher than it's close 39 weeks ago, the
Indicator would plot 100. If none of today's close are higher, it would plot
0. The results are normally between 10 and 90. I have listed the basic setup
at the bottom of this message.
>
> My problem is caused by the fact that Fidelity continually adds new Funds
to their Select list. Although most have been around since 1991, some were
new in 1999 and 2000. If, for example on the list below, FSAVX was new on
1/1/2000, then the earliest the formula would plot ANY indicator is 39 weeks
after 1/1/2000, even if all of the other funds on the list were started in
1991. Apparently, if any of the IF () statements cannot compute due to lack
of data, then the complete formula doesn't function, and nothing is plotted.
>
> What I would like is a setup so that if an IF () statement does not
compute, only it is ignored, and the rest of the formula functions, and the
indicator plots.
>
> Does anyone know how I can accomplish this?
>
> (I realize that my "B" variable would not be correct, since I would not
have the funds counted correctly, but for my use, that would be much better
than having no indicator at all.)
>
>
> Thanks in advance for your help,
>
> Harry
>
> **************************
> A:=-Input("LookBack (Weeks) ?",2,999,39);
> DA:=Input("Funds in Index ?",2,99,40);
> B:=(100/DA);
>
> If(Security("FSAIX",C)>Ref(Security("FSAIX",C),A),B,0)+
> If(Security("FSAVX",C)>Ref(Security("FSAVX",C),A),B,0)+
> If(Security("FSRBX",C)>Ref(Security("FSRBX",C),A),B,0)+
> If(Security("FBIOX",C)>Ref(Security("FBIOX",C),A),B,0)+
> If(Security("FSLBX",C)>Ref(Security("FSLBX",C),A),B,0)+
> If(Security("FBSOX",C)>Ref(Security("FBSOX",C),A),B,0)+
> etc., etc.
> ************************************
>
>
>
> 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/
>
>
>
>
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Get A Free Psychic Reading! Your Online Answer To Life's Important Questions.
http://us.click.yahoo.com/Lj3uPC/Me7FAA/ySSFAA/BefplB/TM
---------------------------------------------------------------------~->
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/
|