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

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



PureBytes Links

Trading Reference Links

Thanks Tomasz, saw your previous response after sending mine

Cheers,
Graham
http://groups.msn.com/ASXShareTrading
http://groups.msn.com/FMSAustralia


-----Original Message-----
From: Tomasz Janeczko [mailto:amibroker@xxxxxx] 
Sent: Friday, 10 October 2003 9:01 PM
To: amibroker@xxxxxxxxxxxxxxx
Subject: Re: [amibroker] sublimely naive? Manual Stock Sorting.


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
> > > >http://docs.yahoo.com/info/terms/
> > > >
> > > >
> > > >
> > > >
> > > >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
> > > >http://docs.yahoo.com/info/terms/
> > >
> > >
> > >
> > >
> > >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
> > >http://docs.yahoo.com/info/terms/
> > >
> > >
> > >
> > >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
> > >http://docs.yahoo.com/info/terms/
> >
> >
> >
> >
> >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
> >http://docs.yahoo.com/info/terms/
> >
> >
> >
> >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
> >http://docs.yahoo.com/info/terms/
> 
> 
> 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 
> http://docs.yahoo.com/info/terms/
> 
> 
> 
> 
> 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 
> http://docs.yahoo.com/info/terms/
> 
> 
> 


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 http://docs.yahoo.com/info/terms/ 


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Rent DVDs from home.
Over 14,500 titles. Free Shipping
& No Late Fees. Try Netflix for FREE!
http://us.click.yahoo.com/ArdFIC/hP.FAA/ySSFAA/GHeqlB/TM
---------------------------------------------------------------------~->

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 http://docs.yahoo.com/info/terms/