Hi all,

I've had no luck with a formula to calculate profit and loss based on a
strategy in the market all the time either long or short.

Column A is market position: 1 or -1
Column B is the entry price:
Column C is the profit (difference between sell and buy price or buy and
sell price:

For instance:

Market position, price:
-1, 98 12/32
1, 99 14/32
-1, 99 3/32
1, 99 2/32
-1, 97 16/32
1, 99 1/32

Therefo
(98 12/32 -(99 14/32) + ( 99 3/32 - 99 14/32) + (99 3/32 - 99 2/32) + (97
16/32 - 99 2/32) =

Thanks,

Scott