Spreadsheet: benjamin_rogers__912__PJM-NY Arbitrage
Sheet: DA NYPPW - RT ZONE P

MonthName | (All)
Day Num | (All)
DayName | (All)
Year | (All)
Period | (All)
WeekNum | (All)
Q | (All)
DayAhead Vs RealTime | HE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DA NYISO ZONE P less: DA NYPP W
Date_No | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
2001-09-16 00:00:00 | 3.98 | 5.8 | 9.825 | 11.24 | 11.745 | 12.32 | 6.365 | 7.455 | 2.855 | 0.06528499999999937 | 0.106307000000001 | 0.8099864999999973 | 2.882535999999998 | 3.235062499999998 | 2.564936499999998 | 3.003172500000002 | 3.592112 | 0.7097755000000028 | -6.561518500000002 | -1.565472 | -1.226682499999999 | -0.8374670000000002 | 1.852198499999997 | 0.7346249999999976 |  | DA Zone P | Peak | [NAME] | 24-Hr |  | HE | 31Day | 10Day | 3Day
2001-09-17 00:00:00 | 5.7 | 8.755 | 9.315 | 9.135 | 498.69 | 507.355 | -1.98 | -0.6410754999999995 | -0.2376894999999983 | -1.659343499999999 | -1.758200500000001 | 1.442619000000001 | 1.959402000000001 | -2.6202595 | -1.773441000000002 | 5.663977499999998 | 3.718213500000001 | 5.6183665 | 0.02187699999999992 | 0.082748500000001 | 3.9902345 | -0.2351039999999998 | 2.485277 | -0.68 |  | 31-day |  |  |  |  | 1
2001-09-18 00:00:00 | 2.325 | 5.315 | 4.655 | 4.325 | 30.255 | 276.09 | 35.0688165 | -0.7189394999999976 | 0.1489410000000007 | 0.2365929999999992 | -2.986895000000001 | -3.651128 | -2.285098000000001 | 2.461130000000001 | 4.410764 | 5.883381499999999 | 16.5278045 | 13.984438 | 0.1368204999999989 | -2.772944000000003 | 0.6349864999999966 | 0.2510520000000014 | 3.338607999999997 | 0.4323000000000015 |  | 10-day |  |  |  |  | 2
2001-09-19 00:00:00 | 7.165 | -0.07500000000000107 | 3.275 | 5.04 | -0.8450000000000006 | -0.1450000000000031 | -1.772745499999999 | 0.1941780000000008 | -3.045900000000003 | -4.652481999999999 | -4.844966000000003 | -9.302978500000002 | -6.129514499999999 | -11.2344765 | -17.6573005 | 0.3998050000000006 | -1.239641999999996 | 1.4960545 | -5.456666500000001 | -16.036749 | -10.324027 | -7.4708975 | -5.619739499999998 | -6.187514500000002 |  | 3-day |  |  |  |  | 3
2001-09-20 00:00:00 | -2.85398 | -3.489753 | -1.842832 | -3.254322500000001 | -3.7785835 | -6.906445999999999 | -26.1700665 | -13.771115 | -6.943715000000005 | -15.046272 | -8.709873000000002 | -7.597472500000002 | -6.855632000000004 | -4.4373735 | -1.688347499999999 | -1.855776000000002 | -3.010642999999998 | -3.749727499999999 | -12.343539 | -14.4412655 | -8.769486 | -13.459492 | -16.985346 | -4.112855 |  |  |  |  |  |  | 4
2001-09-21 00:00:00 | -2.186230999999999 | -2.944826500000001 | 0.8500029999999992 | -1.0002625 | -1.841729000000001 | -3.784581500000002 | -10.5766735 | -12.0853525 | -8.574692500000001 | -10.147863 | -11.1689115 | -23.0258175 | -17.6674355 | -12.4621975 | -17.354327 | -20.813744 | -15.055624 | -10.5899355 | -8.8943045 | -14.390969 | -8.291450000000005 | -8.046067999999998 | -8.632335000000001 | -8.469601500000003 |  |  |  |  |  |  | 5
2001-09-22 00:00:00 | 0.699859 | 2.2519575 | -0.1601499999999998 | 3.28223 | 3.999067500000001 | -0.6833819999999999 | -6.151575999999999 | -2.945517500000001 | -6.067847 | -9.816008999999998 | -8.012094499999996 | -6.147113000000001 | -6.8033535 | -12.2929585 | -12.7335225 | -8.188930500000001 | -11.9660855 | -17.6528135 | -8.04524 | -22.360879 | -9.243111499999998 | -12.0960935 | -10.92792 | -4.630564999999997 |  | DA NYPP W | Peak | [NAME] | 24-Hr |  | 6
2001-09-23 00:00:00 | -1.809978999999998 | -0.07262049999999931 | 0.1974185000000013 | -5.561886000000001 | 1.5896825 | -1.348781499999999 | -2.531116000000001 | -0.06932999999999723 | -0.3547919999999998 | -3.051832000000001 | -3.290821000000001 | -5.600605999999999 | -4.287579000000001 | -4.820145999999998 | -4.286498999999999 | -2.8182525 | -2.867813000000002 | -2.3560315 | -3.448298999999999 | -10.3167295 | -6.674552499999997 | -6.354179500000001 | -7.4418805 | -6.186456500000002 |  | 31-day |  |  |  |  | 7
2001-09-24 00:00:00 | -0.507871999999999 | 0.1621680000000012 | 5.5150275 | 1.627966000000001 | 3.441933000000001 | -3.837249499999999 | -10.8617225 | -3.341527500000002 | -10.250722 | -23.627569 | -35.12243700000001 | -33.06032200000001 | -50.60443100000001 | -49.7316685 | -44.238083 | -38.73260749999999 | -0.5540669999999963 | -3.453927500000006 | -23.5816955 | -16.8985835 | -6.903382499999999 | -10.292581 | -8.255907 | -8.853126499999998 |  | 10-day |  |  |  |  | 8
2001-09-25 00:00:00 | -4.973869499999999 | -1.958945 | -0.7303420000000003 | 1.556448000000001 | 3.364127499999999 | 4.622036000000001 | -14.282416 | -13.9243535 | -9.5837985 | -2.815860000000001 | -0.2104950000000017 | -1.802467499999999 | -0.9710535 | -15.3286435 | -1.072317999999999 | 3.010101499999998 | -0.02936699999999703 | 0.991734000000001 | 2.565555 | -12.565 | 1.422609000000001 | -0.2088384999999988 | -1.676066500000001 | -0.0145824999999995 |  | 3-day |  |  |  |  | 9
2001-09-26 00:00:00 | 6.562772500000001 | 4.479341 | 3.776557 | 6.564608 | 7.131722 | 4.502405 | -2.124361499999999 | 4.658783499999998 | 4.388325500000001 | 5.114865999999999 | 6.858428 | 7.5258775 | 5.687108500000001 | 6.291579000000002 | 5.9615315 | 6.966811499999999 | 6.120778000000001 | 8.284691000000002 | 3.427661999999998 | 2.369681 | 6.7824025 | 0.266828499999999 | -0.4849619999999994 | -1.132993500000001 |  |  |  |  |  |  | 10
2001-09-27 00:00:00 | 4.128295499999998 | 1.347937499999999 | 2.281922 | -0.428860499999999 | 0.3927099999999992 | 1.063939000000001 | 0.7519704999999988 | 6.965008000000001 | 2.695764499999999 | 2.694177 | 2.3578565 | 4.262035000000001 | 5.767925999999999 | 4.7237975 | 4.076823999999998 | 4.017649000000002 | 3.530533999999999 | 4.829353999999999 | 0.3000609999999995 | 9.561359 | 6.2756015 | 3.479284500000002 | 0.4629665000000003 | 0.1516330000000004 |  |  |  |  |  |  | 11
2001-09-28 00:00:00 | 2.012137499999998 | 1.4553735 | 1.296324499999999 | 1.327131 | 6.445 | 0.9699999999999989 | -0.8870740000000019 | -1.525868499999998 | -0.2182509999999986 | -3.0437045 | -6.685372000000001 | -6.366443999999998 | -3.304066000000002 | -2.271141500000002 | -0.8787190000000002 | -0.8408169999999977 | -0.09192649999999958 | 3.165781000000003 | 0.5670864999999985 | 4.778742999999999 | 3.506628500000001 | 0.3571345000000008 | 1.886439499999998 | 0.5046149999999976 |  | DA P - NYPP W* | Peak | [NAME] | 24-Hr |  | 12
2001-09-29 00:00:00 | -3.14 | 0.1099999999999994 | 7.775 | -0.2100000000000009 | 0.07000000000000028 | 0.2099999999999991 | 3.075 | 0.695 | 1.45 | 2.26 | 3.124030999999999 | 2.262753 | 2.461658 | 3.233202499999997 | 2.233273000000001 | 4.359584000000002 | 0.7275945000000021 | 3.375457000000001 | 0.2567464999999984 | 3.7588215 | 1.836371999999997 | -0.1138189999999994 | -0.4978855000000024 | -0.5399999999999991 |  | 31-day |  |  |  |  | 13
2001-09-30 00:00:00 | -6.88 | -6.025 | -7.255 | -7.56 | -7.905 | -3.865 | 2.65 | -0.26 | -0.6649999999999991 | 2.115 | 1.2069185 | 1.3924825 | 2.5867845 | 0.9461140000000015 | 2.211293999999999 | 1.5432655 | 1.12 | 0.5365800000000007 | -1.104498499999998 | -0.2419119999999992 | -0.05455599999999805 | -0.6025995000000002 | -6.141987 | -4.195 |  | 10-day |  |  |  |  | 14
2001-10-01 00:00:00 | -8.575 | -8.905 | -13.775 | -1.585 | 0.24 | -2.501843999999998 | -25.52 | 4.638785500000001 | 4.935036 | 5.711685000000003 | 8.269793 | 8.211554999999997 | 6.793122 | 7.300604 | 9.346195499999997 | 6.8142225 | 6.722449999999998 | 6.550396500000002 | 0.8724455000000013 | 1.446658499999998 | 4.904326000000001 | 4.741978 | 3.666535 | -4.347994499999999 |  | 3-day |  |  |  |  | 15
2001-10-02 00:00:00 | -2.635565999999997 | -1.683160999999998 | -0.2253875000000001 | -0.6399999999999988 | -1.23 | 2.638104999999999 | 2.6994495 | 1.472002499999999 | 0.1358199999999989 | 0.7137600000000006 | 1.122427500000001 | 1.326181500000001 | 0.701356999999998 | 1.072063 | 1.385603999999997 | 2.458098499999998 | 0.5922990000000006 | 1.537578 | -5.731462499999999 | -14.4958355 | -0.7965480000000014 | -0.4842964999999992 | -0.9572704999999999 | -4.640459 |  |  |  |  |  |  | 16
2001-10-03 00:00:00 | -6.01163 | -0.285 | -1.025 | -0.5399999999999991 | -0.9499999999999993 | 0.9279174999999995 | -6.369556500000002 | -1.993036 | -0.5003600000000006 | 0.6496880000000012 | -1.818569999999998 | -8.623644500000001 | 0.0405409999999975 | -1.007163500000004 | 2.002399499999999 | 3.902542500000003 | 1.659864499999998 | 9.363048000000003 | -5.859307000000005 | -5.035134499999998 | 0.7642050000000005 | -4.754865000000002 | -1.926067999999997 | -1.769779499999999 |  |  |  |  |  |  | 17
2001-10-04 00:00:00 | -0.8887365000000003 | -1.422470999999998 | -0.3630220000000008 | -0.9977335000000025 | -0.5974160000000026 | 1.4913925 | -2.891563999999999 | -5.040651 | -1.295454000000003 | -4.575862999999998 | -10.120462 | -6.748600500000002 | -3.4543775 | -4.902155499999999 | -0.7817094999999981 | 2.815254000000003 | -1.008480000000006 | 3.946156500000001 | -5.213060499999997 | -7.630971000000002 | 1.620302999999996 | 4.1 | 2.961475500000002 | -2.947252500000001 |  | Transmission Cost: |  |  |  |  | 18
2001-10-05 00:00:00 | -5.724121 | -6.588654500000001 | -7.551807 | -6.467648499999999 | -7.049596000000001 | -1.919358500000001 | -4.716861000000002 | -4.811544999999999 | -1.630582 | -0.1889054999999971 | -0.2274789999999989 | -1.846361999999996 | 1.554828500000003 | -1.838598000000005 | 2.222066999999996 | -10.356168 | 4.025073500000001 | 7.0082515 | -1.124123499999996 | 9.645262999999996 | 7.895 | 5.905 | 7.09 | -0.27 |  | PJM to NYISO | 1.15 |  |  |  | 19
2001-10-06 00:00:00 | -2.215 | -5.105 | -3.620517 | -3.981622000000002 | -1.065 | -0.805 | 0.504999999999999 | -0.8500000000000014 | -1.385 | -5.2 | 0.9294809999999991 | 5.105148500000002 | 4.4846875 | 2.865 | 2.86 | 2.98 | 3.45 | 2.32 | 2.86 | 8.805 | 4.115 | 0.48 | 0.465 | 0.25 |  | NYISO to PJM | 6.3 |  |  |  | 20
2001-10-07 00:00:00 | -0.7949999999999982 | -1.325 | -0.8900000000000006 | 0.4949999999999992 | -1.53 | -2.71 | -2.905 | -0.6800000000000033 | 1.659306999999998 | 1.071597999999998 | 3.112734 | 3.978873 | 4.078267500000003 | 4.495 | 5.725 | 4.765 | 4.83 | 6.735 | 4.838089 | 5.022810999999997 | 3.965 | 5.485 | 0.8099999999999987 | 3.105 |  |  |  |  |  |  | 21
2001-10-08 00:00:00 | -2.21 | 0.6700000000000017 | -1.5 | -3.24 | -3.07 | 5.14 | -0.2828895000000031 | 2.388688000000002 | -3.240055000000002 | -11.319967 | -1.472828999999997 | 6.168541000000001 | 7.040975 | 7.423428000000001 | 6.023889 | 6.777689500000001 | 7.388096999999998 | 9.162571 | 12.656944 | 19.24815 | 7.491107999999997 | 5.05 | 3.515 | -5.675 |  | *Statistics INCLUDE Transmission Cost $1.15 |  |  |  |  | 22
2001-10-09 00:00:00 | 8.72 | 5.99 | 13.17 | 17.91 | 17.18 | 17.94 | 7.67 | 0.5299999999999976 | -7.76 | -0.4400000000000013 | 0.3900000000000006 | 2.97 | 3.1 | 3.35 | 1.09 | 2.21 | 3.15 | 2.62 | 2.76 | 7.17 | 2.69 | 2.75 | 3.37 | -5.16 |  |  |  |  |  |  | 23
2001-10-10 00:00:00 | -1.35 | 1.22 | 14.16 | 2.1 | 0.9499999999999993 | 4.4 | 12.52 | 5.72 | 9.29 | 13.18 | 14.75 | 22.57 | 15.08 | 14.28 | 13.01 | 10.38 | 10.03 | 11.26 | 16.97 | 33.95 | 27.57 | 15.17 | 2.04 | 0.5100000000000016 |  |  |  |  |  |  | 24
2001-10-11 00:00:00 | 0.03999999999999915 | 0.945 | -1.475 | -1.94 | -0.08000000000000185 | 2.86 | 7.261264000000004 | -2.525827500000002 | 1.884805500000002 | -2.158640500000001 | -0.008586000000001093 | -2.043471500000003 | -3.809874499999999 | -7.764856499999997 | -2.236604500000002 | -4.200136499999999 | -3.74953 | 1.782774499999999 | -8.731882499999998 | -24.2842305 | -7.501662500000002 | -2.19 | -3.215 | -1.06
2001-10-12 00:00:00 | -0.2550000000000026 | 0.8350000000000009 | -1.475 | -0.75 | 1.035 | 2.625 | 7.750243000000001 | -0.1727849999999975 | 2.2349885 | -3.520168000000002 | -2.444915999999996 | -1.708474999999996 | 0.562006499999999 | -6.548993500000002 | -2.945035999999998 | -4.413179999999997 | -1.126633499999997 | 6.016221000000002 | -1.191800000000001 | 1.39 | 4.35 | 3.915 | 1.42 | 0.4200000000000017
2001-10-13 00:00:00 | -9.5 | -9.76 | -7.4 | -3.33 | -4.2 | -3.55 | -7.09 | -4.88 | -1.22 | 0 | 2.28 | -1.58 | -0.740000000000002 | -0.1099999999999994 | 0.3000000000000007 | 0.9200000000000017 | 0.82 | 0.34 | -5.65 | 16.28 | 4.11 | 3.39 | -0.120000000000001 | 2.6
2001-10-14 00:00:00 | -5.92 | -6.26 | -3.99 | -5.82 | 4.49 | -2.67 | 1.02 | -0.25 | 0.06000000000000227 | -0.9499999999999993 | -1.44 | -0.9500000000000028 | -0.740000000000002 | -0.3300000000000018 | 0.2600000000000016 | -0.8499999999999979 | -0.73 | 0.1400000000000006 | -0.7100000000000009 | 14.95 | 6.16 | 1.16 | 0.9399999999999977 | 1.34
2001-10-15 00:00:00 | 7.795 | 7.75 | 8.2 | 3.54 | 2.195 | 4.165 | 3.470298 | 2.996115 | 3.920641500000002 | 3.808148500000001 | 0.7105174999999981 | 0.6049959999999999 | 1.231522500000001 | -3.521146999999999 | 0.324147 | 0.0999769999999991 | 0.7402540000000002 | 2.215467499999999 | 5.446574999999999 | 8.8037265 | 3.5582785 | 2.444580999999999 | 0.8150000000000013 | -2.42
2001-10-16 00:00:00 | -3.74 | -3.37 | -2.35 | -3.12 | -3.67 | -9.64 | -17.32 | -7.65 | -7.01 | -18.65 | -1.22 | -6.07 | -6.17 | -3.68 | 24.29 | -4.65 | -3.73 | -5.38 | -8.23 | -6.64 | -2.8 | -2.54 | -4.12 | -7.39
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  | Peak | Off-Peak | 24-hr
31-day Average
10-day Average
3-day Average