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

Re: [amibroker] Re: Date Sorting seems odd in Explore



PureBytes Links

Trading Reference Links

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