hi 

i have open below S3 and open above R3 ...

what i need now is open above R1 and or   R2  (separately )

and the same for S1 and S2... (open below)...thx

Open above R1 would be:

O > (2 * H1 - L1 + 2 * C1) / 3

Open above R2 would be:

O > (4 * H1 - 2 * L1 + C1) / 3

Open below S1 would be:

O < (2 * L1 - H1 + 2 * C1) / 3

Open below S2 would be: 

O < (4 * L1 - 2 * H1 + C1) / 3

Pivot Points

thx bruce

now would a stock that opened below S1 still show up in the scan window if it opened there and bounced  back  above it  ...oh and i think what i need it (if its not the same ) is open at or below S1 S2

and the same for R1 R2 at or above 

O is the open of the current bar. So if you are using a daily time frame, it is entirely immaterial that price may have later crossed through the line of interest.

You can change the > to >= and the < to <= to include equality in the checks.

Open above R1 would be:

O >= (2 * H1 - L1 + 2 * C1) / 3

Open above R2 would be:

O >= (4 * H1 - 2 * L1 + C1) / 3

Open below S1 would be:

O <= (2 * L1 - H1 + 2 * C1) / 3

Open below S2 would be: 

O <= (4 * L1 - 2 * H1 + C1) / 3

i was also trying to create a scan open above S1 yesterday using the today values and changing them from L! to L2 ect. ...but i guess that did not work ....so can you give me the  R1 R2 S1 S2 and PP for yesterday .....and jst to be clear can you formulate   that in the R's open above (yesterday) and the S's open below (yesterday)  and the pp (yesterdays) open above 

-and can you also give me the pp for today  open above  pivot point (today)  ....thx

Formulas for the various pivot point values for the current day can be written as follows.

R4:
(7 * H1 - 5 * L1 + C1) / 3

R3:
(5 * H1 - 4 * L1 + 2 * C1) / 3

R2:
(4 * H1 - 2 * L1 + C1) / 3

R1:
(2 * H1 - L1 + 2 * C1) / 3

PP:
(H1 + L1 + C1) / 3

S1:
(2 * L1 - H1 + 2 * C1) / 3

S2:
(4 * L1 - 2 * H1 + C1) / 3

S3:
(5 * L1 - 4 * H1 + 2 * C1) / 3

S4:
(7 * L1 - 5 * H1 + C1) / 3

Adding 1 to the bars ago parameters really does work to get data from the day before, so I am not sure why you think it isn't working. Note that if you are looking for the open of yesterday to be above or below one of the lines which are currently plotting on the chart, then you would only change O to O1 and leave everything else unchanged.

R4 yesterday:
(7 * H2 - 5 * L2 + C2) / 3

R3 yesterday:
(5 * H2 - 4 * L2 + 2 * C2) / 3

R2 yesterday:
(4 * H2 - 2 * L2 + C2) / 3

R1 yesterday:
(2 * H2 - L2 + 2 * C2) / 3

PP yesterday:
(H2 + L2 + C2) / 3

S1 yesterday:
(2 * L2 - H2 + 2 * C2) / 3

S2 yesterday:
(4 * L2 - 2 * H2 + C2) / 3

S3 yesterday:
(5 * L2 - 4 * H2 + 2 * C2) / 3

S4 yesterday:
(7 * L2 - 5 * H2 + C2) / 3

I really don't know all of the comparisons you want to make, but you can just add something like O > to the front of one of the formulas to check for the open being above the value or O < to check for the open being below something. Change O to O1 to check for yesterday's open instead of the current open.