Feature Request: add support for EPEX Spot sensors

[madmat17]

Hi @woopstar ,

I was thinking, if it was possible to have support for EPEX Spot being added in HSEM as well, as quite some folks are using the EPEX Spot integration (which in turn supports multiple sources).
https://github.com/mampfes/ha_epex_spot

The main sensors published by EPEX Spot in HA are the following:

Total Price (sensor.epex_spot_data_total_price)
Usually the spot price with all fix and variable charges added on top - import price.
The sensor populates the following data within the attributes:

state_class: measurement
data:
  - start_time: "2026-03-12T00:00:00+01:00"
    end_time: "2026-03-12T01:00:00+01:00"
    price_per_kwh: 0.295285
  - start_time: "2026-03-12T01:00:00+01:00"
    end_time: "2026-03-12T02:00:00+01:00"
    price_per_kwh: 0.286633
  - start_time: "2026-03-12T02:00:00+01:00"
    end_time: "2026-03-12T03:00:00+01:00"
    price_per_kwh: 0.2796
  - start_time: "2026-03-12T03:00:00+01:00"
    end_time: "2026-03-12T04:00:00+01:00"
    price_per_kwh: 0.278611
  - start_time: "2026-03-12T04:00:00+01:00"
    end_time: "2026-03-12T05:00:00+01:00"
    price_per_kwh: 0.286757
  - start_time: "2026-03-12T05:00:00+01:00"
    end_time: "2026-03-12T06:00:00+01:00"
    price_per_kwh: 0.303331
  - start_time: "2026-03-12T06:00:00+01:00"
    end_time: "2026-03-12T07:00:00+01:00"
    price_per_kwh: 0.32815
  - start_time: "2026-03-12T07:00:00+01:00"
    end_time: "2026-03-12T08:00:00+01:00"
    price_per_kwh: 0.326778
  - start_time: "2026-03-12T08:00:00+01:00"
    end_time: "2026-03-12T09:00:00+01:00"
    price_per_kwh: 0.281219
  - start_time: "2026-03-12T09:00:00+01:00"
    end_time: "2026-03-12T10:00:00+01:00"
    price_per_kwh: 0.251419
  - start_time: "2026-03-12T10:00:00+01:00"
    end_time: "2026-03-12T11:00:00+01:00"
    price_per_kwh: 0.203784
  - start_time: "2026-03-12T11:00:00+01:00"
    end_time: "2026-03-12T12:00:00+01:00"
    price_per_kwh: 0.162613
  - start_time: "2026-03-12T12:00:00+01:00"
    end_time: "2026-03-12T13:00:00+01:00"
    price_per_kwh: 0.160326
  - start_time: "2026-03-12T13:00:00+01:00"
    end_time: "2026-03-12T14:00:00+01:00"
    price_per_kwh: 0.181919
  - start_time: "2026-03-12T14:00:00+01:00"
    end_time: "2026-03-12T15:00:00+01:00"
    price_per_kwh: 0.255745
  - start_time: "2026-03-12T15:00:00+01:00"
    end_time: "2026-03-12T16:00:00+01:00"
    price_per_kwh: 0.319931
  - start_time: "2026-03-12T16:00:00+01:00"
    end_time: "2026-03-12T17:00:00+01:00"
    price_per_kwh: 0.32113
  - start_time: "2026-03-12T17:00:00+01:00"
    end_time: "2026-03-12T18:00:00+01:00"
    price_per_kwh: 0.347988
  - start_time: "2026-03-12T18:00:00+01:00"
    end_time: "2026-03-12T19:00:00+01:00"
    price_per_kwh: 0.34716
  - start_time: "2026-03-12T19:00:00+01:00"
    end_time: "2026-03-12T20:00:00+01:00"
    price_per_kwh: 0.328608
  - start_time: "2026-03-12T20:00:00+01:00"
    end_time: "2026-03-12T21:00:00+01:00"
    price_per_kwh: 0.304444
  - start_time: "2026-03-12T21:00:00+01:00"
    end_time: "2026-03-12T22:00:00+01:00"
    price_per_kwh: 0.302207
  - start_time: "2026-03-12T22:00:00+01:00"
    end_time: "2026-03-12T23:00:00+01:00"
    price_per_kwh: 0.281924
  - start_time: "2026-03-12T23:00:00+01:00"
    end_time: "2026-03-13T00:00:00+01:00"
    price_per_kwh: 0.300118
  - start_time: "2026-03-13T00:00:00+01:00"
    end_time: "2026-03-13T01:00:00+01:00"
    price_per_kwh: 0.286942
  - start_time: "2026-03-13T01:00:00+01:00"
    end_time: "2026-03-13T02:00:00+01:00"
    price_per_kwh: 0.274446
  - start_time: "2026-03-13T02:00:00+01:00"
    end_time: "2026-03-13T03:00:00+01:00"
    price_per_kwh: 0.276102
  - start_time: "2026-03-13T03:00:00+01:00"
    end_time: "2026-03-13T04:00:00+01:00"
    price_per_kwh: 0.277647
  - start_time: "2026-03-13T04:00:00+01:00"
    end_time: "2026-03-13T05:00:00+01:00"
    price_per_kwh: 0.291441
  - start_time: "2026-03-13T05:00:00+01:00"
    end_time: "2026-03-13T06:00:00+01:00"
    price_per_kwh: 0.297362
  - start_time: "2026-03-13T06:00:00+01:00"
    end_time: "2026-03-13T07:00:00+01:00"
    price_per_kwh: 0.318534
  - start_time: "2026-03-13T07:00:00+01:00"
    end_time: "2026-03-13T08:00:00+01:00"
    price_per_kwh: 0.311922
  - start_time: "2026-03-13T08:00:00+01:00"
    end_time: "2026-03-13T09:00:00+01:00"
    price_per_kwh: 0.25907
  - start_time: "2026-03-13T09:00:00+01:00"
    end_time: "2026-03-13T10:00:00+01:00"
    price_per_kwh: 0.172266
  - start_time: "2026-03-13T10:00:00+01:00"
    end_time: "2026-03-13T11:00:00+01:00"
    price_per_kwh: 0.161673
  - start_time: "2026-03-13T11:00:00+01:00"
    end_time: "2026-03-13T12:00:00+01:00"
    price_per_kwh: 0.158373
  - start_time: "2026-03-13T12:00:00+01:00"
    end_time: "2026-03-13T13:00:00+01:00"
    price_per_kwh: 0.155765
  - start_time: "2026-03-13T13:00:00+01:00"
    end_time: "2026-03-13T14:00:00+01:00"
    price_per_kwh: 0.152589
  - start_time: "2026-03-13T14:00:00+01:00"
    end_time: "2026-03-13T15:00:00+01:00"
    price_per_kwh: 0.159436
  - start_time: "2026-03-13T15:00:00+01:00"
    end_time: "2026-03-13T16:00:00+01:00"
    price_per_kwh: 0.233003
  - start_time: "2026-03-13T16:00:00+01:00"
    end_time: "2026-03-13T17:00:00+01:00"
    price_per_kwh: 0.286349
  - start_time: "2026-03-13T17:00:00+01:00"
    end_time: "2026-03-13T18:00:00+01:00"
    price_per_kwh: 0.329782
  - start_time: "2026-03-13T18:00:00+01:00"
    end_time: "2026-03-13T19:00:00+01:00"
    price_per_kwh: 0.344626
  - start_time: "2026-03-13T19:00:00+01:00"
    end_time: "2026-03-13T20:00:00+01:00"
    price_per_kwh: 0.35507
  - start_time: "2026-03-13T20:00:00+01:00"
    end_time: "2026-03-13T21:00:00+01:00"
    price_per_kwh: 0.332835
  - start_time: "2026-03-13T21:00:00+01:00"
    end_time: "2026-03-13T22:00:00+01:00"
    price_per_kwh: 0.316149
  - start_time: "2026-03-13T22:00:00+01:00"
    end_time: "2026-03-13T23:00:00+01:00"
    price_per_kwh: 0.304271
  - start_time: "2026-03-13T23:00:00+01:00"
    end_time: "2026-03-14T00:00:00+01:00"
    price_per_kwh: 0.293394
  - start_time: "2026-03-14T00:00:00+01:00"
    end_time: "2026-03-14T01:00:00+01:00"
    price_per_kwh: 0.29128
  - start_time: "2026-03-14T01:00:00+01:00"
    end_time: "2026-03-14T02:00:00+01:00"
    price_per_kwh: 0.286151
  - start_time: "2026-03-14T02:00:00+01:00"
    end_time: "2026-03-14T03:00:00+01:00"
    price_per_kwh: 0.279254
  - start_time: "2026-03-14T03:00:00+01:00"
    end_time: "2026-03-14T04:00:00+01:00"
    price_per_kwh: 0.282876
  - start_time: "2026-03-14T04:00:00+01:00"
    end_time: "2026-03-14T05:00:00+01:00"
    price_per_kwh: 0.284037
  - start_time: "2026-03-14T05:00:00+01:00"
    end_time: "2026-03-14T06:00:00+01:00"
    price_per_kwh: 0.286102
  - start_time: "2026-03-14T06:00:00+01:00"
    end_time: "2026-03-14T07:00:00+01:00"
    price_per_kwh: 0.288401
  - start_time: "2026-03-14T07:00:00+01:00"
    end_time: "2026-03-14T08:00:00+01:00"
    price_per_kwh: 0.265695
  - start_time: "2026-03-14T08:00:00+01:00"
    end_time: "2026-03-14T09:00:00+01:00"
    price_per_kwh: 0.208988
  - start_time: "2026-03-14T09:00:00+01:00"
    end_time: "2026-03-14T10:00:00+01:00"
    price_per_kwh: 0.189595
  - start_time: "2026-03-14T10:00:00+01:00"
    end_time: "2026-03-14T11:00:00+01:00"
    price_per_kwh: 0.169633
  - start_time: "2026-03-14T11:00:00+01:00"
    end_time: "2026-03-14T12:00:00+01:00"
    price_per_kwh: 0.147933
  - start_time: "2026-03-14T12:00:00+01:00"
    end_time: "2026-03-14T13:00:00+01:00"
    price_per_kwh: 0.147538
  - start_time: "2026-03-14T13:00:00+01:00"
    end_time: "2026-03-14T14:00:00+01:00"
    price_per_kwh: 0.149758
  - start_time: "2026-03-14T14:00:00+01:00"
    end_time: "2026-03-14T15:00:00+01:00"
    price_per_kwh: 0.178965
  - start_time: "2026-03-14T15:00:00+01:00"
    end_time: "2026-03-14T16:00:00+01:00"
    price_per_kwh: 0.225068
  - start_time: "2026-03-14T16:00:00+01:00"
    end_time: "2026-03-14T17:00:00+01:00"
    price_per_kwh: 0.301712
  - start_time: "2026-03-14T17:00:00+01:00"
    end_time: "2026-03-14T18:00:00+01:00"
    price_per_kwh: 0.325691
  - start_time: "2026-03-14T18:00:00+01:00"
    end_time: "2026-03-14T19:00:00+01:00"
    price_per_kwh: 0.34852
  - start_time: "2026-03-14T19:00:00+01:00"
    end_time: "2026-03-14T20:00:00+01:00"
    price_per_kwh: 0.359322
  - start_time: "2026-03-14T20:00:00+01:00"
    end_time: "2026-03-14T21:00:00+01:00"
    price_per_kwh: 0.335134
  - start_time: "2026-03-14T21:00:00+01:00"
    end_time: "2026-03-14T22:00:00+01:00"
    price_per_kwh: 0.319288
  - start_time: "2026-03-14T22:00:00+01:00"
    end_time: "2026-03-14T23:00:00+01:00"
    price_per_kwh: 0.316557
  - start_time: "2026-03-14T23:00:00+01:00"
    end_time: "2026-03-15T00:00:00+01:00"
    price_per_kwh: 0.30767
