Spreadsheet: phillip_m_love__31160__Options Detail
Sheet: Results

 |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  | Phy/ | [NAME] | Opt |  | Option | Monthly | Option | Stike | Mid | Mid | Mid | Premium
Counterparty | Deal Num | Pub Code | Fin | Put | Type | Period | [NAME] | Option Qty | Delta | Price | Price | Vol | Value | Value
NG-PR-OPT | VD8734.1 | NXB2 | F | P | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 3.75 | 3.397 | 0.405295 | -353000 | 0
NG-PR-OPT | VD8737.1 | NXB2 | F | P | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 3.75 | 3.397 | 0.405295 | -353000 | 0
NG-PR-OPT | VD8738.1 | NXB2 | F | P | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 3.75 | 3.397 | 0.405295 | -353000 | 0
NG-PR-OPT | VD8741.1 | NXB2 | F | P | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 3.75 | 3.397 | 0.405295 | -353000 | 0
NG-PR-OPT | VD8748.1 | NXB2 | F | P | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 3.75 | 3.397 | 0.405295 | -353000 | 0
NG-PR-OPT | VD8751.1 | NXB2 | F | P | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 3.75 | 3.397 | 0.405295 | -353000 | 0
NG-PR-OPT | VD8766.1 | NXB2 | F | P | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 3.75 | 3.397 | 0.405295 | -353000 | 0
NG-PR-OPT | VD8767.1 | NXB2 | F | P | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 3.75 | 3.397 | 0.405295 | -353000 | 0
NG-PR-OPT | VE2119.1 | NXB2 | F | P | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 3.75 | 3.397 | 0.405295 | 353000 | 0
NG-PR-OPT | VE2121.1 | NXB2 | F | P | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 3.75 | 3.397 | 0.405295 | 353000 | 0
NG-PR-OPT | VE2124.1 | NXB2 | F | P | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 3.75 | 3.397 | 0.405295 | 353000 | 0
NG-PR-OPT | VE2127.1 | NXB2 | F | C | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 4.5 | 3.397 | 0.416545 | 0 | 0
NG-PR-OPT | VE2132.1 | NXB2 | F | C | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 4.5 | 3.397 | 0.416545 | 0 | 0
NG-PR-OPT | VE2134.1 | NXB2 | F | C | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 4.5 | 3.397 | 0.416545 | 0 | 0
NG-PR-OPT | [NAME] | NXB2 | F | C | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 4.5 | 3.397 | 0.416545 | 0 | 0
NG-PR-OPT | VE2556.1 | NXB2 | F | C | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 4.5 | 3.397 | 0.416545 | 0 | 0
NG-PR-OPT | VF1368.1 | NXB2 | F | C | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 4.5 | 3.397 | 0.416545 | 0 | 0
NG-PR-OPT | VF1373.1 | NXB2 | F | C | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 4.5 | 3.397 | 0.416545 | 0 | 0
NG-PR-OPT | VF1377.1 | NXB2 | F | C | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 4.5 | 3.397 | 0.416545 | 0 | 0
NG-PR-OPT | VF1379.1 | NXB2 | F | C | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 4.5 | 3.397 | 0.416545 | 0 | 0
NG-PR-OPT | VF1383.1 | NXB2 | F | C | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 4.5 | 3.397 | 0.416545 | 0 | 0
NG-PR-OPT | VF1547.1 | NXB2 | F | C | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 3.75 | 3.397 | 0.405295 | 0 | 0
NG-PR-OPT | VF1555.1 | NXB2 | F | C | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 3.75 | 3.397 | 0.405295 | 0 | 0
NG-PR-OPT | VF1569.1 | NXB2 | F | C | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 3.75 | 3.397 | 0.405295 | 0 | 0
NG-PR-OPT | VF1582.1 | NXB2 | F | C | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 3.75 | 3.397 | 0.405295 | 0 | 0
NG-PR-OPT | VF1588.1 | NXB2 | F | C | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 3.75 | 3.397 | 0.405295 | 0 | 0
NG-PR-OPT | VG2686.1 | NXB2 | F | P | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 3.75 | 3.397 | 0.405295 | 353000 | 0
NG-PR-OPT | VG2688.1 | NXB2 | F | P | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 3.75 | 3.397 | 0.405295 | 353000 | 0
NG-PR-OPT | VG2692.1 | NXB2 | F | P | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 3.75 | 3.397 | 0.405295 | 353000 | 0
NG-PR-OPT | VG2696.1 | NXB2 | F | P | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 3.75 | 3.397 | 0.405295 | 353000 | 0
NG-PR-OPT | VG2698.1 | NXB2 | F | P | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 3.75 | 3.397 | 0.405295 | 353000 | 0
NG-PR-OPT | VH8783.1 | NXB2 | F | P | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 3.5 | 3.397 | 0.401545 | 103000 | 0
NG-PR-OPT | VH8787.1 | NXB2 | F | P | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 3.5 | 3.397 | 0.401545 | 103000 | 0
NG-PR-OPT | VH8789.1 | NXB2 | F | P | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 3.5 | 3.397 | 0.401545 | 103000 | 0
NG-PR-OPT | VH8790.1 | NXB2 | F | P | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 3.5 | 3.397 | 0.401545 | 103000 | 0
NG-PR-OPT | VH8792.1 | NXB2 | F | P | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 3.5 | 3.397 | 0.401545 | 103000 | 0
NG-PR-OPT | VI5326.1 | NXB2 | F | P | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 3.75 | 3.397 | 0.405295 | 1765000 | 0
NG-PR-OPT | VI5326.2 | NXB2 | F | P | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 3.5 | 3.397 | 0.401545 | -515000 | 0
NG-PR-OPT | VI7522.1 | NXB2 | F | P | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 3.75 | 3.397 | 0.405295 | -353000 | 0
NG-PR-OPT | VI7526.1 | NXB2 | F | P | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 3.75 | 3.397 | 0.405295 | -353000 | 0
NG-PR-OPT | VI7533.1 | NXB2 | F | P | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 3.75 | 3.397 | 0.405295 | -353000 | 0
NG-PR-OPT | VI7538.1 | NXB2 | F | P | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 3.75 | 3.397 | 0.405295 | -353000 | 0
NG-PR-OPT | VI7547.1 | NXB2 | F | P | EUR | 2001-07-01 00:00:00 | 2001-06-26 00:00:00 | 0 | 0 | 3.75 | 3.397 | 0.405295 | -353000 | 0
NG-PR-OPT | VK8179.1 | NXB2 | F | C | EUR | 2001-08-01 00:00:00 | 2001-07-26 00:00:00 | -1000000 | -344016.6228 | 3.5 | 3.282 | 0.65577 | -96312.1323 | 0
NG-PR-OPT | VK8179.1 | OPTION | F | C | EUR | 2001-07-01 00:00:00 | 2001-07-01 00:00:00 | 0 | 0 | 0 | 3.182 | 0.4 | 0 | 120000
NG-PR-OPT | VK8184.1 | NXB2 | F | C | EUR | 2001-08-01 00:00:00 | 2001-07-26 00:00:00 | -1000000 | -344016.6228 | 3.5 | 3.282 | 0.65577 | -96312.1323 | 0
NG-PR-OPT | VK8184.1 | OPTION | F | C | EUR | 2001-07-01 00:00:00 | 2001-07-01 00:00:00 | 0 | 0 | 0 | 3.182 | 0.4 | 0 | 120000
NG-PR-OPT | VK8189.1 | NXB2 | F | C | EUR | 2001-08-01 00:00:00 | 2001-07-26 00:00:00 | -1000000 | -344016.6228 | 3.5 | 3.282 | 0.65577 | -96312.1323 | 0
NG-PR-OPT | VK8189.1 | OPTION | F | C | EUR | 2001-07-01 00:00:00 | 2001-07-01 00:00:00 | 0 | 0 | 0 | 3.182 | 0.4 | 0 | 120000
NG-PR-OPT | VK8193.1 | NXB2 | F | C | EUR | 2001-08-01 00:00:00 | 2001-07-26 00:00:00 | -1000000 | -344016.6228 | 3.5 | 3.282 | 0.65577 | -96312.1323 | 0
NG-PR-OPT | VK8193.1 | OPTION | F | C | EUR | 2001-07-01 00:00:00 | 2001-07-01 00:00:00 | 0 | 0 | 0 | 3.182 | 0.4 | 0 | 120000
NG-PR-OPT | VK8206.1 | NXB2 | F | C | EUR | 2001-08-01 00:00:00 | 2001-07-26 00:00:00 | -1000000 | -344016.6228 | 3.5 | 3.282 | 0.65577 | -96312.1323 | 0
NG-PR-OPT | VK8206.1 | OPTION | F | C | EUR | 2001-07-01 00:00:00 | 2001-07-01 00:00:00 | 0 | 0 | 0 | 3.182 | 0.4 | 0 | 120000
NG-PR-OPT | VL0699.1 | NXB2 | F | C | EUR | 2001-08-01 00:00:00 | 2001-07-26 00:00:00 | 1000000 | 344016.6228 | 3.5 | 3.282 | 0.65577 | 96312.1323 | 0
NG-PR-OPT | VL0699.1 | OPTION | F | C | EUR | 2001-07-01 00:00:00 | 2001-07-01 00:00:00 | 0 | 0 | 0 | 3.182 | 0.4 | 0 | -107500
NG-PR-OPT | VL0707.1 | NXB2 | F | C | EUR | 2001-08-01 00:00:00 | 2001-07-26 00:00:00 | 1000000 | 344016.6228 | 3.5 | 3.282 | 0.65577 | 96312.1323 | 0
NG-PR-OPT | VL0707.1 | OPTION | F | C | EUR | 2001-07-01 00:00:00 | 2001-07-01 00:00:00 | 0 | 0 | 0 | 3.182 | 0.4 | 0 | -107500
NG-PR-OPT | VL0715.1 | NXB2 | F | C | EUR | 2001-08-01 00:00:00 | 2001-07-26 00:00:00 | 1000000 | 344016.6228 | 3.5 | 3.282 | 0.65577 | 96312.1323 | 0
NG-PR-OPT | VL0715.1 | OPTION | F | C | EUR | 2001-07-01 00:00:00 | 2001-07-01 00:00:00 | 0 | 0 | 0 | 3.182 | 0.4 | 0 | -107500
NG-PR-OPT | VL0755.1 | NXB2 | F | C | EUR | 2001-08-01 00:00:00 | 2001-07-26 00:00:00 | 1000000 | 344016.6228 | 3.5 | 3.282 | 0.65577 | 96312.1323 | 0
NG-PR-OPT | VL0755.1 | OPTION | F | C | EUR | 2001-07-01 00:00:00 | 2001-07-01 00:00:00 | 0 | 0 | 0 | 3.182 | 0.4 | 0 | -102500
NG-PR-OPT | VL0757.1 | NXB2 | F | C | EUR | 2001-08-01 00:00:00 | 2001-07-26 00:00:00 | 1000000 | 344016.6228 | 3.5 | 3.282 | 0.65577 | 96312.1323 | 0
NG-PR-OPT | VL0757.1 | OPTION | F | C | EUR | 2001-07-01 00:00:00 | 2001-07-01 00:00:00 | 0 | 0 | 0 | 3.182 | 0.4 | 0 | -102500
NG-PR-OPT | VL3063.1 | NXB2 | F | P | EUR | 2001-08-01 00:00:00 | 2001-07-26 00:00:00 | -1000000 | 234256.5191 | 3 | 3.282 | 0.65532 | -66125.1698 | 0
NG-PR-OPT | VL3063.1 | OPTION | F | P | EUR | 2001-07-01 00:00:00 | 2001-07-01 00:00:00 | 0 | 0 | 0 | 3.182 | 0.4 | 0 | 152500
NG-PR-OPT | VL3065.1 | NXB2 | F | P | EUR | 2001-08-01 00:00:00 | 2001-07-26 00:00:00 | -1000000 | 234256.5191 | 3 | 3.282 | 0.65532 | -66125.1698 | 0
NG-PR-OPT | VL3065.1 | OPTION | F | P | EUR | 2001-07-01 00:00:00 | 2001-07-01 00:00:00 | 0 | 0 | 0 | 3.182 | 0.4 | 0 | 152500
NG-PR-OPT | VL3069.1 | NXB2 | F | P | EUR | 2001-08-01 00:00:00 | 2001-07-26 00:00:00 | -1000000 | 234256.5191 | 3 | 3.282 | 0.65532 | -66125.1698 | 0
NG-PR-OPT | VL3069.1 | OPTION | F | P | EUR | 2001-07-01 00:00:00 | 2001-07-01 00:00:00 | 0 | 0 | 0 | 3.182 | 0.4 | 0 | 150000
NG-PR-OPT | VL3070.1 | NXB2 | F | P | EUR | 2001-08-01 00:00:00 | 2001-07-26 00:00:00 | -1000000 | 234256.5191 | 3 | 3.282 | 0.65532 | -66125.1698 | 0
NG-PR-OPT | VL3070.1 | OPTION | F | P | EUR | 2001-07-01 00:00:00 | 2001-07-01 00:00:00 | 0 | 0 | 0 | 3.182 | 0.4 | 0 | 150000
NG-PR-OPT | VL3076.1 | NXB2 | F | P | EUR | 2001-08-01 00:00:00 | 2001-07-26 00:00:00 | -1000000 | 234256.5191 | 3 | 3.282 | 0.65532 | -66125.1698 | 0
NG-PR-OPT | VL3076.1 | OPTION | F | P | EUR | 2001-07-01 00:00:00 | 2001-07-01 00:00:00 | 0 | 0 | 0 | 3.182 | 0.4 | 0 | 150000
NG-PR-OPT | VM7669.1 | NXB2 | F | P | EUR | 2001-08-01 00:00:00 | 2001-07-26 00:00:00 | 1000000 | -234256.5191 | 3 | 3.282 | 0.65532 | 66125.1698 | 0
NG-PR-OPT | VM7669.1 | OPTION | F | P | EUR | 2001-07-01 00:00:00 | 2001-07-01 00:00:00 | 0 | 0 | 0 | 3.182 | 0.4 | 0 | -60000
NG-PR-OPT | VM7772.1 | NXB2 | F | P | EUR | 2001-08-01 00:00:00 | 2001-07-26 00:00:00 | 1000000 | -234256.5191 | 3 | 3.282 | 0.65532 | 66125.1698 | 0
NG-PR-OPT | VM7772.1 | OPTION | F | P | EUR | 2001-07-01 00:00:00 | 2001-07-01 00:00:00 | 0 | 0 | 0 | 3.182 | 0.4 | 0 | -65000
NG-PR-OPT | VN0214.1 | NXB2 | F | P | EUR | 2001-08-01 00:00:00 | 2001-07-26 00:00:00 | 1000000 | -234256.5191 | 3 | 3.282 | 0.65532 | 66125.1698 | 0
NG-PR-OPT | VN0214.1 | OPTION | F | P | EUR | 2001-07-01 00:00:00 | 2001-07-01 00:00:00 | 0 | 0 | 0 | 3.182 | 0.4 | 0 | -70000
NG-PR-OPT | VN0562.1 | NXB2 | F | P | EUR | 2001-08-01 00:00:00 | 2001-07-26 00:00:00 | 1000000 | -234256.5191 | 3 | 3.282 | 0.65532 | 66125.1698 | 0
NG-PR-OPT | VN0562.1 | OPTION | F | P | EUR | 2001-07-01 00:00:00 | 2001-07-01 00:00:00 | 0 | 0 | 0 | 3.182 | 0.4 | 0 | -70000
NG-PR-OPT | VN0567.1 | NXB2 | F | P | EUR | 2001-08-01 00:00:00 | 2001-07-26 00:00:00 | 1000000 | -234256.5191 | 3 | 3.282 | 0.65532 | 66125.1698 | 0
NG-PR-OPT | VN0567.1 | OPTION | F | P | EUR | 2001-07-01 00:00:00 | 2001-07-01 00:00:00 | 0 | 0 | 0 | 3.182 | 0.4 | 0 | -70000