|
PureBytes Links
Trading Reference Links
|
Roy:
Thanks for the prompt reply. I had looked at the IsDefined() function, but as I understand it, it only returns a "1" or a "0"; not the value of the underlying formula. So I could not see how to make it useful.
You reference "procedures that already worked in 6.52". Since ver 8 is my first Metastock, I don't know these historical procedures. Could you elaborate, or direct me to where I might find something? I had searched several Metastock forums, as well as lists of formulas (Guppy, etc.) but could never find anything that seemed to fit my needs.
Harry
--- In equismetastock@xxxxxxxxxxxxxxx, "Roy Larsen" <rlarsen@xxxx> wrote:
> 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@xxxx>
> 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/
|