[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

I see this post. For the newcomer, it takes few days to pass into the 
unmoderated list.

Best regards

Gabby a écrit :
>
> 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 -----
>     *From:* Tomasz Janeczko <mailto:groups@xxxxxxxxxxxxx>
>     *To:* amibroker@xxxxxxxxxxxxxxx <mailto:amibroker@xxxxxxxxxxxxxxx>
>     *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@xxxxxxxxx <mailto:gmorlosky@xxxxxxxxx>>
>     To: <amibroker@xxxxxxxxxxxxxxx <mailto: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
>     <mailto:amibroker%40yahoogroups.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@xxx>
>     >> To: <amibroker@xxxxxxxxxxxxxxx
>     <mailto:amibroker%40yahoogroups.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@xxxxxxxxxxxxxxx
>     <mailto:amibroker%40yahoogroups.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@xxxxxxxxxxxxxxx
>     <mailto:amibroker%40yahoogroups.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@xxxxxxxxxxxxxxx
>     <mailto:amibroker%40yahoogroups.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/
>     <http://www.amibroker.com/devlog/>
>     >> >> >
>     >> >> > For other support material please check also:
>     >> >> > http://www.amibroker.com/support.html
>     <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/
>     <http://www.amibroker.com/devlog/>
>     >> >
>     >> > For other support material please check also:
>     >> > http://www.amibroker.com/support.html
>     <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/ <http://www.amibroker.com/devlog/>
>     >
>     > For other support material please check also:
>     > http://www.amibroker.com/support.html
>     <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/