My template sensors stopped working after latest updates

[ThorAlex87]

Hi!

First: Not a programmer or IT guy, can copy/paste code and do minor modifications but that's as far as my understanding of this goes...

Not sure if this is a problem with how my templates are written, or if there is an issue with the integration after the problems lately...

So I have these templates that turn on a sensor during the x number of cheapest hours during the day, that my automations use to choose when to run devices. These worked well for a long time, but after the update to 6.1 they are broken, and despite all being variations of the same they seem to break in a couple off different ways... I've tried the 6.3 beta, seems to make no difference. They all seem to break at midnight, and work again after a restart.

This one just stays at "false" and never becomes true even when it should be. ` - platform: template sensors: billigste_4_timer_entsoe_offpeak: value_template: >- {% set l= ( state_attr('sensor.strompriser_entso_e_nettleie_average_electricity_price_today', 'prices')[14:15]|list

• state_attr('sensor.strompriser_entso_e_nettleie_average_electricity_price_today', 'prices')[19:29]|list
• state_attr('sensor.strompriser_entso_e_nettleie_average_electricity_price_today', 'prices')[32:38]|list ) |sort (attribute='price') %} {% set t = now() %} {{ (t >= as_datetime(l[0].time) and t <= as_datetime(l[0].time) + timedelta(hours = 1)) or (t >= as_datetime(l[1].time) and t <= as_datetime(l[1].time) + timedelta(hours = 1)) or (t >= as_datetime(l[2].time) and t <= as_datetime(l[2].time) + timedelta(hours = 1)) or (t >= as_datetime(l[3].time) and t <= as_datetime(l[3].time) + timedelta(hours = 1)) }}`

This one becomes unavailable at midnight, but becomes available again at 13:00. Seems to work as intended from then and until it breaks again at the next midnight. ` - platform: template sensors: billigste_8_timer_entsoe_offpeak: value_template: >- {% set l= ( state_attr('sensor.strompriser_entso_e_nettleie_average_electricity_price_today', 'prices')[14:15]|list

• state_attr('sensor.strompriser_entso_e_nettleie_average_electricity_price_today', 'prices')[19:29]|list
• state_attr('sensor.strompriser_entso_e_nettleie_average_electricity_price_today', 'prices')[32:38]|list ) |sort (attribute='price') %} {% set t = now() %} {{ (t >= as_datetime(l[0].time) and t <= as_datetime(l[0].time) + timedelta(hours = 1)) or (t >= as_datetime(l[1].time) and t <= as_datetime(l[1].time) + timedelta(hours = 1)) or (t >= as_datetime(l[2].time) and t <= as_datetime(l[2].time) + timedelta(hours = 1)) or (t >= as_datetime(l[3].time) and t <= as_datetime(l[3].time) + timedelta(hours = 1)) or (t >= as_datetime(l[4].time) and t <= as_datetime(l[4].time) + timedelta(hours = 1)) or (t >= as_datetime(l[5].time) and t <= as_datetime(l[5].time) + timedelta(hours = 1)) or (t >= as_datetime(l[6].time) and t <= as_datetime(l[6].time) + timedelta(hours = 1)) or (t >= as_datetime(l[7].time) and t <= as_datetime(l[7].time) + timedelta(hours = 1)) }}`

In total I have 8 of these in different variations, they all break in one of those two ways.

