Spreadsheet: louise_kitchen__22604__ERCOT_PvsGAS1_7-30
Sheet: Historical

TRADE_DT | PWR_PRICE | GAS_PRICE | Delta | Implied HR |  |  |  | Correlation
2000-07-20 00:00:00 | 97.5 | 4.06 |  |  |  |  | 7/25/00 to 7/25/01
2000-07-21 00:00:00 | 56.25 | 3.91
2000-07-24 00:00:00 | 61.33 | 3.9
2000-07-25 00:00:00 | 50.25 | 3.74
2000-07-26 00:00:00 | 48.63 | 3.63
2000-07-27 00:00:00 | 47.72 | 3.575
2000-07-28 00:00:00 | 49.1 | 3.755
2000-07-31 00:00:00 | 47.42 | 3.885
2000-08-01 00:00:00 | 44.26 | 3.76
2000-08-02 00:00:00 | 43.64 | 3.765
2000-08-03 00:00:00 | 47.81 | 4.035
2000-08-04 00:00:00 | 45.33 | 4.21
2000-08-08 00:00:00 | 56.25 | 4.395
2000-08-09 00:00:00 | 55.56 | 4.45
2000-08-10 00:00:00 | 50.11 | 4.445
2000-08-11 00:00:00 | 49.76 | 4.46
2000-08-14 00:00:00 | 49.57 | 4.425
2000-08-15 00:00:00 | 44.94 | 4.415
2000-08-16 00:00:00 | 44 | 4.235
2000-08-17 00:00:00 | 42.81 | 4.23
2000-08-18 00:00:00 | 44.2 | 4.365
2000-08-21 00:00:00 | 44.31 | 4.38
2000-08-22 00:00:00 | 50 | 4.585
2000-08-23 00:00:00 | 50.14 | 4.735
2000-08-24 00:00:00 | 50.6 | 4.71
2000-08-25 00:00:00 | 56 | 4.475
2000-08-28 00:00:00 | 54.75 | 4.505
2000-08-29 00:00:00 | 54.71 | 4.65
2000-08-30 00:00:00 | 58.19 | 4.62
2000-09-07 00:00:00 | 72.8 | 4.89
2000-09-08 00:00:00 | 55.96 | 4.85
2000-09-11 00:00:00 | 50.25 | 4.735
2000-09-12 00:00:00 | 50.6 | 4.88
2000-09-13 00:00:00 | 49.96 | 4.97
2000-09-14 00:00:00 | 49.68 | 5.055
2000-09-15 00:00:00 | 50.1 | 5.105
2000-09-18 00:00:00 | 49.44 | 5.26
2000-09-19 00:00:00 | 48.09 | 5.07
2000-09-20 00:00:00 | 47.18 | 5.215
2000-09-21 00:00:00 | 47.37 | 5.25
2000-09-22 00:00:00 | 47.17 | 5.185
2000-09-25 00:00:00 | 47.96 | 5.165
2000-09-26 00:00:00 | 47.02 | 5.12
2000-09-27 00:00:00 | 44.67 | 5.27
2000-09-28 00:00:00 | 42.8 | 5.33
2000-09-29 00:00:00 | 41.64 | 5.185
2000-10-02 00:00:00 | 55.63 | 5.11
2000-10-03 00:00:00 | 56.29 | 5.23
2000-10-04 00:00:00 | 57.75 | 5.245
2000-10-05 00:00:00 | 60.21 | 5.215
2000-10-06 00:00:00 | 51.81 | 5.21
2000-10-09 00:00:00 | 47.67 | 5.045
2000-10-10 00:00:00 | 48.13 | 5.075
2000-10-11 00:00:00 | 49.27 | 5.08
2000-10-12 00:00:00 | 45.69 | 5.175
2000-10-13 00:00:00 | 48.73 | 5.565
2000-10-16 00:00:00 | 50.2 | 5.425
2000-10-17 00:00:00 | 55 | 5.32
2000-10-18 00:00:00 | 54.33 | 5.275
2000-10-19 00:00:00 | 54.96 | 5.375
2000-10-20 00:00:00 | 55.17 | 5.065
2000-10-23 00:00:00 | 53.3 | 4.895
2000-10-24 00:00:00 | 54 | 4.82
2000-10-25 00:00:00 | 54.75 | 4.86
2000-10-26 00:00:00 | 53 | 4.675
2000-10-30 00:00:00 | 51 | 4.5
2000-10-31 00:00:00 | 51.63 | 4.595
2000-11-01 00:00:00 | 49.39 | 4.335
2000-11-02 00:00:00 | 47.83 | 4.405
2000-11-03 00:00:00 | 45.57 | 4.505
2000-11-06 00:00:00 | 47.46 | 4.61
2000-11-07 00:00:00 | 49.09 | 4.64
2000-11-08 00:00:00 | 49.86 | 4.685
2000-11-09 00:00:00 | 50.98 | 4.965
2000-11-10 00:00:00 | 50.41 | 5.345
2000-11-13 00:00:00 | 48.93 | 5.24
2000-11-14 00:00:00 | 50.73 | 5.58
2000-11-15 00:00:00 | 50.07 | 5.79
2000-11-16 00:00:00 | 49.53 | 5.92
2000-11-17 00:00:00 | 50.65 | 5.925
2000-11-20 00:00:00 | 49.89 | 5.65
2000-11-21 00:00:00 | 51.05 | 6.22
2000-11-22 00:00:00 | 51.42 | 6.305
2000-11-27 00:00:00 | 50.05 | 6.31
2000-11-28 00:00:00 | 51.81 | 6.245
2000-11-29 00:00:00 | 54.58 | 5.97
2000-11-30 00:00:00 | 52.18 | 5.985
2000-12-01 00:00:00 | 54.36 | 6.295
2000-12-04 00:00:00 | 55.13 | 6.605
2000-12-05 00:00:00 | 65.33 | 7.495
2000-12-06 00:00:00 | 65.89 | 7.955
2000-12-07 00:00:00 | 72.62 | 8.94
2000-12-08 00:00:00 | 82.31 | 8.835
2000-12-11 00:00:00 | 65.59 | 8.09
2000-12-12 00:00:00 | 82.87 | 9.985
2000-12-13 00:00:00 | 81.14 | 8.865
2000-12-14 00:00:00 | 59.53 | 7.915
2000-12-15 00:00:00 | 61.14 | 7.495
2000-12-18 00:00:00 | 65.14 | 8.04
2000-12-19 00:00:00 | 90 | 9.27
2000-12-20 00:00:00 | 76.88 | 9.16
2000-12-21 00:00:00 | 73 | 10.05
2000-12-27 00:00:00 | 80 | 10.24
2000-12-28 00:00:00 | 82.5 | 9.765
2000-12-29 00:00:00 | 87.5 | 9.2
2001-01-02 00:00:00 | 90 | 10.5
2001-01-03 00:00:00 | 86.48 | 9.495
2001-01-04 00:00:00 | 91.44 | 9.565
2001-01-05 00:00:00 | 85.82 | 9.525
2001-01-08 00:00:00 | 81.4 | 9.95
2001-01-09 00:00:00 | 76 | 10.265
2001-01-10 00:00:00 | 77.92 | 9.965
2001-01-11 00:00:00 | 74.2 | 9.885
2001-01-12 00:00:00 | 71.38 | 9.025
2001-01-18 00:00:00 | 66.57 | 7.965
2001-01-19 00:00:00 | 65 | 7.07
2001-01-22 00:00:00 | 70.67 | 7.57
2001-01-23 00:00:00 | 68.45 | 7.68
2001-01-24 00:00:00 | 68.5 | 7.175
2001-01-25 00:00:00 | 66.5 | 6.925
2001-01-26 00:00:00 | 64 | 7.295
2001-01-29 00:00:00 | 59.8 | 7.01
2001-01-30 00:00:00 | 54.4 | 6.68
2001-01-31 00:00:00 | 50.4 | 5.995
2001-02-01 00:00:00 | 52.67 | 5.9
2001-02-02 00:00:00 | 52.68 | 5.89
2001-02-05 00:00:00 | 57.56 | 6.625
2001-02-06 00:00:00 | 53.23 | 5.885
2001-02-07 00:00:00 | 51.14 | 5.61
2001-02-08 00:00:00 | 45 | 5.685
2001-02-12 00:00:00 | 46.42 | 6.035
2001-02-13 00:00:00 | 46.2 | 5.67
2001-02-14 00:00:00 | 44.1 | 5.65
2001-02-15 00:00:00 | 45 | 5.825
2001-02-16 00:00:00 | 44.75 | 5.39
2001-02-20 00:00:00 | 46.04 | 5.46
2001-02-21 00:00:00 | 46.73 | 5.23
2001-02-22 00:00:00 | 46.06 | 5.19
2001-02-23 00:00:00 | 44.33 | 5.095
2001-02-26 00:00:00 | 45.93 | 5.055
2001-02-27 00:00:00 | 45.35 | 5.07
2001-02-28 00:00:00 | 47 | 5.115
2001-03-01 00:00:00 | 51.15 | 5.17
2001-03-02 00:00:00 | 53.6 | 5.065
2001-03-05 00:00:00 | 53.19 | 5.11
2001-03-06 00:00:00 | 49.27 | 5.315
2001-03-07 00:00:00 | 51.42 | 5.265
2001-03-08 00:00:00 | 48.32 | 5.225
2001-03-09 00:00:00 | 48.2 | 5.25
2001-03-12 00:00:00 | 45.66 | 5.09
2001-03-13 00:00:00 | 43.06 | 4.99
2001-03-14 00:00:00 | 41.95 | 5.02
2001-03-15 00:00:00 | 39 | 5
2001-03-16 00:00:00 | 39.44 | 4.91
2001-03-19 00:00:00 | 40.6 | 4.985
2001-03-20 00:00:00 | 43.5 | 5.065
2001-03-21 00:00:00 | 42.81 | 5.08
2001-03-22 00:00:00 | 43.07 | 5.17
2001-03-23 00:00:00 | 41.43 | 5.06
2001-03-26 00:00:00 | 44.26 | 5.2
2001-03-27 00:00:00 | 44.61 | 5.22
2001-03-28 00:00:00 | 44.84 | 5.405
2001-03-29 00:00:00 | 45.17 | 5.6
2001-03-30 00:00:00 | 45.23 | 5.325
2001-04-02 00:00:00 | 45.91 | 5.315
2001-04-03 00:00:00 | 46.24 | 5.02
2001-04-04 00:00:00 | 48.25 | 5.21
2001-04-05 00:00:00 | 50.87 | 5.225
2001-04-06 00:00:00 | 51.23 | 5.25
2001-04-09 00:00:00 | 52.45 | 5.345
2001-04-10 00:00:00 | 56.75 | 5.445
2001-04-11 00:00:00 | 55.73 | 5.525
2001-04-12 00:00:00 | 57.16 | 5.47
2001-04-16 00:00:00 | 54.17 | 5.375
2001-04-17 00:00:00 | 53.48 | 5.475
2001-04-18 00:00:00 | 53.21 | 5.36
2001-04-19 00:00:00 | 51.86 | 5.17
2001-04-20 00:00:00 | 50.58 | 5.07
2001-04-23 00:00:00 | 54.89 | 5.005
2001-04-24 00:00:00 | 46.28 | 5.07
2001-04-25 00:00:00 | 43.67 | 5.075
2001-04-26 00:00:00 | 42.83 | 5.015
2001-04-27 00:00:00 | 42.83 | 4.91
2001-04-30 00:00:00 | 44.83 | 4.83
2001-05-01 00:00:00 | 46.52 | 4.735
2001-05-02 00:00:00 | 48.08 | 4.555
2001-05-03 00:00:00 | 49.43 | 4.525
2001-05-04 00:00:00 | 47.66 | 4.465
2001-05-07 00:00:00 | 45.13 | 4.495
2001-05-08 00:00:00 | 43.03 | 4.3
2001-05-09 00:00:00 | 42.25 | 4.22
2001-05-10 00:00:00 | 45.4 | 4.165
2001-05-11 00:00:00 | 44.56 | 4.19
2001-05-14 00:00:00 | 45.21 | 4.24
2001-05-15 00:00:00 | 48.57 | 4.27
2001-05-16 00:00:00 | 56.34 | 4.485
2001-05-17 00:00:00 | 55.79 | 4.47
2001-05-18 00:00:00 | 52.89 | 4.195
2001-05-21 00:00:00 | 43.95 | 4.16
2001-05-22 00:00:00 | 40.4 | 4.145
2001-05-23 00:00:00 | 39.06 | 4.05
2001-05-24 00:00:00 | 38.51 | 4.105
2001-05-25 00:00:00 | 38.54 | 4.125
2001-05-29 00:00:00 | 39.31 | 3.845
2001-05-30 00:00:00 | 38.2 | 3.865
2001-05-31 00:00:00 | 35.12 | 3.665
2001-06-01 00:00:00 | 37.36 | 3.73
2001-06-04 00:00:00 | 37.31 | 3.745
2001-06-05 00:00:00 | 39.14 | 3.945
2001-06-06 00:00:00 | 38.83 | 3.92
2001-06-07 00:00:00 | 35.99 | 3.76
2001-06-08 00:00:00 | 35.56 | 3.68
2001-06-11 00:00:00 | 38.39 | 3.61
2001-06-12 00:00:00 | 38.17 | 3.82
2001-06-13 00:00:00 | 40.64 | 4.12
2001-06-14 00:00:00 | 41.17 | 4.125
2001-06-15 00:00:00 | 41.07 | 4.025
2001-06-18 00:00:00 | 41.46 | 3.855
2001-06-19 00:00:00 | 42.49 | 3.935
2001-06-20 00:00:00 | 42.42 | 3.935
2001-06-21 00:00:00 | 41.11 | 3.815
2001-06-22 00:00:00 | 39.06 | 3.71
2001-06-25 00:00:00 | 39.63 | 3.705
2001-06-26 00:00:00 | 38.17 | 3.58
2001-06-27 00:00:00 | 37.69 | 3.46
2001-06-28 00:00:00 | 35.67 | 3.425
2001-06-29 00:00:00 | 35.08 | 3.215
2001-07-02 00:00:00 | 37.14 | 2.97
2001-07-03 00:00:00 | 34.1 | 3
2001-07-05 00:00:00 | 32 | 3.03
2001-07-06 00:00:00 | 32.85 | 3.035
2001-07-09 00:00:00 | 34.56 | 2.985
2001-07-10 00:00:00 | 37.98 | 3.135
2001-07-11 00:00:00 | 38.66 | 3.175
2001-07-12 00:00:00 | 39.12 | 3.19
2001-07-13 00:00:00 | 39.56 | 3.29
2001-07-16 00:00:00 | 37.88 | 3.155
2001-07-17 00:00:00 | 37.43 | 3.155
2001-07-18 00:00:00 | 37.26 | 3.12
2001-07-19 00:00:00 | 41.03 | 3.14
2001-07-20 00:00:00 | 39.26 | 3.015
2001-07-23 00:00:00 | 39.2 | 2.96
2001-07-24 00:00:00 | 42.07 | 3.005
2001-07-25 00:00:00 | 47.44 | 3.01
[NAME]
2000-09-05 00:00:00 |  |  | 142.775 | 31.34537725823592
2000-09-01 00:00:00 |  |  | 135.23 | 29.35010482180294
2000-09-06 00:00:00 |  |  | 118.955 | 25.80813347236705
2001-07-05 00:00:00 |  |  |  | 28.97 | Delta
2001-07-06 00:00:00 |  |  |  | 29.815
2001-07-03 00:00:00 |  |  |  | 31.1
2001-02-09 00:00:00 |  |  |  | 7.150399999999999 | HR
2000-12-22 00:00:00 |  |  |  | 7.194244604316546
2001-01-16 00:00:00 |  |  |  | 7.252709640616087