Spreadsheet: phillip_m_love__31313__ARUBA Fixed HEDGE Pricing
Sheet: orders

PEOPLES / NORTH SHORE - Fixed Price Transactions
 |  |  |  | Beg | End |  |  | FP | Basis
 | Order # | Volume | company | Term | Term | filled | lock-in price | Vol Hedge | Vol Hedge |  | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00 | 2002-01-01 00:00:00 | 2002-02-01 00:00:00 | 2002-03-01 00:00:00 | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 2002-06-01 00:00:00 | 2002-07-01 00:00:00 | 2002-08-01 00:00:00 | 2002-09-01 00:00:00 | 2002-10-01 00:00:00 | 2002-11-01 00:00:00 |  | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00 | 2002-01-01 00:00:00 | 2002-02-01 00:00:00 | 2002-03-01 00:00:00 | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 2002-06-01 00:00:00 | 2002-07-01 00:00:00 | 2002-08-01 00:00:00 | 2002-09-01 00:00:00 | 2002-10-01 00:00:00 | 2002-11-01 00:00:00
1 | 1 | 2500 | NS | 2001-05-01 00:00:00 | 2002-10-31 00:00:00 |  | 4.66
2 | 1 | 10000 | PGLC | 2001-05-01 00:00:00 | 2002-10-31 00:00:00 |  | 4.66
3 | 2 | 1250 | NS | 2001-05-01 00:00:00 | 2002-10-31 00:00:00 |  | 4.95
4 | 2 | 5000 | PGLC | 2001-05-01 00:00:00 | 2002-10-31 00:00:00 |  | 4.95
5 | 3 | 1250 | NS | 2001-05-01 00:00:00 | 2002-10-31 00:00:00 |  | 4.999
6 | 3 | 5000 | PGLC | 2001-05-01 00:00:00 | 2002-10-31 00:00:00 |  | 4.999
7 | 4 | 1250 | NS | 2001-05-01 00:00:00 | 2002-10-31 00:00:00 |  | 4.97
8 | 4 | 5000 | PGLC | 2001-05-01 00:00:00 | 2002-10-31 00:00:00 |  | 4.97
9 | 6 | 5000 | PGLC | 2001-06-01 00:00:00 | 2002-10-31 00:00:00 |  | 4.93
10 | 5 | 1250 | NS | 2001-06-01 00:00:00 | 2002-10-31 00:00:00 |  | 4.93
11 | 7 | 5000 | PGLC | 2001-06-01 00:00:00 | 2002-10-31 00:00:00 |  | 4.83
12 | 7 | 5000 | NS | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 |  | 5.04
13 | 6 | 1250 | NS | 2001-06-01 00:00:00 | 2002-10-31 00:00:00 |  | 4.83
14 | 8 | 10000 | PGLC | 2001-11-01 00:00:00 | 2001-11-30 00:00:00 |  | 4.945
15 |  | 10000 | PGLC | 2002-02-01 00:00:00 | 2002-02-28 00:00:00 |  | 5.055
16 |  | 10000 | PGLC | 2002-03-01 00:00:00 | 2002-03-31 00:00:00 |  | 4.845
17 | 8 | 1250 | NS | 2001-06-01 00:00:00 | 2002-10-31 00:00:00 |  | 4.48
18 | 9 | 5000 | PGLC | 2001-06-01 00:00:00 | 2002-10-31 00:00:00 |  | 4.48
19 | 9 | 2500 | NS | 2001-06-01 00:00:00 | 2002-10-31 00:00:00 |  | 4.42
20 | 10 | 10000 | PGLC | 2001-06-01 00:00:00 | 2002-10-31 00:00:00 |  | 4.42
21 | 10 | 1250 | NS | 2001-06-01 00:00:00 | 2002-10-31 00:00:00 |  | 0.135
22 | 11 | 5000 | PGLC | 2001-06-01 00:00:00 | 2002-10-31 00:00:00 |  | 0.135
23 | 11 | 2500 | NS | 2001-06-01 00:00:00 | 2002-10-31 00:00:00 |  | 0.125
24 | 12 | 10000 | PGLC | 2001-06-01 00:00:00 | 2002-10-31 00:00:00 |  | 0.125
25 | 12 | 1250 | NS | 2001-06-01 00:00:00 | 2002-03-31 00:00:00 |  | 4.78
26 | 13 | 5000 | PGLC | 2001-06-01 00:00:00 | 2002-03-31 00:00:00 |  | 4.78
27 | 14 | 10000 | PGLC | 2001-06-01 00:00:00 | 2002-03-31 00:00:00 | 10000 | 4.68
28 | 13 | 5000 | NS | 2001-06-01 00:00:00 | 2002-03-31 00:00:00 | 5000 | 4.68
29 | 14 | 5000 | NS | 2001-06-01 00:00:00 | 2002-10-31 00:00:00 | 5000 | 0.125
30 | 15 | 10000 | PGLC | 2001-06-01 00:00:00 | 2002-10-31 00:00:00 | 10000 | 0.125
31 | 15 | 5000 | NS | 2001-06-01 00:00:00 | 2002-10-31 00:00:00 | 5000 | 0.12
32 | 16 | 10000 | PGLC | 2001-06-01 00:00:00 | 2002-10-31 00:00:00 | 10000 | 0.12
33 | 16 | 5000 | NS | 2001-06-01 00:00:00 | 2002-03-31 00:00:00 |  | 4.52
34 | 17 | 5000 | PGLC | 2001-06-01 00:00:00 | 2002-03-31 00:00:00 |  | 4.52
35 | 17 | 2500 | NS | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 |  | 4.585
36 | 18 | 10000 | PGLC | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 |  | 4.585
37 | 18 | 2500 | NS | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 | 2500 | 4.385
38 | 19 | 10000 | PGLC | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 | 10000 | 4.385
39 | 19 | 1250 | NS | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 | 1250 | 4.325
40 | 20 | 10000 | PGLC | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 | 10000 | 4.325
41 | 21 | 2500 | NS | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 | 2500 | 4.7
42 | 22 | 10000 | PGLC | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 | 10000 | 4.7
43 | 23 | 2500 | NS | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 | 2500 | 4.33
44 | 23 | 5000 | PGLC | 2001-11-01 00:00:00 | 2001-11-30 00:00:00 | 5000 | 4.3
45 | 23 | 5000 | PGLC | 2002-01-01 00:00:00 | 2002-01-31 00:00:00 | 5000 | 4.3
46 | 23 | 5000 | PGLC | 2002-02-01 00:00:00 | 2002-02-28 00:00:00 | 5000 | 4.3
47 | 23 | 5000 | PGLC | 2002-03-01 00:00:00 | 2002-03-31 00:00:00 | 5000 | 4.3
48 | 25 | 2500 | NS | 2001-08-01 00:00:00 | 2001-10-31 00:00:00 | 2500 | 3.19
49 | 26 | 5000 | PGLC | 2001-08-01 00:00:00 | 2001-10-31 00:00:00 | 5000 | 3.19
50 | 26 | 2500 | NS | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 | 2500 | 0.12
51 | 27 | 10000 | PGLC | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 | 10000 | 0.12
52 | 27 | 1250 | NS | 2001-08-01 00:00:00 | 2001-10-31 00:00:00 | 1250 | 3.505
 |  | 1250 | NS | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 | 1250 | 4
