EPEX Spot and Awattar Electricity Prices

nleitao · December 17, 2024, 9:15pm

I wonder if this is it.
It feels like it is. The numbers feels right.

Sub307 · December 25, 2024, 11:48am

How I see it you need to put 2, 1 and 6.
The 0.102 = 100% + 2% Surcharge
1 = Absolute surcharge
1.06 = 100% + 6% tax

Ernst0815 · January 3, 2025, 2:58pm

SOLUTION for SmartEnergy.AT is the screenshot HERE!

Thank you @AkshayR and of course @webwude for the information and the detailed description of the steps.
I’ve had the same issues with SmartEnergy.AT and tried all values from their homepage but without any success.

Your’s screenshot here was the solution, although I don’t understand the shown figures

Ernst0815 · January 3, 2025, 3:53pm

Many, many, many thanks @webwude to you for the big effort.
Helped me a lot and is exactly what I was looking for.

But I’m struggling with some details.

I copied all the code into the respective two (current prices, tomorrow’s prices) cards in the dashboard and also got the corresponding layout - see screenshots, BUT:

The marking “Now” - the current price is set back in time for me, approx. 30-45 minutes → why? - see screenshot
Prices for tomorrow are displayed in the dashboard (the condition in the card must be deleted) - BUT the prices are not updated for me - see also screenshots

KingJosef · January 8, 2025, 7:30pm

Servus , hast du es inzwischen hin bekommen ?

KingJosef · January 11, 2025, 6:44pm

@webwude
könntes du mir bitte mal wegen Awattar Dasboard weiter helfen ?

danke

MikeyMike73 · January 13, 2025, 8:09pm

Hi there, great integration and great sensor!
I have set-up everything and it works great.

I want to add one more thing that I can’t seem to find out how to do this. I saw @mmartin327 also wants to have this info.

Is there a way to check if next day price in the morning has a certain spread to the current evening price?
I managed to do this for the current day by template sensor and current day high and low prices. With this template sensor I decide to charge or not charge my battery.

But I would also like to decide when to discharge the battery in the evening based on the next days price. When the price spread is not large enough, then I don’t want to discharge the battery (I also use solar forecast as well as condition). So when it is not sunny and there is a small price difference I don’t want to discharge…

So how can I get next day high and low price into an entity?

nleitao · January 24, 2025, 7:10pm

Am I the only one that today stopped getting this info?

Guidau · January 25, 2025, 10:06am

Hello,
a GitHub issue has already been opened here!

github.com/mampfes/ha_epex_spot

Epex Spot certificate cannot be verified

opened 08:56AM - 24 Jan 25 UTC

x3e

