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

[amibroker] Re: Summation within exploration



PureBytes Links

Trading Reference Links

Ah, that would do the trick. But isn't there a work around? See also 
my previous post.


--- In amibroker@xxxxxxxxxxxxxxx, Grant Noble <gruntus@xxx> wrote:
>
> Checkout SetSumColumns()? 
[http://www.amibroker.com/feedback/view_bug.php?bug_id=706]
> My idea for simple sums for exploration. G
> 
> mpmafma wrote:
> > Bill,
> > 
> > My programmings skills are very limited.
> > I tried defining trueresult and falseresult. But when you define 
this 
> > value to zero it starts counting from zero.
> > This is the code I use.
> > 
> > Filter = DayOfWeek()==1;
> > Rise = IIf( Close > Open,1,0); //this gives results of 0 or 1
> > TotalRise = Cum(Rise);
> > AddColumn( Close-Open, "Close", 1.2,colorYellow,colorBlue );
> > AddColumn(Rise,"Rise",1,1);
> > AddColumn(TotalRise,"# Rise",1.0);
> > 
> > The totalrise value counts all records in stead of the 
conditionals.
> > 
> > regards,
> > 
> > Frans.
> > 
> > --- In amibroker@xxxxxxxxxxxxxxx, "wavemechanic" <fimdot@> wrote:
> >> As far as the error goes, did you look it up in the Users Guide 
> > where it is explained?
> >> To count true and false results, one way to go is to define 
> > trueresult and falseresult and put them into individual columns, 
> > e.g., 
> >> filter = 1;
> >> trueresult = ...
> >> falseresult = ...
> >> addcolumn(trueresult, ...
> >> addcolumn(falseresult, ...
> >>
> >> You can also incorporate cum(), sum(), lastvalue() with 
trueresult 
> > and falseresult to produce what you want.
> >> Bill
> >>
> >> ----- Original Message ----- 
> >> From: "mpmafma" <mpmafma@>
> >> To: <amibroker@xxxxxxxxxxxxxxx>
> >> Sent: Thursday, June 14, 2007 1:33 PM
> >> Subject: [amibroker] Re: Summation within exploration
> >>
> >>
> >>> Hi Bill,
> >>>
> >>> Thansk for the reply.
> >>> It works fine within a chart formula. What I try to do is count 
> > the 
> >>> number a condition is true within an exploration. When I use 
> > the "cum
> >>> ()" function all records are counted.
> >>> When I try:
> >>>
> >>> Filter=1;
> >>> result = IIf(Close > Open,1,0);
> >>> totalresults = totalresults+result;
> >>> AddColumn(totalresults,"tot",1,1);
> >>>
> >>> AB gives an error, totalresults is not defined.
> >>> So how do I create a counter in an exploration counting the 
> > number of 
> >>> true of false conditions?
> >>>
> >>> kind regards,
> >>>
> >>> Frans.
> >>>
> >>> --- In amibroker@xxxxxxxxxxxxxxx, "wavemechanic" <fimdot@> 
wrote:
> >>>> Why do you say not working?  Works for me.  How are you 
viewing 
> >>> results?  Try 
> >>>> result = ....
> >>>> totalresults = ....
> >>>> plot(totalresults, "totalresults", colorred);
> >>>>
> >>>> Click on any point and totalresults info is displayed in title.
> >>>>
> >>>> Bill
> >>>>
> >>>>
> >>>> ----- Original Message ----- 
> >>>> From: "mpmafma" <mpmafma@>
> >>>> To: <amibroker@xxxxxxxxxxxxxxx>
> >>>> Sent: Thursday, June 14, 2007 9:04 AM
> >>>> Subject: [amibroker] Summation within exploration
> >>>>
> >>>>
> >>>>> OK, I tried to do this myself but after extensive searching 
> > this 
> >>> forum 
> >>>>> and the AFL database my last hope is to put my question on 
> > this 
> >>> forum.
> >>>>> What I try to do is to count the number of occurrences. For 
> >>> instance 
> >>>>> Result = Open > ref(high,-1);
> >>>>>
> >>>>> TotalResults = cum(Result);
> >>>>> is not working.
> >>>>>
> >>>>> There must be a way, anyone?
> >>>>>
> >>>>> kind regards,
> >>>>>
> >>>>> Frans.
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>> Please note that this group is for discussion between users 
> > only.
> >>>>> To get 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
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>> -- 
> >>>>> No virus found in this incoming message.
> >>>>> Checked by AVG Free Edition. 
> >>>>> Version: 7.5.472 / Virus Database: 269.8.15/848 - Release 
> > Date: 
> >>> 6/13/2007 12:50 PM
> >>>>>
> >>>
> >>>
> >>>
> >>> Please note that this group is for discussion between users 
only.
> >>>
> >>> To get 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
> >>>
> >>>
> >>>
> >>>
> >>>
> >>> -- 
> >>> No virus found in this incoming message.
> >>> Checked by AVG Free Edition. 
> >>> Version: 7.5.472 / Virus Database: 269.8.15/848 - Release Date: 
> > 6/13/2007 12:50 PM
> >>>
> > 
> > 
> > 
> > 
> > Please note that this group is for discussion between users only.
> > 
> > To get 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
> > 
> > 
> > 
> > 
> >
>




Please note that this group is for discussion between users only.

To get 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/