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 > > >
Vinay - AB.afl
Description: Binary data
