You need to set numeric date format in Windows control panel.
02 instead
of Feb and 01 instead of January.
Best regards,
Tomasz
Janeczko
amibroker.com
----- Original Message -----
From:
"gmorlosky" <gmorlosky@xxxxxxcom>
To:
<amibroker@xxxxxxxxxps.com>
Sent:
Friday, February 06, 2009 8:58 PM
Subject: [amibroker] Re: Date Sorting
seems odd in Explore
> Hi Tomasz - It was a carryover from when I
wanted the date before the
> ticker. I used your code below only, and I
still have an alpha sort
> of the dates.
>
> --- In amibroker@xxxxxxxxxps.com,
"Tomasz Janeczko" <groups@xxx>
> wrote:
>>
>>
Why do you use NoDefaultColumns?
>> It does not make any sense to
remove name and date (default
> columns) and then add name and
date.
>>
>> Simply use:
>>
>>
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);
>>
>> Best regards,
>> Tomasz Janeczko
>>
amibroker.com
>> ----- Original Message -----
>> From:
"gmorlosky" <gmorlosky@x..>
>> To: <amibroker@xxxxxxxxxps.com>
>>
Sent: Friday, February 06, 2009 6:35 PM
>> Subject: [amibroker] Re:
Date Sorting seems odd in Explore
>>
>>
>> >
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@xxxxxxxxxps.com,
"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@xxxxxxxxxps.com>
>>
>> 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@xxxxxxxxxps.com,
"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
>> >
>> >
>>
>
>>
>
>
>
>
>
------------------------------------
>
> ****
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
>
>
>