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

RE: [amibroker] sublimely naive? Manual Stock Sorting.



PureBytes Links

Trading Reference Links




<FONT face=Arial color=#0000ff 
size=2>Michael,
I 
think perhaps because sort= is combining a string (name) with an array 
(barindex).  You are trying to force addtextcolumn to return the array of 
barindex.
 
Regards, 
Jayson 
<FONT face=Tahoma 
size=2>-----Original Message-----From: Michael.S.G. 
[mailto:OzFalcon@xxxxxxxx]Sent: Friday, October 10, 2003 9:18 
AMTo: amibroker@xxxxxxxxxxxxxxxSubject: Re: [amibroker] 
sublimely naive? Manual Stock Sorting.Tomasz,So 
Date<FONT 
face="Courier New, Courier">() must be doing the same thing - returns 
single string.Im unsure as to why the following code doesn't work 
though....?Sort = <FONT 
face="Courier New, Courier" color=#0000ff>Name<FONT 
face="Courier New, Courier">()+<FONT face="Courier New, Courier" 
color=#ff00ff>" "+<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.