The integration fails to load with the following error: Cannot connect to host …www.epexspot.com:443 ssl:True [SSLCertVerificationError: (1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1018)')] It seems that epexspot is missing a(n intermediate) certificate. I cannot "wget" the web page either: > $ wget https://www.epexspot.com --2025-01-24 08:55:17-- https://www.epexspot.com/ Resolving www.epexspot.com (www.epexspot.com)... 195.254.158.137 Connecting to www.epexspot.com (www.epexspot.com)|195.254.158.137|:443... connected. ERROR: cannot verify www.epexspot.com's certificate, issued by ‘CN=Sectigo RSA Domain Validation Secure Server CA,O=Sectigo Limited,L=Salford,ST=Greater Manchester,C=GB’: Unable to locally verify the issuer's authority. To connect to www.epexspot.com insecurely, use `--no-check-certificate'.

KingJosef · January 27, 2025, 6:26pm

there is an uptdate to 3.0.0

Michel1973 · January 29, 2025, 12:19pm

Hallo Webwude,
Seit dem Update auf Version 3.0 müssen die Scripte für die Apex Graphen aktualisiert werden.

entry.price_ct_per_kwh Muss mit entry.price_per_kwh ersetzt werden.

Falls die Werte weiterhin in Cent angezeigt werden sollen, muss man diesen Wert nochmals mit 100 multiplizieren.

Viele Grüße
Michel

fritzphantom · February 2, 2025, 1:09pm

Ja das war leider eine Änderung, die meine config zerstört hat.

Hier ist meine reparierte Darstellung, die die Awattar Preise für heute und morgen anzeigt. Weil ich noch einen Fixpreis habe, ist der als horizontale Linie als Referenz dabei. Vielleicht braucht es ja jemand

Code:

type: vertical-stack
cards:
  - type: custom:apexcharts-card
    graph_span: 24h
    experimental:
      color_threshold: true
    header:
      title: Strom Einkaufspreis aWATTar (heute)
      show: true
      show_states: true
    span:
      start: day
    now:
      show: true
      label: now
      color: darkblue
    series:
      - entity: sensor.epex_spot_data_net_price
        type: column
        extend_to: end
        unit: €/kWh
        float_precision: 3
        yaxis_id: Price
        show:
          in_header: before_now
          extremas: true
          header_color_threshold: true
        color_threshold:
          - value: 0.02
            color: 00ed01
          - value: 0.04
            color: 3af901
          - value: 0.06
            color: 87fa00
          - value: 0.08
            color: cefb02
          - value: 0.1
            color: eeff00
          - value: 0.12
            color: ffde1a
          - value: 0.14
            color: ffa700
          - value: 0.16
            color: ff8d00
          - value: 0.18
            color: ff7400
          - value: 0.2
            color: ff4d00
          - value: 0.22
            color: ff4d00
          - value: 0.24
            color: ff0000
          - value: 0.26
            color: e60000
          - value: 0.28
            color: cc0000
          - value: 0.3
            color: b30000
          - value: 0.32
            color: "990000"
          - value: 0.34
            color: "800000"
          - value: 0.36
            color: "660000"
          - value: 0.38
            color: 4d0000
          - value: 0.4
            color: "330000"
        data_generator: |
          return entity.attributes.data.map((entry) => {
            return [new Date(entry.start_time), entry.price_per_kwh];
          });
        group_by:
          func: avg
          duration: 1h
    yaxis:
      - id: Price
        decimals: 3
        apex_config:
          title:
            text: €/kWh
          tickAmount: 5
        min: 0
    apex_config:
      legend:
        show: false
      tooltip:
        x:
          show: true
          format: HH:00 - HH:59
      annotations:
        yaxis:
          - "y": 0.089
            borderColor: "#00E396"
            borderWidth: 2
            strokeDashArray: 15
            label:
              borderColor: "#00E396"
              style:
                color: "#fff"
                background: "#00E396"
                fontSize: "16"
              text: Fixpreis
  - type: custom:apexcharts-card
    graph_span: 24h
    experimental:
      color_threshold: true
    header:
      title: Strom Einkaufspreis aWATTar (morgen)
      show: true
      show_states: false
    span:
      start: day
      offset: +1day
    series:
      - entity: sensor.epex_spot_data_net_price
        type: column
        extend_to: end
        unit: €/kWh
        float_precision: 3
        yaxis_id: Price
        show:
          extremas: true
          header_color_threshold: true
        color_threshold:
          - value: 0.02
            color: 00ed01
          - value: 0.04
            color: 3af901
          - value: 0.06
            color: 87fa00
          - value: 0.08
            color: cefb02
          - value: 0.1
            color: eeff00
          - value: 0.12
            color: ffde1a
          - value: 0.14
            color: ffa700
          - value: 0.16
            color: ff8d00
          - value: 0.18
            color: ff7400
          - value: 0.2
            color: ff4d00
          - value: 0.22
            color: ff4d00
          - value: 0.24
            color: ff0000
          - value: 0.26
            color: e60000
          - value: 0.28
            color: cc0000
          - value: 0.3
            color: b30000
          - value: 0.32
            color: "990000"
          - value: 0.34
            color: "800000"
          - value: 0.36
            color: "660000"
          - value: 0.38
            color: 4d0000
          - value: 0.4
            color: "330000"
        data_generator: |
          return entity.attributes.data.map((entry) => {
            return [new Date(entry.start_time), entry.price_per_kwh];
          });
        group_by:
          func: avg
          duration: 1h
    yaxis:
      - id: Price
        decimals: 3
        apex_config:
          title:
            text: €/kWh
          tickAmount: 5
        min: 0
    apex_config:
      legend:
        show: false
      tooltip:
        x:
          show: true
          format: HH:00 - HH:59
      annotations:
        yaxis:
          - "y": 0.089
            borderColor: "#00E396"
            borderWidth: 2
            strokeDashArray: 15
            label:
              borderColor: "#00E396"
              style:
                color: "#fff"
                background: "#00E396"
                fontSize: "16"
              text: Fixpreis

webwude · February 9, 2025, 10:08pm

I did not get any mails or they were moved to spam, usually I was getting any question as notification, sorry.

I updated my dashboards and will post the updates shortly. I will follow up with the questions as well. Sorry for the delay.

Ernst0815 · February 11, 2025, 9:21pm

Nein, habe ich leider nicht.
Bin auch durch viele Recherchen nirgendwo auf eine Lösung gekommen?
Hast Du eine Idee?

Ernst0815 · February 12, 2025, 4:30am

Good morning everyone,

Last night, for the first time, my dishwasher successfully started its program automatically, thanks to the amazing Super-Sensor ha_epex_spot from mampfes in its latest version 3.0.0. Huge thanks for this great work!

BUT – despite following all the instructions, I still can’t get the electricity price chart (EPEX Sensor Configuration) for Smart Energy to display the correct values.
I have entered everything exactly as described on the GitHub page.

Why am I seeing discrepancies in the prices? → See screenshots.

Can anyone help me?

Petzi · February 14, 2025, 12:44am

Have a look into your APEX chart config.

Ernst0815 · February 15, 2025, 3:19pm

What to look for?
I cannot find any errors or wrong formulas - please see:

Summary

type: custom:apexcharts-card
graph_span: 24h
experimental:
  color_threshold: true
header:
  title: Strom Einkaufspreis SMART-ENERGY (heute)
  show: true
  show_states: true
span:
  start: day
now:
  show: true
  label: now
  color: darkblue
series:
  - entity: sensor.epex_spot_data_net_price
    type: column
    extend_to: end
    unit: ct/kWh
    float_precision: 3
    yaxis_id: Price
    show:
      in_header: before_now
      extremas: true
      header_color_threshold: true
    color_threshold:
      - value: 2
        color: 00ed01
      - value: 4
        color: 3af901
      - value: 6
        color: 87fa00
      - value: 8
        color: cefb02
      - value: 10
        color: eeff00
      - value: 12
        color: ffde1a
      - value: 14
        color: ffa700
      - value: 16
        color: ff8d00
      - value: 18
        color: ff7400
      - value: 20
        color: ff4d00
      - value: 22
        color: ff4d00
      - value: 24
        color: ff0000
      - value: 26
        color: e60000
      - value: 28
        color: cc0000
      - value: 30
        color: b30000
      - value: 32
        color: "990000"
      - value: 34
        color: "800000"
      - value: 36
        color: "660000"
      - value: 38
        color: 4d0000
      - value: 40
        color: "330000"
    data_generator: |
      return entity.attributes.data.map((entry) => {
        return [new Date(entry.start_time), entry.price_per_kwh*100];
      });
    group_by:
      func: avg
      duration: 1h
yaxis:
  - id: Price
    decimals: 3
    apex_config:
      title:
        text: ct/kWh
      tickAmount: 5
    min: 0
apex_config:
  legend:
    show: false
  tooltip:
    x:
      show: true
      format: HH:00 - HH:59

kreativhuhn · March 29, 2025, 5:42pm

Your code looks completely correct. I think you took the wrong config from the screenshot.

For SmartEnergy the EPEX Spot configuration values have to be:
Percent Surcharge (%):
0
Absolute Surcharge (€ per kWh):
0,012
Tax (%):
20

DaHype · April 7, 2025, 11:49am

@webwude
May can you please post the Update? Or did i miss it? Thanks

webwude · April 20, 2025, 11:15am

Thx for the reminder. I will post the updates today.

Ok not today, but soon. Very busy lately.