EPEX Spot and Awattar Electricity Prices

Hi,
the energy dashboard does that for you.

I don´t think, this is what i need, the € is much too high.


The Entity is from here: (with all in Costs)
image
Any Idea what is going wrong?
Or even better:
Is there a way to calculate it without the Energy Dashboard? I need it outside the Energy Dashboard, because i never use it anyway.

The price is provided in ct/kWh, but the dashboard needs it in €/kWh:

1 Like

Thank you!
With this Template, it works perfect!

Now, i´d like to use it not only on the Energy Dashboard, because i never look at it, but on my Dashboard, it would be fine to see this Calculation.
Any Ideas how to make it possible?

You can add a manual card with

type: energy-sources-table

Yes, i already put it on my Dashboard, but it doesn´t look very User friendly…

I think, i have to wait until someone invites a Integration for this Problem.

Hello, so for me its working but since i switched to smartenergy its not updating the prices.
The forcastcard is showing at 17:00 (bc SE is providing data at 17:00).
I changed code also to 17:00 but for some reason its not updating the chart.

Only after I manually refresh the integration its loading.

What can it be?

I have the same Problem. But i just use awattar.at for tomorrow, because it doesn´t matter if the Price is 15,6C or 15,2C in Forecast for me.

The SmartENERGY API is often down. Please check with the browser.

If you configure the tax and surcharges properly, you should get the correct values also if you use awattar.

hallo,
bin grad völlig neu hier, und stehe etwas auf der Leitung.
Den Graph und Epex habe ich hinbekommen.
Aber jetzt hier mit den Sensoren und der Automatisierung scheitere ich gerade.
Wo muss der Sensor erstellt werden? in der configuration.yaml? einfach reinkopieren? und die Automatisierung?
Am ENDE des Tages möchte ich meinen Boiler zum niedrigsten Tarif aufheizen,

DAnke im Voraus
Andreas

Schau mal hier:

Damit kannst Du Dir alles so einstellen, wie Du es brauchst.

1 Like

This has started happening since last week. The API has been super spotty and hasn’t been updating at 17:00. It’s 18:25 as I’m writing this and the API still doesn’t have tomorrow’s prices.

I wrote an automation that tries to get the latest prices, but you can’t do much if the API doesn’t update.

EDIT: Seems the API updated some time past 20:30…

alias: Refresh EPEX Spot Data
description: >-
  Fetches Data when "sensor.display_tomorrow_s_energy_graph_between_17_00_00_00"
  turns True.
trigger:
  - platform: state
    entity_id:
      - sensor.display_tomorrow_s_energy_graph_between_17_00_00_00
    to: "True"
condition: []
action:
  - delay:
      hours: 0
      minutes: 0
      seconds: 30
      milliseconds: 0
  - service: epex_spot.fetch_data
    metadata: {}
    data: {}
  - repeat:
      sequence:
        - if:
            - condition: and
              conditions:
                - condition: state
                  entity_id: sensor.dishwasher_start_time
                  state: Waiting for new data
                - condition: state
                  entity_id: sensor.next_60deg_batch_end_time
                  state: Waiting for new data
                - condition: state
                  entity_id: sensor.next_30deg_batch_end_time
                  state: Waiting for new data
          then:
            - delay:
                hours: 0
                minutes: 1
                seconds: 0
                milliseconds: 0
            - service: epex_spot.fetch_data
              metadata: {}
              data: {}
          else:
            - stop: Data refreshed successfully
      count: 3
  - if:
      - condition: and
        conditions:
          - condition: state
            entity_id: sensor.dishwasher_start_time
            state: Waiting for new data
          - condition: state
            entity_id: sensor.next_60deg_batch_end_time
            state: Waiting for new data
          - condition: state
            entity_id: sensor.next_30deg_batch_end_time
            state: Waiting for new data
    then:
      - service: homeassistant.reload_config_entry
        metadata: {}
        data: {}
        target:
          device_id: 58693c8242f2fdb0458c5f4d22f7e066
    else:
      - stop: Data refreshed successfully
  - if:
      - condition: and
        conditions:
          - condition: state
            entity_id: sensor.dishwasher_start_time
            state: Waiting for new data
          - condition: state
            entity_id: sensor.next_60deg_batch_end_time
            state: Waiting for new data
          - condition: state
            entity_id: sensor.next_30deg_batch_end_time
            state: Waiting for new data
    then:
      - service: notify.mobile_app_oneplus_7t_pro
        metadata: {}
        data:
          title: EPEX Data not refreshed
          message: Is the damn API down again?
    else:
      - stop: Data refreshed successfully
