Re: [amibroker] I need little help

["Vinay Gakkhar." <vgakkhar@xxxxxxxxxxx>]

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/