Why not do it the same way you did XYZ_Check? Also, it would be more
efficient to add variables rather than repeating the same operation.
Open1 = Open > Ref(Open, -1);
Open2 = Open > Ref(Open, -2);
...
Open6 = Open > Ref(Open, -6);
Open123 = Open1 AND Open2 AND Open3;
Open234 = Open2 AND Open3 AND Open4;
...
Open456 = Open4 AND Open5 AND Open6;
RU1_Check = IIF(XYZ_Check == 0,
Open123,
IIF(XYZ_Check == 1,
Open234,
IIF(XYZ_Check == 2,
...
);
Mike
--- In [email protected], "sidhartha70" <[EMAIL PROTECTED]>
wrote:
>
> Herman,
>
> This is where the problem occurs... because what I actually want to
do
> within each conditional if() statement is carry out some more array
> manipulations. For example,
>
> HLRange = abs( H - L );
> ABC = HLRange > Ref( HLRange, -1 ) AND HLRange > Ref( HLRange, -2)
AND
> HLRange > Ref( HLRange, -3 );
> XYZ_Check=IIf(Ref(ABC,-1),1,IIf(Ref(ABC,-2),2,IIf(Ref(ABC,-
3),3,0)));
>
> if(XYZ_Check==0)
> {
> RU1_Check = Open>Ref(Open,-1) AND Open>Ref(Open,-2) AND
Open>Ref(Open,-3);
> }
> if(XYZ_Check==1)
> {
> RU1_Check = Open>Ref(Open,-2) AND Open>Ref(Open,-3) AND
Open>Ref(Open,-4);
> }
> if(XYZ_Check==2)
> {
> RU1_Check = Open>Ref(Open,-3) AND Open>Ref(Open,-4) AND
Open>Ref(Open,-5);
> }
> if(XYZ_Check==3)
> {
> RU1_Check = Open>Ref(Open,-4) AND Open>Ref(Open,-5) AND
Open>Ref(Open,-6);
> }
>
> Any way to achieve this across the entire price array outside of a
> loop....?
>
> TIA
>
