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

MonthName | (All)
Day Num | (All)
DayName | (All)
Year | (All)
Period | (All)
WeekNum | (All)
Q | (All)
DayAhead 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 | -2.055601442619635 | -2.642186240186716 | -2.004111770569045 | -1.921312886462605 | -1.865368499618921 | -2.09874295787203 | -2.444613058012365 | -2.659680823894728 | -2.633197921688154 | -2.942590857462132 | -2.470039218952572 | -2.036494628628347 | -2.161330233645192 | -2.015118187984431 | -1.810558668337741 | -1.28362068070258 | -0.463467717515929 | -0.9760664001979826 | -1.308749669762786 | 0.4724787381030602 | -0.6831767151160903 | -2.52456076727357 | 0.6702174280492521 | -0.02268038639060777 |  | DA Zone P | Peak | [NAME] | 24-Hr |  | HE | 31Day | 10Day | 3Day
2001-09-17 00:00:00 | -3.59555150764737 | -2.800890059990845 | -4.421606595534314 | -4.508931123225047 | -3.819754256515075 | -4.03799572728891 | -4.22118019275575 | -4.343369443057899 | -4.415509844037238 | -3.927622450753269 | -2.70879353275588 | -3.84586154548505 | -2.827148867120233 | -2.691794384432985 | -3.277159036832593 | -0.1634291001897381 | -1.977343478295495 | -1.151057976381075 | -4.069388755259116 | -3.194767457012393 | -1.959581617174724 | -3.704671988339872 | -2.85571235589677 | -3.8508562102881 |  | 31-day |  |  |  |  | 1
2001-09-18 00:00:00 | -4.330060021537474 | -3.326001804482713 | -2.130587842051845 | -2.779284613955024 | -2.177062685595736 | -3.052616869782685 | -3.635859775546773 | -3.503990896596523 | -3.696001021540933 | -1.778108586827649 | -1.540136986110955 | -1.856149724387262 | -0.0295528976432351 | 0.1317243887271147 | 0.2193356624692413 | -0.1221031912896073 | 6.273331474733169 | 3.972760824100384 | -3.231170227731401 | -0.6793618912672201 | -0.08170100486118059 | -2.241337605807541 | -2.091276309005192 | -3.794667064661635 |  | 10-day |  |  |  |  | 2
2001-09-19 00:00:00 | -3.040232251194258 | -1.867688238674797 | -1.7 | -1.995 | -1.235 | -2.354607551136617 | -3.453591493352825 | -3.325165385316414 | -2.391333013805927 | -2.323538399513374 | -0.1881133545107296 | -0.08163031275060462 | -1.856007395738192 | -0.9019800021902249 | -1.126362518087809 | 1.264516844823369 | 0.3351958216647617 | -0.5948279600525446 | -3.596021243018193 | -0.6849617042485008 | -1.928624087541998 | -3.69129664012916 | -3.65805898169544 | -4.133578292830702 |  | 3-day |  |  |  |  | 3
2001-09-20 00:00:00 | -3.705195338500243 | -1.938556589068551 | -1.98 | -2.035 | -1.98 | -2.112608384170301 | -3.744267070066915 | -2.567576205428626 | -1.388350388118596 | -0.2595444922905941 | -1.538155582682382 | -1.745380297316483 | -0.4414665679876215 | 0.2971788935282405 | -3.2046557938415 | -3.137342029512233 | -3.175551918197648 | -3.624044453478085 | -5.166696973843788 | -5.058461463762864 | -4.27708413309005 | -4.64994219280408 | -3.97653539781081 | -3.780804454607953 |  |  |  |  |  |  | 4
2001-09-21 00:00:00 | -2.290854870264535 | -1.237187511976025 | -0.4643632956587567 | -0.8433914624777952 | -0.3207209004520983 | -1.131811942807254 | -1.565835105647924 | -2.71040909184131 | -1.617925340014114 | -1.826800675629471 | -1.057532185244401 | -2.559963141434775 | -3.022196941577235 | -2.92989090531723 | -2.713486431628077 | -2.131214250321307 | -2.152085967689864 | -2.681155471236938 | -5.283168347219611 | -3.981660104225455 | -4.068148199988805 | -4.140466891226904 | -3.611421452636762 | -3.058517489021288 |  |  |  |  |  |  | 5
2001-09-22 00:00:00 | -4.814254547966321 | -3.544790141062935 | -3.60863710314783 | -2.68930777259814 | -2.927558077694306 | -4.266190809290094 | -3.262150703594489 | -4.0815638146784 | -4.85550594847955 | -3.522455757494139 | -3.949067529406136 | -3.710181594100771 | -3.259529833661759 | -3.534977740162777 | -3.49919852685807 | -2.682703674063923 | -2.751961220615815 | -3.646107966548026 | -4.245005101549999 | -3.403743422188956 | -2.952115675888571 | -4.29002168441027 | -4.001332703092039 | -4.772459726127344 |  | DA NYPP W | Peak | [NAME] | 24-Hr |  | 6
2001-09-23 00:00:00 | -2.59850001451716 | -0.7841132315088863 | -1.776374797641413 | -2.159501118166212 | -1.533029071841765 | -4.091626860238284 | -3.142444188202852 | -4.431923572646514 | -4.803654263922631 | -4.387133477724575 | -4.665769927649812 | -5.630744742184575 | -5.157492943484204 | -4.918461392513709 | -4.361851415763915 | -4.5103290889843 | -5.045365501413666 | -4.971962482361327 | -6.52639862800347 | -5.180549895514353 | -5.361069626958447 | -5.574038135794691 | -4.368334117912898 | -3.972063292597365 |  | 31-day |  |  |  |  | 7
2001-09-24 00:00:00 | -2.180729830796061 | -1.912759540480163 | -1.41677878208244 | -2.201031860362523 | -1.759757847072533 | -1.707037810265223 | -0.0901673453205376 | -8.486812403909902 | -7.403741741833592 | -6.236209993468318 | -5.332802039476633 | -6.484595704078458 | -5.481561729511803 | -3.315568254846085 | -3.027530846550853 | -2.207063777006454 | -1.728927474290451 | -3.428423345723395 | -6.683696119105875 | -1.946733845612897 | -2.917152832579745 | -5.822554345192916 | -3.379254989183224 | -1.26849565540315 |  | 10-day |  |  |  |  | 8
2001-09-25 00:00:00 | -1.901376381098519 | -0.7245349058227788 | -0.1876093474942095 | -0.9607172111346483 | 1.305183760714957 | 1.767193131397001 | -0.8725007803494158 | -1.238212887709174 | -1.400964197580269 | -0.6194219657644311 | -1.632272458576136 | -2.151233371643453 | -2.363807681273215 | -1.6062753167 | -1.643852663582219 | -1.716945231963592 | -1.691938777042704 | -1.689871354067034 | -1.548777554673396 | -1.743462385782678 | -1.813446226603304 | -3.459387266666671 | -2.851461500359186 | -3.310779894585661 |  | 3-day |  |  |  |  | 9
2001-09-26 00:00:00 | 0.1958075079931199 | 0.6301746902763696 | 0.7411595693389224 | -0.2948438339105763 | 0.706020387686344 | 2.465595136526261 | 0.5265109919352788 | -1.71500996283682 | -4.858833271472655 | -3.889037380483984 | -6.180016168696877 | -4.429919349625457 | -4.985140326510344 | -4.63756921029854 | -5.046461877830108 | -5.178409654466769 | -5.316171220272167 | -5.35223631952859 | -5.649973669350075 | -4.883661830021317 | -4.295090454380947 | -5.138263347072307 | -3.45505000666558 | -4.040951291181251 |  |  |  |  |  |  | 10
2001-09-27 00:00:00 | -2.657630593645106 | -1.570526894832081 | -0.3974926964011338 | -0.700213708489839 | -0.7131980668491966 | 0.4789234031445453 | -0.3779618995772864 | -1.515984054909318 | -2.757371715628199 | -3.326046485897635 | -3.07921386269469 | -2.899035382127529 | -2.595767344669646 | -2.325024382722003 | -2.532940557419394 | -3.414522371637805 | -3.140882367466542 | -2.839089538021913 | -4.023306641176355 | 1.118459211442826 | -1.709021164167083 | -3.405280003117877 | -3.290476639363742 | -3.480967761715142 |  |  |  |  |  |  | 11
2001-09-28 00:00:00 | -1.959679672069772 | -1.005548410944499 | -0.6465105090048571 | -0.9048290501022205 | -0.993862260794824 | 0.5132026613721443 | -2.247104865031684 | -2.347566223323479 | -2.61316261537419 | -3.822462410885052 | -3.23625166760462 | -3.469895547637964 | -3.556908012326222 | -3.595846515848987 | -3.752044703640092 | -3.912382745462253 | -3.671914971309342 | -3.669035153186613 | -4.786218035589336 | -1.982147236419525 | -3.135323406855296 | -4.694138772095485 | -3.847472344965222 | -4.174791309699753 |  | DA P - NYPP W* | Peak | [NAME] | 24-Hr |  | 12
2001-09-29 00:00:00 | -0.2738669147075754 | -1.679644016631544 | -1.604848317044445 | -1.076879615031851 | -0.8728217709145287 | -1.293821932133863 | -1.916373363655474 | -3.251059500034433 | -3.781841364025823 | -4.377815235702531 | -4.784598452134826 | -5.163519077924274 | -5.193825869880499 | -5.0353366125284 | -5.134200937671821 | -4.436660259776282 | -4.593722323227357 | -4.78419923476806 | -4.711153438875041 | -4.287323201772683 | -5.737741679593853 | -5.465113572215802 | -4.014706876488177 | -3.435416378814605 |  | 31-day |  |  |  |  | 13
2001-09-30 00:00:00 | -1.660297474154772 | -1.008411842960909 | -1.43661003592992 | -2.020730402108095 | -2.090802462049295 | -1.066877960661815 | -0.3392032326334142 | -1.971950900511146 | -3.5880611917705 | -3.087384099944426 | -2.784211952832059 | -2.23720166375864 | -2.372441329968645 | -2.973828587281293 | -2.769710969108687 | -2.712030163136721 | -1.830222192782216 | -2.076683431942666 | -0.137588761470969 | -1.539489706429073 | -2.636834236407015 | -2.273447116770946 | -3.2172712495755 | -3.202471771592304 |  | 10-day |  |  |  |  | 14
2001-10-01 00:00:00 | -1.700289298806105 | -0.08313304317286452 | -0.03371065884231506 | 0.152032819414945 | 0.156290078152395 | 1.049417667958537 | 0.6943725845131361 | 2.358493089988396 | 2.380190245786537 | 2.095094119351103 | 3.122204823444328 | 2.864474112486846 | 2.051236177549711 | 1.880797033272867 | 1.271763089714497 | 0.8282498508568281 | 0.6257190101606938 | 0.507487731795571 | -0.5707392297977236 | 2.868719931951794 | 2.240853165436 | 1.094050121973062 | -1.226294179578289 | -1.649647611429419 |  | 3-day |  |  |  |  | 15
2001-10-02 00:00:00 | 1.390517334173968 | 0.6649750785348765 | 0.3470872992604246 | 0.5474860608269907 | 1.002374417969909 | 2.568168906108614 | 3.166198029188148 | 0.5756017610596622 | -0.1581917927936303 | -0.6050186084993889 | 0.3919204586272791 | 0.4057585914140134 | -0.02156971877900205 | 0.3191393483282994 | 0.1368470161416049 | -0.1156715379757323 | -0.1282476432982982 | 0.07956588424539035 | -0.7482950168687594 | 1.098996268594558 | 0.3052235980631046 | -0.7243141095078798 | -1.708147738390664 | -0.6786082136159166 |  |  |  |  |  |  | 16
2001-10-03 00:00:00 | 0.1928969831160892 | -0.2982201141554377 | 0.6183323384538291 | 0.953598256386611 | 1.222764234075159 | 2.256697002712759 | 3.69611912464508 | -0.5121168009820138 | -0.5316922579485208 | -0.1091658743910315 | 0.7767290449206499 | 0.9656780815919994 | 1.018353055333318 | 2.031212373823596 | 2.894817499129108 | 3.743888897718509 | 3.190225155838164 | 4.805825761975239 | 1.271599429326344 | 5.009194233393352 | 2.607541952196311 | 0.9043867967000168 | -0.8474895225424106 | 0.09871681319795655 |  |  |  |  |  |  | 17
2001-10-04 00:00:00 | 0.2898580359979448 | -0.5024209655341494 | -0.4071571317845688 | -0.5254550368862922 | -0.3748966607671598 | 1.547657073582119 | 0.7461458087018222 | -1.550188495743221 | -1.679128605512275 | -0.5378284523878065 | 0.4700467004423707 | 0.7124361873218596 | 0.9907509338404914 | 2.78512707321028 | 3.175463967157956 | 3.921547378217596 | 3.379725638242768 | 3.270230760226308 | 1.207404775195901 | 5.878549626224348 | 1.367179790900845 | 0.5774918182845816 | -0.1692697723165253 | -0.9518198923164327 |  | Transmission Cost: |  |  |  |  | 18
2001-10-05 00:00:00 | 1.94397993944721 | -1.075348126236733 | -1.061206155125806 | -0.8785654302232331 | -1.043418241285156 | -0.7926255893411316 | 0.04687542808504119 | -2.083228733410046 | -2.160076525699264 | 0.7637298780787951 | 1.353140132265739 | 1.086628088073127 | 1.0933846801281 | 2.421423808990721 | 4.0691196572769 | 4.568526804498589 | 2.275045996233956 | 4.126557143568412 | 3.141954705190184 | 5.29465672921711 | 3.285866255909355 | 1.256406917693685 | -1.453875857240259 | -3.0362839879154 |  | PJM to NYISO | 1.15 |  |  |  | 19
2001-10-06 00:00:00 | 3.332947735177594 | -0.1526741530262647 | -1.544306814605992 | -1.677414962412271 | -1.543821415366743 | -1.399265502021535 | -1.4656991656685 | -1.850714173719247 | -0.08464709437993534 | -0.9578108811330459 | -0.005177865483407373 | 0.3396079093106117 | -1.475409748339107 | -2.309896188508702 | -3.005484269678099 | -2.976104319464515 | -3.058608759692842 | -3.846611882380149 | -4.139096101646935 | 0.8774499783938126 | -3.149376255197467 | -3.192571744645402 | -3.091864011379801 | -1.697036212242431 |  | NYISO to PJM | 6.3 |  |  |  | 20
2001-10-07 00:00:00 | 0.1490393110101316 | -2.426419653326423 | -2.700599811646939 | -2.800517080731431 | -2.652305189294456 | -2.545246183994305 | -2.656237410257734 | -3.133113843869463 | -2.924255050363055 | -2.453484097509964 | -2.595789821534822 | -2.659613354782266 | -2.940380555358029 | -3.465996090475524 | -3.104843386107728 | -3.1992704285353 | -2.903994711620257 | -1.59397199938158 | -2.101582037061181 | 0.6964729950633171 | -1.478639294644026 | -2.729358808268245 | -2.221267502208285 | -1.993730056476185 |  |  |  |  |  |  | 21
2001-10-08 00:00:00 | 0.06795402896044322 | -1.706942275430524 | -2.286755893586196 | -2.543232501284031 | -2.80363746910529 | -0.9258255703194784 | 0.08641504140353362 | -0.4126928182896883 | -2.227803528110162 | -0.6931093958425159 | -0.6955642303953837 | -1.710380988397802 | -1.473591250093492 | -1.143785481223329 | -2.284841992888737 | -1.725980085257628 | -1.278532650268019 | -1.272161439581257 | -0.006467471186518026 | 3.387076425005645 | -0.1512963794092741 | -2.189045621177645 | -2.6788763261745 | -2.505452975782873 |  | *Statistics INCLUDE Transmission Cost $1.15 |  |  |  |  | 22
2001-10-09 00:00:00 | 2.053339639705797 | -0.3664666848213471 | -1.726863646001277 | -1.705472273065151 | -1.096864839930248 | -0.9258362664187771 | -0.244205773820422 | -1.49407982144691 | -4.936577877893516 | -3.282280139280001 | -3.656082750019021 | -3.588359193088294 | -3.069970790231498 | -2.996736197973124 | -3.209292677104543 | -3.335989838497145 | -2.808736908957844 | -3.610869244038838 | -4.988459848312232 | -2.292886066229151 | -4.75823467657052 | -4.237234645076473 | -1.584299062378925 | -2.16135868456708 |  |  |  |  |  |  | 23
2001-10-10 00:00:00 | 2.341684489450145 | 0.1158833554365941 | -1.393211769861491 | -0.7691942386424131 | -0.167698103810455 | 0.4339425276969529 | 5.979333682502784 | 2.955813662421026 | 3.0623403520685 | 4.84419333449064 | 6.454622596297849 | 11.2433704379038 | 5.764775021122752 | 5.696411109829256 | 3.971481632405347 | 3.805016054341344 | 3.968751885555843 | 3.566790565339776 | 5.877772337237424 | 18.10651535685147 | 13.96926970604466 | 6.344805676331728 | 0.8126726655942882 | -0.115994875226999 |  |  |  |  |  |  | 24
2001-10-11 00:00:00 | -0.342483627943249 | -1.43491307089818 | -2.636515216895216 | -2.765932570207315 | -1.182495693526 | 1.373943107871934 | 7.716665376065151 | -1.571659291387039 | -5.014162446051099 | -3.77670800599595 | -4.190859301927681 | -4.178947841318145 | -2.972458863089201 | -3.002439248681533 | -2.914279052494912 | -2.708789552238809 | -2.925983501068185 | -3.296711893624369 | -3.811549363560815 | -2.653773319418551 | -2.02245798639705 | -4.186866851741225 | -3.55753708823762 | -0.7036637814545692
2001-10-12 00:00:00 | 0.2464176346566944 | -1.760660787045875 | -1.780020713797459 | -1.070037479230258 | -0.2134905575996626 | 0.7006338043982687 | 4.249491540408592 | -1.644132462576874 | -2.459599868895829 | -1.871493602511151 | 0.06584685767150233 | 0.6601268049703819 | 1.149741455011686 | 1.21036804223187 | 0.6629621669187529 | -1.327298292407562 | -1.339147547574754 | -0.2575998114601639 | -0.3300902232917053 | 1.675165340011581 | 1.440201516103219 | -0.6801019506973169 | -0.8932249382195749 | -0.287521595027691
2001-10-13 00:00:00 | -1 | -1.25 | -1.42 | -1.25 | -1.364646422573657 | -1.914618776869276 | -2.250823094533001 | -1.68545729905712 | -0.7716992820371544 | 0.6168846892440598 | 1.755197418668892 | 1.050551304551306 | 0.1041895160480948 | -0.0736761013813414 | -0.2649770958099111 | -0.5220459546969742 | -0.4447366497475791 | -0.712841966061383 | 1.390025756190362 | 10.31276495774288 | 1.623932649675474 | 0.476083632844901 | -1.492585746923666 | 1.218431867568714
2001-10-14 00:00:00 | -1.132009864620304 | -1.520937798375529 | -1.08 | -1.44 | -1.45 | -1.9 | -1.5 | -2.362003735757931 | -2.651000068104999 | -2.284228269685293 | -1.938777524226211 | -1.393594890638063 | -1.284269061011948 | -1.315824729554155 | -1.784287965755759 | -2.079072776045567 | -1.755157922113952 | -1.339833441857099 | -0.7275627237726638 | 6.353796761603512 | 1.701919476671797 | -1.665488428581067 | -2.002727643227232 | -0.8914015980177687
2001-10-15 00:00:00 | 3.541331342492562 | -0.9377234127051217 | -1.200395429095998 | -0.9876101101101078 | -0.7244275693106665 | -0.976560940028719 | -1.212652529339 | -1.221960474319861 | -2.504833120461999 | -1.496317008804432 | -1.707596339292074 | -1.68902811043915 | -2.040264182456617 | -1.994776607440912 | -2.055197385388663 | -3.091893691716319 | -2.48589954893184 | -2.393939746113755 | 0.2039054868925483 | 4.722513545678623 | 1.18584331021443 | -1.753246491307962 | -1.374246459369296 | -2.182933132118325
2001-10-16 00:00:00 | 3.449770992971001 | -1.403123629968919 | -1.135263863803736 | -1.240711307130482 | -0.9469916228612991 | -1.123040576985026 | -2.564223182335386 | -3.625446250959161 | -3.508767209549845 | -3.001694520037976 | -2.974724833002295 | -3.671238917640956 | -3.842618588596558 | -3.086385415464513 | -3.566020130718201 | -3.58956191147956 | -3.704317249547856 | -3.615743986925477 | 1.441012783655964 | 2.249309072664751 | -0.6752462401415009 | -2.953898523892473 | -2.321992282381849 | -2.68800384136674
 | 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