unit_of_measurement: €/kWh
icon: mdi:currency-eur
friendly_name: EPEX Spot Data Total Price

Market Price (sensor.epex_spot_data_market_price)
Plain spot price (in many scenarios the export price).
The sensor populates the following data within the attributes:

state_class: measurement
data:
  - start_time: "2026-03-12T00:00:00+01:00"
    end_time: "2026-03-12T01:00:00+01:00"
    price_per_kwh: 0.11803
  - start_time: "2026-03-12T01:00:00+01:00"
    end_time: "2026-03-12T02:00:00+01:00"
    price_per_kwh: 0.11103
  - start_time: "2026-03-12T02:00:00+01:00"
    end_time: "2026-03-12T03:00:00+01:00"
    price_per_kwh: 0.10534
  - start_time: "2026-03-12T03:00:00+01:00"
    end_time: "2026-03-12T04:00:00+01:00"
    price_per_kwh: 0.10454
  - start_time: "2026-03-12T04:00:00+01:00"
    end_time: "2026-03-12T05:00:00+01:00"
    price_per_kwh: 0.11113
  - start_time: "2026-03-12T05:00:00+01:00"
    end_time: "2026-03-12T06:00:00+01:00"
    price_per_kwh: 0.12454
  - start_time: "2026-03-12T06:00:00+01:00"
    end_time: "2026-03-12T07:00:00+01:00"
    price_per_kwh: 0.14462
  - start_time: "2026-03-12T07:00:00+01:00"
    end_time: "2026-03-12T08:00:00+01:00"
    price_per_kwh: 0.14351
  - start_time: "2026-03-12T08:00:00+01:00"
    end_time: "2026-03-12T09:00:00+01:00"
    price_per_kwh: 0.10665
  - start_time: "2026-03-12T09:00:00+01:00"
    end_time: "2026-03-12T10:00:00+01:00"
    price_per_kwh: 0.08254
  - start_time: "2026-03-12T10:00:00+01:00"
    end_time: "2026-03-12T11:00:00+01:00"
    price_per_kwh: 0.044
  - start_time: "2026-03-12T11:00:00+01:00"
    end_time: "2026-03-12T12:00:00+01:00"
    price_per_kwh: 0.01069
  - start_time: "2026-03-12T12:00:00+01:00"
    end_time: "2026-03-12T13:00:00+01:00"
    price_per_kwh: 0.00884
  - start_time: "2026-03-12T13:00:00+01:00"
    end_time: "2026-03-12T14:00:00+01:00"
    price_per_kwh: 0.02631
  - start_time: "2026-03-12T14:00:00+01:00"
    end_time: "2026-03-12T15:00:00+01:00"
    price_per_kwh: 0.08604
  - start_time: "2026-03-12T15:00:00+01:00"
    end_time: "2026-03-12T16:00:00+01:00"
    price_per_kwh: 0.13797
  - start_time: "2026-03-12T16:00:00+01:00"
    end_time: "2026-03-12T17:00:00+01:00"
    price_per_kwh: 0.13894
  - start_time: "2026-03-12T17:00:00+01:00"
    end_time: "2026-03-12T18:00:00+01:00"
    price_per_kwh: 0.16067
  - start_time: "2026-03-12T18:00:00+01:00"
    end_time: "2026-03-12T19:00:00+01:00"
    price_per_kwh: 0.16
  - start_time: "2026-03-12T19:00:00+01:00"
    end_time: "2026-03-12T20:00:00+01:00"
    price_per_kwh: 0.14499
  - start_time: "2026-03-12T20:00:00+01:00"
    end_time: "2026-03-12T21:00:00+01:00"
    price_per_kwh: 0.12544
  - start_time: "2026-03-12T21:00:00+01:00"
    end_time: "2026-03-12T22:00:00+01:00"
    price_per_kwh: 0.12363
  - start_time: "2026-03-12T22:00:00+01:00"
    end_time: "2026-03-12T23:00:00+01:00"
    price_per_kwh: 0.10722
  - start_time: "2026-03-12T23:00:00+01:00"
    end_time: "2026-03-13T00:00:00+01:00"
    price_per_kwh: 0.12194
  - start_time: "2026-03-13T00:00:00+01:00"
    end_time: "2026-03-13T01:00:00+01:00"
    price_per_kwh: 0.11128
  - start_time: "2026-03-13T01:00:00+01:00"
    end_time: "2026-03-13T02:00:00+01:00"
    price_per_kwh: 0.10117
  - start_time: "2026-03-13T02:00:00+01:00"
    end_time: "2026-03-13T03:00:00+01:00"
    price_per_kwh: 0.10251
  - start_time: "2026-03-13T03:00:00+01:00"
    end_time: "2026-03-13T04:00:00+01:00"
    price_per_kwh: 0.10376
  - start_time: "2026-03-13T04:00:00+01:00"
    end_time: "2026-03-13T05:00:00+01:00"
    price_per_kwh: 0.11492
  - start_time: "2026-03-13T05:00:00+01:00"
    end_time: "2026-03-13T06:00:00+01:00"
    price_per_kwh: 0.11971
  - start_time: "2026-03-13T06:00:00+01:00"
    end_time: "2026-03-13T07:00:00+01:00"
    price_per_kwh: 0.13684
  - start_time: "2026-03-13T07:00:00+01:00"
    end_time: "2026-03-13T08:00:00+01:00"
    price_per_kwh: 0.13149
  - start_time: "2026-03-13T08:00:00+01:00"
    end_time: "2026-03-13T09:00:00+01:00"
    price_per_kwh: 0.08873
  - start_time: "2026-03-13T09:00:00+01:00"
    end_time: "2026-03-13T10:00:00+01:00"
    price_per_kwh: 0.0185
  - start_time: "2026-03-13T10:00:00+01:00"
    end_time: "2026-03-13T11:00:00+01:00"
    price_per_kwh: 0.00993
  - start_time: "2026-03-13T11:00:00+01:00"
    end_time: "2026-03-13T12:00:00+01:00"
    price_per_kwh: 0.00726
  - start_time: "2026-03-13T12:00:00+01:00"
    end_time: "2026-03-13T13:00:00+01:00"
    price_per_kwh: 0.00515
  - start_time: "2026-03-13T13:00:00+01:00"
    end_time: "2026-03-13T14:00:00+01:00"
    price_per_kwh: 0.00258
  - start_time: "2026-03-13T14:00:00+01:00"
    end_time: "2026-03-13T15:00:00+01:00"
    price_per_kwh: 0.00812
  - start_time: "2026-03-13T15:00:00+01:00"
    end_time: "2026-03-13T16:00:00+01:00"
    price_per_kwh: 0.06764
  - start_time: "2026-03-13T16:00:00+01:00"
    end_time: "2026-03-13T17:00:00+01:00"
    price_per_kwh: 0.1108
  - start_time: "2026-03-13T17:00:00+01:00"
    end_time: "2026-03-13T18:00:00+01:00"
    price_per_kwh: 0.14594
  - start_time: "2026-03-13T18:00:00+01:00"
    end_time: "2026-03-13T19:00:00+01:00"
    price_per_kwh: 0.15795
  - start_time: "2026-03-13T19:00:00+01:00"
    end_time: "2026-03-13T20:00:00+01:00"
    price_per_kwh: 0.1664
  - start_time: "2026-03-13T20:00:00+01:00"
    end_time: "2026-03-13T21:00:00+01:00"
    price_per_kwh: 0.14841
  - start_time: "2026-03-13T21:00:00+01:00"
    end_time: "2026-03-13T22:00:00+01:00"
    price_per_kwh: 0.13491
  - start_time: "2026-03-13T22:00:00+01:00"
    end_time: "2026-03-13T23:00:00+01:00"
    price_per_kwh: 0.1253
  - start_time: "2026-03-13T23:00:00+01:00"
    end_time: "2026-03-14T00:00:00+01:00"
    price_per_kwh: 0.1165
  - start_time: "2026-03-14T00:00:00+01:00"
    end_time: "2026-03-14T01:00:00+01:00"
    price_per_kwh: 0.11479
  - start_time: "2026-03-14T01:00:00+01:00"
    end_time: "2026-03-14T02:00:00+01:00"
    price_per_kwh: 0.11064
  - start_time: "2026-03-14T02:00:00+01:00"
    end_time: "2026-03-14T03:00:00+01:00"
    price_per_kwh: 0.10506
  - start_time: "2026-03-14T03:00:00+01:00"
    end_time: "2026-03-14T04:00:00+01:00"
    price_per_kwh: 0.10799
  - start_time: "2026-03-14T04:00:00+01:00"
    end_time: "2026-03-14T05:00:00+01:00"
    price_per_kwh: 0.10893
  - start_time: "2026-03-14T05:00:00+01:00"
    end_time: "2026-03-14T06:00:00+01:00"
    price_per_kwh: 0.1106
  - start_time: "2026-03-14T06:00:00+01:00"
    end_time: "2026-03-14T07:00:00+01:00"
    price_per_kwh: 0.11246
  - start_time: "2026-03-14T07:00:00+01:00"
    end_time: "2026-03-14T08:00:00+01:00"
    price_per_kwh: 0.09409
  - start_time: "2026-03-14T08:00:00+01:00"
    end_time: "2026-03-14T09:00:00+01:00"
    price_per_kwh: 0.04821
  - start_time: "2026-03-14T09:00:00+01:00"
    end_time: "2026-03-14T10:00:00+01:00"
    price_per_kwh: 0.03252
  - start_time: "2026-03-14T10:00:00+01:00"
    end_time: "2026-03-14T11:00:00+01:00"
    price_per_kwh: 0.01637
  - start_time: "2026-03-14T11:00:00+01:00"
    end_time: "2026-03-14T12:00:00+01:00"
    price_per_kwh: -0.00126
  - start_time: "2026-03-14T12:00:00+01:00"
    end_time: "2026-03-14T13:00:00+01:00"
    price_per_kwh: -0.0016
  - start_time: "2026-03-14T13:00:00+01:00"
    end_time: "2026-03-14T14:00:00+01:00"
    price_per_kwh: 0.00029
  - start_time: "2026-03-14T14:00:00+01:00"
    end_time: "2026-03-14T15:00:00+01:00"
    price_per_kwh: 0.02392
  - start_time: "2026-03-14T15:00:00+01:00"
    end_time: "2026-03-14T16:00:00+01:00"
    price_per_kwh: 0.06122
  - start_time: "2026-03-14T16:00:00+01:00"
    end_time: "2026-03-14T17:00:00+01:00"
    price_per_kwh: 0.12323
  - start_time: "2026-03-14T17:00:00+01:00"
    end_time: "2026-03-14T18:00:00+01:00"
    price_per_kwh: 0.14263
  - start_time: "2026-03-14T18:00:00+01:00"
    end_time: "2026-03-14T19:00:00+01:00"
    price_per_kwh: 0.1611
  - start_time: "2026-03-14T19:00:00+01:00"
    end_time: "2026-03-14T20:00:00+01:00"
    price_per_kwh: 0.16984
  - start_time: "2026-03-14T20:00:00+01:00"
    end_time: "2026-03-14T21:00:00+01:00"
    price_per_kwh: 0.15027
  - start_time: "2026-03-14T21:00:00+01:00"
    end_time: "2026-03-14T22:00:00+01:00"
    price_per_kwh: 0.13745
  - start_time: "2026-03-14T22:00:00+01:00"
    end_time: "2026-03-14T23:00:00+01:00"
    price_per_kwh: 0.13524
  - start_time: "2026-03-14T23:00:00+01:00"
    end_time: "2026-03-15T00:00:00+01:00"
    price_per_kwh: 0.12805