I found this in the logs, this is after installing 6.3-beta1: 2024-10-08 00:00:00.446 ERROR (MainThread) [homeassistant.helpers.template] Template variable error: list object has no element 6 when rendering '{% set l= ( state_attr('sensor.strompriser_entso_e_nettleie_average_electricity_price_today', 'prices')[14:15]|list + state_attr('sensor.strompriser_entso_e_nettleie_average_electricity_price_today', 'prices')[19:29]|list + state_attr('sensor.strompriser_entso_e_nettleie_average_electricity_price_today', 'prices')[32:38]|list ) |sort (attribute='price') %} {% set t = now() %} {{ (t >= as_datetime(l[0].time) and t <= as_datetime(l[0].time) + timedelta(hours = 1)) or (t >= as_datetime(l[1].time) and t <= as_datetime(l[1].time) + timedelta(hours = 1)) or (t >= as_datetime(l[2].time) and t <= as_datetime(l[2].time) + timedelta(hours = 1)) or (t >= as_datetime(l[3].time) and t <= as_datetime(l[3].time) + timedelta(hours = 1)) or (t >= as_datetime(l[4].time) and t <= as_datetime(l[4].time) + timedelta(hours = 1)) or (t >= as_datetime(l[5].time) and t <= as_datetime(l[5].time) + timedelta(hours = 1)) or (t >= as_datetime(l[6].time) and t <= as_datetime(l[6].time) + timedelta(hours = 1)) or (t >= as_datetime(l[7].time) and t <= as_datetime(l[7].time) + timedelta(hours = 1)) }}' 2024-10-08 00:00:00.446 ERROR (MainThread) [homeassistant.components.template.template_entity] TemplateError('UndefinedError: list object has no element 6') while processing template 'Template<template=({% set l= ( state_attr('sensor.strompriser_entso_e_nettleie_average_electricity_price_today', 'prices')[14:15]|list + state_attr('sensor.strompriser_entso_e_nettleie_average_electricity_price_today', 'prices')[19:29]|list + state_attr('sensor.strompriser_entso_e_nettleie_average_electricity_price_today', 'prices')[32:38]|list ) |sort (attribute='price') %} {% set t = now() %} {{ (t >= as_datetime(l[0].time) and t <= as_datetime(l[0].time) + timedelta(hours = 1)) or (t >= as_datetime(l[1].time) and t <= as_datetime(l[1].time) + timedelta(hours = 1)) or (t >= as_datetime(l[2].time) and t <= as_datetime(l[2].time) + timedelta(hours = 1)) or (t >= as_datetime(l[3].time) and t <= as_datetime(l[3].time) + timedelta(hours = 1)) or (t >= as_datetime(l[4].time) and t <= as_datetime(l[4].time) + timedelta(hours = 1)) or (t >= as_datetime(l[5].time) and t <= as_datetime(l[5].time) + timedelta(hours = 1)) or (t >= as_datetime(l[6].time) and t <= as_datetime(l[6].time) + timedelta(hours = 1)) or (t >= as_datetime(l[7].time) and t <= as_datetime(l[7].time) + timedelta(hours = 1)) }}) renders=480>' for attribute '_state' in entity 'binary_sensor.billigste_8_timer_entsoe_offpeak' 2024-10-08 00:00:00.447 ERROR (MainThread) [homeassistant.helpers.template] Template variable error: list object has no element 0 when rendering '{% set l= ( state_attr('sensor.strompriser_entso_e_nettleie_average_electricity_price_today', 'prices')[32:40]|list ) |sort (attribute='price') %} {% set t = now() %} {{ (t >= as_datetime(l[0].time) and t <= as_datetime(l[0].time) + timedelta(hours = 1)) or (t >= as_datetime(l[1].time) and t <= as_datetime(l[1].time) + timedelta(hours = 1)) }}' 2024-10-08 00:00:00.447 ERROR (MainThread) [homeassistant.components.template.template_entity] TemplateError('UndefinedError: list object has no element 0') while processing template 'Template<template=({% set l= ( state_attr('sensor.strompriser_entso_e_nettleie_average_electricity_price_today', 'prices')[32:40]|list ) |sort (attribute='price') %} {% set t = now() %} {{ (t >= as_datetime(l[0].time) and t <= as_datetime(l[0].time) + timedelta(hours = 1)) or (t >= as_datetime(l[1].time) and t <= as_datetime(l[1].time) + timedelta(hours = 1)) }}) renders=480>' for attribute '_state' in entity 'binary_sensor.billigste_2_timer_entsoe_dag' 2024-10-08 00:00:00.447 ERROR (MainThread) [homeassistant.helpers.template] Template variable error: list object has no element 0 when rendering '{% set l= ( state_attr('sensor.strompriser_entso_e_nettleie_average_electricity_price_today', 'prices')[32:40]|list ) |sort (attribute='price') %} {% set t = now() %} {{ (t >= as_datetime(l[0].time) and t <= as_datetime(l[0].time) + timedelta(hours = 1)) or (t >= as_datetime(l[1].time) and t <= as_datetime(l[1].time) + timedelta(hours = 1)) or (t >= as_datetime(l[2].time) and t <= as_datetime(l[2].time) + timedelta(hours = 1)) or (t >= as_datetime(l[3].time) and t <= as_datetime(l[3].time) + timedelta(hours = 1)) }}' 2024-10-08 00:00:00.447 ERROR (MainThread) [homeassistant.components.template.template_entity] TemplateError('UndefinedError: list object has no element 0') while processing template 'Template<template=({% set l= ( state_attr('sensor.strompriser_entso_e_nettleie_average_electricity_price_today', 'prices')[32:40]|list ) |sort (attribute='price') %} {% set t = now() %} {{ (t >= as_datetime(l[0].time) and t <= as_datetime(l[0].time) + timedelta(hours = 1)) or (t >= as_datetime(l[1].time) and t <= as_datetime(l[1].time) + timedelta(hours = 1)) or (t >= as_datetime(l[2].time) and t <= as_datetime(l[2].time) + timedelta(hours = 1)) or (t >= as_datetime(l[3].time) and t <= as_datetime(l[3].time) + timedelta(hours = 1)) }}) renders=480>' for attribute '_state' in entity 'binary_sensor.billigste_4_timer_entsoe_dag' 2024-10-08 00:00:00.448 ERROR (MainThread) [homeassistant.helpers.template] Template variable error: list object has no element 23 when rendering '{% set l=state_attr('sensor.strompriser_entso_e_nettleie_average_electricity_price_today', 'prices')[14:38]|sort(attribute='price') %} {% set t = now() %} {{ (t >= as_datetime(l[23].time) and t <= as_datetime(l[23].time) + timedelta(hours = 1)) or (t >= as_datetime(l[22].time) and t <= as_datetime(l[22].time) + timedelta(hours = 1)) or (t >= as_datetime(l[21].time) and t <= as_datetime(l[21].time) + timedelta(hours = 1)) or (t >= as_datetime(l[20].time) and t <= as_datetime(l[20].time) + timedelta(hours = 1)) }}' 2024-10-08 00:00:00.448 ERROR (MainThread) [homeassistant.components.template.template_entity] TemplateError('UndefinedError: list object has no element 23') while processing template 'Template<template=({% set l=state_attr('sensor.strompriser_entso_e_nettleie_average_electricity_price_today', 'prices')[14:38]|sort(attribute='price') %} {% set t = now() %} {{ (t >= as_datetime(l[23].time) and t <= as_datetime(l[23].time) + timedelta(hours = 1)) or (t >= as_datetime(l[22].time) and t <= as_datetime(l[22].time) + timedelta(hours = 1)) or (t >= as_datetime(l[21].time) and t <= as_datetime(l[21].time) + timedelta(hours = 1)) or (t >= as_datetime(l[20].time) and t <= as_datetime(l[20].time) + timedelta(hours = 1)) }}) renders=480>' for attribute '_state' in entity 'binary_sensor.dyreste_4_timer_entsoe'

