Voyager, Thanks for your efforts on this. I did get the correct answers using your code.
Steve --- In [email protected], Inquisitive Voyager <hedonist2...@...> wrote: > > OOPS! > > same variable name was used in 2 premises- > > use this code rest same- > > > a=LastValue(Month())-1; > > z=LastValue(Month())-2; > > b=Month()!=Ref(Month(),-1); > > bi=BarIndex(); > > d=LastValue(ValueWhen(Month()==a *AND* b,bi,1)); > > e=*BarCount*-d; > > f=LastValue(ValueWhen(Month()==z *AND* b,bi,1)); > > g=*BarCount*-f; > > i=LastValue(HHV(*H*,e)) ; j= LastValue(HHV(*H*,g)); > * > > Filter*=i *OR* j; > > AddColumn(*C*,"close",1.2); > > AddColumn(i,"1 month high",1.1); > > AddColumn(j,"2 month high",1.1); > > > On Mon, Jun 21, 2010 at 10:03 PM, Inquisitive Voyager < > hedonist2...@...> wrote: > >
