Spreadsheet: sally_beck__35801__Summary Report for EOL 2-29
Sheet: RAW DATA (DATABASE)

USE LONDON? | YES | 2000-02-29 00:00:00
 | COMMODITY | COMMODITY-TYPE | EOL FLAG | SumOfLTDDEAL | SumOfLTDVOLBUY | [NAME] | SumOfLTDAMTBUY | SumOfLTDAMTSELL | SumOfMTDDEAL | SumOfMTDVOLBUY | SumOfMTDVOLSELL | SumOfMTDAMTBUY | SumOfMTDAMTSELL | SumOfONEDEAL | SumOfONEVOLBUY | SumOfONEVOLSELL | SumOfONEAMTBUY | [NAME] | SumOfYTDDEAL | SumOfYTDVOLBUY | SumOfYTDVOLSELL | SumOfYTDAMTBUY | SumOfYTDAMTSELL
 |  | COAL-PHYSICAL | Yes | 85 | 1543500 | 1679250 | 14411857.5 | 15355575 | 26 | 505500 | 805500 | 3863156.25 | 5017912.5 | 3 | 150000 | 75000 | 676500 | 324750 | 64 | 1263000 | 1329000 | 11506432.5 | 10724625
 |  | COAL-PHYSICAL | No | 171 | 3291699.1 | 8026334 | 46399375.55 | 90364925.54 | 89 | 1613200 | 3233025 | 26650902.5 | 42960079.68 | 2 | 193000 | 0 | 2667350 | 0 | 142 | 2932699 | 4381118 | 41577373.1 | 69869039.96
 |  | CONTINENTAL GAS-FINANCIAL | No | 71 | 16235904.9 | 0 | 138022.17 | 0 | 36 | 13399475.8 | 0 | 0 | 0 | 1 | 100000 | 0 | 0 | 0 | 71 | 16235904.8976 | 0 | 138022.174548828 | 0
 |  | CONTINENTAL GAS-PHYSICAL | Yes | 83 | 8950000 | 7690000 | 32669404.16 | 0 | 32 | 1825000 | 3517500 | 11067819.77 | 0 | 1 | 0 | 75000 | 151562.99 | 0 | 83 | 8950000 | 7690000 | 32669404.1605555 | 0
 |  | CONTINENTAL GAS-PHYSICAL | No | 381 | 49425596.88 | 30306423.85 | 126263215.06 | 0 | 168 | 27855351.79 | 21908961.83 | 67485886.62 | 0 | 7 | 950000 | 307536.2 | 2830675.65 | 0 | 381 | 49425596.877 | 30306423.85438 | 126263215.061719 | 0
 |  | CONTINENTAL POWER-FINANCIAL | Yes | 31 | 16550 | 60660 | 1748104.51 | 0 | 26 | 16550 | 47660 | 1419920.76 | 0 | 3 | 0 | 5900 | 113349.53 | 0 | 31 | 16550 | 60660 | 1748104.50781394 | 0
 |  | CONTINENTAL POWER-FINANCIAL | No | 79 | 482326 | 496680 | 36124287.34 | 20656450 | 41 | 45560 | 153160 | 4750902.38 | 0 | 2 | 6900 | 0 | 167042.19 | 0 | 79 | 482326 | 496680 | 36124287.3398411 | 20656450
 |  | CONTINENTAL POWER-PHYSICAL | Yes | 211 | 824823 | 812520 | 29948581.4 | 181296 | 186 | 772643 | 780180 | 28173308.1 | 0 | 25 | 45420 | 51180 | 1585168.74 | 0 | 211 | 824823 | 812520 | 29948581.395222 | 181296
 |  | CONTINENTAL POWER-PHYSICAL | No | 2947 | 17885789.2 | 2650435.5 | 367667155.05 | 11835439.01 | 1545 | 15476416.2 | 1061287.9 | 281343816.55 | 0 | 71 | 27253.9 | 24476.4 | 876846.78 | 0 | 2947 | 17885789.2 | 2650435.5 | 367667155.048072 | 11835439.008
 |  | CRUDE & PRODUCTS-BASIS | Yes | 14 | 539999.99 | 1170000 | 9539342.65 | 20632566.8 |  |  |  |  |  |  |  |  |  |  | 14 | 539999.9949 | 1169999.9961 | 9539342.647254 | 20632566.797892
 |  | CRUDE & PRODUCTS-BASIS | No | 29 | 1991499.99 | 1041000.01 | 38949983.18 | 17572954.38 |  |  |  |  |  |  |  |  |  |  | 29 | 1991499.9947 | 1041000.0081 | 38949983.181638 | 17572954.376145
 |  | CRUDE & PRODUCTS-PHYSICAL | Yes |  | 1146000 | 4008000 | 4569600 | 15018090 |  | 217000 | 1654000 | 867070 | 6547570 |  |  |  |  |  |  | 1146000 | 4008000 | 4569600 | 15018090
 |  | CRUDE & PRODUCTS-PHYSICAL | No | 853 | 35017638.35 | 37114127.66 | 1005822885.77 | 2046868515.01 | 470 | 19126285.03 | 22277901.02 | 611212912.56 | 1458445425.04 | 16 | 370016.01 | 1309008 | 28031915.57 | 170326076.2 | 853 | 35017638.353 | 37114127.6619 | 1005822885.77013 | 2046868515.01232
 |  | CRUDE & PRODUCTS-PRICE | Yes | 171 | 9030999.99 | 11228749.97 | 206997028.89 | 236826740.27 | 67 | 3996000 | 4203749.99 | 90710963.36 | 110784030.4 | 4 | 180000 | 420000 | 3367909.12 | 8721286.36 | 171 | 9030999.9855 | 11228749.9743 | 206997028.886328 | 236826740.266214
 |  | CRUDE & PRODUCTS-PRICE | No | 6892 | 246939765.47 | 229676873.36 | 8477106906.13 | 7579107781.14 | 3965 | 133797455.09 | 129583511.07 | 4900879336.34 | 4666195127.34 | 261 | 10220350 | 8714849.99 | 464218734.69 | 272556602.91 | 6892 | 246939765.4661 | 229676873.3581 | 8477106906.12671 | 7579107781.14363
 |  | EMISSIONS-FINANCIAL | No | 1 | 0 | 0 | 0 | 83102 | 1 | 0 | 0 | 0 | 83102 |  |  |  |  |  | 1 | 0 | 0 | 0 | 83102
 |  | EMISSIONS-PHYSICAL | Yes | 58 | 72500 | 72500 | 18611125 | 0 | 17 | 10000 | 32500 | 5577350 | 0 |  |  |  |  |  | 58 | 72500 | 72500 | 18611125 | 0
 |  | EMISSIONS-PHYSICAL | No | 303 | 464563 | 535321 | 129868960.25 | 0 | 76 | 96139 | 125767 | 29546615.75 | 0 | 7 | 10000 | 12500 | 2962500 | 0 | 303 | 464563 | 535321 | 129868960.25 | 0
 |  | GAS-BASIS | Yes | 3242 | 1122555000 | 1183205000 | 2904754552.56 | 3090247935.23 | 1554 | 622420000 | 644980000 | 1611067835.06 | 1729500985.06 | 66 | 16040000 | 35635000 | 50484400 | 113750900 | 2585 | 917465000 | 987640000 | 2392097227.562 | 2608975097.5775
 |  | GAS-BASIS | No | 3877 | 1703761202.75 | 1724447637 | 4334223495.38 | 4354549424.03 | 1185 | 547674508 | 528439856 | 1454179297.26 | 1424724091.13 | 36 | 34871500 | 24585000 | 111832667.5 | 77982370 | 2397 | 1025430740 | 1088428402 | 2749620875.28232 | 2868690008.48674
 |  | GAS-GAS DAILY | Yes | 3497 | 357058599.1 | 309385613.64 | 904873700.79 | 784158157.14 | 1860 | 201485113.35 | 184781699.35 | 526623633.66 | 485415147.24 | 132 | 17640000 | 13370000 | 47204200 | 35470550 | 2859 | 303848599.100821 | 265665613.640711 | 777863525.787977 | 681537013.387619
 |  | GAS-GAS DAILY | No | 2525 | 392612761.95 | 362522863.86 | 981453186.5 | 920091188.83 | 563 | 66849089.18 | 87645083.86 | 178813940.49 | 237093948.6 | 23 | 2620000 | 3421049 | 6945050 | 9091892.38 | 1434 | 233313329.954084 | 235247863.857471 | 606508771.105691 | 620727670.737823
 |  | GAS-PHYSICAL | Yes | 17950 | 492698294.28 | 564944289.54 | 1276171733.84 | 1499406529.56 | 9230 | 244633507.66 | 324395458.33 | 673421545.87 | 898979345.74 | 547 | 12120420.39 | 25567651.2 | 38906550.16 | 82074006.12 | 14815 | 387598504.361074 | 480107024.630094 | 1028271575.28164 | 1299644959.76977
 |  | GAS-PHYSICAL | No | 22531 | 1584089323.33 | 1287551904.81 | 4009174285.15 | 3235495079.64 | 7820 | 735094830.08 | 666073518.87 | 1927360877.59 | 1730076434.03 | 386 | 28684199.57 | 17491395.38 | 91931730.75 | 56154886.01 | 15270 | 1256805567.31345 | 980997870.411549 | 3249206107.6669 | 2526138772.3943
 |  | GAS-PRICE | Yes |  | 1099321881.12 | 1021043410.69 | 2731233679.31 | 2540613144.67 |  | 592526062.35 | 543205599.57 | 1510715082.55 | 1402902190.38 | 153 | 28932117.84 | 30818764.79 | 77496938.59 | 84407724.14 |  | 1004545297.8749 | 907765167.5933 | 2510882953.82063 | 2283163675.28782
 |  | GAS-PRICE | No | 10698 | 5493665311.4 | 5812393843.99 | 13981675932.44 | 14799181660.99 | 3305 | 1756698140.9 | 2003121121.14 | 4658650426.65 | 5195937433.1 | 181 | 65551950 | 85798410.07 | 202603649 | 232550634.94 | 6603 | 3351564042.30599 | 3777189568.27866 | 8574558095.60393 | 9805587549.32928
 |  | LPG-FINANCIAL | Yes | 2 | 11000 | 29 | 351900 | 5103.06 |  |  |  |  |  |  |  |  |  |  | 2 | 11000 | 29 | 351900 | 5103.06
 |  | LPG-PHYSICAL | No | 266 | 3820344.02 | 3710863 | 232081809.25 | 217916860.24 | 139 | 2027344.02 | 2589463 | 107297089.06 | 107629641.97 | 14 | 25000 | 364000 | 522375.52 | 8550788.55 | 266 | 3820344.016 | 3710863 | 232081809.249977 | 217916860.242082
 |  | LPG-PRICE | Yes | 165 | 672000 | 1184000 | 188948508.99 | 318073817.97 | 145 | 640000 | 952000 | 179652508.99 | 259481817.97 | 7 | 8000 | 48000 | 2400000 | 13960000 | 165 | 671999.9992 | 1183999.9984 | 188948508.9888 | 318073817.9728
 |  | LPG-PRICE | No | 462 | 5468500 | 6592881.37 | 697655711.78 | 799453315.63 | 301 | 3103000 | 4452928.99 | 411930329.52 | 509944761.64 | 13 | 98000 | 133000 | 15009525.85 | 4313252.11 | 462 | 5468499.9984 | 6592881.3654 | 697655711.78415 | 799453315.627575
 |  | NATURAL GAS-FINANCIAL | Yes | 2 | 5000 | 5017 | 12662.5 | 14847.33 |  |  |  |  |  |  |  |  |  |  | 2 | 5000 | 5017 | 12662.5 | 14847.3275
 |  | NATURAL GAS-PHYSICAL | Yes | 5 | 30000 | 46 | 29225 | 51.75 |  |  |  |  |  |  |  |  |  |  | 5 | 30000 | 46 | 29225 | 51.7475
 |  | NORDIC POWER-FINANCIAL | Yes | 98 | 915502 | 849478 | 13345560.37 | 11892602.17 | 66 | 556177 | 622193 | 7795303.91 | 8738034.94 | 1 | 11045 | 0 | 169016.82 | 0 | 94 | 867737 | 834963 | 12637443.8205756 | 11648421.0343945
 |  | NORDIC POWER-FINANCIAL | No | 1910 | 25661448.01 | 18981810.17 | 351775239.61 | 258828852.96 | 723 | 9742375.01 | 7836443.74 | 124473077.4 | 89510825.11 | 27 | 292800 | 659463 | 3367299.26 | 6894073.52 | 1558 | 22421728.01 | 14160032.17 | 299491285.661822 | 178184981.686228
 |  | NORDIC POWER-PHYSICAL | No | 196 | 77145.2 | 905270.04 | 1052379.72 | 16978037.51 | 60 | 85 | 94476.55 | 3726.39 | 1394248.58 |  |  |  |  |  | 163 | 76746.2 | 788729.27 | 1042628.95476978 | 14852956.4244664
 |  | PAPER & PULP-PHYSICAL | No | 99 | 20516 | 11233 | 5195858 | 4953375 | 31 | 3880 | 3930 | 2179820 | 2182570 |  |  |  |  |  | 81 | 10480 | 10857 | 4773350.00006 | 4917819.00006
 |  | PAPER & PULP-PRICE | Yes | 4 | 750 | 1800 | 393750 | 1107000 |  |  |  |  |  |  |  |  |  |  | 1 | 750 | 0 | 393750 | 0
 |  | PAPER & PULP-PRICE | No | 111 | 589920 | 326564.04 | 102852504 | 144498566.76 | 91 | 349920 | 67464 | 39432504 | 19795920 | 6 | 1176 | 1896 | 918456 | 1435656 | 107 | 481920 | 321564 | 96192504 | 144264404.311925
 |  | PETROCHEMICALS-PHYSICAL | Yes | 40 | 194000 | 262083 | 33235105.09 | 57298355.6 | 25 | 55000 | 142054 | 11931201.73 | 36314049.28 |  |  |  |  |  | 40 | 194000 | 262083 | 33235105.0862 | 57298355.5973
 |  | PETROCHEMICALS-PHYSICAL | No | 161 | 964542.1 | 826426.74 | 297845212.63 | 305261257.28 | 90 | 533200.02 | 429782.58 | 147588973.78 | 157976372.92 | 3 | 800 | 16000 | 713865.09 | 10256000 | 161 | 964542.104 | 826426.744 | 297845212.627648 | 305261257.27604
 |  | PETROCHEMICALS-PRICE | No | 28 | 792000 | 1104000 | 184202000 | 245596000 | 15 | 592000 | 424000 | 139112000 | 100616000 | 1 | 40000 | 0 | 10930000 | 0 | 28 | 792000 | 1104000 | 184202000 | 245596000
 |  | PLASTICS-PRICE | Yes | 1 | 0 | 1500000 | 0 | 427500 | 1 | 0 | 1500000 | 0 | 427500 |  |  |  |  |  | 1 | 0 | 1500000 | 0 | 427500
 |  | PLASTICS-PRICE | No | 40 | 1943600 | 25895000 | 28038923.54 | 38172699.64 | 2 | 0 | 24300000 | 0 | 13536000 |  |  |  |  |  | 2 | 0 | 24300000 | 0 | 13536000
 |  | POWER-PHYSICAL | Yes |  | 11265740 | 13753544 | 899153656 | 0 | 1744 | 6828840 | 8905744 | 601441904 | 0 | 96 | 180000 | 528320 | 28073960 | 0 |  | 10533340 | 12856344 | 851261780 | 0
 |  | POWER-PHYSICAL | No | 20390 | 131112668.74 | 114876858.38 | 8049609568.15 | 0 | 8456 | 53370316.24 | 43155494.72 | 3672582637.26 | 0 | 418 | 3341470.27 | 2365771.27 | 199800812.4 | 0 | 16938 | 93498104.21 | 83119062.96 | 6141171073.638 | 0
 |  | UK GAS- | Yes | 1 | 0 | 5000 | 11157.83 | 0 | 1 | 0 | 5000 | 11157.83 | 0 |  |  |  |  |  | 1 | 0 | 5000 | 11157.8266494179 | 0
 |  | UK GAS-FINANCIAL | Yes | 106 | 20757500 | 5252500 | 47928856.65 | 0 | 56 | 9825000 | 4340000 | 26961188.67 | 0 | 6 | 677500 | 1145000 | 3499763.18 | 0 | 106 | 20757500 | 5252500 | 47928856.6519058 | 0
 |  | UK GAS-FINANCIAL | No | 155 | 28237529.92 | 36292026 | 133735854.89 | 0 | 103 | 18619350.5 | 32908731 | 115018508.56 | 0 | 6 | 9401595.13 | 20225122 | 71260397.93 | 0 | 155 | 28237529.91654 | 36292026 | 133735854.891169 | 0
 |  | UK GAS-PHYSICAL | Yes | 1872 | 100295000 | 144294000 | 489423638.19 | 0 | 992 | 70502500 | 94342500 | 333097266.98 | 0 | 112 | 11802500 | 10322500 | 43887314.49 | 0 | 1872 | 100295000 | 144294000 | 489423638.188598 | 0
 |  | UK GAS-PHYSICAL | No | 1859 | 225607084.25 | 450959596 | 1185601499.15 | 0 | 990 | 157134289.81 | 279692047.72 | 782095409.27 | 0 | 57 | 10732599.75 | 2823319.7 | 27403314.82 | 0 | 1859 | 225607084.254099 | 450959596.004509 | 1185601499.15071 | 0
 |  | UK POWER-FINANCIAL | Yes | 178 | 6066783.9 | 2237378.3 | 270639511 | 49931720.63 | 100 | 4234423.9 | 1108278.3 | 158190969.12 | 44782071.04 |  |  |  |  |  | 178 | 6066783.9 | 2237378.3 | 270639510.998404 | 49931720.6255126
 |  | UK POWER-FINANCIAL | No | 616 | 14057120.52 | 22676333.81 | 870763970.67 | 551568015.35 | 297 | 8205507.58 | 12853240.23 | 313772184.76 | 496881680.89 | 11 | 268960 | 105260 | 9792282.92 | 3875194.51 | 616 | 14057120.5178 | 22676333.8057284 | 870763970.666352 | 551568015.346141
 |  | WEATHER-FINANCIAL | Yes | 95 | 46 | 235 |  | 0 | 60 | 29 | 217 |  | 0 | 1 | 0 | 187 |  | 0 | 95 | 46 | 235 |  | 0
 |  | WEATHER-FINANCIAL | No | 65 | 219 | 209 |  | 0 | 43 | 205 | 201 |  | 0 | 2 | 183 | 182 |  | 0 | 65 | 219 | 209 |  | 0