Spreadsheet: kevin_presto__20055__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 |  |  |  | 1006869506433 |  |  | Cinergy | Daily
29062 |  |  |  | 1006778376932 |  |  | Comed | Daily
29094 |  |  |  | 1006793106657 |  |  | 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 |  |  |  | 1006806219782 |  |  | Nepool | Dec
33302 |  |  |  | 1006806342539 |  | Cal02 | Nepool | Jan Feb |  |  |  | 672
48660 |  |  |  | 1006803702002 |  |  | Nepool | Mar April |  |  |  | 688
48662 |  |  |  | 1006803686719 |  |  | Nepool | May |  |  |  | 352
48664 |  |  |  | 1006805554030 |  |  | Nepool | Jun |  |  |  | 320
33303 |  |  |  | 1006803691879 |  |  | Nepool | [NAME] |  |  |  | 704
48666 |  |  |  | 1006796081405 |  |  | Nepool | Sep |  |  |  | 320
48668 |  |  |  | 1006796081907 |  |  | 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.85 | 26.15 |  | 1006869683196 | 2001-11-27 08:01:23 |  | PJM W | Dec
33032 |  |  |  | 1006803646752 |  | Cal02 | PJM W | Jan Feb |  |  |  | 672
48656 |  |  |  | 1006803633283 |  |  | PJM W | Mar April |  |  |  | 688
48050 |  |  |  | 1006806520333 |  |  | PJM W | May |  |  |  | 352
45311 |  |  |  | 1006805019456 |  |  | PJM W | Jun |  |  |  | 320
33033 |  |  |  | 1006805016640 |  |  | PJM W | [NAME] |  |  |  | 704
48658 |  |  |  | 1006806517052 |  |  | PJM W | Sep |  |  |  | 320
45219 |  |  |  | 1006806327777 |  |  | PJM W | Q4 |  |  |  | 1024
33309 |  |  |  | 1006792291997 |  | Cal 03 | PJM W | Jan Feb |  |  |  | 672
55274 |  |  |  | 1006792297990 |  |  | PJM W | Mar April |  |  |  | 688
55276 |  |  |  | 1006792299521 |  |  | PJM W | May |  |  |  | 336
53431 |  |  |  | 1006792301674 |  |  | PJM W | Jun |  |  |  | 336
33034 |  |  |  | 1006784877166 |  |  | PJM W | [NAME] |  |  |  | 688
55278 |  |  |  | 1006784870326 |  |  | PJM W | Sep |  |  |  | 336
55280 |  |  |  | 1006786215575 |  |  | PJM W | Q4 |  |  |  | 1024
40881 |  |  |  | 1006869590490 |  |  | Cinergy | Dec
33288 |  |  |  | 1006795446731 |  | 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 |  |  |  | 1006793402330 |  | 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 |  |  |  | 1006779082285 |  |  | Comed | Dec
33279 |  |  |  | 1006793402297 |  | 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 |  |  |  | 1006794527625 |  |  | TVA | Dec
33314 |  |  |  | 1006793402341 |  | 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 |  |  |  | 1006806145864 |  |  | ERCOT | Dec
56337 |  |  |  | 1006806115535 |  | Cal02 | ERCOT | Jan Feb |  |  |  | 672
56345 |  |  |  | 1006806116489 |  |  | ERCOT | Mar April |  |  |  | 688
56347 |  |  |  | 1006806116862 |  |  | ERCOT | May |  |  |  | 352
56343 |  |  |  | 1006806117278 |  |  | ERCOT | Jun |  |  |  | 320
56339 |  |  |  | 1006806117694 |  |  | ERCOT | [NAME] |  |  |  | 704
56355 |  |  |  | 1006806118068 |  |  | ERCOT | Sep |  |  |  | 320
56353 |  |  |  | 1006806118521 |  |  | ERCOT | Q4 |  |  |  | 1024
62221 |  |  |  | 1006806118918 |  | Cal 03 | ERCOT | Jan Feb |  |  |  | 672
62223 |  |  |  | 1006806119719 |  |  | ERCOT | Mar April |  |  |  | 688
62225 |  |  |  | 1006806120082 |  |  | ERCOT | May |  |  |  | 336
62227 |  |  |  | 1006806120443 |  |  | ERCOT | Jun |  |  |  | 336
56341 |  |  |  | 1006806120816 |  |  | ERCOT | [NAME] |  |  |  | 688
62229 |  |  |  | 1006806121177 |  |  | ERCOT | Sep |  |  |  | 336
62231 |  |  |  | 1006806121540 |  |  | ERCOT | Q4 |  |  |  | 1024
58992 |  |  |  | 1006806121928 |  | Cal 04 | ERCOT
58994 |  |  |  | 1006806122312 |  | 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 |  |  |  | 1006792308033 |  |  | NY-A | Mar April 02 |  |  |  | 688
30192 |  |  |  | 1006792310195 |  |  | NY-A | May 02 |  |  |  | 352
30193 |  |  |  | 1006792313139 |  |  | NY-A | Jun 02 |  |  |  | 320
30194 |  |  |  | 1006793748642 |  |  | NY-A | July Aug 02 |  |  |  | 704
30195 |  |  |  | 1006786154666 |  |  | NY-A | Sep 02 |  |  |  | 320
30196 |  |  |  | 1006786156357 |  |  | 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 |  |  |  | 1006803715059 |  | Cal02 | NY-G | Jan Feb 02 |  |  |  | 672
32221 |  |  |  | 1006789733197 |  |  | 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 |  |  |  | 1006784079864 |  |  | NY-G | Sep 02 |  |  |  | 320
32226 |  |  |  | 1006786235301 |  |  | 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 |  |  |  | 1006803718438 |  | 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.56 | 2.57 |  | 1006869697679 | 2001-11-27 08:01:38 |  | Nymex | Dec
58076 | 2.87 | 2.875 |  | 1006869657092 | 2001-11-27 08:00:57 |  | Nymex | Jan 02
58078 |  |  |  | 1006869519316 |  |  | Nymex | Feb 02
54674 | 2.925 | 2.93 |  | 1006869715630 | 2001-11-27 08:01:55 |  | Nymex | Apr-Oct 02
48724 |  |  |  | 1006806365432 |  |  | Nymex | Jan-Dec 02
51173 |  |  |  | 1006806365685 |  |  | Nymex | Jan-Dec 03