This is in Norway NO3.

I can't really make sence of this, but hopefully someone can help me fix this!

Edit: Forgot to add, I suspect this might be related to the Belgium issues but I looked at the data and could not f8nd anything off... But I might be missing what to look for.

[Pluimvee]

Not sure what the issue is but you may want to look into using the new sensor: ' Current Percentage in electricity price range' As this sensor can immediately be used to turn on/off some devices using simple automations without complex templates

[ThorAlex87]

Thanks for the tip, I'll look into it. Are there any examples of automations for this anywhere?

[Pluimvee]

I'm using automation like this

alias: EV charge on description: At the lowest price during the night or day triggers:

• trigger: numeric_state entity_id:
  • sensor.electricity_data_eu_current_price_percentage_in_range below: 5 conditions: [] actions:
• metadata: {} data: {} target: entity_id: switch.sonoff_1001f8d4e6 action: switch.turn_on mode: single

[Roeland54]

I think it would be helpful for a lot of people to have this documented in the documentation. Using it like that would also be a more robust solution than the template you have because the template you have uses the position of the price to determine what prices belong to today/tomorrow.

[ThorAlex87]

I setup a test of the percentage sensor yesterday with a modified version of my water heater automation switching a "dummy" boolean and have already run into a major problem. I set the threshold to 20%, that would give 6 hours of runtime yesterday, but today that will maybe two hours... That is no good for a water heater, I'll need something that gives a reliable minimum runtime every day. So I'll need something like "x number of hours with lowest percentage", and I'm right back to templates like above. Unless there is a really easy way to do that that I'm missing?

Back on topic: All the templates failed again tonight, but recovered after the automatic reboot I set up as a temporary fix.

[Pluimvee]

Turning on your heater can be done when price gets below 20% of the price range of that day

