Hi

Before

_____ Workbook: ap.xls ( Using Excel 2007 32 bit )
Row\Col
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
1
 NetBuyValue NetSellValue NetValue NetBuyQty NetSellQty NetQty BEP SellAvgPrice BuyAvgPrice LastTradedPrice MarkToMarket Realized MarkToMarket Unrealized MarkToMarket EL MarkToMarket
2
10781.10
10878.30
97.20
54
54
201.45
199.65
201
97.2
97.2
97.2
3
420.60
430.50
9.90
2
2
215.25
210.30
210.35
9.9
9.9
9.9
4
2429.10
2405.70
-23.40
18
18
133.65
134.95
135
-23.4
-23.4
-23.4
5
6120.90
6064.20
-56.70
54
54
112.30
113.35
111.6
-56.7
-56.7
-56.7
6
66.30
65.70
-0.60
2
2
32.85
33.15
32.5
-0.6
-0.6
-0.6
7
15114.60
14966.10
-148.50
54
54
277.15
279.90
279.15
-148.5
-148.5
-148.5
8
570.60
567.00
-3.60
6
6
94.50
95.10
93.35
-3.6
-3.6
-3.6
9
7344.00
7272.40
-71.60
54
54
134.67
136.00
138.5
-71.6
-71.6
-71.6
10
Worksheet: ap-Sheet1

After

_____ Workbook: ap.xls ( Using Excel 2007 32 bit )
Row\Col
U
1
 EL MarkToMarket
2
-1
3
9.9
4
-23.4
5
-56.7
6
-0.6
7
-148.5
8
-3.6
9
-71.6
10
Worksheet: ap-Sheet1


Macro here: https://excelfox.com/forum/showthrea...ll=1#post13424


Alan