price_per_kwh: 0.15795
unit_of_measurement: €/kWh
icon: mdi:currency-eur
friendly_name: EPEX Spot Data Market Price

There're also other EPEX Spot sensors, which I'm not sure, if they'd be of any use for HSEM (assuming that the data therein is computed in some way by HSEM anyway):

• Average Price
• Highest Price
• Lowest Price
• Median Price
• Quantile
• Rank (ranking the current hour's price in relation to the day's highest and lowest price)

Cheers
Mat

[madmat17]

For the time being the following workaround could help users to get the EPEX data fed into HSEM:
Create a template sensor that retains the EPEX Spot data in the Energi integration's format, which then may be used in HSEM.

template:
  - sensor:
      # Energy price sensors in ct/kWh
      # Attributes formatted for HSEM
      - name: "EPEX Spot Rate Inport (ct/kWh)"
        unique_id: epex_spot_rate_import_ct_kwh
        unit_of_measurement: "ct/kWh"
        device_class: monetary
        state: >
          {% set price = states('sensor.epex_spot_data_total_price') %}
          {{ (price | float(0) * 100) | round(2) if is_number(price) else 'unavailable' }}
        attributes:
          raw_today: >
            {% set data = state_attr('sensor.epex_spot_data_total_price', 'data') %}
            {% if data is iterable %}
              {% set today = now().strftime('%Y-%m-%d') %}
              {% set ns = namespace(items=[]) %}
              {% for item in data if item.start_time.startswith(today) %}
                {% set ns.items = ns.items + [{"hour": item.start_time, "price": (item.price_per_kwh | float(0) * 100) | round(2)}] %}
              {% endfor %}
              {{ ns.items }}
            {% else %}
              []
            {% endif %}
          raw_tomorrow: >
            {% set data = state_attr('sensor.epex_spot_data_total_price', 'data') %}
            {% if data is iterable %}
              {% set tomorrow = (now() + timedelta(days=1)).strftime('%Y-%m-%d') %}
              {% set ns = namespace(items=[]) %}
              {% for item in data if item.start_time.startswith(tomorrow) %}
                {% set ns.items = ns.items + [{"hour": item.start_time, "price": (item.price_per_kwh | float(0) * 100) | round(2)}] %}
              {% endfor %}
              {{ ns.items }}
            {% else %}
              []
            {% endif %}
  
      - name: "EPEX Spot Rate Export (ct/kWh)"
        unique_id: epex_spot_rate_export_ct_kwh
        unit_of_measurement: "ct/kWh"
        device_class: monetary
        state: >
          {% set price = states('sensor.epex_spot_data_market_price') %}
          {{ (price | float(0) * 100) | round(2) if is_number(price) else 'unavailable' }}
        attributes:
          raw_today: >
            {% set data = state_attr('sensor.epex_spot_data_market_price', 'data') %}
            {% if data is iterable %}
              {% set today = now().strftime('%Y-%m-%d') %}
              {% set ns = namespace(items=[]) %}
              {% for item in data if item.start_time.startswith(today) %}
                {% set ns.items = ns.items + [{"hour": item.start_time, "price": (item.price_per_kwh | float(0) * 100) | round(2)}] %}
              {% endfor %}
              {{ ns.items }}
            {% else %}
              []
            {% endif %}
          raw_tomorrow: >
            {% set data = state_attr('sensor.epex_spot_data_market_price', 'data') %}
            {% if data is iterable %}
              {% set tomorrow = (now() + timedelta(days=1)).strftime('%Y-%m-%d') %}
              {% set ns = namespace(items=[]) %}
              {% for item in data if item.start_time.startswith(tomorrow) %}
                {% set ns.items = ns.items + [{"hour": item.start_time, "price": (item.price_per_kwh | float(0) * 100) | round(2)}] %}
              {% endfor %}
              {{ ns.items }}
            {% else %}
              []
            {% endif %}

