Spreadsheet: benjamin_rogers__912__PJM-NY Arbitrage
Sheet: RTPJM Vs DA NYZp

MonthName | (All)
Day Num | (All)
DayName | (All)
Year | (All)
Period | (All)
WeekNum | (All)
Q | (All)
RealTime Vs DayAhead | 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.235601442619636 | -4.812186240186715 | -11.17411177056904 | -13.91131288646261 | -13.86536849961892 | -14.66874295787203 | -3.054613058012364 | -3.569680823894728 | -3.443197921688157 | -3.832590857462133 | -5.44003921895257 | -5.936494628628346 | -5.38133023364519 | -4.925118187984427 | -4.830558668337741 | -4.063620680702581 | -3.841467717515929 | 0.3779335998020166 | 14.32125033023722 | 7.212478738103062 | 1.29682328488391 | -7.224560767273569 | -5.549782571950747 | -4.612680386390606 |  | DA Zone P | Peak | [NAME] | 24-Hr |  | HE | 31Day | 10Day | 3Day
2001-09-17 00:00:00 | -9.475551507647369 | -16.27089005999085 | -14.55160659553431 | -14.39893112322505 | -5.149754256515076 | -2.827995727288911 | 1.02881980724425 | -7.875369443057899 | -6.52150984403724 | -3.063622450753268 | -0.4127935327558809 | -9.26386154548505 | -8.973148867120234 | -2.949794384432984 | -4.371159036832591 | -11.38542910018974 | -11.5433434782955 | -10.44505797638108 | -8.755388755259116 | -9.140767457012394 | -9.793581617174723 | -7.16867198833987 | -7.697712355896773 | -4.740856210288101 |  | 31-day |  |  |  |  | 1
2001-09-18 00:00:00 | -3.230060021537476 | -0.6060018044827125 | 0.07941215794815548 | -0.4592846139550257 | 0.6129373144042649 | -0.5626168697826834 | 2.374140224453225 | -2.707990896596524 | -6.740001021540934 | -4.530108586827648 | 1.979863013889045 | 3.277850275612739 | 4.418447102356765 | -0.3422756112728855 | -5.49666433753076 | -8.342103191289606 | -12.16266852526683 | -12.67123917589961 | -7.145170227731398 | 4.552638108732779 | 0.9182989951388194 | -1.105337605807541 | -2.54927630900519 | -2.228667064661636 |  | 10-day |  |  |  |  | 2
2001-09-19 00:00:00 | -1.320232251194255 | -1.657688238674796 | -6.04 | -1.255 | -1.645 | 1.185392448863386 | -3.889591493352825 | -4.651165385316414 | -3.785333013805925 | -0.5735383995133745 | -0.7241133545107274 | -2.165630312750604 | -1.264007395738194 | 14.22001999780977 | -2.212362518087808 | -3.191483155176634 | -3.73880417833524 | -7.934827960052544 | -3.674021243018192 | 20.0930382957515 | 9.397375912458 | -0.6892966401291609 | -1.464058981695441 | -3.4635782928307 |  | 3-day |  |  |  |  | 3
2001-09-20 00:00:00 | -2.349195338500241 | -0.03455658906855064 | 3.238 | 6.096999999999998 | 4.998000000000001 | 12.6593916158297 | 16.97973292993309 | 12.29042379457137 | -3.644350388118596 | 6.742455507709405 | 0.02984441731761933 | -3.739380297316483 | 4.642533432012378 | 6.737178893528238 | -5.978655793841501 | -7.09134202951223 | -5.609551918197649 | -4.816044453478085 | 5.267303026156213 | 7.237538536237135 | -0.32108413309005 | 1.482057807195918 | 11.19946460218919 | 0.7291955453920487 |  |  |  |  |  |  | 4
2001-09-21 00:00:00 | -0.278854870264535 | 3.908812488023976 | 4.247636704341243 | 3.328608537522204 | 3.937279099547901 | 0.1801880571927477 | 15.48416489435207 | 5.933590908158692 | 6.180074659985884 | 7.361199324370528 | 10.9704678147556 | 24.65403685856523 | 24.50980305842277 | 12.49010909468277 | 19.77051356837192 | 13.6227857496787 | -2.796085967689862 | -8.409155471236936 | -4.725168347219611 | 8.274339895774546 | 1.671851800011197 | -0.2824668912269068 | 1.576578547363241 | 0.6794825109787155 |  |  |  |  |  |  | 5
2001-09-22 00:00:00 | -0.7902545479663203 | 2.181209858937066 | 0.4953628968521713 | 2.498692227401861 | 0.1724419223056941 | -2.156190809290095 | -0.3541507035944882 | -2.545563814678403 | 4.872494051520452 | 28.77354424250586 | 8.536932470593861 | -1.478181594100768 | -3.409529833661761 | -0.04897774016277623 | 2.004801473141931 | -6.494703674063924 | -5.649961220615818 | -6.548107966548024 | -6.357005101549998 | 20.90625657781105 | -1.164115675888571 | -5.262021684410271 | -4.245332703092039 | -5.936459726127346 |  | DA NYPP W | Peak | [NAME] | 24-Hr |  | 6
2001-09-23 00:00:00 | -2.63850001451716 | -3.862113231508886 | -2.118374797641414 | -2.421501118166212 | -2.469029071841765 | -4.035626860238285 | -4.274444188202851 | -8.263923572646515 | -7.87565426392263 | -6.317133477724575 | -6.279769927649809 | -4.572744742184575 | -2.707492943484205 | -1.716461392513711 | -7.419851415763915 | -6.934329088984299 | -5.809365501413666 | -6.075962482361327 | -10.28639862800347 | -1.170549895514352 | -8.105069626958446 | -8.014038135794689 | -3.176334117912898 | -3.524063292597365 |  | 31-day |  |  |  |  | 7
2001-09-24 00:00:00 | -2.38072983079606 | -1.452759540480164 | -0.9907787820824403 | -0.4370318603625236 | 0.9642421529274685 | 4.994962189734778 | 18.75183265467946 | -11.8488124039099 | -4.965741741833593 | -9.852209993468318 | -9.434802039476633 | 2.28140429592154 | 16.4844382704882 | 22.17443174515392 | 3.336469153449151 | -0.3290637770064535 | -13.71092747429045 | -12.01842334572339 | 5.276303880894126 | 12.9912661543871 | 2.554847167420256 | 1.651445654807084 | 2.972745010816777 | 5.291504344596849 |  | 10-day |  |  |  |  | 8
2001-09-25 00:00:00 | 6.65862361890148 | 12.36146509417722 | 9.990390652505791 | 3.233282788865353 | 5.213183760714958 | 5.015193131396998 | 15.35349921965058 | 12.89178711229082 | 9.277035802419729 | 2.168578034235569 | -2.394272458576136 | -2.421233371643453 | -2.429807681273218 | 26.4577246833 | -2.025852663582221 | -9.86294523196359 | -4.703938777042705 | -4.591871354067035 | -5.122777554673394 | 23.01653761421732 | -4.465446226603305 | -3.491387266666671 | -1.273461500359183 | -2.486779894585663 |  | 3-day |  |  |  |  | 9
2001-09-26 00:00:00 | -0.852192492006882 | -0.8778253097236295 | 0.445159569338923 | -0.6028438339105762 | 1.362020387686343 | -0.6524048634737412 | 6.336510991935281 | -7.70900996283682 | -9.988833271472654 | -10.67303738048398 | -14.64201616869688 | -14.71591934962546 | -14.01514032651034 | -13.51956921029854 | -10.80046187783011 | -12.88240965446677 | -11.53217122027217 | -16.54223631952859 | -11.74797366935007 | -6.585661830021319 | -13.01509045438095 | -7.412263347072304 | -3.55705000666558 | -1.828951291181252 |  |  |  |  |  |  | 10
2001-09-27 00:00:00 | 0.8623694063548939 | 1.73547310516792 | 4.518507303598865 | 4.11178629151016 | 3.658801933150805 | 1.442923403144544 | -1.235961899577287 | -6.42798405490932 | -4.1793717156282 | -6.572046485897637 | -6.241213862694689 | -5.87903538212753 | -7.281767344669646 | -6.405024382722001 | -6.534940557419393 | -6.748522371637804 | -6.010882367466539 | -8.539089538021912 | -4.283306641176353 | -6.597540788557176 | -7.337021164167083 | -4.779280003117879 | -2.212476639363743 | -2.278967761715144 |  |  |  |  |  |  | 11
2001-09-28 00:00:00 | -0.2516796720697698 | 1.024451589055499 | 1.763489490995145 | -1.77082905010222 | -2.623862260794825 | -1.256797338627855 | -2.169104865031684 | -1.607566223323481 | -2.731162615374192 | 6.019537589114947 | 6.429748332395381 | 3.966104452362035 | -0.1509080123262194 | -2.155846515848985 | -2.124044703640092 | -1.536382745462255 | -3.085914971309339 | -9.091035153186613 | -8.458218035589333 | -8.454147236419523 | -8.659323406855297 | -6.986138772095487 | -4.047472344965222 | -4.296791309699753 |  | DA P - NYPP W* | Peak | [NAME] | 24-Hr |  | 12
2001-09-29 00:00:00 | -1.143866914707576 | -1.989644016631543 | -2.984848317044444 | -0.8968796150318497 | -0.4828217709145299 | -0.583821932133862 | -1.696373363655475 | -6.801059500034434 | -5.761841364025823 | -8.567815235702533 | -6.896598452134825 | -4.747519077924274 | -4.809825869880498 | -6.297336612528401 | -9.178200937671821 | -11.92866025977628 | -8.69772232322736 | -6.31619923476806 | -3.505153438875038 | -5.65732320177268 | -6.381741679593851 | -5.005113572215802 | -5.004706876488175 | -4.245416378814603 |  | 31-day |  |  |  |  | 13
2001-09-30 00:00:00 | -1.370297474154771 | -0.09841184296090866 | 0.9933899640700812 | 0.9292695978919046 | 0.7991975379507039 | -0.8168779606618148 | -0.5492032326334151 | -2.731950900511146 | -2.8880611917705 | -4.307384099944425 | -6.574211952832059 | -7.479201663758637 | -6.672441329968645 | -5.823828587281294 | -5.299710969108688 | -5.622030163136721 | -5.690222192782215 | -5.486683431942666 | 3.252411238529032 | 22.97651029357093 | 8.963165763592986 | -3.643447116770943 | -4.4472712495755 | -1.652471771592307 |  | 10-day |  |  |  |  | 14
2001-10-01 00:00:00 | -2.510289298806104 | -0.6731330431728644 | -0.1037106588423153 | 0.05203281941494531 | 0.836290078152393 | 2.937417667958535 | 26.68437258451313 | -1.889506910011605 | -2.851809754213466 | -3.012905880648898 | -4.441795176555672 | -4.471525887513152 | -3.012763822450289 | -4.425202966727134 | -8.524236910285502 | -8.555750149143169 | -8.508280989839307 | -8.46451226820443 | -2.648739229797723 | 3.406719931951798 | -5.253146834563999 | -5.169949878026941 | -2.958294179578289 | -0.9216476114294174 |  | 3-day |  |  |  |  | 15
2001-10-02 00:00:00 | 1.404517334173967 | 1.654975078534875 | 1.621087299260424 | 0.4074860608269901 | 1.402374417969908 | 0.4301689061086158 | 3.790198029188151 | -2.192398238940335 | -1.784191792793628 | -3.095018608499391 | -0.9480795413727208 | -0.5322414085859855 | -0.1535697187789999 | 0.02513934832829889 | 0.1048470161416049 | -3.281671537975733 | -1.378247643298298 | -2.550434115754612 | 6.065704983131241 | 6.126996268594556 | 2.839223598063107 | 1.129685890492119 | 0.617852261609336 | 3.233391786384086 |  |  |  |  |  |  | 16
2001-10-03 00:00:00 | 7.506896983116089 | -1.568220114155441 | 0.6683323384538298 | -0.4964017436133901 | 0.8027642340751608 | 0.7306970027127591 | 6.596119124645082 | 3.741883199017987 | 1.334307742051479 | -1.365165874391032 | 2.960729044920647 | 16.829678081592 | -2.271646944666681 | -3.978787626176402 | 2.234817499129111 | 2.363888897718507 | 2.426225155838168 | -6.776174238024765 | -4.682400570673654 | 1.073194233393352 | 3.673541952196306 | 7.154386796700017 | 1.984510477457587 | 1.130716813197957 |  |  |  |  |  |  | 17
2001-10-04 00:00:00 | -0.3201419640020546 | 0.6115790344658478 | 1.202842868215431 | 0.5545449631137096 | 1.147103339232842 | -1.014342926417882 | 3.34614580870182 | -4.39818849574322 | -5.339128605512276 | 4.114171547612195 | 17.01004670044237 | 5.172436187321861 | 3.686750933840489 | 8.461127073210282 | 2.13546396715795 | 0.5415473782175937 | 0.4317256382427708 | -5.805769239773692 | -4.840595224804098 | -2.977450373775646 | -4.086820209099152 | -5.50250818171542 | -2.667269772316526 | 2.480180107683566 |  | Transmission Cost: |  |  |  |  | 18
2001-10-05 00:00:00 | 9.441979939447211 | 7.416651873763268 | 7.974793844874196 | 6.949434569776766 | 3.784581758714843 | -2.060625589341132 | 3.416875428085039 | -7.095228733410046 | -9.602076525699264 | -1.602270121921208 | 2.389140132265741 | 7.936628088073125 | 11.3553846801281 | 7.589423808990727 | 1.995119657276902 | -2.15747319550141 | -3.944954003766043 | -5.911442856431588 | -2.32604529480982 | -4.635343270782887 | -2.884133744090644 | -3.853593082306318 | -4.903875857240259 | -6.086283987915401 |  | PJM to NYISO | 1.15 |  |  |  | 19
2001-10-06 00:00:00 | 1.752947735177596 | -0.1326741530262652 | -1.316306814605991 | -0.8674149624122727 | -2.053821415366741 | -0.3592655020215361 | -3.935699165668499 | -4.140714173719246 | 1.535352905620066 | 2.312189118866954 | -4.625177865483405 | -8.134392090689389 | -9.373409748339107 | -9.1398961885087 | -9.0754842696781 | -9.276104319464515 | -10.22860875969284 | -9.336611882380147 | -10.94909610164693 | -8.482550021606187 | -8.369376255197466 | -3.4025717446454 | -6.101864011379799 | -5.357036212242431 |  | NYISO to PJM | 6.3 |  |  |  | 20
2001-10-07 00:00:00 | -2.220960688989869 | -4.566419653326424 | -3.830599811646939 | -5.320517080731431 | -3.732305189294454 | -2.405246183994304 | -3.306237410257737 | -5.343113843869462 | -5.574255050363053 | -4.613484097509964 | -8.405789821534821 | -8.189613354782264 | -8.61038055535803 | -10.32599609047553 | -9.734843386107729 | -7.139270428535298 | -7.693994711620256 | -10.32397199938158 | -8.041582037061179 | -1.781527004936677 | -2.608639294644028 | -8.469358808268243 | -1.861267502208285 | -6.273730056476186 |  |  |  |  |  |  | 21
2001-10-08 00:00:00 | -2.582045971039555 | -3.636942275430526 | -4.706755893586195 | -3.06323250128403 | -4.273637469105292 | -7.16582557031948 | -4.685584958596465 | -8.41669281828969 | -5.825803528110161 | 0.008890604157485882 | -3.597564230395388 | -12.1743809883978 | -13.32959125009349 | -12.71778548122333 | -10.01284199288874 | -11.29398008525763 | -11.69653265026802 | -14.77416143958126 | -16.32646747118651 | -19.19092357499435 | -6.477296379409271 | -6.619045621177644 | -3.388876326174501 | 2.734547024217125 |  | *Statistics INCLUDE Transmission Cost $1.15 |  |  |  |  | 22
2001-10-09 00:00:00 | -16.8866603602942 | -18.28646668482135 | -19.74686364600128 | -19.72547227306515 | -20.17686483993025 | -23.82583626641878 | -30.18420577382042 | -30.30407982144691 | -30.91657787789352 | -30.51228013928 | -29.56608275001902 | -29.4383591930883 | -28.6199707902315 | -28.36673619797313 | -27.51929267710454 | -27.43598983849715 | -27.83873690895784 | -27.96086924403884 | -30.95845984831223 | -33.47288606622915 | -29.56823467657052 | -27.69723464507647 | -23.71429906237892 | -22.10135868456708 |  |  |  |  |  |  | 23
2001-10-10 00:00:00 | -16.94831551054985 | -17.88411664456341 | -18.47321176986149 | -17.41919423864241 | -19.27769810381045 | -23.75605747230305 | -30.40066631749722 | -27.27418633757897 | -29.2676596479315 | -31.01580666550936 | -30.73537740370215 | -33.4866295620962 | -30.56522497887725 | -29.71358889017074 | -28.59851836759465 | -28.53498394565866 | -28.48124811444416 | -29.67320943466023 | -33.44222766276258 | -39.70348464314853 | -35.76073029395533 | -29.35519432366828 | -23.47732733440571 | -22.345994875227 |  |  |  |  |  |  | 24
2001-10-11 00:00:00 | -2.242483627943248 | -3.83491307089818 | -3.066515216895215 | -2.565932570207316 | -2.842495693526001 | -0.4060568921280634 | 9.316665376065146 | 2.73034070861296 | -10.9821624460511 | -0.8967080059959507 | -6.578859301927682 | -2.786947841318142 | 3.0695411369108 | 9.927560751318463 | -2.560279052494913 | -2.492789552238808 | 0.5660164989318162 | -11.32071189362437 | -2.355549363560815 | 12.70022668058145 | 8.109542013602947 | -3.006866851741226 | -3.157537088237618 | -4.603663781454571
2001-10-12 00:00:00 | -2.373582365343303 | -4.460660787045875 | -3.300020713797458 | -2.040037479230259 | -1.363490557599661 | -4.499366195601731 | -10.55050845959141 | -4.252132462576874 | -8.557599868895828 | 4.980506397488849 | 7.987846857671503 | 6.712126804970385 | -1.982258544988312 | 10.22236804223187 | 6.290962166918757 | 5.170701707592436 | -0.3131475475747543 | -10.42359981146016 | -5.300090223291704 | 1.345165340011576 | -1.199798483896778 | -6.280101950697318 | -5.343224938219574 | -4.807521595027691
2001-10-13 00:00:00 | -21.3 | -18.34 | -17.95 | -17.53 | -17.60464642257365 | -18.74461877686927 | -19.770823094533 | -19.65545729905712 | -24.41169928203716 | -26.89311531075594 | -29.43480258133111 | -28.32944869544869 | -26.4558104839519 | -26.48367610138134 | -26.15497709580991 | -26.03204595469698 | -26.14473664974758 | -25.90284196606138 | -29.17997424380964 | -38.44723504225712 | -29.42606735032453 | -26.8439163671551 | -21.92258574692367 | -21.78156813243129
2001-10-14 00:00:00 | -18.9320098646203 | -17.35093779837553 | -15.85 | -15.46 | -15.45 | -16.1 | -16.5 | -16.82200373575793 | -20.771000068105 | -22.28422826968529 | -22.83877752422621 | -23.29359489063806 | -23.41426906101195 | -23.33582472955415 | -22.94428796575576 | -22.67907277604557 | -23.02515792211395 | -23.7598334418571 | -25.13756272377266 | -34.07620323839649 | -29.3480805233282 | -25.06548842858107 | -22.38272764322723 | -20.69140159801777
2001-10-15 00:00:00 | 1.841331342492561 | -2.837723412705122 | -4.570395429095999 | -4.957610110110108 | -3.314427569310666 | -6.696560940028718 | -9.700652529339 | -10.08196047431986 | -11.808833120462 | -5.942317008804434 | -2.441596339292072 | -1.57302811043915 | -2.812264182456619 | 2.32322339255909 | -2.071197385388665 | -2.955893691716319 | -2.46789954893184 | -6.801939746113757 | -10.57409451310745 | -6.405486454321377 | -4.23015668978557 | -7.403246491307964 | -8.124246459369296 | -4.382933132118325
2001-10-16 00:00:00 | -13.550229007029 | -17.12312362996892 | -16.61526386380374 | -16.26071130713048 | -16.7269916228613 | -19.62304057698503 | -25.81422318233539 | -25.61544625095916 | -27.50876720954984 | -29.00169452003798 | -28.5447248330023 | -28.06123891764096 | -27.76261858859656 | -28.39638541546451 | -27.8560201307182 | -27.31956191147956 | -27.31431724954786 | -27.85574398692548 | -32.28898721634403 | -34.62069092733525 | -29.1552462401415 | -25.82389852389247 | -22.25199228238185 | -21.06800384136674
 | 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