mode: single

Schau mal die Dokumentation vom Hauptplugin auf Github. Da hab ich ziemlich viel erweitert mit verschieden Beispiele und noch mehr Details in ein Paar “Show and Tell” Diskussion Posts. Vielleicht hilft dir das :slight_smile:

Die Beispiele in der Dokumentation sind hauptsächlich zeitbasiert, aber für deiner Anwendungsfall, sollte es eigentlich die Ranks reichen.

Die einfachste Automatisierungsmöglichkeit wäre irgendwas in Richtung “If Rank < 4, then switch Boiler on”.

Guten Abend,
bin wohl leider zu doof für HA.
Habe die EPEX Sensoren drinnen, “start boiler wenn preis am niedrigsten”…
Aber wie kann ich mit dem Signal “Sensor” einen shelly 1pm ansteuern?
bitte um Hilfe, danke

Muss dafür ein Automation schreiben. Ich kann empfehlen, einige YouTube tutorials anzuschauen. Wird mMn viel einfacher :slight_smile:

doch nicht, anscheinend keine Auswertung wann der niedirgste Tarif ist, start immer um 0:00:00 :woozy_face:

kann hier jemand helfen? sync worker problem?

die Preise kommen (richtig), min und max wird angezeigt, jedoch ist die Startzeit immer um 00:00:00

Ich BITTE um eure Hilfe.

Danke

