Thanks GP Just what I was after.
Cheers Graham > > BarsSince will return Null (not zero) for every bar if there's never > been any instances of High equal to Low. So you could check for that > by adding: > > vTmp = BarsSince(High == Low); > vTmp = IIf(IsNull(vTmp), Cum(1)-1, vTmp); > > This will set all Null values to the bar index. > > Regards, > GP > > > --- In [email protected], "Graham Johnson" <grahamj@> wrote: > > > > Good point - I hadn't thought of it that way. > > > > What I want it to return is the number of bars since bar 1 (or 0). > > > > Cheers > > > > Graham > > > > > What do you expect it to return if there's never been any instances > > of > > > High equal to Low? > > > > > > Regards, > > > GP > > > > > > > > > --- In [email protected], "Graham Johnson" <grahamj@> wrote: > > > > > > > > I'm wanting to test the number of bars since a security had equal > > High > > > > and Low - seemed simple. > > > > > > > > vTmp = BarsSince(High == Low); > > > > > > > > Works fine where there has been High == Low, but when there > > hasn't > > > > been, it returns 0 for all bars. > > > > > > > > Is there a workaround, or should I be using a different function. > > > > > > > > Thanks > > > > > > > > Graham > > > > > > > > > >
