Did it work ? I forgot to include this ,

AA = TargetA - Result;

AB = TargetB + Result;

Am attaching the AFL just in case. 

Cheers

Prashanth

----- Original Message ----- 
From: "Vinay Gakkhar." <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Saturday, September 13, 2008 19:29
Subject: [amibroker] I need little help


> Dear Prashanth,
> 
> Many thanks, it worked like it should.
> 
> Best regards,
> 
> Vinay
> 
> On Sat, 13 Sep 2008 13:08:11 +0530, Prashanth <[EMAIL PROTECTED]>  
> wrote:
> 
> > AddColumn(IIf(Result >0 ,AA, AB),"Column4");
> >
> > Add the above syntax and you should get the required.
> >
> > Cheers
> >
> > Prashanth
> >
> > ----- Original Message -----
> > From: "Vinay Gakkhar." <[EMAIL PROTECTED]>
> > To: <[email protected]>
> > Sent: Saturday, September 13, 2008 12:20
> > Subject: Re: [amibroker] I need little help
> >
> >
> >> Dear Prashanth,
> >>
> >> Many thanks for your, as always, volunteering to help.
> >>
> >> Please check the following:
> >>
> >> TargetA = (Ref(C,-1))*1.05;
> >> TargetB = C*1.02;
> >> Result = ( C-(Ref(C,-1))*100/(Ref(C,-1)) );
> >> AddColumn ( TargetA , "TargetA", 1.0);
> >> AddColumn ( TargetB , "TargetB", 1.0);
> >> AddColumn ( Result , "Result", 1.0);
> >> AddColumn ( TargetA-Result , "Column4", 1.0);; // if Result is a  
> >> positive
> >> figure
> >> AddColumn ( TargetB+Result , "Column4", 1.0);; // if Result is a  
> >> negative
> >> figure
> >> Filter = Result > -3 AND Result < 3 ;
> >>
> >> Here, instead of the two "Column4", I want to have only one which shows
> >> the resultant of "TargetA-Result" if the Result is a positive figure,  
> >> but
> >> shows the resultant of "TargeB+Result" if the Result is a negative  
> >> figure.
> >>
> >> Thanks again,
> >>
> >> Vinay
> >>
> >> On Sat, 13 Sep 2008 08:32:48 +0530, Prashanth <[EMAIL PROTECTED]>
> >> wrote:
> >>
> >> > You can use IIf condition. To get a AFL itself, it would be helpfull  
> >> if
> >> > you
> >> > can provide your AFL so that required modifications can be done on the
> >> > same.
> >> >
> >> > Cheers
> >> >
> >> > Prashanth
> >> > ----- Original Message -----
> >> > From: "Vinay Gakkhar." <[EMAIL PROTECTED]>
> >> > To: "Amibroker" <[email protected]>
> >> > Sent: Saturday, September 13, 2008 08:18
> >> > Subject: [amibroker] I need little help
> >> >
> >> >
> >> >> In Automatic Analysis, I have "TargetA" in one column, "TargetB" in  
> >> the
> >> >> second column, and the 'Result' of a formula in the third column.  
> >> Based
> >> >> on
> >> >> several factors, the Result will be either a plus figure or a minus
> >> > figure.
> >> >>
> >> >> I want that if result is a plus figure, then I should get in fourth
> >> >> column
> >> >> the resultant of TargetA minus Result, and if result is a minus  
> >> figure,
> >> >> I
> >> >> should get in fourth column the resultant of TargetB plus Result.
> >> >>
> >> >> Can anyone please guide me what to write in my exploration?
> >> >>
> >> >> vgakkhar
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >> ------------------------------------
> >> >>
> >> >> Please note that this group is for discussion between users only.
> >> >>
> >> >> To get support from AmiBroker please send an e-mail directly to
> >> >> SUPPORT {at} amibroker.com
> >> >>
> >> >> For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
> >> >> http://www.amibroker.com/devlog/
> >> >>
> >> >> For other support material please check also:
> >> >> http://www.amibroker.com/support.html
> >> >> Yahoo! Groups Links
> >> >>
> >> >>
> >> >>
> >> >
> >> >
> >> > ------------------------------------
> >> >
> >> > Please note that this group is for discussion between users only.
> >> >
> >> > To get support from AmiBroker please send an e-mail directly to
> >> > SUPPORT {at} amibroker.com
> >> >
> >> > For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
> >> > http://www.amibroker.com/devlog/
> >> >
> >> > For other support material please check also:
> >> > http://www.amibroker.com/support.html
> >> > Yahoo! Groups Links
> >> >
> >> >
> >> >
> >>
> >>
> >>
> >> ------------------------------------
> >>
> >> Please note that this group is for discussion between users only.
> >>
> >> To get support from AmiBroker please send an e-mail directly to
> >> SUPPORT {at} amibroker.com
> >>
> >> For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
> >> http://www.amibroker.com/devlog/
> >>
> >> For other support material please check also:
> >> http://www.amibroker.com/support.html
> >> Yahoo! Groups Links
> >>
> >>
> >>
> 
> 
> 
> ------------------------------------
> 
> Please note that this group is for discussion between users only.
> 
> To get support from AmiBroker please send an e-mail directly to 
> SUPPORT {at} amibroker.com
> 
> For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
> http://www.amibroker.com/devlog/
> 
> For other support material please check also:
> http://www.amibroker.com/support.html
> Yahoo! Groups Links
> 
> 
> 

Attachment: Vinay - AB.afl
Description: Binary data

Reply via email to