2024-04-05 18:14:47.112 WARNING (SyncWorker_3) [homeassistant.loader] We found a custom integration epex_spot_sensor which has not been tested by Home Assistant. This component might cause stability problems, be sure to disable it if you experience issues with Home Assistant
2024-04-05 18:14:47.115 WARNING (SyncWorker_3) [homeassistant.loader] We found a custom integration scheduler which has not been tested by Home Assistant. This component might cause stability problems, be sure to disable it if you experience issues with Home Assistant
2024-04-05 18:14:47.118 WARNING (SyncWorker_3) [homeassistant.loader] We found a custom integration epex_spot which has not been tested by Home Assistant. This component might cause stability problems, be sure to disable it if you experience issues with Home Assistant
2024-04-05 18:14:47.120 WARNING (SyncWorker_3) [homeassistant.loader] We found a custom integration hacs which has not been tested by Home Assistant. This component might cause stability problems, be sure to disable it if you experience issues with Home Assistant
2024-04-05 18:14:55.361 WARNING (MainThread) [homeassistant.helpers.frame] Detected that custom integration ‘hacs’ accesses hass.components.frontend. This is deprecated and will stop working in Home Assistant 2024.9, it should be updated to import functions used from frontend directly at custom_components/hacs/frontend.py, line 68: hass.components.frontend.async_register_built_in_panel(, please create a bug report at Issues · hacs/integration · GitHub
2024-04-05 18:14:58.675 ERROR (MainThread) [homeassistant.helpers.template] Template variable error: ‘resp’ is undefined when rendering 'template:

  • trigger:
    • platform: time
      at: “00:00:00”
      action:
    • service: epex_spot.get_lowest_price_interval
      data:
      earliest_start: “20:00:00”
      latest_end: “23:00:00”
      duration:
      hours: 1
      minutes: 5
      response_variable: resp
      sensor:
    • name: Start Appliance
      device_class: timestamp
      state: “{{ resp.start is defined and resp.start }}”’
      2024-04-05 18:14:58.681 ERROR (MainThread) [homeassistant.helpers.event] Error while processing template: Template<template=(template:
  • trigger:
    • platform: time
      at: “00:00:00”
      action:
    • service: epex_spot.get_lowest_price_interval
      data:
      earliest_start: “20:00:00”
      latest_end: “23:00:00”
      duration:
      hours: 1
      minutes: 5
      response_variable: resp
      sensor:
    • name: Start Appliance
      device_class: timestamp
      state: “{{ resp.start is defined and resp.start }}”) renders=2>
      Traceback (most recent call last):
      File “/usr/src/homeassistant/homeassistant/helpers/template.py”, line 586, in async_render
      render_result = _render_with_context(self.template, compiled, **kwargs)
      ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
      File “/usr/src/homeassistant/homeassistant/helpers/template.py”, line 2545, in _render_with_context
      return template.render(**kwargs)
      ^^^^^^^^^^^^^^^^^^^^^^^^^
      File “/usr/local/lib/python3.12/site-packages/jinja2/environment.py”, line 1301, in render
      self.environment.handle_exception()
      File “/usr/local/lib/python3.12/site-packages/jinja2/environment.py”, line 936, in handle_exception
      raise rewrite_traceback_stack(source=source)
      File “”, line 17, in top-level template code
      File “/usr/local/lib/python3.12/site-packages/jinja2/sandbox.py”, line 326, in getattr
      value = getattr(obj, attribute)
      ^^^^^^^^^^^^^^^^^^^^^^^
      File “/usr/src/homeassistant/homeassistant/helpers/template.py”, line 2580, in _fail_with_undefined_error
      raise ex
      File “/usr/src/homeassistant/homeassistant/helpers/template.py”, line 2577, in _fail_with_undefined_error
      return super()._fail_with_undefined_error(*args, **kwargs)
      ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
      jinja2.exceptions.UndefinedError: ‘resp’ is undefined

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File “/usr/src/homeassistant/homeassistant/helpers/template.py”, line 712, in async_render_to_info
render_info._result = self.async_render(
^^^^^^^^^^^^^^^^^^
File “/usr/src/homeassistant/homeassistant/helpers/template.py”, line 588, in async_render
raise TemplateError(err) from err
homeassistant.exceptions.TemplateError: UndefinedError: ‘resp’ is undefined
2024-04-05 18:14:58.701 ERROR (MainThread) [homeassistant.helpers.template] Template variable error: ‘resp’ is undefined when rendering 'template:

  • trigger:
    • platform: time
      at: “00:00:00”
      action:
    • service: epex_spot.get_lowest_price_interval
      data:
      earliest_start: “20:00:00”
      latest_end: “23:00:00”
      duration:
      hours: 1
      minutes: 5
      response_variable: resp
      sensor:
    • name: Start Appliance
      device_class: timestamp
      state: “{{ resp.start is defined and resp.start }}”’
      2024-04-05 18:14:58.703 ERROR (MainThread) [homeassistant.components.template.template_entity] TemplateError(‘UndefinedError: ‘resp’ is undefined’) while processing template 'Template<template=(template:
  • trigger:
    • platform: time
      at: “00:00:00”
      action:
    • service: epex_spot.get_lowest_price_interval
      data:
      earliest_start: “20:00:00”
      latest_end: “23:00:00”
      duration:
      hours: 1
      minutes: 5
      response_variable: resp
      sensor:
    • name: Start Appliance
      device_class: timestamp
      state: “{{ resp.start is defined and resp.start }}”) renders=4>’ for attribute ‘_attr_native_value’ in entity ‘sensor.start_appliance_2’
      2024-04-05 18:15:00.022 WARNING (MainThread) [async_upnp_client.profiles.dlna] Only InstanceID 0 is supported
      2024-04-05 18:15:01.126 WARNING (MainThread) [async_upnp_client.profiles.dlna] Only InstanceID 0 is supported
      2024-04-05 18:15:01.133 WARNING (MainThread) [async_upnp_client.profiles.dlna] Only InstanceID 0 is supported
      2024-04-05 18:15:01.464 WARNING (MainThread) [async_upnp_client.profiles.dlna] Only InstanceID 0 is supported
      2024-04-05 18:15:01.468 WARNING (MainThread) [async_upnp_client.profiles.dlna] Only InstanceID 0 is supported
      2024-04-05 18:15:01.571 WARNING (MainThread) [async_upnp_client.profiles.dlna] Only InstanceID 0 is supported
      2024-04-05 18:22:26.184 WARNING (MainThread) [homeassistant.components.homeassistant.triggers.numeric_state] Error initializing ‘websocket_api’ trigger: In ‘numeric_state’ condition: entity sensor.epex_spot_data_rank state '[{‘start_time’: ‘2024-04-05T13:00:00+02:00’, ‘end_time’: ‘2024-04-05T14:00:00+02:00’, ‘rank’: 0}, {‘start_time’:

@roadjet Please maintain indentation when pasting configuration data. Otherwise the info is unusable.

good evening, can someone please tell me what I’m doing wrong?
I am getting the current daily values and the values for the next day. However, the sensor always wants to start at 0:00:00.

Thanks in advance.