Turning off your heater can be easily done with standard automations:

• you can turn off after 6 hours of being turned on (turn off triggered by turned on event with duration of 6hrs)
• you can turn off when price exceeds 40% (or any other value)
• you can turn off when water temperature reached setpoint (power consumption of the heater is below 50W for 15 minutes)

Only using the price-percentage-in-range to steer your heater would have give you the below in the NL (using 20%-40%)

ps. Of course you can add other conditions in your automation script to limit runtime, set time-of-the-day, net-power-consumption-in-household, etc

[ThorAlex87]

Does your sensor always use the full range from 0% to 100% every day? Mine does not, and right now has not been under 20% for almost 30 hours... Seems a bit weird?

[Pluimvee]

The percentage, min, max, avg sensors are dependent on the analysis window (calculation_mode) configured in your device. When you use the sliding mode the analysis window extends from the current hour till the last data fetched. When you use rotation the analysis is based on todays values. In case of publish the analysis is based on all data, including historical.

I suggest top put your calculation_mode on rotation and see what the curve is.

Personally I'm using the mode sliding-12, which is a new functionality in pull request #197. You can install this branch to have the same functionality. See for more details on this in issue #194

[Roeland54]

To know what data is missing you would need to look at the attributes of the 'sensor.strompriser_entso_e_nettleie_average_electricity_price_today' entity. Copy and paste here a version from when the template is broken and then also a version after reboot when it works again.

[ThorAlex87]

Here's the current attribute, while tamplates are working after the auto reboot last night. I'll update tomorrow morning if it's broken again, and I'v turned off the reboot so I can get broken data.

Prices today

