Spreadsheet: kevin_presto__20057__EOL_Prices(Markets)_v1
Sheet: Data

Product ID | Bid price | Offer Price | Last Trade | TimeStamp | Actual time stamp | Enter number of products in H1 | 225 |  | Mid | Time |  | Hurdle
29082 |  |  |  | 1006869473925 |  |  | Nepool | Daily
29088 |  |  | 1001943167670 | #[NAME]! |  |  | PJM | Daily
30594 |  |  |  | 1006869616565 |  |  | NY A | Daily
32198 |  |  |  | 1006779586447 |  |  | NY G | Daily
29069 | 18.35 | 18.6 |  | 1006870204867 | 2001-11-27 08:10:04 |  | Cinergy | Daily
29062 |  |  |  | 1006778376932 |  |  | Comed | Daily
29094 | 17.75 | 18 |  | 1006870146878 | 2001-11-27 08:09:06 |  | TVA | Daily
52661 |  |  |  | 1006782965910 |  |  | SOCO | Daily
29075 |  |  |  | 1006783056420 |  |  | Entergy | Daily
56295 |  |  |  | 1006786242928 |  |  | ERCOT | Daily
32227 |  |  |  |  |  |  | NY J | Daily
29078 |  |  |  | 1006358089326 |  |  | Nepool | Bal Week
29085 |  |  |  | 1006805603324 |  |  | PJM | Bal Week
30598 |  |  |  | 1006802581843 |  |  | NY A | Bal Week
32203 |  |  |  | 1006802577489 |  |  | NY G | Bal Week
29066 |  |  |  | 1006797391930 |  |  | Cinergy | Bal Week
29064 |  |  |  | 1006788550048 |  |  | Comed | Bal Week
29091 |  |  |  | 1006786458484 |  |  | TVA | Bal Week
52076 |  |  |  | 1006180526306 |  |  | SOCO | Bal Week
29072 |  |  |  | 1006792271145 |  |  | Entergy | Bal Week
56291 |  |  |  | 1006806145363 |  |  | ERCOT | Bal Week
32232 |  |  |  | 1006802567200 |  |  | NY J | Bal Week
61779 |  |  |  | 1004963727965 |  |  | Nepool | Bal Month
61599 |  |  |  | 1004972254421 |  |  | PJM | Bal Month
61609 |  |  |  | 1004972449055 |  |  | NY A | Bal Month
61611 |  |  |  | 1006346100264 |  |  | NY G | Bal Month
61587 |  |  |  | 1004973127347 |  |  | Cinergy | Bal Month
61591 |  |  |  | 1004971613912 |  |  | Comed | Bal Month
61791 |  |  |  | 1006262335248 |  |  | TVA | Bal Month
61589 |  |  |  | 1004011021542 |  |  | SOCO | Bal Month
61593 |  |  |  | 1006262704421 |  |  | Entergy | Bal Month
61613 |  |  |  | 1004100873381 |  |  | ERCOT | Bal Month
32233 |  |  |  |  |  |  | NY J | Bal Month
40927 |  |  |  | 1006801861245 |  |  | Entergy | Dec
33296 |  |  |  | 1006802882646 |  | Cal02 | Entergy | Jan Feb |  |  |  | 672
43346 |  |  |  | 1006801862364 |  |  | Entergy | Mar April |  |  |  | 688
48490 |  |  |  | 1006801862839 |  |  | Entergy | May |  |  |  | 352
48492 |  |  |  | 1006801863313 |  |  | Entergy | Jun |  |  |  | 320
31711 |  |  |  | 1006801863872 |  |  | Entergy | [NAME] |  |  |  | 704
48494 |  |  |  | 1006801864392 |  |  | Entergy | Sep |  |  |  | 320
48496 |  |  |  | 1006801864867 |  |  | Entergy | Q4 |  |  |  | 1024
33297 |  |  |  | 1006801865321 |  | Cal 03 | Entergy | Jan Feb |  |  |  | 672
55292 |  |  |  | 1006801865804 |  |  | Entergy | Mar April |  |  |  | 688
55294 |  |  |  | 1006801866268 |  |  | Entergy | May |  |  |  | 336
55296 |  |  |  | 1006801866769 |  |  | Entergy | Jun |  |  |  | 336
31762 |  |  |  | 1006801867203 |  |  | Entergy | [NAME] |  |  |  | 688
55298 |  |  |  | 1006801867668 |  |  | Entergy | Sep |  |  |  | 336
55300 |  |  |  | 1006801868206 |  |  | Entergy | Q4 |  |  |  | 1024
50514 |  |  |  | 1006801868730 |  | Cal 04 | Entergy
50516 |  |  |  | 1006801869211 |  | Cal 05 | Entergy
36470 | 34.6 | 34.9 |  | 1006870394599 | 2001-11-27 08:13:15 |  | Nepool | Dec
33302 | 42.25 | 42.5 |  | 1006870468270 | 2001-11-27 08:14:28 | Cal02 | Nepool | Jan Feb |  |  |  | 672
48660 | 36.35 | 36.85 |  | 1006870465413 | 2001-11-27 08:14:25 |  | Nepool | Mar April |  |  |  | 688
48662 | 37.6 | 38.1 |  | 1006870476206 | 2001-11-27 08:14:36 |  | Nepool | May |  |  |  | 352
48664 | 42.85 | 43.35 |  | 1006870482607 | 2001-11-27 08:14:42 |  | Nepool | Jun |  |  |  | 320
33303 | 53.25 | 54.05 |  | 1006870477921 | 2001-11-27 08:14:38 |  | Nepool | [NAME] |  |  |  | 704
48666 | 36.3 | 36.8 |  | 1006870478537 | 2001-11-27 08:14:39 |  | Nepool | Sep |  |  |  | 320
48668 | 36.3 | 36.8 |  | 1006870479358 | 2001-11-27 08:14:39 |  | Nepool | Q4 |  |  |  | 1024
33304 |  |  |  | 1006804345780 |  | Cal 03 | Nepool | Jan Feb |  |  |  | 672
52923 |  |  |  | 1006804346225 |  |  | Nepool | Mar April |  |  |  | 688
52929 |  |  |  | 1006804346636 |  |  | Nepool | May |  |  |  | 336
52937 |  |  |  | 1006804347090 |  |  | Nepool | Jun |  |  |  | 336
33306 |  |  |  | 1006804347544 |  |  | Nepool | [NAME] |  |  |  | 688
52933 |  |  |  | 1006804347971 |  |  | Nepool | Sep |  |  |  | 336
52935 |  |  |  | 1006804348337 |  |  | Nepool | Q4 |  |  |  | 1024
54532 | 25.95 | 26.2 |  | 1006870402160 | 2001-11-27 08:13:23 |  | PJM W | Dec
33032 | 29.75 | 30.1 |  | 1006870387873 | 2001-11-27 08:13:08 | Cal02 | PJM W | Jan Feb |  |  |  | 672
48656 | 28.1 | 28.6 |  | 1006870399182 | 2001-11-27 08:13:20 |  | PJM W | Mar April |  |  |  | 688
48050 | 30.95 | 31.45 |  | 1006870506229 | 2001-11-27 08:15:06 |  | PJM W | May |  |  |  | 352
45311 | 40.75 | 41.25 |  | 1006870508512 | 2001-11-27 08:15:08 |  | PJM W | Jun |  |  |  | 320
33033 | 52.7 | 53.3 |  | 1006870436530 | 2001-11-27 08:13:56 |  | PJM W | [NAME] |  |  |  | 704
48658 | 27.75 | 28.15 |  | 1006870438475 | 2001-11-27 08:13:58 |  | PJM W | Sep |  |  |  | 320
45219 | 27.75 | 28.15 |  | 1006870440497 | 2001-11-27 08:14:00 |  | PJM W | Q4 |  |  |  | 1024
33309 | 32.85 | 33.35 |  | 1006870442255 | 2001-11-27 08:14:02 | Cal 03 | PJM W | Jan Feb |  |  |  | 672
55274 |  |  |  | 1006792297990 |  |  | PJM W | Mar April |  |  |  | 688
55276 | 32.05 | 32.65 |  | 1006870444090 | 2001-11-27 08:14:04 |  | PJM W | May |  |  |  | 336
53431 | 42.05 | 42.65 |  | 1006870445833 | 2001-11-27 08:14:06 |  | PJM W | Jun |  |  |  | 336
33034 | 51 | 52 |  | 1006870448507 | 2001-11-27 08:14:08 |  | PJM W | [NAME] |  |  |  | 688
55278 | 30.5 | 31.1 |  | 1006870451896 | 2001-11-27 08:14:12 |  | PJM W | Sep |  |  |  | 336
55280 | 30.4 | 31 |  | 1006870453657 | 2001-11-27 08:14:14 |  | PJM W | Q4 |  |  |  | 1024
40881 | 23.1 | 23.3 |  | 1006870277059 | 2001-11-27 08:11:17 |  | Cinergy | Dec
33288 | 26 | 26.2 |  | 1006870334901 | 2001-11-27 08:12:16 | Cal02 | Cinergy | Jan Feb |  |  |  | 672
48648 |  |  |  | 1006793506948 |  |  | Cinergy | Mar April |  |  |  | 688
48506 |  |  |  | 1006793376680 |  |  | Cinergy | May |  |  |  | 352
26116 |  |  |  | 1006793377144 |  |  | Cinergy | Jun |  |  |  | 320
26117 |  |  |  | 1006793528533 |  |  | Cinergy | [NAME] |  |  |  | 704
48508 |  |  |  | 1006793535172 |  |  | Cinergy | Sep |  |  |  | 320
48510 |  |  |  | 1006793540104 |  |  | Cinergy | Q4 |  |  |  | 1024
33289 | 27.45 | 27.9 |  | 1006870335119 | 2001-11-27 08:12:15 | Cal 03 | Cinergy | Jan Feb |  |  |  | 672
55262 |  |  |  | 1006793507047 |  |  | Cinergy | Mar April |  |  |  | 688
55264 |  |  |  | 1006793376801 |  |  | Cinergy | May |  |  |  | 336
26118 |  |  |  | 1006793377392 |  |  | Cinergy | Jun |  |  |  | 336
26119 |  |  |  | 1006793528763 |  |  | Cinergy | [NAME] |  |  |  | 688
55270 |  |  |  | 1006793535279 |  |  | Cinergy | Sep |  |  |  | 336
55272 |  |  |  | 1006793540200 |  |  | Cinergy | Q4 |  |  |  | 1024
61949 | 21.5 | 22 |  | 1006870302541 | 2001-11-27 08:11:42 |  | Comed | Dec
33279 | 23.85 | 24.15 |  | 1006870335107 | 2001-11-27 08:12:16 | Cal02 | Comed | Jan Feb |  |  |  | 672
53061 |  |  |  | 1006778474010 |  |  | Comed | Mar April |  |  |  | 688
53063 |  |  |  | 1006778474384 |  |  | Comed | May |  |  |  | 352
53065 |  |  |  | 1006778474732 |  |  | Comed | Jun |  |  |  | 320
53067 |  |  |  | 1006778514358 |  |  | Comed | [NAME] |  |  |  | 704
53069 |  |  |  | 1006778780123 |  |  | Comed | Sep |  |  |  | 320
53071 |  |  |  | 1006778774796 |  |  | Comed | Q4 |  |  |  | 1024
55324 |  |  |  | 1006778476150 |  | Cal 03 | Comed | Jan Feb |  |  |  | 672
55326 |  |  |  | 1006778476884 |  |  | Comed | Mar April |  |  |  | 688
55328 |  |  |  | 1006778477248 |  |  | Comed | May |  |  |  | 336
55330 |  |  |  | 1006778477603 |  |  | Comed | Jun |  |  |  | 336
55334 |  |  |  | 1006778477956 |  |  | Comed | [NAME] |  |  |  | 688
55338 |  |  |  | 1006778478306 |  |  | Comed | Sep |  |  |  | 336
55340 |  |  |  | 1006778478666 |  |  | Comed | Q4 |  |  |  | 1024
36494 | 21.75 | 22.15 |  | 1006870317216 | 2001-11-27 08:11:57 |  | TVA | Dec
33314 | 25.4 | 25.9 |  | 1006870335131 | 2001-11-27 08:12:15 | Cal02 | TVA | Jan Feb |  |  |  | 672
57314 |  |  |  | 1006787229076 |  |  | TVA | Mar April |  |  |  | 688
57316 |  |  |  | 1006787256503 |  |  | TVA | May |  |  |  | 352
57312 |  |  |  | 1006787256893 |  |  | TVA | Jun |  |  |  | 320
57310 |  |  |  | 1006787257263 |  |  | TVA | [NAME] |  |  |  | 704
57320 |  |  |  | 1006787257664 |  |  | TVA | Sep |  |  |  | 320
57318 |  |  |  | 1006787258035 |  |  | TVA | Q4 |  |  |  | 1024
58358 |  |  |  | 1006787258392 |  | Cal 03 | TVA | Jan Feb |  |  |  | 672
58364 |  |  |  | 1006787259115 |  |  | TVA | Mar April |  |  |  | 688
58366 |  |  |  | 1006787259473 |  |  | TVA | May |  |  |  | 336
58362 |  |  |  | 1006787259832 |  |  | TVA | Jun |  |  |  | 336
58360 |  |  |  | 1006787260195 |  |  | TVA | [NAME] |  |  |  | 688
58370 |  |  |  | 1006787260558 |  |  | TVA | Sep |  |  |  | 336
58368 |  |  |  | 1006787261009 |  |  | TVA | Q4 |  |  |  | 1024
56327 | 22.25 | 22.75 |  | 1006870448556 | 2001-11-27 08:14:09 |  | ERCOT | Dec
56337 | 24.3 | 24.7 |  | 1006870449076 | 2001-11-27 08:14:09 | Cal02 | ERCOT | Jan Feb |  |  |  | 672
56345 | 24.1 | 24.6 |  | 1006870449668 | 2001-11-27 08:14:10 |  | ERCOT | Mar April |  |  |  | 688
56347 | 26.25 | 26.75 |  | 1006870450056 | 2001-11-27 08:14:10 |  | ERCOT | May |  |  |  | 352
56343 | 29.9 | 30.4 |  | 1006870450521 | 2001-11-27 08:14:10 |  | ERCOT | Jun |  |  |  | 320
56339 | 37.8 | 38.3 |  | 1006870451102 | 2001-11-27 08:14:11 |  | ERCOT | [NAME] |  |  |  | 704
56355 | 26.95 | 27.45 |  | 1006870451525 | 2001-11-27 08:14:12 |  | ERCOT | Sep |  |  |  | 320
56353 | 26.05 | 26.55 |  | 1006870451961 | 2001-11-27 08:14:12 |  | ERCOT | Q4 |  |  |  | 1024
62221 | 28.05 | 28.55 |  | 1006870452377 | 2001-11-27 08:14:13 | Cal 03 | ERCOT | Jan Feb |  |  |  | 672
62223 | 26.5 | 27 |  | 1006870453194 | 2001-11-27 08:14:13 |  | ERCOT | Mar April |  |  |  | 688
62225 | 29.25 | 29.75 |  | 1006870453659 | 2001-11-27 08:14:14 |  | ERCOT | May |  |  |  | 336
62227 | 32.8 | 33.3 |  | 1006870454081 | 2001-11-27 08:14:15 |  | ERCOT | Jun |  |  |  | 336
56341 | 41.6 | 42.1 |  | 1006870454575 | 2001-11-27 08:14:16 |  | ERCOT | [NAME] |  |  |  | 688
62229 | 30 | 30.5 |  | 1006870455047 | 2001-11-27 08:14:18 |  | ERCOT | Sep |  |  |  | 336
62231 | 28.3 | 28.8 |  | 1006870455532 | 2001-11-27 08:14:18 |  | ERCOT | Q4 |  |  |  | 1024
58992 | 30.95 | 31.95 |  | 1006870456049 | 2001-11-27 08:14:19 | Cal 04 | ERCOT
58994 | 31.65 | 32.65 |  | 1006870456560 | 2001-11-27 08:14:19 | Cal 05 | ERCOT
56802 |  |  |  | 1006790461372 |  |  | SOCO | Dec
51062 |  |  |  | 1006803439902 |  | Cal02 | SOCO | Jan Feb |  |  |  | 672
51068 |  |  |  | 1006803440298 |  |  | SOCO | Mar April |  |  |  | 688
51074 |  |  |  | 1006803440756 |  |  | SOCO | May |  |  |  | 352
51078 |  |  |  | 1006803441211 |  |  | SOCO | Jun |  |  |  | 320
51084 |  |  |  | 1006803441837 |  |  | SOCO | [NAME] |  |  |  | 704
51100 |  |  |  | 1006803442311 |  |  | SOCO | Sep |  |  |  | 320
51102 |  |  |  | 1006803442812 |  |  | SOCO | Q4 |  |  |  | 1024
51112 |  |  |  | 1006802762922 |  | Cal03 | SOCO | Jan Feb |  |  |  | 672
51114 |  |  |  | 1006802763548 |  |  | SOCO | Mar April |  |  |  | 688
51116 |  |  |  | 1006802764077 |  |  | SOCO | May |  |  |  | 336
51118 |  |  |  | 1006802764585 |  |  | SOCO | Jun |  |  |  | 336
51122 |  |  |  | 1006802765046 |  |  | SOCO | [NAME] |  |  |  | 688
51126 |  |  |  | 1006802765880 |  |  | SOCO | Sep |  |  |  | 336
51128 |  |  |  | 1006802766431 |  |  | SOCO | Q4 |  |  |  | 1024
57796 |  |  |  | 1006790447073 |  |  | SOCO | Cal04
57914 |  |  |  | 1002736777922 |  |  | SOCO | Cal05
40515 |  |  |  | 1006791962308 |  |  | NY-A | Dec
30188 |  |  |  | 1006803716901 |  | Cal02 | NY-A | Jan Feb 02 |  |  |  | 672
30190 | 30.1 | 30.7 |  | 1006870135035 | 2001-11-27 08:08:55 |  | NY-A | Mar April 02 |  |  |  | 688
30192 |  |  |  | 1006792310195 |  |  | NY-A | May 02 |  |  |  | 352
30193 | 40.9 | 41.5 |  | 1006870474199 | 2001-11-27 08:14:35 |  | NY-A | Jun 02 |  |  |  | 320
30194 | 52.9 | 53.6 |  | 1006870476265 | 2001-11-27 08:14:37 |  | NY-A | July Aug 02 |  |  |  | 704
30195 | 30.25 | 30.85 |  | 1006870478876 | 2001-11-27 08:14:39 |  | NY-A | Sep 02 |  |  |  | 320
30196 | 30.2 | 30.8 |  | 1006870479823 | 2001-11-27 08:14:40 |  | NY-A | Q4 02 |  |  |  | 1024
57240 |  |  |  | 1004972798826 |  |  | NY-A | Jan -Dec 02
62841 |  |  |  | 1006777647195 |  | Cal03 | NY-A | Jan Feb 03 |  |  |  | 672
 |  |  |  |  |  |  | NY-A | Mar April 03 |  |  |  | 688
