Spreadsheet: 840308d1692635899-correlation-formula-finding-the-correlation
Sheet: Sheet1

 | Day Ahead Prices
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  |  |  | Day Ahead over Real time price spread
2023-08-01 00:00:00 | 24.63 | 21.8 | 18.13 | 18.02 | 17.97 | 19.12 | 17.01 | 16.26 | 17 | 18.95 | 22.17 | 32.76 | 44.25 | 64 | 93.09 | 118.72 | 135 | 132.92 | 108.89 | 194.01 | 141.54 | 43.39 | 33.51 | 28.56 |  |  |  | 7
2023-08-02 00:00:00 | 22.6 | 21.83 | 20.08 | 19.01 | 19.5 | 20 | 19.04 | 18.53 | 18.69 | 19.06 | 24 | 26.83 | 37 | 64.7 | 90.4 | 118.08 | 139.33 | 117.58 | 125.38 | 197.89 | 139.34 | 44.11 | 30.04 | 26.06 |  |  | 2023-08-01 00:00:00
2023-08-03 00:00:00 | 24.44 | 21.88 | 20.5 | 19.04 | 19 | 20.43 | 20.06 | 20.64 | 20.64 | 19.84 | 23.45 | 29.45 | 43.05 | 73.78 | 150 | 250.26 | 300 | 201.76 | 200 | 339.45 | 192.08 | 47.85 | 33.34 | 27.27 |  |  | 2023-08-02 00:00:00
2023-08-04 00:00:00 | 23.68 | 20.41 | 18.24 | 17.48 | 17.79 | 19.53 | 19.45 | 19.52 | 19.8 | 20.21 | 23.87 | 29.1 | 49.87 | 100.39 | 255.91 | 343.42 | 433.62 | 355.37 | 387.23 | 742.72 | 355.18 | 60.93 | 35.04 | 27.77 |  |  | 2023-08-03 00:00:00
2023-08-05 00:00:00 | 24.18 | 20.77 | 17.68 | 15.94 | 15.53 | 15.71 | 13.9 | 14.19 | 14.63 | 16.03 | 20.71 | 23.03 | 33.83 | 54.65 | 93.87 | 118.61 | 150 | 150.48 | 167.25 | 290.12 | 177.29 | 40.93 | 29.21 | 25.6 |  |  | 2023-08-04 00:00:00
2023-08-06 00:00:00 | 21.89 | 19.36 | 16.49 | 15.39 | 15.48 | 15.65 | 15.24 | 15.5 | 15.99 | 17.7 | 21.46 | 27.88 | 37.74 | 93 | 224.11 | 559.23 | 1200.1 | 1516.79 | 1997.36 | 2571.54 | 1468.15 | 114.93 | 36.28 | 26.31 |  |  | 2023-08-05 00:00:00
2023-08-07 00:00:00 | 22.23 | 20 | 18.56 | 17.85 | 18.25 | 19.81 | 22.07 | 21.91 | 20.33 | 22.17 | 25.42 | 37.8 | 60.3 | 171.15 | 531.25 | 936.62 | 592.74 | 439.33 | 316.99 | 513.19 | 187.6 | 50 | 28.14 | 23.33 |  |  | 2023-08-06 00:00:00
2023-08-08 00:00:00 | 25.7 | 24.16 | 23.09 | 23.05 | 20.99 | 21.43 | 21.37 | 19.95 | 19.78 | 19.99 | 21.55 | 26.13 | 32.1 | 55.2 | 116.12 | 186.27 | 214.14 | 205.47 | 194.77 | 303.96 | 111.94 | 36.75 | 28.4 | 24.19 |  |  | 2023-08-07 00:00:00
2023-08-09 00:00:00 | 21.95 | 20.01 | 19.61 | 18.65 | 18.54 | 18.97 | 17.76 | 17.75 | 17.6 | 17.79 | 20.64 | 28 | 30 | 64.95 | 132.62 | 213.87 | 318.74 | 359.53 | 463.76 | 768.49 | 281.47 | 54.22 | 37.14 | 29.78 |  |  | 2023-08-08 00:00:00
2023-08-10 00:00:00 | 26.51 | 24.46 | 23.69 | 22.07 | 21.91 | 22.35 | 22.35 | 22.45 | 21.01 | 22 | 30.7 | 41.87 | 70 | 193.25 | 517.3 | 1045.4399 | 1555.75 | 1677.84 | 1600 | 2585.8999 | 783.25 | 99.99 | 35.76 | 28.45 |  |  | 2023-08-09 00:00:00
2023-08-11 00:00:00 | 26.47 | 23.56 | 19.58 | 18.43 | 18.29 | 19.7 | 19.86 | 19.7 | 18.11 | 17.55 | 20 | 28.27 | 41 | 65 | 188.94 | 333.96 | 484.2 | 401.21 | 400 | 733.35 | 256.72 | 52.99 | 32.6 | 27.97 |  |  | 2023-08-10 00:00:00
2023-08-12 00:00:00 | 26.68 | 23.67 | 19.17 | 18.54 | 18.73 | 17.46 | 16.91 | 17.13 | 17.21 | 16.65 | 19.42 | 27.94 | 33.89 | 65 | 141.83 | 257.61 | 356.09 | 318.81 | 302.93 | 590.59 | 210.7 | 52.25 | 36.77 | 27.59 |  |  | 2023-08-11 00:00:00
2023-08-13 00:00:00 | 26.88 | 23.12 | 22.23 | 20.78 | 18.96 | 18 | 16.98 | 16.82 | 16.14 | 15.63 | 17.88 | 25.41 | 32.98 | 57.81 | 115.68 | 266.48 | 365.7 | 359.32 | 374.36 | 783 | 294.68 | 49.96 | 32.72 | 27.28 |  |  | 2023-08-12 00:00:00
2023-08-14 00:00:00 | 24.96 | 22.66 | 20.22 | 20.27 | 20.62 | 22.05 | 23.23 | 22.31 | 19.76 | 18.78 | 25.38 | 30 | 32.27 | 61.79 | 146.92 | 298.99 | 371.69 | 322.38 | 389.54 | 1027.26 | 321.72 | 71.92 | 34.9 | 30.58 |  |  | 2023-08-13 00:00:00
2023-08-15 00:00:00 | 27.47 | 24.41 | 23.09 | 23.03 | 22.86 | 23.94 | 25.19 | 25.47 | 24.32 | 24.72 | 29.85 | 43.9 | 50 | 168.84 | 400.34 | 1041.16 | 1557.04 | 2004.83 | 2495.49 | 3310.3899 | 1495.2 | 70 | 32.51 | 27.55 |  |  | 2023-08-14 00:00:00
2023-08-16 00:00:00 | 24.42 | 21.34 | 19.09 | 18.87 | 18.43 | 19 | 19 | 19.03 | 19 | 19 | 20 | 25 | 28.85 | 50.86 | 100 | 330.36 | 494.13 | 911.92 | 1117.65 | 1994.17 | 585.58 | 37.88 | 24.72 | 22.72 |  |  | 2023-08-15 00:00:00
2023-08-17 00:00:00 | 18.01 | 15.76 | 15.14 | 14.62 | 15 | 16.41 | 17.02 | 16.95 | 17.54 | 17.52 | 22.12 | 32.38 | 49.7 | 272.1 | 804.81 | 1881.55 | 2224.79 | 2608.6001 | 3001.55 | 3339.8501 | 1511.98 | 65.16 | 35.14 | 26.92 |  |  | 2023-08-16 00:00:00
2023-08-18 00:00:00 | 24.08 | 20.82 | 18.55 | 17.75 | 18.59 | 20.21 | 20 | 19.3 | 18.45 | 21.1 | 29.24 | 41.62 | 71 | 213.03 | 626.04 | 1089.95 | 917.74 | 789.96 | 749.72 | 930.49 | 319.85 | 48.45 | 32 | 25.88 |  |  | 2023-08-17 00:00:00
2023-08-19 00:00:00 | 21.96 | 19.21 | 16.81 | 15.68 | 15.91 | 16.52 | 15 | 15 | 15.48 | 17.29 | 21 | 30.15 | 40.43 | 76.16 | 124.86 | 206.78 | 270.93 | 217.3 | 253.6 | 451.23 | 184.95 | 43.72 | 35.46 | 27.27 |  |  | 2023-08-18 00:00:00
2023-08-20 00:00:00 | 22.41 | 20.46 | 19.17 | 18.13 | 17.74 | 18.19 | 15.9 | 16.33 | 16.81 | 19.05 | 22.78 | 31.83 | 45 | 71 | 100 | 200.84 | 250 | 285.54 | 319.51 | 1000.33 | 675.58 | 129.47 | 59.26 | 41.84 |  |  | 2023-08-19 00:00:00
2023-08-21 00:00:00 | 44.05 | 33.16 | 31.19 | 27.74 | 29.03 | 32.64 | 28.48 | 27.2 | 25.37 | 26.31 | 35.61 | 49.55 | 33.43 | 46.77 | 82.06 | 85.48 | 97.73 | 93.2 | 112.94 | 177.76 | 120.11 | 39.46 | 44 | 31.11 |  |  | 2023-08-20 00:00:00
 | Real Time Prices
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
2023-08-01 00:00:00 | 21.46 | 20.205 | 19.17 | 18.045 | 18.245 | 19.925 | 20.83 | 20.5825 | 20.945 | 20.89 | 23.49 | 30.41 | 53.155 | 182.96 | 86.87 | 71.9275 | 40.2375 | 33.35 | 39.6925 | 40.07 | 57.0475 | 39.795 | 107.34 | 28.37
2023-08-02 00:00:00 | 24.2825 | 22.95 | 22.4025 | 23.045 | 23.4225 | 24.2325 | 24.355 | 23.19 | 22.4975 | 21.2175 | 22.1675 | 30.8725 | 48.8625 | 59.62 | 144.56 | 58.3625 | 43.2675 | 50.9925 | 82.3675 | 174.9 | 149.3275 | 34.3225 | 33.32 | 24.52
2023-08-03 00:00:00 | 22.5675 | 20.1625 | 18.7575 | 18.48 | 18.72 | 20.94 | 21.5375 | 19.8725 | 18.9275 | 17.9425 | 18.605 | 23.795 | 38.59 | 90.0575 | 93.3725 | 142.4225 | 109.655 | 114.13 | 148.575 | 320.2725 | 285.4 | 35.9675 | 25.1 | 22.57
2023-08-04 00:00:00 | 20.205 | 18.145 | 16.6175 | 16.1525 | 16.5825 | 18.7625 | 21 | 20.535 | 19.215 | 18.6075 | 22.3725 | 44.075 | 69.245 | 145.7825 | 580.8975 | 1030.26 | 2247.1526 | 1342.0625 | 1447.5625 | 1398.6625 | 339.0475 | 75.7775 | 30.4975 | 24.1825
2023-08-05 00:00:00 | 21.895 | 20.66 | 18.405 | 16.66 | 15.1475 | 15.6875 | 16.335 | 16.445 | 16.315 | 16.33 | 20.955 | 24.21 | 27.035 | 31.425 | 43.67 | 43.3175 | 30.0175 | 39.8075 | 53.87 | 84.9725 | 51.16 | 24.7125 | 23.6225 | 22.0275
2023-08-06 00:00:00 | 19.6075 | 17.8475 | 15.875 | 16.3925 | 18.5775 | 18.4825 | 18.3475 | 17.7475 | 15.43 | 13.75 | 18.045 | 21.1375 | 23.1975 | 25.75 | 29.905 | 42.1575 | 52.4375 | 84.635 | 223.4475 | 1464.3325 | 528.3825 | 34.6625 | 23.795 | 22.585
2023-08-07 00:00:00 | 21.465 | 19.4175 | 18.92 | 20.8325 | 21.9325 | 24.4725 | 24.8925 | 23.7625 | 21.525 | 20.1425 | 24.715 | 27.9275 | 43.4725 | 69.2475 | 155.9425 | 556.8475 | 1426.33 | 782.255 | 668.3825 | 1121.135 | 123.63 | 44.9425 | 45.36 | 33.0375
2023-08-08 00:00:00 | 33.8075 | 33.745 | 30.1875 | 21.6825 | 21.015 | 17.915 | 20.15 | 22.165 | 21.565 | 22.6425 | 26.1625 | 28.2225 | 56.265 | 161.45 | 272.975 | 960.65 | 599.5625 | 84.49 | 107.955 | 1434.225 | 520.2125 | 56.29 | 26.995 | 24.18
2023-08-09 00:00:00 | 21.195 | 21.525 | 21.1325 | 20.925 | 20.03 | 18.6225 | 18.7225 | 18.725 | 16.655 | 16.9675 | 19.01 | 20.9075 | 22.8075 | 26.3925 | 39.715 | 31.415 | 58.7125 | 93.16 | 344.0425 | 1169.8525 | 297.015 | 37.805 | 23.055 | 24.5875
2023-08-10 00:00:00 | 27.5075 | 27.06 | 30.9075 | 27.955 | 26.8075 | 27.5275 | 28.4225 | 27.4025 | 26.095 | 28.845 | 31.7275 | 34.58 | 58.8425 | 249.6575 | 1638.6851 | 3547.875 | 3278.0325 | 2339.2524 | 1058.5975 | 931.49 | 284.3925 | 33.11 | 40.7825 | 32.6525
2023-08-11 00:00:00 | 30.6725 | 28.73 | 26.8525 | 24.0875 | 22.59 | 22.35 | 22.24 | 22.0275 | 21.2975 | 20.7425 | 23.4025 | 32.38 | 48.795 | 78.14 | 176.3325 | 693.03 | 1092.1949 | 1643.7125 | 741.5775 | 1047.4025 | 130.385 | 31.44 | 29.75 | 28.03
2023-08-12 00:00:00 | 27.3075 | 23.885 | 22.4425 | 21.365 | 21.175 | 20.4925 | 19.6125 | 18.8775 | 16.705 | 17.4675 | 17.9225 | 22.01 | 26.46 | 41.21 | 76.66 | 102.505 | 276.895 | 106.565 | 719.44 | 1352.645 | 273.9025 | 33.0775 | 28.2325 | 24.315
2023-08-13 00:00:00 | 25.0725 | 23.89 | 23.6275 | 22.9075 | 23.2825 | 21.6 | 20.8725 | 18.0425 | 13.625 | 12.995 | 16.7425 | 19.96 | 26.4725 | 36.0125 | 35.69 | 62.4175 | 90.0875 | 227.21 | 305.41 | 745.3325 | 725.325 | 46.815 | 27.51 | 24.8475
2023-08-14 00:00:00 | 21.3525 | 21.32 | 20.7575 | 21.2325 | 21.9575 | 25.1375 | 25.1725 | 22.7575 | 19.8325 | 14.8925 | 19.4875 | 26.175 | 39.635 | 29.3 | 31.575 | 30.695 | 28.08 | 26.085 | 25.135 | 28.2625 | 29.33 | 28.6 | 29.4575 | 27.4175
2023-08-15 00:00:00 | 26.6575 | 24.63 | 24.0325 | 23.255 | 23.8975 | 25.745 | 27.56 | 26.41 | 23.77 | 22.26 | 24.235 | 26.6975 | 27.8875 | 38.2025 | 38.395 | 71.1575 | 70.8775 | 55.45 | 97.0875 | 322.49 | 128.47 | 39.875 | 26.54 | 21.265
2023-08-16 00:00:00 | 18.9925 | 17.635 | 13.5825 | 12.99 | 12.7675 | 13.5 | 15.8375 | 15.1625 | 13.1875 | 13.2175 | 17.405 | 20.61 | 23.385 | 28.06 | 34.9625 | 65.1175 | 74.1425 | 77.545 | 106.7475 | 111.8425 | 42.875 | 22.3975 | 19.89 | 13.8525
2023-08-17 00:00:00 | 10.3475 | 11.105 | 8.585 | 6.8925 | 10.39 | 12.415 | 14.2875 | 13.4125 | 13.9075 | 16.77 | 20.4525 | 27.115 | 44.95 | 530.815 | 2387.4075 | 2140.0576 | 2402.3774 | 3970.2424 | 1889.16 | 5180.645 | 3302.4099 | 97.0425 | 62.2475 | 38.115
2023-08-18 00:00:00 | 24.1825 | 21.0525 | 19.7675 | 18.4 | 18.3125 | 19.475 | 20.9875 | 20.6375 | 20.085 | 21.2975 | 24.6275 | 33.3425 | 70.5275 | 73.89 | 104.2925 | 86.6625 | 94.6625 | 100.62 | 135.44 | 167.945 | 57.5925 | 26.465 | 24.0575 | 21.975
2023-08-19 00:00:00 | 19.75 | 17.4225 | 14.6075 | 13.195 | 13.2175 | 14.515 | 16.165 | 16.6125 | 17.4925 | 22.515 | 25.945 | 34.8725 | 35.06 | 34.505 | 37.6775 | 45.365 | 40.9075 | 41.375 | 67.24 | 149.4325 | 146.64 | 31.7875 | 27.3275 | 24.725
2023-08-20 00:00:00 | 22.31 | 20.81 | 19.855 | 19.5775 | 20.3475 | 21.3725 | 21.8675 | 21.9025 | 21.7275 | 24.0675 | 28.465 | 28.1075 | 39.6675 | 68.8575 | 55.49 | 119.265 | 69.1825 | 64.495 | 278.5025 | 435.2325 | 1004.675 | 198.205 | 57.6625 | 32.6175
slope
intercept
corr (=r)
R2