• time: '2024-10-09 00:00:00+02:00' price: 0.6239
• time: '2024-10-09 01:00:00+02:00' price: 0.62186
• time: '2024-10-09 02:00:00+02:00' price: 0.6201
• time: '2024-10-09 03:00:00+02:00' price: 0.61879
• time: '2024-10-09 04:00:00+02:00' price: 0.61908
• time: '2024-10-09 05:00:00+02:00' price: 0.61967
• time: '2024-10-09 06:00:00+02:00' price: 0.80243
• time: '2024-10-09 07:00:00+02:00' price: 0.80754
• time: '2024-10-09 08:00:00+02:00' price: 0.80885
• time: '2024-10-09 09:00:00+02:00' price: 0.80885
• time: '2024-10-09 10:00:00+02:00' price: 0.79527
• time: '2024-10-09 11:00:00+02:00' price: 0.79819
• time: '2024-10-09 12:00:00+02:00' price: 0.79614
• time: '2024-10-09 13:00:00+02:00' price: 0.79541
• time: '2024-10-09 14:00:00+02:00' price: 0.79351
• time: '2024-10-09 15:00:00+02:00' price: 0.77832
• time: '2024-10-09 16:00:00+02:00' price: 0.77803
• time: '2024-10-09 17:00:00+02:00' price: 0.79322
• time: '2024-10-09 18:00:00+02:00' price: 0.79483
• time: '2024-10-09 19:00:00+02:00' price: 0.78416
• time: '2024-10-09 20:00:00+02:00' price: 0.75451
• time: '2024-10-09 21:00:00+02:00' price: 0.73449
• time: '2024-10-09 22:00:00+02:00' price: 0.5567
• time: '2024-10-09 23:00:00+02:00' price: 0.51083 Prices tomorrow
• time: '2024-10-10 00:00:00+02:00' price: 0.51361
• time: '2024-10-10 01:00:00+02:00' price: 0.53508
• time: '2024-10-10 02:00:00+02:00' price: 0.55539
• time: '2024-10-10 03:00:00+02:00' price: 0.56927
• time: '2024-10-10 04:00:00+02:00' price: 0.61733
• time: '2024-10-10 05:00:00+02:00' price: 0.63574
• time: '2024-10-10 06:00:00+02:00' price: 0.84903
• time: '2024-10-10 07:00:00+02:00' price: 0.94968
• time: '2024-10-10 08:00:00+02:00' price: 0.9751
• time: '2024-10-10 09:00:00+02:00' price: 0.97393
• time: '2024-10-10 10:00:00+02:00' price: 0.95173
• time: '2024-10-10 11:00:00+02:00' price: 0.94822
• time: '2024-10-10 12:00:00+02:00' price: 0.90571
• time: '2024-10-10 13:00:00+02:00' price: 0.81966
• time: '2024-10-10 14:00:00+02:00' price: 0.87576
• time: '2024-10-10 15:00:00+02:00' price: 0.87751
• time: '2024-10-10 16:00:00+02:00' price: 0.84844
• time: '2024-10-10 17:00:00+02:00' price: 0.82039
• time: '2024-10-10 18:00:00+02:00' price: 0.81996
• time: '2024-10-10 19:00:00+02:00' price: 0.81177
• time: '2024-10-10 20:00:00+02:00' price: 0.81367
• time: '2024-10-10 21:00:00+02:00' price: 0.8128
• time: '2024-10-10 22:00:00+02:00' price: 0.63325
• time: '2024-10-10 23:00:00+02:00' price: 0.62887 Prices
• time: '2024-10-09 00:00:00+02:00' price: 0.6239
• time: '2024-10-09 01:00:00+02:00' price: 0.62186
• time: '2024-10-09 02:00:00+02:00' price: 0.6201
• time: '2024-10-09 03:00:00+02:00' price: 0.61879
• time: '2024-10-09 04:00:00+02:00' price: 0.61908
• time: '2024-10-09 05:00:00+02:00' price: 0.61967
• time: '2024-10-09 06:00:00+02:00' price: 0.80243
• time: '2024-10-09 07:00:00+02:00' price: 0.80754
• time: '2024-10-09 08:00:00+02:00' price: 0.80885
• time: '2024-10-09 09:00:00+02:00' price: 0.80885
• time: '2024-10-09 10:00:00+02:00' price: 0.79527
• time: '2024-10-09 11:00:00+02:00' price: 0.79819
• time: '2024-10-09 12:00:00+02:00' price: 0.79614
• time: '2024-10-09 13:00:00+02:00' price: 0.79541
• time: '2024-10-09 14:00:00+02:00' price: 0.79351
• time: '2024-10-09 15:00:00+02:00' price: 0.77832
• time: '2024-10-09 16:00:00+02:00' price: 0.77803
• time: '2024-10-09 17:00:00+02:00' price: 0.79322
• time: '2024-10-09 18:00:00+02:00' price: 0.79483
• time: '2024-10-09 19:00:00+02:00' price: 0.78416
• time: '2024-10-09 20:00:00+02:00' price: 0.75451
• time: '2024-10-09 21:00:00+02:00' price: 0.73449
• time: '2024-10-09 22:00:00+02:00' price: 0.5567
• time: '2024-10-09 23:00:00+02:00' price: 0.51083
• time: '2024-10-10 00:00:00+02:00' price: 0.51361
• time: '2024-10-10 01:00:00+02:00' price: 0.53508
• time: '2024-10-10 02:00:00+02:00' price: 0.55539
• time: '2024-10-10 03:00:00+02:00' price: 0.56927
• time: '2024-10-10 04:00:00+02:00' price: 0.61733
• time: '2024-10-10 05:00:00+02:00' price: 0.63574
• time: '2024-10-10 06:00:00+02:00' price: 0.84903
• time: '2024-10-10 07:00:00+02:00' price: 0.94968
• time: '2024-10-10 08:00:00+02:00' price: 0.9751
• time: '2024-10-10 09:00:00+02:00' price: 0.97393
• time: '2024-10-10 10:00:00+02:00' price: 0.95173
• time: '2024-10-10 11:00:00+02:00' price: 0.94822
• time: '2024-10-10 12:00:00+02:00' price: 0.90571
• time: '2024-10-10 13:00:00+02:00' price: 0.81966
• time: '2024-10-10 14:00:00+02:00' price: 0.87576
• time: '2024-10-10 15:00:00+02:00' price: 0.87751
• time: '2024-10-10 16:00:00+02:00' price: 0.84844
• time: '2024-10-10 17:00:00+02:00' price: 0.82039
• time: '2024-10-10 18:00:00+02:00' price: 0.81996
• time: '2024-10-10 19:00:00+02:00' price: 0.81177
• time: '2024-10-10 20:00:00+02:00' price: 0.81367
• time: '2024-10-10 21:00:00+02:00' price: 0.8128
• time: '2024-10-10 22:00:00+02:00' price: 0.63325
• time: '2024-10-10 23:00:00+02:00' price: 0.62887

@Pluimvee I've changed to rotation and the graph so far looks more promesing! I'll keep experimenting with this, thanks for the help so far!