53 | 29 | 10000 | PGLC | 2001-08-01 00:00:00 | 2001-10-31 00:00:00 | 10000 | 3.505
 |  | 10000 | PGLC | 2001-11-01 00:00:00 | 2001-11-30 00:00:00 | 10000 | 3.985
 |  | 10000 | PGLC | 2002-01-01 00:00:00 | 2002-03-31 00:00:00 | 10000 | 3.985
54 | 29 | 10000 | PGLC | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 | 10000 | 0.125
55 | 28 | 1250 | NS | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 | 1250 | 0.125
56 | 29 | 1250 | NS | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 | 1250 | 0.1075
57 | 30 | 10000 | PGLC | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 | 10000 | 0.1075
58 | 30 | 1250 | NS | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 | 1250 | 3.56
59 | 34 | 5000 | PGLC | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 | 5000 | 3.56
60 | 31 | 1250 | NS | 2001-11-01 00:00:00 | 2002-04-30 00:00:00 | 0 | 3.6
61 | 32 | 2500 | NS | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 | 2500 | 0.125
62 | 35 | 5000 | PGLC | 2001-11-01 00:00:00 | 2002-04-30 00:00:00 | 0 | 3.44
63 | 36 | 10000 | PGLC | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 | 10000 | 0.125
64 | 33 | 5000 | NS | 2001-04-01 00:00:00 | 2001-04-30 00:00:00 |  | 3.48
65 | 37 | 10000 | PGLC | 2001-04-01 00:00:00 | 2001-04-30 00:00:00 |  | 3.48
66 | 34 | 5000 | NS | 2001-10-01 00:00:00 | 2001-10-31 00:00:00 | 5000 | 3.38
 |  | 1250 | NS | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 | 1250 | 3.38
 |  | 5000 | NS | 2002-04-01 00:00:00 | 2002-04-30 00:00:00 | 5000 | 3.635
