[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: [amibroker] sublimely naive? Manual Stock Sorting.



PureBytes Links

Trading Reference Links



Yes, I was. 
Though using
(Status("stocknum")+1)
works quite nicely.
KR Michael.
 
At 09:52 AM 10/10/2003 -0400, you wrote:
Michael,
I think perhaps because sort= is combining a string (name) with an array (barindex).  You are trying to force addtextcolumn to return the array of barindex.
 
Regards, 
Jayson 
-----Original Message-----
From: Michael.S.G. [mailto:OzFalcon@xxxxxxxx]
Sent: Friday, October 10, 2003 9:18 AM
To: amibroker@xxxxxxxxxxxxxxx
Subject: Re: [amibroker] sublimely naive? Manual Stock Sorting.
Tomasz,
So Date() must be doing the same thing - returns single string.
Im unsure as to why the following code doesn't work though....?
Sort = Name()+" "+BarIndex();
AddTextColumn( sort,"Sort");
AddColumn(BarIndex(),"BarIndex",1);
KR
        Michael.

At 03:00 PM 10/10/2003 +0200, you wrote:
Graham,
No, the reason for such behaviour is simple: WriteVal returns SINGLE
string (not array of strings) therefore can convert only SINGLE number
(not many) to string. The number converted is the 'selected value' of the array.
See 
http://www.amibroker.com/guide/afl/afl_view.php?name=SELECTEDVALUE
What you are trying to do would involve WriteVal to return ARRAY of strings
(separate string for each day)
Best regards,
Tomasz Janeczko
amibroker.com
----- Original Message ----- 
From: "Graham" <gkavanagh@xxxxxxxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Friday, October 10, 2003 2:53 PM
Subject: RE: [amibroker] sublimely naive? Manual Stock Sorting.

> It seems that the addcolumn using Valuewhen in it is only reporting the last
> event of Buy or Sell, not when the events happened
> 
> Cheers,
> Graham
> http://groups.msn.com/ASXShareTrading
> http://groups.msn.com/FMSAustralia
> 
> 
> -----Original Message-----
> From: Michael.S.G. [mailto:OzFalcon@xxxxxxxx] 
> Sent: Friday, 10 October 2003 8:25 PM
> To: amibroker@xxxxxxxxxxxxxxx
> Subject: RE: [amibroker] sublimely naive? Manual Stock Sorting.
> 
> 
> Graham,
> This afl seems to have the same problem..
> see attached pic.
> 
> KR
>          Michael.
> 
> At 08:07 PM 10/10/2003 +0800, you wrote:
> >Michael
> >I just did a quick check to see what is possible, and it seems to work 
> >sorting on the last column
> >
> >Buy=Cross(EMA(C,5),EMA(C,20));
> >Sell=Cross(EMA(C,20),EMA(C,5));
> >
> >Filter=Buy OR Sell;
> >AddColumn(Buy,"buy",1);
> >AddColumn(Sell,"sell",1);
> >AddTextColumn( WriteVal(ValueWhen(Buy OR Sell,DateNum()),1)+" 
> >"+Name(),"sort column");
> >
> >Cheers,
> >Graham
> >http://groups.msn.com/ASXShareTrading
> >http://groups.msn.com/FMSAustralia
> >
> >
> >-----Original Message-----
> >From: Michael.S.G. [mailto:OzFalcon@xxxxxxxx]
> >Sent: Friday, 10 October 2003 7:34 PM
> >To: amibroker@xxxxxxxxxxxxxxx
> >Subject: RE: [amibroker] sublimely naive? Manual Stock Sorting.
> >
> >
> >Double Tier Sort Must not be possible I guess.
> >
> >Michael.
> >
> >
> >At 11:53 AM 10/10/2003 +0800, you wrote:
> > >You can remove the builtin columns SetOption("NoDefaultColumns",1); 
> > >Filter=1; AddTextColumn(Name(),"");
> > >
> > >Cheers,
> > >Graham
> > >http://groups.msn.com/ASXShareTrading
> > >http://groups.msn.com/FMSAustralia
> > >
> > >
> > >-----Original Message-----
> > >From: Michael.S.G. [mailto:OzFalcon@xxxxxxxx]
> > >Sent: Friday, 10 October 2003 10:22 AM
> > >To: amibroker@xxxxxxxxxxxxxxx
> > >Subject: RE: [amibroker] sublimely naive? Manual Stock Sorting.
> > >
> > >
> > >Hi Graham,
> > >   They all seem to do the same thing.
> > >
> > >I wonder how Tomasz gets it to display dates for each bar? Perhaps 
> > >It's internal code (& Thats why you can't remove date or ticker 
> > >columns).
> > >
> > >Im not sure if this is a bug or just my missunderstanding of AA.
> > >
> > >KR
> > >          Michael.
> > >
> > >
> > >
> > >At 07:11 AM 10/10/2003 +0800, you wrote:
> > > >Michael
> > > >The barnumber is
> > > >Barindex() or Cum(1)
> > > >You could also use Datenum()
> > > >
> > > >Cheers,
> > > >Graham
> > > >http://groups.msn.com/ASXShareTrading
> > > >http://groups.msn.com/FMSAustralia
> > > >
> > > >
> > > >-----Original Message-----
> > > >From: Michael.S.G. [mailto:OzFalcon@xxxxxxxx]
> > > >Sent: Thursday, 9 October 2003 11:12 PM
> > > >To: amibroker@xxxxxxxxxxxxxxx
> > > >Subject: RE: [amibroker] sublimely naive? Manual Stock Sorting.
> > > >
> > > >
> > > >Hi Graham,
> > > >This is a good solution. But the date gets Stuck. Im not sure why.
> > > >
> > > >Also, I thought perhaps displaying the name + bar number might 
> > > >work, But I can't seem to figure out how to retrieve the bar 
> > > >number.....?
> > > >
> > > >Here's what happens when combining the two.
> > > ><Attached pic)
> > > >
> > > >Stumped
> > > >          Michael.
> > > >
> > > >At 10:32 AM 9/10/2003 +0800, you wrote:
> > > > >You could try a double entry for a column, example 
> > > > >AddTextColumn(Name()+" "+Date(),"");
> > > > >
> > > > >Cheers,
> > > > >Graham
> > > > >http://groups.msn.com/ASXShareTrading
> > > > >http://groups.msn.com/FMSAustralia
> > > > >
> > > > >
> > > > >-----Original Message-----
> > > > >From: Michael.S.G. [mailto:OzFalcon@xxxxxxxx]
> > > > >Sent: Thursday, 9 October 2003 10:05 AM
> > > > >To: amibroker@xxxxxxxxxxxxxxx
> > > > >Subject: [amibroker] sublimely naive? Manual Stock Sorting.
> > > > >
> > > > >
> > > > >Im looking to do a double tiered manual sort from my AA report.
> > > > >
> > > > >Quite simply, I wisthto sort by ticker, Then have each ticker 
> > > > >entry sorted bydate.
> > > > >
> > > > >I'd rather not export into excel and multi sort that way. Has 
> > > > >anyone got a workaround or some info I have possibly missed on 
> > > > >doing this?
> > > > >
> > > > >Here is a snapshot of what I'd like to sort. Highlighted lines - 
> > > > >as you can see, are not sorted by date.
> > > > >
> > > > >All The Best
> > > > >         Michael.
> > > >
> > > >
Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx 
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 
Yahoo! Groups Sponsor 
 

Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx 
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 






Yahoo! Groups Sponsor


  ADVERTISEMENT 









Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx 
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


Attachment: Description: ""

Attachment: Description: ""