Spreadsheet: errol_mclaughlin_jr__10139__Sapient
Sheet: Options

 |  |  |  |  |  |  |  |  |  |  |  | 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
SAPIENTENECOR | ND7282.3 | IF-ELPO/PERMIAN | F | C | EUR | 2001-01-01 00:00:00 | 2000-12-27 00:00:00 | 0 | 0 | 2.9200001 | 9.77 | 0.9 | 34249.9995 | 0
SAPIENTENECOR | ND7282.3 | IF-ELPO/PERMIAN | F | C | EUR | 2001-02-01 00:00:00 | 2001-01-29 00:00:00 | 5000 | 4971.3399 | 2.9200001 | 9.755 | 1.05 | 33979.9011 | 0
SAPIENTENECOR | ND7282.3 | IF-ELPO/PERMIAN | F | C | EUR | 2001-03-01 00:00:00 | 2001-02-26 00:00:00 | 5000 | 4936.6915 | 2.9200001 | 8.761 | 1.02 | 28903.1909 | 0
SAPIENTENECOR | ND7282.3 | IF-ELPO/PERMIAN | F | C | EUR | 2001-04-01 00:00:00 | 2001-03-28 00:00:00 | 5000 | 4895.5708 | 2.9200001 | 6.256 | 0.64 | 16432.4217 | 0
SAPIENTENECOR | ND7282.3 | IF-ELPO/PERMIAN | F | C | EUR | 2001-05-01 00:00:00 | 2001-04-26 00:00:00 | 5000 | 4847.6606 | 2.9200001 | 5.401 | 0.495 | 12176.056 | 0
SAPIENTENECOR | ND7282.3 | IF-ELPO/PERMIAN | F | C | EUR | 2001-06-01 00:00:00 | 2001-05-29 00:00:00 | 5000 | 4782.9974 | 2.9200001 | 5.31 | 0.478 | 11696.786 | 0
SAPIENTENECOR | ND7282.3 | IF-ELPO/PERMIAN | F | C | EUR | 2001-07-01 00:00:00 | 2001-06-27 00:00:00 | 5000 | 4732.2126 | 2.9200001 | 5.365 | 0.478 | 11940.4632 | 0
SAPIENTENECOR | ND7282.3 | IF-ELPO/PERMIAN | F | C | EUR | 2001-08-01 00:00:00 | 2001-07-27 00:00:00 | 5000 | 4671.0877 | 2.9200001 | 5.355 | 0.478 | 11881.294 | 0
SAPIENTENECOR | ND7282.3 | IF-ELPO/PERMIAN | F | C | EUR | 2001-09-01 00:00:00 | 2001-08-29 00:00:00 | 5000 | 4601.8142 | 2.9200001 | 5.325 | 0.478 | 11737.8919 | 0
SAPIENTENECOR | ND7282.3 | IF-ELPO/PERMIAN | F | C | EUR | 2001-10-01 00:00:00 | 2001-09-26 00:00:00 | 5000 | 4547.1307 | 2.9200001 | 5.31 | 0.478 | 11672.109 | 0
SAPIENTENECOR | ND7282.3 | IF-ELPO/PERMIAN | F | C | EUR | 2001-11-01 00:00:00 | 2001-10-29 00:00:00 | 5000 | 4514.3891 | 2.9200001 | 5.425 | 0.478 | 12196.2931 | 0
SAPIENTENECOR | ND7282.3 | IF-ELPO/PERMIAN | F | C | EUR | 2001-12-01 00:00:00 | 2001-11-28 00:00:00 | 5000 | 4483.5698 | 2.9200001 | 5.51 | 0.478 | 12580.4162 | 0
SAPIENTENECOR | ND7282.4 | IF-ELPO/PERMIAN | F | P | EUR | 2001-01-01 00:00:00 | 2000-12-27 00:00:00 | 0 | 0 | 2.4700001 | 9.77 | 0.9 | 0 | 0
SAPIENTENECOR | ND7282.4 | IF-ELPO/PERMIAN | F | P | EUR | 2001-02-01 00:00:00 | 2001-01-29 00:00:00 | -5000 | 0.0087 | 2.4700001 | 9.755 | 1.05 | -0.0052 | 0
SAPIENTENECOR | ND7282.4 | IF-ELPO/PERMIAN | F | P | EUR | 2001-03-01 00:00:00 | 2001-02-26 00:00:00 | -5000 | 2.4612 | 2.4700001 | 8.761 | 1.02 | -2.5429 | 0
SAPIENTENECOR | ND7282.4 | IF-ELPO/PERMIAN | F | P | EUR | 2001-04-01 00:00:00 | 2001-03-28 00:00:00 | -5000 | 4.7881 | 2.4700001 | 6.256 | 0.64 | -2.7974 | 0
SAPIENTENECOR | ND7282.4 | IF-ELPO/PERMIAN | F | P | EUR | 2001-05-01 00:00:00 | 2001-04-26 00:00:00 | -5000 | 8.5597 | 2.4700001 | 5.401 | 0.495 | -4.0038 | 0
SAPIENTENECOR | ND7282.4 | IF-ELPO/PERMIAN | F | P | EUR | 2001-06-01 00:00:00 | 2001-05-29 00:00:00 | -5000 | 19.9954 | 2.4700001 | 5.31 | 0.478 | -10.9907 | 0
SAPIENTENECOR | ND7282.4 | IF-ELPO/PERMIAN | F | P | EUR | 2001-07-01 00:00:00 | 2001-06-27 00:00:00 | -5000 | 31.9502 | 2.4700001 | 5.365 | 0.478 | -20.5771 | 0
SAPIENTENECOR | ND7282.4 | IF-ELPO/PERMIAN | F | P | EUR | 2001-08-01 00:00:00 | 2001-07-27 00:00:00 | -5000 | 49.6205 | 2.4700001 | 5.355 | 0.478 | -36.6537 | 0
SAPIENTENECOR | ND7282.4 | IF-ELPO/PERMIAN | F | P | EUR | 2001-09-01 00:00:00 | 2001-08-29 00:00:00 | -5000 | 72.9341 | 2.4700001 | 5.325 | 0.478 | -61.2244 | 0
SAPIENTENECOR | ND7282.4 | IF-ELPO/PERMIAN | F | P | EUR | 2001-10-01 00:00:00 | 2001-09-26 00:00:00 | -5000 | 93.1161 | 2.4700001 | 5.31 | 0.478 | -85.9326 | 0
SAPIENTENECOR | ND7282.4 | IF-ELPO/PERMIAN | F | P | EUR | 2001-11-01 00:00:00 | 2001-10-29 00:00:00 | -5000 | 102.6314 | 2.4700001 | 5.425 | 0.478 | -105.021 | 0
SAPIENTENECOR | ND7282.4 | IF-ELPO/PERMIAN | F | P | EUR | 2001-12-01 00:00:00 | 2001-11-28 00:00:00 | -5000 | 111.9251 | 2.4700001 | 5.51 | 0.478 | -124.6489 | 0
SAPIENTENECOR | ND7282.5 | IF-ELPO/PERMIAN | F | C | EUR | 2002-01-01 00:00:00 | 2001-12-27 00:00:00 | 30000 | 27099.3875 | 2.7000001 | 5.5 | 0.478 | 80693.332 | 0
SAPIENTENECOR | ND7282.5 | IF-ELPO/PERMIAN | F | C | EUR | 2002-02-01 00:00:00 | 2002-01-29 00:00:00 | 30000 | 26633.5444 | 2.7000001 | 5.245 | 0.465 | 73559.277 | 0
SAPIENTENECOR | ND7282.5 | IF-ELPO/PERMIAN | F | C | EUR | 2002-03-01 00:00:00 | 2002-02-26 00:00:00 | 30000 | 26228.6111 | 2.7000001 | 4.915 | 0.43 | 64191.3782 | 0
SAPIENTENECOR | ND7282.5 | IF-ELPO/PERMIAN | F | C | EUR | 2002-04-01 00:00:00 | 2002-03-26 00:00:00 | 30000 | 25637.8048 | 2.7000001 | 4.355 | 0.358 | 48268.2958 | 0
SAPIENTENECOR | ND7282.5 | IF-ELPO/PERMIAN | F | C | EUR | 2002-05-01 00:00:00 | 2002-04-26 00:00:00 | 30000 | 25280.3817 | 2.7000001 | 4.2 | 0.333 | 43816.9402 | 0
SAPIENTENECOR | ND7282.5 | IF-ELPO/PERMIAN | F | C | EUR | 2002-06-01 00:00:00 | 2002-05-29 00:00:00 | 30000 | 25029.6378 | 2.7000001 | 4.17 | 0.325 | 42905.1478 | 0
SAPIENTENECOR | ND7282.5 | IF-ELPO/PERMIAN | F | C | EUR | 2002-07-01 00:00:00 | 2002-06-26 00:00:00 | 30000 | 24883.1345 | 2.7000001 | 4.173 | 0.32 | 42876.04 | 0
SAPIENTENECOR | ND7282.5 | IF-ELPO/PERMIAN | F | C | EUR | 2002-08-01 00:00:00 | 2002-07-29 00:00:00 | 30000 | 24634.7227 | 2.7000001 | 4.175 | 0.32 | 42931.9192 | 0
SAPIENTENECOR | ND7282.5 | IF-ELPO/PERMIAN | F | C | EUR | 2002-09-01 00:00:00 | 2002-08-28 00:00:00 | 30000 | 24384.159 | 2.7000001 | 4.165 | 0.32 | 42693.8396 | 0
SAPIENTENECOR | ND7282.5 | IF-ELPO/PERMIAN | F | C | EUR | 2002-10-01 00:00:00 | 2002-09-26 00:00:00 | 30000 | 24190.6007 | 2.7000001 | 4.17 | 0.32 | 42820.8837 | 0
SAPIENTENECOR | ND7282.5 | IF-ELPO/PERMIAN | F | C | EUR | 2002-11-01 00:00:00 | 2002-10-29 00:00:00 | 30000 | 24226.1646 | 2.7000001 | 4.268 | 0.32 | 45184.7394 | 0
SAPIENTENECOR | ND7282.5 | IF-ELPO/PERMIAN | F | C | EUR | 2002-12-01 00:00:00 | 2002-11-26 00:00:00 | 30000 | 24231.9624 | 2.7000001 | 4.362 | 0.323 | 47520.6861 | 0
SAPIENTENECOR | ND7282.6 | IF-ELPO/PERMIAN | F | P | EUR | 2002-01-01 00:00:00 | 2001-12-27 00:00:00 | -30000 | 779.0815 | 2.4700001 | 5.5 | 0.478 | -932.0626 | 0
SAPIENTENECOR | ND7282.6 | IF-ELPO/PERMIAN | F | P | EUR | 2002-02-01 00:00:00 | 2002-01-29 00:00:00 | -30000 | 1016.7024 | 2.4700001 | 5.245 | 0.465 | -1237.0319 | 0
SAPIENTENECOR | ND7282.6 | IF-ELPO/PERMIAN | F | P | EUR | 2002-03-01 00:00:00 | 2002-02-26 00:00:00 | -30000 | 1204.7217 | 2.4700001 | 4.915 | 0.43 | -1343.4546 | 0
SAPIENTENECOR | ND7282.6 | IF-ELPO/PERMIAN | F | P | EUR | 2002-04-01 00:00:00 | 2002-03-26 00:00:00 | -30000 | 1458.2097 | 2.4700001 | 4.355 | 0.358 | -1248.5697 | 0
SAPIENTENECOR | ND7282.6 | IF-ELPO/PERMIAN | F | P | EUR | 2002-05-01 00:00:00 | 2002-04-26 00:00:00 | -30000 | 1590.6685 | 2.4700001 | 4.2 | 0.333 | -1276.7046 | 0
SAPIENTENECOR | ND7282.6 | IF-ELPO/PERMIAN | F | P | EUR | 2002-06-01 00:00:00 | 2002-05-29 00:00:00 | -30000 | 1676.4533 | 2.4700001 | 4.17 | 0.325 | -1364.8123 | 0
SAPIENTENECOR | ND7282.6 | IF-ELPO/PERMIAN | F | P | EUR | 2002-07-01 00:00:00 | 2002-06-26 00:00:00 | -30000 | 1705.0502 | 2.4700001 | 4.173 | 0.32 | -1412.8567 | 0
SAPIENTENECOR | ND7282.6 | IF-ELPO/PERMIAN | F | P | EUR | 2002-08-01 00:00:00 | 2002-07-29 00:00:00 | -30000 | 1805.6012 | 2.4700001 | 4.175 | 0.32 | -1569.1329 | 0
SAPIENTENECOR | ND7282.6 | IF-ELPO/PERMIAN | F | P | EUR | 2002-09-01 00:00:00 | 2002-08-28 00:00:00 | -30000 | 1916.3901 | 2.4700001 | 4.165 | 0.32 | -1734.7222 | 0
SAPIENTENECOR | ND7282.6 | IF-ELPO/PERMIAN | F | P | EUR | 2002-10-01 00:00:00 | 2002-09-26 00:00:00 | -30000 | 1987.4345 | 2.4700001 | 4.17 | 0.32 | -1867.887 | 0
SAPIENTENECOR | ND7282.6 | IF-ELPO/PERMIAN | F | P | EUR | 2002-11-01 00:00:00 | 2002-10-29 00:00:00 | -30000 | 1873.8356 | 2.4700001 | 4.268 | 0.32 | -1837.0385 | 0
SAPIENTENECOR | ND7282.6 | IF-ELPO/PERMIAN | F | P | EUR | 2002-12-01 00:00:00 | 2002-11-26 00:00:00 | -30000 | 1800.9108 | 2.4700001 | 4.362 | 0.323 | -1856.5634 | 0
SAPIENTENECOR | Q86438.1 | IF-PAN/TX/OK | F | C | EUR | 2003-01-01 00:00:00 | 2002-12-27 00:00:00 | 120000 | 31786.4805 | 6.0300001 | 4.265 | 0.323 | 31409.6516 | 0
SAPIENTENECOR | Q86438.1 | IF-PAN/TX/OK | F | C | EUR | 2003-02-01 00:00:00 | 2003-01-29 00:00:00 | 120000 | 28017.8323 | 6.0300001 | 4.0925 | 0.313 | 25468.9762 | 0
SAPIENTENECOR | Q86438.1 | IF-PAN/TX/OK | F | C | EUR | 2003-03-01 00:00:00 | 2003-02-26 00:00:00 | 120000 | 24033.9408 | 6.0300001 | 3.9 | 0.305 | 19887.1574 | 0
SAPIENTENECOR | Q86438.1 | IF-PAN/TX/OK | F | C | EUR | 2003-04-01 00:00:00 | 2003-03-27 00:00:00 | 120000 | 18747.2508 | 6.0300001 | 3.64 | 0.295 | 13487.4794 | 0
SAPIENTENECOR | Q86438.1 | IF-PAN/TX/OK | F | C | EUR | 2003-05-01 00:00:00 | 2003-04-28 00:00:00 | 120000 | 17667.5901 | 6.0300001 | 3.577 | 0.29 | 12362.2194 | 0
SAPIENTENECOR | Q86438.1 | IF-PAN/TX/OK | F | C | EUR | 2003-06-01 00:00:00 | 2003-05-28 00:00:00 | 120000 | 18356.848 | 6.0300001 | 3.585 | 0.29 | 13184.1015 | 0
SAPIENTENECOR | Q86438.1 | IF-PAN/TX/OK | F | C | EUR | 2003-07-01 00:00:00 | 2003-06-26 00:00:00 | 120000 | 19125.2267 | 6.0300001 | 3.6 | 0.29 | 14123.1964 | 0
SAPIENTENECOR | Q86438.1 | IF-PAN/TX/OK | F | C | EUR | 2003-08-01 00:00:00 | 2003-07-29 00:00:00 | 120000 | 19606.6397 | 6.0300001 | 3.595 | 0.29 | 14772.6213 | 0
SAPIENTENECOR | Q86438.1 | IF-PAN/TX/OK | F | C | EUR | 2003-09-01 00:00:00 | 2003-08-27 00:00:00 | 120000 | 20284.0722 | 6.0300001 | 3.607 | 0.29 | 15664.5606 | 0
SAPIENTENECOR | Q86438.1 | IF-PAN/TX/OK | F | C | EUR | 2003-10-01 00:00:00 | 2003-09-26 00:00:00 | 120000 | 21058.9141 | 6.0300001 | 3.625 | 0.29 | 16713.424 | 0
SAPIENTENECOR | Q86438.1 | IF-PAN/TX/OK | F | C | EUR | 2003-11-01 00:00:00 | 2003-10-29 00:00:00 | 120000 | 24220.9058 | 6.0300001 | 3.76 | 0.293 | 21114.4365 | 0
SAPIENTENECOR | Q86438.1 | IF-PAN/TX/OK | F | C | EUR | 2003-12-01 00:00:00 | 2003-11-25 00:00:00 | 120000 | 26933.2508 | 6.0300001 | 3.8825 | 0.295 | 25357.9206 | 0
SAPIENTENECOR | Q86438.2 | IF-PAN/TX/OK | F | P | EUR | 2003-01-01 00:00:00 | 2002-12-27 00:00:00 | -120000 | 14746.6314 | 2.8800001 | 4.265 | 0.323 | -18124.2055 | 0
SAPIENTENECOR | Q86438.2 | IF-PAN/TX/OK | F | P | EUR | 2003-02-01 00:00:00 | 2003-01-29 00:00:00 | -120000 | 16763.3064 | 2.8800001 | 4.0925 | 0.313 | -20301.6749 | 0
SAPIENTENECOR | Q86438.2 | IF-PAN/TX/OK | F | P | EUR | 2003-03-01 00:00:00 | 2003-02-26 00:00:00 | -120000 | 19452.9864 | 2.8800001 | 3.9 | 0.305 | -23301.3587 | 0
SAPIENTENECOR | Q86438.2 | IF-PAN/TX/OK | F | P | EUR | 2003-04-01 00:00:00 | 2003-03-27 00:00:00 | -120000 | 23817.6257 | 2.8800001 | 3.64 | 0.295 | -28013.6938 | 0
SAPIENTENECOR | Q86438.2 | IF-PAN/TX/OK | F | P | EUR | 2003-05-01 00:00:00 | 2003-04-28 00:00:00 | -120000 | 24977.1704 | 2.8800001 | 3.577 | 0.29 | -29506.5308 | 0
SAPIENTENECOR | Q86438.2 | IF-PAN/TX/OK | F | P | EUR | 2003-06-01 00:00:00 | 2003-05-28 00:00:00 | -120000 | 24842.4435 | 2.8800001 | 3.585 | 0.29 | -30058.6816 | 0
SAPIENTENECOR | Q86438.2 | IF-PAN/TX/OK | F | P | EUR | 2003-07-01 00:00:00 | 2003-06-26 00:00:00 | -120000 | 24565.4926 | 2.8800001 | 3.6 | 0.29 | -30394.803 | 0
SAPIENTENECOR | Q86438.2 | IF-PAN/TX/OK | F | P | EUR | 2003-08-01 00:00:00 | 2003-07-29 00:00:00 | -120000 | 24672.5685 | 2.8800001 | 3.595 | 0.29 | -31298.9293 | 0
SAPIENTENECOR | Q86438.2 | IF-PAN/TX/OK | F | P | EUR | 2003-09-01 00:00:00 | 2003-08-27 00:00:00 | -120000 | 24446.0843 | 2.8800001 | 3.607 | 0.29 | -31671.6158 | 0
SAPIENTENECOR | Q86438.2 | IF-PAN/TX/OK | F | P | EUR | 2003-10-01 00:00:00 | 2003-09-26 00:00:00 | -120000 | 24111.2946 | 2.8800001 | 3.625 | 0.29 | -31907.1041 | 0
SAPIENTENECOR | Q86438.2 | IF-PAN/TX/OK | F | P | EUR | 2003-11-01 00:00:00 | 2003-10-29 00:00:00 | -120000 | 21902.5228 | 2.8800001 | 3.76 | 0.293 | -30095.9083 | 0
SAPIENTENECOR | Q86438.2 | IF-PAN/TX/OK | F | P | EUR | 2003-12-01 00:00:00 | 2003-11-25 00:00:00 | -120000 | 20123.8981 | 2.8800001 | 3.8825 | 0.295 | -28480.8724 | 0