67 | 38 | 10000 | PGLC | 2001-10-01 00:00:00 | 2001-10-31 00:00:00 | 10000 | 3.38
 |  | 5000 | PGLC | 2001-11-01 00:00:00 | 2001-11-30 00:00:00 | 5000 | 3.82
 |  | 5000 | PGLC | 2002-01-01 00:00:00 | 2002-03-31 00:00:00 | 5000 | 3.82
 |  | 10000 | PGLC | 2002-04-01 00:00:00 | 2002-04-30 00:00:00 | 10000 | 3.635
68 | 35 | 5000 | NS | 2001-10-01 00:00:00 | 2001-10-31 00:00:00 | 5000 | 3.3
 |  | 1250 | NS | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 | 1250 | 3.73
 |  | 5000 | NS | 2002-04-01 00:00:00 | 2002-04-30 00:00:00 | 5000 | 3.5
69 | 39 | 10000 | PGLC | 2001-10-01 00:00:00 | 2001-10-31 00:00:00 | 10000 | 3.3
 |  | 5000 | PGLC | 2001-11-01 00:00:00 | 2001-11-30 00:00:00 | 5000 | 3.72
 |  | 5000 | PGLC | 2002-01-01 00:00:00 | 2002-03-31 00:00:00 | 5000 | 3.72
 |  | 10000 | PGLC | 2002-04-01 00:00:00 | 2002-04-30 00:00:00 | 10000 | 3.5
70 | 36 | 2500 | NS | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 | 2500 | 0.12
71 | 40 | 10000 | PGLC | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 | 10000 | 0.12
72 | 37 | 5000 | NS | 2002-04-01 00:00:00 | 2002-04-30 00:00:00 |  | 3.47
73 | 42 | 5000 | PGLC | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 |  | 3.64
 |  | 10000 | PGLC | 2002-04-01 00:00:00 | 2002-04-30 00:00:00 |  | 3.47
74 | 38 | 5000 | NS | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 |  | 3.59
75 | 43 | 5000 | PGLC | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 |  | 3.69
 |  | 10000 | PGLC | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 |  | 3.59
76 | 39 | 5000 | NS | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | 5000 | 3.58
77 | 44 | 5000 | PGLC | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 | 5000 | 3.64
 |  | 10000 | PGLC | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | 10000 | 3.58
78 | 40 | 10000 | NS | 2001-10-01 00:00:00 | 2001-10-31 00:00:00 | 10000 | 0.015
 |  | 10000 | NS | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 | 10000 | 0.1175
79 | 45 | 25000 | PGLC | 2001-10-01 00:00:00 | 2001-10-31 00:00:00 | 25000 | 0.015
 |  | 25000 | PGLC | 2001-11-01 00:00:00 | 2001-11-30 00:00:00 | 25000 | 0.1175
 |  | 5000 | PGLC | 2001-12-01 00:00:00 | 2001-12-31 00:00:00 | 5000 | 0.1175
 |  | 25000 | PGLC | 2002-01-01 00:00:00 | 2002-03-31 00:00:00 | 25000 | 0.1175
 |  | 25000 | PGLC | 2002-04-01 00:00:00 | 2002-04-30 00:00:00 |  | 0.025
 |  | 10000 | PGLC | 2002-05-01 00:00:00 | 2002-10-31 00:00:00 |  | 0.025
80 | 41 | 5000 | NS | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | 5000 | 3.17
81 | 46 | 5000 | PGLC | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 | 5000 | 3.12
 |  | 10000 | PGLC | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | 10000 | 3.17
82 | 42 | 5000 | NS | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | 5000 | 3.065
83 | 47 | 5000 | PGLC | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 | 5000 | 3
 |  | 10000 | PGLC | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | 10000 | 3.065