[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

Hi Thomasz.
 
I am a new user of AB and new to the yahoo AB user group. I posted 2 questions there in the pair trading thread yesterday but am not getting seeing it in the threads. i saw a little statement there that the moderator has to approve it. Is that the reason why it is not showing there ...yet? Could you please tell me the procedure in order for me to pose questions and hopefully get solutions to my issues. I appreciate it.
 
Gabriel
 
 
----- Original Message -----
Sent: Friday, February 06, 2009 6:03 PM
Subject: Re: [amibroker] Re: Date Sorting seems odd in Explore

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



__._,_.___


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

*********************************




Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___