lowest night hours

[Nick75wien]

Hello!

Thanks for the nice integration - I want to use it to trigger battery charge during low cost night hours.

Therefore I have adapted your calculation:

state: >-
{% set ns = namespace(attr_dict=[]) %}
{% for item in (state_attr('sensor.epex_spot_at_price', 'data'))[0:24] %}
{%- set ns.attr_dict = ns.attr_dict + [(loop.index-1,item["price_eur_per_mwh"])] %}
{% endfor %}
{%- set price_map = dict(ns.attr_dict) %}
{%- set price_sort = price_map.values()|list %}
{%- set keys_list = price_map.keys()|list %}
{%- set ns = namespace(combo=[]) %}
{%- for p in keys_list %}
{%- set p = p|int %}
{%- if p < 22 %}
{%- set ns.combo = ns.combo + [(p, ((price_sort)[p] + (price_sort)[p+1] )|round(2))] %}
{%- endif %}
{%- endfor %}
{%- set ns.combo = ns.combo[0:8] %}
{%- set mapper = dict(ns.combo) %}
{%- set key = mapper.keys()|list %}
{%- set val = mapper.values()|list %}
{%- set val_min = mapper.values()|min %}
{{ key[val.index(val_min)]|string + ":00" }}

But I need to have it as time to trigger the Automation with it - could you help me on that ?

KR Niki

[mampfes]

Sorry, I'm not very familiar with this syntax - the example was provided by an user.

Do you know the rank and the percentile sensor? Maybe they are sufficient for your request.

[Joebinator]

@Nick75wien

If you want to run a simple automation then your trigger for the automation should look like this:

platform: template
value_template: >-
{{ now().timestamp() | timestamp_custom('%H%M') ==
today_at(states('sensor.your_sensor_name')).timestamp()
| timestamp_custom('%H%M') }}

I am running an automation like that to heat up my water boiler

[Nick75wien]

but how is that sensor defined ?
sensor.beste_uhrzeit_warmwasserheizung_abend

[Joebinator]

Just like in your first post, but just in case here is mine:

  - name: beste_uhrzeit_warmwasserheizung_abend
    unique_id: "Uhrzeit_warmwasseraufheizen"
    state: >- 
      {% set ns = namespace(attr_dict=[]) %}
      {% for item in (state_attr('sensor.epex_spot_at_price', 'data'))[0:24] %}
          {%- set ns.attr_dict = ns.attr_dict + [(loop.index-1,item["price_eur_per_mwh"])] %}
      {% endfor %}
      {%- set price_map = dict(ns.attr_dict) %}
      {%- set price_sort = price_map.values()|list %}
      {%- set keys_list = price_map.keys()|list %}
      {%- set ns = namespace(combo=[]) %}
      {%- for p in keys_list %}
        {%- set p = p|int %}
        {%- if p < 22 %}
          {%- set ns.combo = ns.combo + [(p, ((price_sort)[p])|round(2))] %}
        {%- endif %}
      {%- endfor %}
      {%- set ns.combo = ns.combo[0:24] %}
      {%- set mapper = dict(ns.combo) %}
      {%- set key = mapper.keys()|list %}
      {%- set val = mapper.values()|list %}
      {%- set val_min = mapper.values()|min %}
      {{ key[val.index(val_min)]|string + ":00" }}

That gives you the Time (1 Hour) for the lowest Price before midnight.

if you want the best time for exaplme 3 hours of runtime (like in the documentation) then you need to change this section
{%- set ns.combo = ns.combo + [(p, ((price_sort)[p])|round(2))] %}

to

{%- set ns.combo = ns.combo + [(p, ((price_sort)[p] + (price_sort)[p+1] + (price_sort)[p+2])|round(2))] %}

[Nick75wien]

this actually gives 13:00

[Joebinator]

Yeah, because 13:00 is the cheapest hour today.

[Nick75wien]

ok! thats what I also use for starting the washing machine

but I now also have created a cheap night sensor to recharge my battery to have cheap electricity in the morning before the solar panels start working ;-)

thanks anyway for your help

[Hankersern]

Hey there, maybe you could help me.
My battery should be loaded at lowest prices and needs about 3 hours to charge.

But the sensor seems to be wrong. It should be 13:00 but show 01:00.

edit - my sensor:

## Sensor guenstigster Zeitpunkt um Batterien zu laden ##
template:
  - sensor:
      - name: epex_start_low_period
        state: >-
          {% set ns = namespace(attr_dict=[]) %}
          {% for item in (state_attr('sensor.epex_spot_de_lu_price', 'data'))[0:24] %}
              {%- set ns.attr_dict = ns.attr_dict + [(loop.index-1,item["price_eur_per_mwh"])] %}
          {% endfor %}
          {%- set price_map = dict(ns.attr_dict) %}
          {%- set price_sort = price_map.values()|list %}
          {%- set keys_list = price_map.keys()|list %}
          {%- set ns = namespace(combo=[]) %}
          {%- for p in keys_list %}
            {%- set p = p|int %}
            {%- if p < 22 %}
              {%- set ns.combo = ns.combo + [(p, ((price_sort)[p] + (price_sort)[p+1] + (price_sort)[p+2])|round(2))] %}
            {%- endif %}
          {%- endfor %}
          {%- set mapper = dict(ns.combo) %}
          {%- set key = mapper.keys()|list %}
          {%- set val = mapper.values()|list %}
          {%- set val_min = mapper.values()|min %}
          {{ key[val.index(val_min)]|string + ":00" }}

Thanks!

[Hankersern]

Ok, i'll change my integration to use the scraper. Let's see if this works :-)

[Hankersern]

Well, maybe the Scraper works better. But I have to keep a look on it - Screenshot should speak for itself.
I mean, the best hours should be from ~4 to 7 and not 13:00h now, shouldnt?

[Joebinator]

The time value you get is for today, after midnight it will change accordingly.

if anybody has an idea how to configure this template to look for the whole available data, i would also be very grateful =)

[Hankersern]

I will stay awake until 0:30 today to see if it changes :-D

[Joebinator]

don't ask my why, but mine changes always at 01:00

[Hankersern]

don't ask my why, but mine changes always at 01:00

Epex releases the new prices daily at 13:00 oO

Mine seems to work so far. I'll change the automations for charging now and keep an eye on it.
Thanks again!