|
PureBytes Links
Trading Reference Links
|
Assuming Name and long and short values are in cells A2,B2,C2
then in cell E2 have this
="AlertIf( Cross(C, "&B2&") AND
Name()=="""&A2&""""&","&""""""&","&"""Long"""&",3);"
and in cell F2 have this
="AlertIf( Cross("&C2&", C) AND
Name()=="""&A2&""""&","&""""""&","&"""Short"""&",3);"
copy paste of the cells e2 ad f2 separately will give this in AB
AlertIf( Cross(C, 40.2) AND Name()=="X","","Long",3);
AlertIf( Cross(30.25, C) AND Name()=="X","","Short",3);
--
Cheers
Graham
AB-Write >< Professional AFL Writing Service
Yes, I write AFL code to your requirements
http://e-wire.net.au/~eb_kavan/ab_write.htm
On 11/27/05, Tony Lei <yiupang91@xxxxxxxxx> wrote:
> Nevermind
>
> I got it,
>
> thanks for the tip
>
> tony
>
>
>
> On 11/26/05, Tony Lei <yiupang91@xxxxxxxxx> wrote:
> > Graham,
> >
> > I'm a little lost since i'm not familiar with concatenate function in excel. Can you provide some tips on how to start?
> >
> > My first step is to create a table:
> >
> > e.g.
> >
> > Stock Name Long trigger Short Trigger
> > X 40.20 30.25
> >
> > excel then will output the above as
> >
> > AlertIf( Cross(C, 40.20) AND Name()=="X", "", "Long", 3 );
> > AlertIf( Cross(30.25,C) AND Name()=="X", "", "Short", 3 );
> >
> > thanks
> >
> > tony
> >
> >
> >
> > On 11/26/05, Graham < kavemanperth@xxxxxxxxx> wrote:
> > >
> > > One thing you can do is
> > > copy/paste your explore list of stock/prices and create your alertif statements in excel using concatenate function
> > > then just copy/paste back to afl
> > >
> > >
> > >
> > > On 11/26/05, Tony Lei < yiupang91@xxxxxxxxx> wrote:
> > > >
> > > > Hi,
> > > >
> > > > I have the following stock picks with triggers and would like to make a simple code that will alert me of these stocks.
> > > >
> > > > ACI LONG 70.51 SHORT 69.23
> > > > HOV LONG 48.70 SHORT 47.83
> > > >
> > > > Currently, I'm using the following code. My question is there a better and more efficient way of doing this. The reason is because I have about 5 stocks per week with both long and short triggers. I was wondering if I can do something in AA where I can go to parameters and set the required parameters that will allow me to enter both the stock and their triggers without going back to "edit AFL."
> > > >
> > > > AlertIf( Cross(69.23,C) AND Name()=="ACI", "", "Short", 3 );
> > > > AlertIf( Cross(C, 70.51) AND Name()=="ACI", "", "Long", 3 );
> > > >
> > > >
> > > > thanks
> > > >
> > > > tony
------------------------ Yahoo! Groups Sponsor --------------------~-->
Try Online Currency Trading with GFT. Free 50K Demo. Trade
24 Hours. Commission-Free.
http://us.click.yahoo.com/RvFikB/9M2KAA/U1CZAA/GHeqlB/TM
--------------------------------------------------------------------~->
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 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/
<*> 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/
|