63602 |  |  |  | 1006778125198 |  |  | NY-A | May 03 |  |  |  | 336
60259 |  |  |  | 1006778127854 |  |  | NY-A | Jun 03 |  |  |  | 336
58334 |  |  |  | 1006784350557 |  |  | NY-A | July Aug 03 |  |  |  | 688
 |  |  |  |  |  |  | NY-A | Sep 03 |  |  |  | 336
 |  |  |  |  |  |  | NY-A | Q4 03 |  |  |  | 1024
57240 |  |  |  |  |  |  | NY-A | Jan -Dec 03
40517 |  |  |  | 1006793689337 |  |  | NY-G | Dec
32219 | 41 | 41.5 |  | 1006869948899 | 2001-11-27 08:05:49 | Cal02 | NY-G | Jan Feb 02 |  |  |  | 672
32221 | 37.55 | 38.15 |  | 1006870009185 | 2001-11-27 08:06:49 |  | NY-G | Mar April 02 |  |  |  | 688
32222 |  |  |  | 1006785303765 |  |  | NY-G | May 02 |  |  |  | 352
32223 |  |  |  | 1006785301361 |  |  | NY-G | Jun 02 |  |  |  | 320
32224 |  |  |  | 1006785299446 |  |  | NY-G | July Aug 02 |  |  |  | 704
32225 | 37.9 | 38.5 |  | 1006870465621 | 2001-11-27 08:14:26 |  | NY-G | Sep 02 |  |  |  | 320
32226 | 37.9 | 38.5 |  | 1006870467549 | 2001-11-27 08:14:27 |  | NY-G | Q4 02 |  |  |  | 1024
32929 |  |  |  |  |  |  | NY-G | Jan -Dec 02
62793 |  |  |  |  |  | Cal03 | NY-G | Jan Feb 03 |  |  |  | 672
 |  |  |  |  |  |  | NY-G | Mar April 03 |  |  |  | 688
