Apex chart Epex spot price

Energy
1

Hello can anyone check ma apex code i does not show the epex spot chart i have edit it cause there was a update from cent to euro an now i doesnt see the chart any ideas?

image

type: custom:apexcharts-card
graph_span: 48h
experimental:
  color_threshold: true
header:
  title: Stromkosten inkl. NG
  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: 2
    yaxis_id: preis
    show:
      in_header: before_now
      extremas: true
      header_color_threshold: true
    color_threshold:
      - value: 0.12
        color: 00ed01
      - value: 0.14
        color: 3af901
      - value: 0.16
        color: 87fa00
      - value: 0.18
        color: cefb02
      - value: 0.2
        color: eeff00
      - value: 0.22
        color: ffde1a
      - value: 0.24
        color: ffa700
      - value: 0.26
        color: ff8d00
      - value: 0.28
        color: ff7400
      - value: 0.3
        color: ff4d00
      - value: 0.32
        color: ff4d00
      - value: 0.34
        color: ff0000
      - value: 0.36
        color: e60000
      - value: 0.38
        color: cc0000
      - value: 0.4
        color: b30000
      - value: 0.42
        color: "990000"
      - value: 0.44
        color: "800000"
      - value: 0.46
        color: "660000"
      - value: 0.48
        color: 4d0000
      - value: 0.5
        color: "330000"
    data_generator: |
      return entity.attributes.data.map((entry) => {
        return [new Date(entry.start_time), entry.price_ct_per_kwh];
      });
    group_by:
      func: avg
      duration: 1h
yaxis:
  - id: preis
    decimals: 2
    apex_config:
      title:
        text: €/kWh
      tickAmount: 5
apex_config:
  legend:
    show: false
  tooltip:
    x:
      show: true
      format: HH:00 - HH:59
2

got fixed entry price changed

3

I have the same issue, do you mean that you fixed it with this comment?

If so, how did you? :slight_smile:

4

Hi
I use the same script. The only difference is the entity.

… return [new Date(entry.start_time), entry.price_per_kwh]; …

I think that’s the mistake.

1 Like
5

If you still want the cent graph with same colouring, you could simply multiply by 100 to convert € to ct, like:
…return [new Date(entry.start_time), 100*entry.price_per_kwh];