Solved
excel calculation
Posted on 2011-03-01
Is there a simple formula for figuring this out, the sum of the rows? See below for further explanation:
A B C D
S 825.2 1 3/1/2011 14:34
B 824.8 1 3/1/2011 14:35
B 821.2 1 3/1/2011 14:41
S 821.1 1 3/1/2011 14:41
The above columns show trading contracts.
Column A is S or B, meaning short or long. An S contract is a negative amount and a B contract is a positive amount.
Column B is the contract value.
Column C is the quantity of contracts traded
Column D is the date and doesn't matter for this calculation.
If the formula is working correctly, I would be able to select rows 1 and 2 and apply the formula and get a sum of 4 in Column E