macro to track profit when long
 

Hello MVPs

I need help getting started. I'd like to have a macro
that would enable a spreadsheet to automatically
calculate profits for long positions.

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. In A1(day1) IF A3(low) < A5(pivot) AND A4 A5, THEN
A6 = A4 - A5 AND A7 = LONG. IF A4 < A5 then A7 = NOT LONG

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 = NOT LONG, THEN 1. for day2

3. IF B7 = LONG, THEN iIF C4 C5, THEN C6 = C4-B5 AND B6
= 0 AND C7 = LONG. IF C4 < C5 then C6 = C4-B5 AND B6 = 0
AND C7 = CLOSE LONG. IF B7 = NOT LONG, THEN 1 for day3

...this repeats until last non blank column

Thanks in advance for your help and feedback!