|
PureBytes Links
Trading Reference Links
|
Michael,
For the same reason: there are NO arrays of strings in AFL.
All string functions / arithmetic
give you SINGLE string (not array of strings).
To achieve what you want you would need to use NUMERIC
column:
AddColumn( Status("stocknum") * 1000 + BarIndex(), "sortcol"
);
Best regards,Tomasz Janeczkoamibroker.com
<BLOCKQUOTE
>
----- Original Message -----
<DIV
>From:
Michael.S.G.
To: <A title=amibroker@xxxxxxxxxxxxxxx
href="">amibroker@xxxxxxxxxxxxxxx
Sent: Friday, October 10, 2003 3:18
PM
Subject: Re: [amibroker] sublimely naive?
Manual Stock Sorting.
Tomasz,So <FONT face="Courier New, Courier"
color=#0000ff>Date() must be
doing the same thing - returns single string.Im unsure as to why the
following code doesn't work though....?<FONT
face="Courier New, Courier">Sort = <FONT face="Courier New, Courier"
color=#0000ff>Name()+<FONT
face="Courier New, Courier" color=#ff00ff>" "<FONT
face="Courier New, Courier">+<FONT face="Courier New, Courier"
color=#0000ff>BarIndex<FONT
face="Courier New, Courier">();<FONT face="Courier New, Courier"
color=#0000ff>AddTextColumn(
sort,"Sort"<FONT
face="Courier New, Courier">);<FONT face="Courier New, Courier"
color=#0000ff>AddColumn(<FONT
face="Courier New, Courier" color=#0000ff>BarIndex<FONT
face="Courier New, Courier">(),<FONT face="Courier New, Courier"
color=#ff00ff>"BarIndex",<FONT
face="Courier New, Courier" color=#ff00ff>1<FONT
face="Courier New, Courier">);KR Michael.At
03:00 PM 10/10/2003 +0200, you wrote:
Graham,No, the reason for
such behaviour is simple: WriteVal returns SINGLEstring (not array of
strings) therefore can convert only SINGLE number(not many) to string.
The number converted is the 'selected value' of the array.See <A
href=""
eudora="autourl">http://www.amibroker.com/guide/afl/afl_view.php?name=SELECTEDVALUEWhat
you are trying to do would involve WriteVal to return ARRAY of
strings(separate string for each day)Best regards,Tomasz
Janeczkoamibroker.com----- Original Message ----- From: "Graham"
<gkavanagh@xxxxxxxxxxxxx>To:
<amibroker@xxxxxxxxxxxxxxx>Sent: Friday, October 10, 2003 2:53
PMSubject: RE: [amibroker] sublimely naive? Manual Stock
Sorting.> It seems that the addcolumn using Valuewhen in it
is only reporting the last> event of Buy or Sell, not when the events
happened> > Cheers,> Graham> <A
href=""
eudora="autourl">http://groups.msn.com/ASXShareTrading> <A
href=""
eudora="autourl">http://groups.msn.com/FMSAustralia> >
> -----Original Message-----> From: Michael.S.G. [<A
href=""
eudora="autourl">mailto:OzFalcon@xxxxxxxx] > Sent: Friday, 10
October 2003 8:25 PM> To: amibroker@xxxxxxxxxxxxxxx> Subject:
RE: [amibroker] sublimely naive? Manual Stock Sorting.> >
> Graham,> This afl seems to have the same problem..>
see attached pic.> >
KR>
Michael.> > At 08:07 PM 10/10/2003 +0800, you wrote:>
>Michael> >I just did a quick check to see what is possible,
and it seems to work > >sorting on the last column>
>> >Buy=Cross(EMA(C,5),EMA(C,20));>
>Sell=Cross(EMA(C,20),EMA(C,5));> >> >Filter=Buy OR
Sell;> >AddColumn(Buy,"buy",1);>
>AddColumn(Sell,"sell",1);> >AddTextColumn(
WriteVal(ValueWhen(Buy OR Sell,DateNum()),1)+" > >"+Name(),"sort
column");> >> >Cheers,> >Graham> ><A
href=""
eudora="autourl">http://groups.msn.com/ASXShareTrading> ><A
href=""
eudora="autourl">http://groups.msn.com/FMSAustralia> >>
>> >-----Original Message-----> >From: Michael.S.G.
[<A href=""
eudora="autourl">mailto:OzFalcon@xxxxxxxx]> >Sent: Friday, 10
October 2003 7:34 PM> >To: amibroker@xxxxxxxxxxxxxxx>
>Subject: RE: [amibroker] sublimely naive? Manual Stock Sorting.>
>> >> >Double Tier Sort Must not be possible I
guess.> >> >Michael.> >> >>
>At 11:53 AM 10/10/2003 +0800, you wrote:> > >You can remove
the builtin columns SetOption("NoDefaultColumns",1); > >
>Filter=1; AddTextColumn(Name(),"");> > >> >
>Cheers,> > >Graham> > ><A
href=""
eudora="autourl">http://groups.msn.com/ASXShareTrading> >
><A href=""
eudora="autourl">http://groups.msn.com/FMSAustralia> >
>> > >> > >-----Original Message----->
> >From: Michael.S.G. [<A href=""
eudora="autourl">mailto:OzFalcon@xxxxxxxx]> > >Sent:
Friday, 10 October 2003 10:22 AM> > >To:
amibroker@xxxxxxxxxxxxxxx> > >Subject: RE: [amibroker]
sublimely naive? Manual Stock Sorting.> > >> >
>> > >Hi Graham,> > > They all seem
to do the same thing.> > >> > >I wonder how Tomasz
gets it to display dates for each bar? Perhaps > > >It's
internal code (& Thats why you can't remove date or ticker > >
>columns).> > >> > >Im not sure if this is a
bug or just my missunderstanding of AA.> > >> >
>KR> >
> Michael.>
> >> > >> > >> > >At 07:11 AM
10/10/2003 +0800, you wrote:> > > >Michael> > >
>The barnumber is> > > >Barindex() or Cum(1)> >
> >You could also use Datenum()> > > >> >
> >Cheers,> > > >Graham> > > ><A
href=""
eudora="autourl">http://groups.msn.com/ASXShareTrading> > >
><A href=""
eudora="autourl">http://groups.msn.com/FMSAustralia> > >
>> > > >> > > >-----Original
Message-----> > > >From: Michael.S.G. [<A
href=""
eudora="autourl">mailto:OzFalcon@xxxxxxxx]> > > >Sent:
Thursday, 9 October 2003 11:12 PM> > > >To:
amibroker@xxxxxxxxxxxxxxx> > > >Subject: RE: [amibroker]
sublimely naive? Manual Stock Sorting.> > > >> >
> >> > > >Hi Graham,> > > >This is a
good solution. But the date gets Stuck. Im not sure why.> > >
>> > > >Also, I thought perhaps displaying the name + bar
number might > > > >work, But I can't seem to figure out how
to retrieve the bar > > > >number.....?> > >
>> > > >Here's what happens when combining the
two.> > > ><Attached pic)> > > >>
> > >Stumped> > >
> Michael.>
> > >> > > >At 10:32 AM 9/10/2003 +0800, you
wrote:> > > > >You could try a double entry for a column,
example > > > > >AddTextColumn(Name()+"
"+Date(),"");> > > > >> > > >
>Cheers,> > > > >Graham> > > > ><A
href=""
eudora="autourl">http://groups.msn.com/ASXShareTrading> > >
> ><A href=""
eudora="autourl">http://groups.msn.com/FMSAustralia> > >
> >> > > > >> > > >
>-----Original Message-----> > > > >From: Michael.S.G.
[<A href=""
eudora="autourl">mailto:OzFalcon@xxxxxxxx]> > > >
>Sent: Thursday, 9 October 2003 10:05 AM> > > > >To:
amibroker@xxxxxxxxxxxxxxx> > > > >Subject: [amibroker]
sublimely naive? Manual Stock Sorting.> > > > >>
> > > >> > > > >Im looking to do a double
tiered manual sort from my AA report.> > > > >>
> > > >Quite simply, I wisthto sort by ticker, Then have each
ticker > > > > >entry sorted bydate.> > >
> >> > > > >I'd rather not export into excel and
multi sort that way. Has > > > > >anyone got a workaround
or some info I have possibly missed on > > > > >doing
this?> > > > >> > > > >Here is a
snapshot of what I'd like to sort. Highlighted lines - > > >
> >as you can see, are not sorted by date.> > > >
>> > > > >All The Best> > > >
> Michael.> >
> >> > > >Send
BUG REPORTS to bugs@xxxxxxxxxxxxxSend SUGGESTIONS to
suggest@xxxxxxxxxxxxx-----------------------------------------Post
AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web page: <A
href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check
group FAQ at: <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the <A
href="">Yahoo! Terms of Service.
Yahoo! Groups Sponsor
Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
|