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