The resulting attributes look like as follows:

raw_today:
  - hour: "2026-03-16T00:00:00+01:00"
    price: 25.24
  - hour: "2026-03-16T01:00:00+01:00"
    price: 25.07
  - hour: "2026-03-16T02:00:00+01:00"
    price: 25.87
  - hour: "2026-03-16T03:00:00+01:00"
    price: 22.47
  - hour: "2026-03-16T04:00:00+01:00"
    price: 26.07
  - hour: "2026-03-16T05:00:00+01:00"
    price: 26.43
  - hour: "2026-03-16T06:00:00+01:00"
    price: 32.86
  - hour: "2026-03-16T07:00:00+01:00"
    price: 31.55
  - hour: "2026-03-16T08:00:00+01:00"
    price: 27.39
  - hour: "2026-03-16T09:00:00+01:00"
    price: 23.99
  - hour: "2026-03-16T10:00:00+01:00"
    price: 20.23
  - hour: "2026-03-16T11:00:00+01:00"
    price: 17.09
  - hour: "2026-03-16T12:00:00+01:00"
    price: 17.91
  - hour: "2026-03-16T13:00:00+01:00"
    price: 22.2
  - hour: "2026-03-16T14:00:00+01:00"
    price: 26.08
  - hour: "2026-03-16T15:00:00+01:00"
    price: 30.27
  - hour: "2026-03-16T16:00:00+01:00"
    price: 32.25
  - hour: "2026-03-16T17:00:00+01:00"
    price: 33.38
  - hour: "2026-03-16T18:00:00+01:00"
    price: 35.78
  - hour: "2026-03-16T19:00:00+01:00"
    price: 37.12
  - hour: "2026-03-16T20:00:00+01:00"
    price: 34.03
  - hour: "2026-03-16T21:00:00+01:00"
    price: 30.51
  - hour: "2026-03-16T22:00:00+01:00"
    price: 30.13
  - hour: "2026-03-16T23:00:00+01:00"
    price: 27.31
raw_tomorrow: []
unit_of_measurement: ct/kWh
device_class: monetary
friendly_name: EPEX Spot Rate Import (ct/kWh)

[woopstar]

#239 should fix this :)

[woopstar]

You can test it in pre-release v5.1.0