Spreadsheet: dutch_quigley__9454__HedgeStrips
Sheet: Mike Option Book - NG-PR-OPT

 |  | AEP |  | Duke |  | [NAME] |  | Bank of Am |  | Barclay's |  | BMO |  | BP |  | Calpine |  | Chase |  | Coral |  | Duke |  | Dynegy |  | El Paso |  | KINMORINC |  | Morgan |  | PG&E |  | Reliant |  | Sempra |  | [NAME]
2001-10-01 00:00:00 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
2001-11-01 00:00:00 |  | 1004.04195611 |  |  |  | 105.43198179 |  | 761.31304708 |  | 96.84935094 |  | -130.74289645 |  | 222.91684018 |  |  |  | 15.67578919 |  | -322.21642521 |  | -446.4981929 |  | 1797.70018814 |  | 3296.21204704 |  |  |  | -140.24421083 |  | 896.9387405 |  | 720.68337914 |  | 779.67886531 |  | 648.42625974
2001-12-01 00:00:00 |  | -15.98467364 |  |  |  | 44.35585458 |  | -12.02138862 |  | 31.64306088 |  | -157.15438596 |  | -94.36324661 |  |  |  | 122.11506597 |  | -389.43347111 |  | -764.68175183 |  | 120.99586947 |  | -1049.65822476 |  |  |  | -187.65693939 |  | -57.4086065 |  | 51.70725471 |  | -991.88075559 |  | 512.34291664
2002-01-01 00:00:00 |  | 10.49818743 |  |  |  | 45.01160899 |  | -394.63473893 |  |  |  | -116.98016461 |  | 99.37843378 |  |  |  | 65.24999355 |  | -328.92263551 |  | -1207.67433597 |  | 230.55560241 |  | 1131.38458699 |  |  |  | -371.92653785 |  | 13.98689416 |  | 41.15005775 |  | -1096.65991316 |  | -547.35661974
2002-02-01 00:00:00 |  | 68.05683687 |  |  |  | -2.76071815 |  | -56.25616071 |  |  |  | -95.7426965 |  | 144.12907166 |  |  |  | -24.95931878 |  | -269.17949312 |  | -2727.70375965 |  | 159.06962176 |  | 1937.25001762 |  |  |  | 234.50252805 |  |  |  | -30.57135947 |  | -253.75335077 |  | 227.50705468
2002-03-01 00:00:00 |  | 141.9691784 |  |  |  | -3.0690413 |  | -139.73718433 |  |  |  | -147.0821648 |  | 70.19854932 |  |  |  | -22.30234379 |  | -436.53790405 |  | -634.46209402 |  | 40.83339659 |  | 2713.31754944 |  |  |  | -728.14698256 |  | -8.25061809 |  | 171.18563121 |  | -493.25849837 |  | -770.78165198
2002-04-01 00:00:00 |  | -29.2526821 |  |  |  | -4.19393332 |  | -14.75876285 |  |  |  | -157.73205185 |  | 17.77672188 |  |  |  | 35.01902651 |  | -516.86636156 |  | -330.16902997 |  | -7.92647025 |  | 513.44430932 |  |  |  | -486.52500245 |  |  |  | 61.67626989 |  | -189.54491556 |  | 170.72158018
2002-05-01 00:00:00 |  | 2.21208601 |  |  |  | -3.70552353 |  | -15.03967181 |  |  |  | -143.22274145 |  | 50.23284656 |  |  |  | 16.06501198 |  | 85.43240294 |  | -152.28421 |  | -7.15893307 |  | 1600.09975717 |  |  |  | -435.8322864 |  |  |  | 8.25545608 |  | 18.86997337 |  | 225.96406295
2002-06-01 00:00:00 |  | -11.74016657 |  |  |  | -3.43361951 |  | -22.27274066 |  |  |  | -146.52344941 |  | 48.9129238 |  |  |  | 17.11856043 |  | 6.37477317 |  | -153.41514599 |  | -4.93720937 |  | 1832.11498752 |  |  |  | -657.56759918 |  |  |  | 10.82603998 |  | 535.08665938 |  | -532.20026299
2002-07-01 00:00:00 |  | -41.58810205 |  |  |  | -3.44069519 |  | -29.53090349 |  |  |  | -152.10065498 |  | 47.11179656 |  |  |  | 7.36681227 |  | -78.24846839 |  | -154.15911721 |  | -2.90932448 |  | 801.55349735 |  |  |  | -645.71714322 |  |  |  | 13.13785401 |  | -0.04072316 |  | 47.87469209
2002-08-01 00:00:00 |  | -34.88990168 |  |  |  | -4.07049678 |  | 29.04357754 |  |  |  | -156.98214827 |  | 45.12042059 |  |  |  | 52.95315201 |  | -86.88681128 |  | -152.86486408 |  | -0.99284407 |  | 740.8055109 |  |  |  | -574.58386607 |  |  |  | 15.62892245 |  | -2.80532155 |  | 450.77008527
2002-09-01 00:00:00 |  | -32.38428278 |  |  |  |  |  | -41.28419068 |  |  |  | -161.73601284 |  | 42.89364258 |  |  |  | 5.9940625 |  | -95.87972717 |  | -147.3947833 |  | -0.13398131 |  | 552.50971755 |  |  |  | -573.04659227 |  |  |  | 17.42172432 |  | -4.61713926 |  | 21.02335304
2002-10-01 00:00:00 |  | -27.28215285 |  |  |  |  |  | -46.45991501 |  |  |  | -165.6935654 |  | 41.27052155 |  |  |  | 5.5926222 |  | -103.96045558 |  | -143.83809536 |  | 1.31238142 |  | 714.86209283 |  |  |  | -579.60217841 |  |  |  | 19.2664351 |  | 99.80357499 |  | 9.04050197
2002-11-01 00:00:00 |  | -256.94692971 |  |  |  |  |  | -88.99241653 |  |  |  | -109.72187442 |  | 31.14796305 |  |  |  | 0.82913053 |  | -2.3667732 |  | -170.01821695 |  |  |  | 667.54541235 |  |  |  | -38.40689304 |  |  |  | 0 |  | 360.33636631 |  | -74.92527098
2002-12-01 00:00:00 |  | -267.25062264 |  |  |  |  |  | -92.22823594 |  |  |  | -109.13953964 |  | 30.25969051 |  |  |  | 3.90215442 |  | -8.99133421 |  | -161.07351108 |  |  |  | 649.87119231 |  |  |  | 347.8695811 |  |  |  | -4.28858638 |  | 471.52067669 |  | -96.48373392
2003-01-01 00:00:00 |  | -324.70194022 |  |  |  |  |  | -70.98168755 |  |  |  | -11.12688039 |  | -9.89337488 |  |  |  | 25.80388387 |  | -147.6441308 |  | -79.22007712 |  |  |  | 572.06945345 |  |  |  | -254.49310543 |  |  |  |  |  | 260.4722755 |  | -93.62274284
2003-02-01 00:00:00 |  | -322.71910016 |  |  |  |  |  | -18.8380395 |  |  |  | -12.30494931 |  | -10.98341096 |  |  |  | 25.6383768 |  | -146.71910775 |  | -70.49473055 |  |  |  | 431.58904883 |  |  |  | -249.29340422 |  |  |  |  |  | 185.03935642 |  | -88.38446271
2003-03-01 00:00:00 |  | -312.61458684 |  |  |  |  |  | -16.26599603 |  |  |  | -13.70856801 |  | -13.37377871 |  |  |  | 21.04654699 |  | -143.61426547 |  | -69.19208008 |  |  |  | 469.3050924 |  |  |  | -190.95077667 |  |  |  |  |  | 200.45851164 |  | -515.37764615
2003-04-01 00:00:00 |  | 64.022169 |  |  |  |  |  | 3.19664987 |  |  |  | -6.45726802 |  | -12.14531722 |  |  |  | 14.39797493 |  | -136.16037796 |  | -59.66781288 |  |  |  | -19.47342318 |  |  |  | -189.03968507 |  |  |  | 2.1478959 |  | -313.14656976 |  | 337.9708894
2003-05-01 00:00:00 |  | 63.26018459 |  |  |  |  |  | 3.46268077 |  |  |  | -7.0292991 |  | -13.26563734 |  |  |  | 14.32440363 |  | -135.85697767 |  | -60.43733598 |  |  |  | -29.70951738 |  |  |  | -153.16837953 |  |  |  | 2.20615627 |  | -292.9546666 |  | -6.26553382
2003-06-01 00:00:00 |  | 63.51765223 |  |  |  |  |  | 2.86816633 |  |  |  | -5.92015979 |  | -10.87736057 |  |  |  | 14.07901306 |  | -134.48530877 |  | -44.19257317 |  |  |  | -13.88206122 |  |  |  | -153.85510405 |  |  |  | 2.20168287 |  | -294.42940984 |  | -2.7400332
2003-07-01 00:00:00 |  | 64.08458624 |  |  |  |  |  | 2.31230858 |  |  |  | -4.51522866 |  | -7.62771491 |  |  |  | 13.80873183 |  | -132.99363012 |  | -47.10224971 |  |  |  | 8.78140567 |  |  |  | -154.88982829 |  |  |  | 2.36099569 |  | -297.01294906 |  | 1.63283857
2003-08-01 00:00:00 |  | 64.68445998 |  |  |  |  |  | 1.55632871 |  |  |  | -2.84699118 |  | -3.91579639 |  |  |  | 13.47871493 |  | -131.29357413 |  | -49.18767221 |  |  |  | 34.33625267 |  |  |  | -156.12327155 |  |  |  | 2.46446486 |  | -300.01770363 |  | 6.84886838
2003-09-01 00:00:00 |  | 65.14407626 |  |  |  |  |  | 1.24969194 |  |  |  | -2.08706201 |  | -2.2970188 |  |  |  | 13.42051946 |  | -130.93905935 |  | -48.09657727 |  |  |  | 48.14556042 |  |  |  | -156.04797708 |  |  |  | 2.39645108 |  | -301.35527287 |  | 8.00251423
2003-10-01 00:00:00 |  | 65.58861052 |  |  |  |  |  | 7.17917545 |  |  |  | -0.89942354 |  | 0.20358338 |  |  |  | 13.21836051 |  | -129.95786757 |  | -66.39332423 |  |  |  | 66.34732442 |  |  |  | -156.59322758 |  |  |  | 2.53413074 |  | -283.54352602 |  | 148.82230364
2003-11-01 00:00:00 |  | -54.59974347 |  |  |  |  |  | -1.77660239 |  |  |  | -65.5181965 |  | 1482.74563805 |  |  |  | 11.77655328 |  | -137.70528469 |  | -73.37227352 |  |  |  | 316.05586716 |  |  |  | -123.712259 |  |  |  |  |  | -318.14619091 |  | -27.49809666
2003-12-01 00:00:00 |  | -52.92130563 |  |  |  |  |  | -3.94392771 |  |  |  | -64.46353307 |  | -6.0414046 |  |  |  | 10.63225094 |  | -136.85971719 |  | -81.19043828 |  |  |  | 208.64229362 |  |  |  | -125.12535161 |  |  |  |  |  | -321.1554679 |  | -17.49761735
2004-01-01 00:00:00 |  | -49.97524081 |  |  |  |  |  | 12.59767152 |  |  |  |  |  |  |  |  |  | 3.46195678 |  |  |  |  |  |  |  | -66.12734165 |  |  |  | 54.59974347 |  |  |  |  |  | 109.19948694 |  | 15.96888161
2004-02-01 00:00:00 |  | -45.71708155 |  |  |  |  |  | 11.0570525 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -67.33509234 |  |  |  | 52.92130563 |  |  |  |  |  | 105.84261125 |  | 14.43019246
2004-03-01 00:00:00 |  | -45.6567957 |  |  |  |  |  | 8.33503344 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -70.41684826 |  |  |  | 49.97524081 |  |  |  |  |  | 99.95048162 |  | 11.79897482
2004-04-01 00:00:00 |  | -46.48483552 |  |  |  |  |  | 4.52807342 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -98.36299287 |  |  |  | -10.15605153 |  |  |  |  |  | 91.4341631 |  | 8.21057056
2004-05-01 00:00:00 |  | -47.41324798 |  |  |  |  |  | 4.63191816 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -97.97861482 |  |  |  | -8.76792854 |  |  |  |  |  | 91.3135914 |  | 8.29102607
2004-06-01 00:00:00 |  | -48.16053008 |  |  |  |  |  | 5.5627866 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -97.92661473 |  |  |  | -6.05077449 |  |  |  |  |  | 92.96967103 |  | 9.15519689
2004-07-01 00:00:00 |  | -48.07297496 |  |  |  |  |  | 6.59984693 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -97.88541778 |  |  |  | -3.0778804 |  |  |  |  |  | 94.82649597 |  | 10.12482072
2004-08-01 00:00:00 |  | -48.09335564 |  |  |  |  |  | 7.45809238 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -97.63873041 |  |  |  | -2.91939978 |  |  |  |  |  | 96.32106016 |  | 10.91151695
2004-09-01 00:00:00 |  | -50.6096518 |  |  |  |  |  | 7.47121707 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -96.6647708 |  |  |  | -3.47496862 |  |  |  |  |  | 96.14594993 |  | 10.85306737
2004-10-01 00:00:00 |  | -52.82487527 |  |  |  |  |  | 7.59973061 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -95.77315742 |  |  |  | -4.40878801 |  |  |  |  |  | 96.18671129 |  | 10.90963034
2004-11-01 00:00:00 |  |  |  |  |  |  |  | 10.26702807 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -97.24175097 |  |  |  | -5.16858256 |  |  |  |  |  | 101.2193036 |  | 13.50357136
2004-12-01 00:00:00 |  |  |  |  |  |  |  | 12.69856896 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -98.87552302 |  |  |  | -5.17791072 |  |  |  |  |  | 105.64975055 |  | 15.87905172
2005-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 64.68316286 |  |  |  | -5.288716 |  |  |  |  |  | -20.12072551
2005-02-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 66.36077617 |  |  |  | -7.7411656 |  |  |  |  |  | -18.75805536
2005-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 66.35095768 |  |  |  | -10.11098039 |  |  |  |  |  | -16.54633854
2005-04-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 68.83349391 |  |  |  |  |  |  |  |  |  | -13.80896774
2005-05-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 67.25103624 |  |  |  |  |  |  |  |  |  | -13.79274439
2005-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 65.22297241 |  |  |  |  |  |  |  |  |  | -14.39204677
2005-07-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 64.49358644 |  |  |  |  |  |  |  |  |  | -15.12059171
2005-08-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 63.94517721 |  |  |  |  |  |  |  |  |  | -15.69842283
2005-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 64.60772641 |  |  |  |  |  |  |  |  |  | -15.5302918
2005-10-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 65.09661893 |  |  |  |  |  |  |  |  |  | -15.46253335
2005-11-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 62.04550477 |  |  |  |  |  |  |  |  |  | -17.68364127
2005-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59.75776116 |  |  |  |  |  |  |  |  |  | -19.70681545
2006-01-01 00:00:00
2006-02-01 00:00:00
2006-03-01 00:00:00
2006-04-01 00:00:00
2006-05-01 00:00:00
2006-06-01 00:00:00
2006-07-01 00:00:00
2006-08-01 00:00:00
2006-09-01 00:00:00
2006-10-01 00:00:00
2006-11-01 00:00:00
2006-12-01 00:00:00
2007-01-01 00:00:00
2007-02-01 00:00:00
2007-03-01 00:00:00
2007-04-01 00:00:00
2007-05-01 00:00:00
2007-06-01 00:00:00
2007-07-01 00:00:00
2007-08-01 00:00:00
2007-09-01 00:00:00
2007-10-01 00:00:00
2007-11-01 00:00:00
2007-12-01 00:00:00
2008-01-01 00:00:00
2008-02-01 00:00:00
2008-03-01 00:00:00
2008-04-01 00:00:00
2008-05-01 00:00:00
2008-06-01 00:00:00
2008-07-01 00:00:00
2008-08-01 00:00:00
2008-09-01 00:00:00
2008-10-01 00:00:00
2008-11-01 00:00:00
2008-12-01 00:00:00
2009-01-01 00:00:00
2009-02-01 00:00:00
2009-03-01 00:00:00
2009-04-01 00:00:00
2009-05-01 00:00:00
2009-06-01 00:00:00
2009-07-01 00:00:00
2009-08-01 00:00:00
2009-09-01 00:00:00
2009-10-01 00:00:00
2009-11-01 00:00:00
2009-12-01 00:00:00
2010-01-01 00:00:00
2010-02-01 00:00:00
2010-03-01 00:00:00
2010-04-01 00:00:00
2010-05-01 00:00:00
2010-06-01 00:00:00
2010-07-01 00:00:00
2010-08-01 00:00:00
2010-09-01 00:00:00
2010-10-01 00:00:00
2010-11-01 00:00:00
2010-12-01 00:00:00
2011-01-01 00:00:00
2011-02-01 00:00:00
2011-03-01 00:00:00
2011-04-01 00:00:00
2011-05-01 00:00:00
2011-06-01 00:00:00
2011-07-01 00:00:00
2011-08-01 00:00:00
2011-09-01 00:00:00
2011-10-01 00:00:00
2011-11-01 00:00:00
2011-12-01 00:00:00
2012-01-01 00:00:00
2012-02-01 00:00:00
2012-03-01 00:00:00
2012-04-01 00:00:00
2012-05-01 00:00:00
2012-06-01 00:00:00
2012-07-01 00:00:00
2012-08-01 00:00:00
2012-09-01 00:00:00
2012-10-01 00:00:00
2012-11-01 00:00:00
2012-12-01 00:00:00
2013-01-01 00:00:00
2013-02-01 00:00:00
2013-03-01 00:00:00
2013-04-01 00:00:00
2013-05-01 00:00:00
2013-06-01 00:00:00
2013-07-01 00:00:00
2013-08-01 00:00:00
2013-09-01 00:00:00
2013-10-01 00:00:00
2013-11-01 00:00:00
2013-12-01 00:00:00