Spreadsheet: darron_c_giron__7983__ExistingDeals
Sheet: Results

Counter Party | Deal Num | Exp Date | Location | Pub Code | Qty | Fwd Qty | Price Mid | Price Fix | Basis Mid | Basis Fix | Index Mid | Index Fix | Total Mid | Total Fix | Price Amt | Basis Amt | Index Amt | Total Amt
NICORGASCOM | EY7144.2 | 2000-07-01 00:00:00 | NGI/CHI. GATE | NX1 | -310000 | -310000 | 4.369000000000001 | 1e-07 | 0.06100000000000001 | 1e-07 | -0.005 | 1e-07 | 4.425 | 3e-07 | -1354389.969 | -18909.969 | 1550.031 | -1371749.907
NICORGASCOM | NC8401.1 | 2000-07-01 00:00:00 | NGI/CHI./NIPSCO | NX1 | 620000 | 620000 | 0 | 0 | 0.06100000000000001 | 0.055 | 0 | 0.015 | 0.06100000000000001 | 0.07 | 0 | 3720 | -9300 | -5580
NICORGASCOM | NC8401.1 | 2000-08-01 00:00:00 | NGI/CHI./NIPSCO | NX1 | 620000 | 618759.4029 | 0 | 0 | 0.0575 | 0.055 | 0.0025 | 0.015 | 0.06 | 0.07 | 0 | 1546.8985 | -7734.4925 | -6187.594
NICORGASCOM | NC8401.1 | 2000-09-01 00:00:00 | NGI/CHI./NIPSCO | NX1 | 600000 | 595394.4018999999 | 0 | 0 | 0.06 | 0.055 | 0.005 | 0.015 | 0.065 | 0.07 | 0 | 2976.972 | -5953.944 | -2976.972
NICORGASCOM | NC8401.1 | 2000-10-01 00:00:00 | NGI/CHI./NIPSCO | NX1 | 620000 | 611825.7969 | 0 | 0 | 0.0775 | 0.055 | 0.0075 | 0.015 | 0.085 | 0.07 | 0 | 13766.0804 | -4588.6935 | 9177.386900000001
NICORGASCOM | NK6968.1 | 2000-07-01 00:00:00 | NGI/CHI. GATE | NX1 | 310000 | 310000 | 4.369000000000001 | 1e-07 | 0.06100000000000001 | 1e-07 | -0.005 | 1e-07 | 4.425 | 3e-07 | 1354389.969 | 18909.969 | -1550.031 | 1371749.907
NICORGASCOM | NK6968.2 | 2000-09-01 00:00:00 | NGI/CHI. GATE | NX1 | -310000 | -307620.441 | 3.863 | 1e-07 | 0.06 | 1e-07 | 0.005 | 1e-07 | 3.928 | 3e-07 | -1188337.7327 | -18457.1957 | -1538.0714 | -1208332.9998
NICORENELLC | NP3995.1 | 2000-08-01 00:00:00 | NGI/CHI. GATE | NX1 | 500000 | 498999.5185 | 0 | 0 | 0.0575 | 1e-07 | 0.0025 | 1e-07 | 0.06 | 2e-07 | 0 | 28692.4224 | 1247.4489 | 29939.8713
NICORENELLC | NP3995.1 | 2000-12-01 00:00:00 | NGI/CHI. GATE | NX1 | 500000 | 487806.2313 | 0 | 0 | 0.1075 | 1e-07 | 0.005 | 1e-07 | 0.1125 | 2e-07 | 0 | 52439.1211 | 2438.9823 | 54878.1034
NICORENELLC | NP3995.1 | 2001-02-01 00:00:00 | NGI/CHI. GATE | NX1 | 500000 | 482123.6166000001 | 0 | 0 | 0.125 | 1e-07 | 0.0125 | 1e-07 | 0.1375 | 2e-07 | 0 | 60265.4039 | 6026.497000000001 | 66291.9009
NICORENELLC | NP3995.2 | 2000-09-01 00:00:00 | NGI/CHI. GATE | NX1 | -225000 | -223272.9007 | 0 | 0 | 0.06 | 1e-07 | 0.005 | 1e-07 | 0.065 | 2e-07 | 0 | -13396.3517 | -1116.3422 | -14512.6939
NICORENELLC | NP3995.2 | 2000-10-01 00:00:00 | NGI/CHI. GATE | NX1 | -775000 | -764782.2461 | 0 | 0 | 0.0775 | 1e-07 | 0.0075 | 1e-07 | 0.085 | 2e-07 | 0 | -59270.5476 | -5735.790400000001 | -65006.338
NICORENELLC | NP3995.2 | 2001-06-01 00:00:00 | NGI/CHI. GATE | NX1 | -500000 | -471190.3906 | 0 | 0 | 0.0575 | 1e-07 | 0 | 1e-07 | 0.0575 | 2e-07 | 0 | -27093.4003 | 0.0471 | -27093.3532
NICORGASCOM | NJ6159.1 | 2000-11-01 00:00:00 | NGI/CHI. GATE |  | -1500000 | -1471618.074 | 0 | 0 | 0 | 0 | 0.005 | 0.0125 | 0.005 | 0.0125 | 0 | 0 | 11037.1356 | 11037.1356
NICORGASCOM | NJ6159.1 | 2000-12-01 00:00:00 | NGI/CHI. GATE |  | -1550000 | -1512199.3171 | 0 | 0 | 0 | 0 | 0.005 | 0.0125 | 0.005 | 0.0125 | 0 | 0 | 11341.4949 | 11341.4949
NICORGASCOM | NJ6159.1 | 2001-01-01 00:00:00 | NGI/CHI. GATE |  | -1550000 | -1503428.6789 | 0 | 0 | 0 | 0 | 0.01 | 0.0125 | 0.01 | 0.0125 | 0 | 0 | 3758.5717 | 3758.5717
NICORGASCOM | NJ6159.1 | 2001-02-01 00:00:00 | NGI/CHI. GATE |  | -1400000 | -1349946.1265 | 0 | 0 | 0 | 0 | 0.0125 | 0.0125 | 0.0125 | 0.0125 | 0 | 0 | 0 | 0
NICORGASCOM | NJ6159.1 | 2001-03-01 00:00:00 | NGI/CHI. GATE |  | -1550000 | -1486583.9174 | 0 | 0 | 0 | 0 | 0.0175 | 0.0125 | 0.0175 | 0.0125 | 0 | 0 | -7432.9196 | -7432.9196
NICORGASCOM | NQ8556.1 | 2000-11-01 00:00:00 | IF-NGPL/OK-NW |  | -750000 | -735809.037 | 0 | 0 | 0 | 0 | 0.08 | 0.12 | 0.08 | 0.12 | 0 | 0 | 29432.3615 | 29432.3615
NICORGASCOM | NQ8556.1 | 2000-12-01 00:00:00 | IF-NGPL/OK-NW |  | -775000 | -756099.6586 | 0 | 0 | 0 | 0 | 0.075 | 0.12 | 0.075 | 0.12 | 0 | 0 | 34024.4846 | 34024.4846
NICORGASCOM | NQ8556.1 | 2001-01-01 00:00:00 | IF-NGPL/OK-NW |  | -775000 | -751714.3395 | 0 | 0 | 0 | 0 | 0.095 | 0.12 | 0.095 | 0.12 | 0 | 0 | 18792.8585 | 18792.8585
NICORGASCOM | NQ8556.1 | 2001-02-01 00:00:00 | IF-NGPL/OK-NW |  | -700000 | -674973.0633 | 0 | 0 | 0 | 0 | 0.0975 | 0.12 | 0.0975 | 0.12 | 0 | 0 | 15186.8939 | 15186.8939
NICORGASCOM | NQ8556.1 | 2001-03-01 00:00:00 | IF-NGPL/OK-NW |  | -775000 | -743291.9587000001 | 0 | 0 | 0 | 0 | 0.1025 | 0.12 | 0.1025 | 0.12 | 0 | 0 | 13007.6093 | 13007.6093
NICORENELLC1 | NK2711.1 | 2000-07-01 00:00:00 |  | NX1 | -20000 | 0 | 4.369000000000001 | 4.35 | 0 | 0 | 0 | 0 | 4.369000000000001 | 4.35 | -380 | 0 | 0 | -380
NICORGASCOM | NK6968.5 | 2000-07-01 00:00:00 |  | ANNUITY | 0 | 0 | 4.369000000000001 | 0 | 0 | 0 | 0 | 0 | 4.369000000000001 | 0 | -13950 | 0 | 0 | -13950
NICORENELLC | NP3995.3 | 2000-07-01 00:00:00 |  | ANNUITY | 0 | 0 | 4.369000000000001 | 0 | 0 | 0 | 0 | 0 | 4.369000000000001 | 0 | -772500 | 0 | 0 | -772500