⚠️ Disclaimer:
NordPool's terms of service states the following:
"Nord Pool does not permit automatic extraction of data or other usage that reduces the performance of the website. Any such extraction or usage will lead to the user being blocked from the website without further notice."
Read the Terms and Conditions here: https://www.nordpoolgroup.com/en/About-us/Terms-and-conditions-for-use/
Get energy rates hourly using NordPool's "website API" using PowerShell
No additional modules required.
The script only uses Invoke-WebRequest, and built in functionality.
.SYNOPSIS
Retrives hourly energy rates from NordPool.
Returns 24 hours of rates.
.DESCRIPTION
Script to get hourly energy rates from NordPool.
Written by: Magnus Børnes
https://github.com/magnusbornes
DISCLAIMER:
NordPool's terms of service states the following:
"Nord Pool does not permit automatic extraction of data or other usage that reduces the performance of the website. Any such extraction or usage will lead to the user being blocked from the website without further notice."
Read the Terms and Conditions here: https://www.nordpoolgroup.com/en/About-us/Terms-and-conditions-for-use/
Use at your own risk.
.PARAMETER Date
Specifies the date to be requested.
Function returns 24 hours.
You can use (Get-Date).AddDays(1) to get tomorrow's rates.
Day ahead rates are usually published around 13:15 (1:15 PM).
All hours in output are in CET/CEST (+1:00/+2:00)
.PARAMETER Currency
Specifies the Currency.
Allowed Currencies includes EUR, DKK, SEK and NOK.
Note: EUR must be used to retrive rates from areas AT, BE, DE-LU, FR and NL.
.PARAMETER IncludeStats
Switch parameter
Use to include values for Max, Min, Peak (08:00-20:00), Offpeak 1 (00:00-08:00) and Offpeak 2 (20:00-00:00).
.PARAMETER IncludeStatsOnly
Switch parameter
Use to include stats values for Max, Min, Peak (08:00-20:00), Offpeak 1 (00:00-08:00) and Offpeak 2 (20:00-00:00).
And exclude hourly rates.
.PARAMETER kWh
Converts Output from MWh til kWh.
.INPUTS
None. You cannot pipe objects to this function
.OUTPUTS
PSCustomObject.
Script returns a object with 24 objects (23/25 if daylight savings time removed/added).
All hours in output are in CET/CEST (+1:00/+2:00)
.EXAMPLE
./Get-NordPoolRates.ps1 -Date (Get-Date).AddDays(1) -Currency NOK -kWh
StartTime EndTime Unit Name SYS SE1 SE2 AT BE DE-LU FR NL
--------- ------- ---- ---- --- --- --- -- -- ----- -- --
12/10/2022 12:00:00 AM 12/10/2022 1:00:00 AM NOK/kWh 00 - 01 3.1445 2.69017 2.69017 - - - - -
12/10/2022 1:00:00 AM 12/10/2022 2:00:00 AM NOK/kWh 01 - 02 3.03469 2.63431 2.63431 - - - - -
12/10/2022 2:00:00 AM 12/10/2022 3:00:00 AM NOK/kWh 02 - 03 2.89852 2.62715 2.62715 - - - - -
12/10/2022 3:00:00 AM 12/10/2022 4:00:00 AM NOK/kWh 03 - 04 2.83582 2.50289 2.50289 - - - - -
[...]
.EXAMPLE
./Get-NordPoolRates.ps1 -Date (Get-Date).AddDays(1) -Currency NOK -IncludeStatsOnly -kWh
StartTime EndTime Unit Name SYS SE1 SE2 AT BE DE-LU FR NL
--------- ------- ---- ---- --- --- --- -- -- ----- -- --
12/10/2022 12:00:00 AM 12/11/2022 12:00:00 AM NOK/kWh Min 2.83266 2.21244 2.21244 - - - - -
12/10/2022 12:00:00 AM 12/11/2022 12:00:00 AM NOK/kWh Max 3.85746 2.77764 2.77764 - - - - -
12/10/2022 12:00:00 AM 12/11/2022 12:00:00 AM NOK/kWh Average 3.34953 2.486 2.486 - - - - -
12/10/2022 12:00:00 AM 12/11/2022 12:00:00 AM NOK/kWh Peak 3.70201 2.4058 2.4058 - - - - -
12/10/2022 12:00:00 AM 12/11/2022 12:00:00 AM NOK/kWh Off-peak 1 2.93102 2.52889 2.52889 - - - - -
12/10/2022 12:00:00 AM 12/11/2022 12:00:00 AM NOK/kWh Off-peak 2 3.12909 2.64079 2.64079 - - - - -
[...]
.EXAMPLE
./Get-NordPoolRates.ps1 -Date 2022-12-10 -Currency EUR -IncludeStats
StartTime EndTime Unit Name SYS SE1 SE2 AT BE DE-LU FR NL
--------- ------- ---- ---- --- --- --- -- -- ----- -- --
12/10/2022 12:00:00 AM 12/10/2022 1:00:00 AM EUR/MWh 00 - 01 298.37 255.26 255.26 307.89 328.80 312.48 336.74 312.80
[...]
12/10/2022 11:00:00 PM 12/11/2022 12:00:00 AM EUR/MWh 23 - 00 275.03 251.90 251.90 277.87 328.76 288.27 354.92 294.71
12/10/2022 12:00:00 AM 12/11/2022 12:00:00 AM EUR/MWh Min 268.78 209.93 209.93 277.87 290.54 284.90 293.35 284.90
12/10/2022 12:00:00 AM 12/11/2022 12:00:00 AM EUR/MWh Max 366.02 263.56 263.56 449.92 449.92 449.92 451.10 449.92
12/10/2022 12:00:00 AM 12/11/2022 12:00:00 AM EUR/MWh Average 317.82 235.89 235.89 352.31 364.38 354.64 370.20 355.66
12/10/2022 12:00:00 AM 12/11/2022 12:00:00 AM EUR/MWh Peak 351.27 228.28 228.28 404.27 406.17 404.41 407.27 404.66
12/10/2022 12:00:00 AM 12/11/2022 12:00:00 AM EUR/MWh Off-peak 1 278.11 239.96 239.96 292.76 311.87 297.19 320.02 298.09
12/10/2022 12:00:00 AM 12/11/2022 12:00:00 AM EUR/MWh Off-peak 2 296.91 250.58 250.58 315.51 344.05 320.24 359.38 323.80
.LINK
NordPool's Online version: https://www.nordpoolgroup.com/en/Market-data1/Dayahead/Area-Rates/ALL1/Hourly/?view=table
.LINK
GitHub: https://github.com/magnusbornes
.LINK
NordPool Terms and Conditions: https://www.nordpoolgroup.com/en/About-us/Terms-and-conditions-for-use/