[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 - 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@xxxxxxxxxxxxxxx, "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@xxx>
> To: <amibroker@xxxxxxxxxxxxxxx>
> 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@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
> > 
> > 
> >
>




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

**** 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/