[amibroker] Re: Date Sorting seems odd in Explore

["gmorlosky" <gmorlosky@xxxxxxxxx>]

Hi Tomasz;

I tried using a filter for just the S&P 500 (in case there was some 
buffer overflow reagrding sorting), so with only 500 symbols AND 
using the default Date as well as the AddCloumn DateTime, they both 
sort erroneously alphabetically. Here are the columns:

// Start Add Columns
//
//SetOption("NoDefaultColumns",True);
AddTextColumn(Name(),"Name",1.0,colorBlack,colorDefault,50);
AddColumn(DateTime
(),"Date",formatDateTime,colorBlack,colorDefault,60);
AddTextColumn(FullName(), "Name",1.0,IIf(BarCount-
1,colorGreen,colorTan),colorDefault,140);
AddTextColumn(MarketID(1),"Market",1.0,colorBlack,colorDefault,80);
AddTextColumn(SectorID(1),"Sector",1.0,colorBlack,colorDefault,80);
AddTextColumn(IndustryID
(1),"Industry",1.0,colorBlack,colorDefault,80);

--- In amibroker@xxxxxxxxxxxxxxx, "gmorlosky" <gmorlosky@xxx> wrote:
>
> Hi Tomasz - Here is my code whihc is giving me a problem, which 
uses 
> AddColumn, as suggested. AB ver 5.2
> 
> // Start Add Columns
> //
> SetOption("NoDefaultColumns",True);
> AddTextColumn(Name(),"Name",1.0,colorBlack,colorDefault,50);
> AddColumn(DateTime
> (),"Date",formatDateTime,colorBlack,colorDefault,60);
> AddTextColumn(FullName(), "Name",1.0,IIf(BarCount-
> 1,colorGreen,colorTan),colorDefault,140);
> AddTextColumn(MarketID(1),"Market",1.0,colorBlack,colorDefault,80);
> AddTextColumn(SectorID(1),"Sector",1.0,colorBlack,colorDefault,80);
> AddTextColumn(IndustryID
> (1),"Industry",1.0,colorBlack,colorDefault,80);
> 
> --- In amibroker@xxxxxxxxxxxxxxx, "Tomasz Janeczko" <groups@> 
> wrote:
> >
> > Apparenly you are using TEXT column for date output 
(AddTextColumn) 
> and it sorts
> > alphabetically. 
> > 
> > Instead use default date/time column or use
> > AddColumn with formatDateTime 
> > 
> > Best regards,
> > Tomasz Janeczko
> > amibroker.com
> > ----- Original Message ----- 
> > From: "gmorlosky" <gmorlosky@>
> > To: <amibroker@xxxxxxxxxxxxxxx>
> > Sent: Friday, February 06, 2009 4:17 PM
> > Subject: [amibroker] Re: Date Sorting seems odd in Explore
> > 
> > 
> > >I did confirm that when sorting on date (of any coloumn that 
> > > generates a date) of an Explore, that it is worng.
> > > Descending sort looks like this:
> > > 30-Jan-2009
> > > 25-Jan-2009 
> > > 12-Jan-2009
> > > 04-Feb-2009
> > > 03-Feb-2009
> > > 
> > > To me it should start with the lastest Julian date and go 
> backward.
> > > 
> > > Any ideas ???
> > > 
> > > --- In amibroker@xxxxxxxxxxxxxxx, "gmorlosky" <gmorlosky@> 
wrote:
> > >>
> > >> I have an explore of 6000 stocks. I descending sort on the 
> default 
> > > Date 
> > >> column and oddly Jan 2009 dates come before Feb 2009 dates 
when 
> in 
> > >> descending order, although 04 Feb comes before 03 Feb, which 
is 
> > > what I 
> > >> expect. How does the sort determine date values ?
> > >>
> > > 
> > > 
> > > 
> > > 
> > > ------------------------------------
> > > 
> > > **** IMPORTANT ****
> > > This group is for the discussion between users only.
> > > This is *NOT* technical support channel.
> > > 
> > > *********************
> > > TO GET TECHNICAL 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
> > > 
> > > 
> > >
> >
>




------------------------------------

**** IMPORTANT ****
This group is for the discussion between users only.
This is *NOT* technical support channel.

*********************
TO GET TECHNICAL 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/