|
PureBytes Links
Trading Reference Links
|
Yes that did it the date short format was set to MMM.
--- In amibroker@xxxxxxxxxxxxxxx, "Tomasz Janeczko" <groups@xxx>
wrote:
>
> 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@xxx>
> To: <amibroker@xxxxxxxxxxxxxxx>
> 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@xxxxxxxxxxxxxxx, "Tomasz Janeczko" <groups@>
> > 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@>
> >> 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
> >
> >
> >
>
------------------------------------
**** 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/
|