[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [amibroker] I need little help



PureBytes Links

Trading Reference Links

AddColumn(IIf(Result >0 ,AA, AB),"Column4");

Add the above syntax and you should get the required.

Cheers

Prashanth

----- Original Message -----
From: "Vinay Gakkhar." <vgakkhar@xxxxxxxxxxx>
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 <
prash454.ta@xxxxxxxxx
> 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." <
vgakkhar@xxxxxxxxxxx>
> > To: "Amibroker" <
amibroker@xxxxxxxxxxxxxxx>
> > 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
>
> <*> To visit your group on the web, go to:
>    
http://groups.yahoo.com/group/amibroker/
>
> <*> Your email settings:
>     Individual Email | Traditional
>
> <*> To change settings online go to:
>    
http://groups.yahoo.com/group/amibroker/join
>     (Yahoo! ID required)
>
> <*> To change settings via email:
>    
mailto:amibroker-digest@xxxxxxxxxxxxxxx
>    
mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx
>
> <*> To unsubscribe from this group, send an email to:
>    
amibroker-unsubscribe@xxxxxxxxxxxxxxx
>
> <*> Your use of Yahoo! Groups is subject to:
>    
http://docs.yahoo.com/info/terms/
> __._,_.___

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




Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___