Team,

I am working to have a macro calculate profits for long
positions. Below is an example and the criteria needed

1/1/04,1/02/04,1/1/04,1/5/04
112740,112750,113090,113500
111900,111350,112200,112250
112740,112040,113040,113230
111956,112131,112062,112312

row1 DAY, row2 HIGH, row3 LOW, row4 CLOSE, row5 PIVOT,
row6 GAIN, row7 STAT

1.) DAY 1
IF A3(low) < A5(pivot) AND A4 A5,
THEN A6 = A4 - A5 AND A7 = LONG.
IF A3 < A5 and A4 < A5
THEN A6 = A4 - A5 AND A7 = LOSS
IF A3 A5 AND A4 < A5 THEN A7 = NOT LONG

2.) DAY 2
IF A7 = LONG
THEN IF B4 B5,
THEN B6 = B4-A5 AND A6 = 0 (B6 has profit from day1 and
day2) AND B7 = LONG.
IF B4 < B5 THEN B6 = B4-A5 AND A6 = 0 AND B7 = CLOSE
LONG.

IF A7 = LOSS OR NOT LONG
THEN 1.) for DAY 2

this macro run until every column (day) until the last
non bank value in row 1

thanks for any help on this.