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 [email protected], "Tomasz Janeczko" <gro...@...> 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" <gmorlo...@...> > To: <[email protected]> > 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 [email protected], "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: <[email protected]> > >> 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 [email protected], "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 > > > > > > >
