Ah, that would do the trick. But isn't there a work around? See also my previous post.
--- In [email protected], Grant Noble <[EMAIL PROTECTED]> 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 [email protected], "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: <[email protected]> > >> 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 [email protected], "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: <[email protected]> > >>>> 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 > > > > > > > > > > >