63604 |  |  |  |  |  |  | NY-G | May 03 |  |  |  | 336
60261 |  |  |  |  |  |  | NY-G | Jun 03 |  |  |  | 336
57260 |  |  |  | 1006261959669 |  |  | NY-G | July Aug 03 |  |  |  | 688
 |  |  |  |  |  |  | NY-G | Sep 03 |  |  |  | 336
 |  |  |  |  |  |  | NY-G | Q4 03 |  |  |  | 1024
57256 |  |  |  |  |  |  | NY-G | Jan -Dec 03
40519 |  |  |  | 1006787809297 |  |  | NY-J | Dec
32249 | 46.25 | 46.75 |  | 1006869951705 | 2001-11-27 08:05:51 | Cal02 | NY-J | Jan Feb 02 |  |  |  | 672
32251 |  |  |  |  |  |  | NY-J | Mar April 02 |  |  |  | 688
32252 |  |  |  |  |  |  | NY-J | May 02 |  |  |  | 352
32253 |  |  |  |  |  |  | NY-J | Jun 02 |  |  |  | 320
32254 |  |  |  | 1006785298087 |  |  | NY-J | July Aug 02 |  |  |  | 704
32255 |  |  |  |  |  |  | NY-J | Sep 02 |  |  |  | 320
32256 |  |  |  |  |  |  | NY-J | Q4 02 |  |  |  | 1024
32931 |  |  |  |  |  |  | NY-J | Jan -Dec 02
58074 | 2.58 | 2.59 |  | 1006870493007 | 2001-11-27 08:14:53 |  | Nymex | Dec
58076 | 2.885 | 2.895 |  | 1006870431720 | 2001-11-27 08:13:52 |  | Nymex | Jan 02
58078 | 2.94 | 2.9525 |  | 1006870431938 | 2001-11-27 08:13:52 |  | Nymex | Feb 02
54674 | 2.94 | 2.95 |  | 1006870472698 | 2001-11-27 08:14:34 |  | Nymex | Apr-Oct 02
48724 | 2.99 | 3 |  | 1006870472356 | 2001-11-27 08:14:33 |  | Nymex | Jan-Dec 02
51173 | 3.315 | 3.33 |  | 1006870472615 | 2001-11-27 08:14:33 |  | Nymex | Jan-Dec 03