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

[amibroker] Re: Date Sorting seems odd in Explore



PureBytes Links

Trading Reference Links

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@xxx> 
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@xxx>
> 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/