{"id":1172,"date":"2022-09-17T07:36:22","date_gmt":"2022-09-17T07:36:22","guid":{"rendered":"https:\/\/www.creatingsmarthome.com\/?p=1172"},"modified":"2023-11-12T08:19:34","modified_gmt":"2023-11-12T08:19:34","slug":"home-assistant-nord-pool-spot-prices-and-how-to-automate-devices-for-cheapest-hours","status":"publish","type":"post","link":"https:\/\/www.creatingsmarthome.com\/index.php\/2022\/09\/17\/home-assistant-nord-pool-spot-prices-and-how-to-automate-devices-for-cheapest-hours\/","title":{"rendered":"Home Assistant: Nord Pool Spot prices and how to automate devices for cheapest hours"},"content":{"rendered":"\n

Most of this information can already be found around the internet, but since I wanted to integrate one as well for my Home Assistant instance, why not to share the same with you?<\/p>\n\n\n\n

So, the energy prices have gone up by a mile. The best way to balance the energy bill is to schedule some devices to cheapest hours of the day.. those devices could be something like washing machines, water boilers or car charging? Most of the devices needs a specific timeframe to run so sequential cheap hours are needed instead of scattered ones. It’s generally a bad idea to run a washing machine at 01:00, pause it at 02:00 and then continue at 05:00 \ud83d\ude42<\/p>\n\n\n\n

Note: There’s now also an advanced version available now that uses local calendar and has support to stretch the sequence between two days (e.g. 22.00 – 06.00). More details can be found from a separate blog post<\/a>.<\/strong><\/p>\n\n\n\n

Integrating Nord Pool to the Home Assistant<\/h2>\n\n\n\n

First we need to get the Nord Pool prices<\/a> into the system so a new integration is needed. Luckily (again) someone has already made it happen<\/a> and it can be installed using HACS<\/a>. If you don’t know what HACS is, it’s a Home Assistant Community Store, a place where tons of integrations and frontend elements are published and can be easily installed. Just need to remember that those are not official Home Assistant components and are maintained by individual people and therefore can break more easily than official ones.<\/p>\n\n\n\n

Anyway, start by installing Nord Pool custom component<\/a>. This integration does not have UI configuration so the has to be done manually to the configurations.yaml.<\/p>\n\n\n\n

For example, here’s my config:<\/p>\n\n\n\n

nordpool:\n\nsensor:\n  - platform: nordpool\n    VAT: true\n    currency: \"EUR\"\n    price_in_cents: true\n    region: \"FI\"\n    precision: 3\n    price_type: kWh<\/code><\/pre>\n\n\n\n
In above configration firstly we enable the integration and second we configure the sensor to use region Finland and currency in Euros. Some tweaking to precision and VAT is also done, but more configuration details can be found from the integration repository<\/a>.<\/p>\n\n\n\n
After everything is configured, restart the Home Assistant and continue to the UI part.<\/p>\n\n\n\n
Making the UI<\/h2>\n\n\n\n
First let’s find the entity id from our integrations. In Home Assistant go to Settings->Devices & Services->Entities<\/strong> and search with the filter ‘nordpool<\/em>‘. You should find a entity id (that is same as unique id) and write it down somewhere. Unique id is generated by the Nord Pool integration from the configuration we made in the previous chapter.<\/p>\n\n\n\n
For this part I’m using Apex Charts Card<\/a> that is very versatile graphical presentation card of various values. Again, this frontend card can be installed using HACS<\/a>. So go to the HACS and search for Apex and install it.<\/p>\n\n\n\n
After installation is succeeded, it’s time to configure two cards (one for today and one for tomorrow).<\/p>\n\n\n\n
Here’s my configuration for the cards (example UI shown at the end of this chapter):<\/p>\n\n\n\n
type: 'custom:apexcharts-card'\ngraph_span: 24h\nheader:\n  title: Energy price today (snt\/kWh)\n  show: true\nspan:\n  start: day\nnow:\n  show: true\n  label: Now\nseries:\n  - entity: sensor.nordpool_kwh_fi_eur_3_10_024\n    type: column\n    data_generator: |\n      return entity.attributes.raw_today.map((start, index) => {\n        return [new Date(start[\"start\"]).getTime(), entity.attributes.raw_today[index][\"value\"]];\n      });<\/code><\/pre>\n\n\n\n
type: custom:apexcharts-card\ngraph_span: 1d\nheader:\n  title: Energy price tomorrow (snt\/kWh)\n  show: true\nspan:\n  start: day\n  offset: +1d\nseries:\n  - entity: sensor.nordpool_kwh_fi_eur_3_10_024\n    type: column\n    data_generator: |\n      return entity.attributes.raw_tomorrow.map((start, index) => {\n        return [new Date(start[\"start\"]).getTime(), entity.attributes.raw_tomorrow[index][\"value\"]];\n      });<\/code><\/pre>\n\n\n\n
Again, you can use the same configurations, just remember to change the proper entity id for the cards (the one that we wrote down in previous chapter).<\/p>\n\n\n\n
That’s it! Now there should be todays electrical spot prices and tomorrows spot prices available in the Home Assistant for any use!<\/p>\n\n\n\n
To make it smart keep on reading the next chapters..<\/p>\n\n\n\n
\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n<\/figure>\n\n\n\n
Finding the cheapest hours<\/h2>\n\n\n\n
One of the key points of having Nord pool is of course finding the cheapest hour(s) and automate devices to run during those hours. <\/p>\n\n\n\n
For this I’ve created a template sensor that ensures validity of next day prices (usually published by Nord Pool at 12:00) and finds the sweet spot of requested lenght!<\/p>\n\n\n\n
It’s easily modifiable by changing numberOfSequentialHours (how long period are we looking for), firstHour (first possible hour we want to start) and last hour (final hour we want to stop latest). E.g. you can also use it to find cheapest hours during the next night by setting the last hour to something like 06:00.<\/p>\n\n\n\n
Note: There’s now also an advanced version available now that uses local calendar and has support to stretch the sequence between two days (e.g. 22.00 – 06.00).  More details can be found from a separate blog post<\/a>.<\/strong> You might want to skip into that blog post from this point forward..<\/p>\n\n\n\n
sensor:\n  - platform: template\n    sensors:\n      cheapest_hours_energy_tomorrow:\n        device_class: timestamp\n        friendly_name: Cheapest sequential electricity hours\n        value_template: >\n          {%- set numberOfSequentialHours = 3 -%}\n          {%- set lastHour = 23 -%}\n          {%- set firstHour = 0 -%}\n\n          {%- if state_attr('sensor.nordpool_kwh_fi_eur_3_10_024', 'tomorrow_valid') == true -%}\n            {%- set ns = namespace(counter=0, list=[], cheapestHour=today_at(\"00:00\") + timedelta( hours = (24)), cheapestPrice=999.00) -%}\n            {%- for i in range(firstHour + numberOfSequentialHours, lastHour+1) -%}\n              {%- set ns.counter = 0.0 -%}\n              {%- for j in range(i-numberOfSequentialHours, i) -%}\n                {%- set ns.counter = ns.counter + state_attr('sensor.nordpool_kwh_fi_eur_3_10_024', 'tomorrow')[j] -%}\n              {%- endfor -%}\n              {%- set ns.list = ns.list + [ns.counter] -%}\n              {%- if ns.counter < ns.cheapestPrice -%}\n                {%- set ns.cheapestPrice = ns.counter -%}\n                {%- set ns.cheapestHour = today_at(\"00:00\") + timedelta( hours = (24 + i - numberOfSequentialHours)) -%}\n              {%- endif -%}\n            {%- endfor -%}\n            {{ ns.cheapestHour }}\n            {%- set ns.cheapestPrice = ns.cheapestPrice \/ numberOfSequentialHours -%}\n          {%- endif -%}\n\n\n<\/code><\/pre>\n\n\n\n
Finally making the automations<\/h2>\n\n\n\n
Now that we know the cheapest hours for the next day, only thing to do is actually do the automations for various devices.<\/p>\n\n\n\n
My automation is actually in two parts: <\/p>\n\n\n\n
\n