17
Dec
Smart Home

Home Assistant – Electrisity Price Graph

Posted on by Martin
type: custom:apexcharts-card header: show: true title: Power Usage Hourly vs Electricity Price show_states: true colorize_states: true now: show: true label: Now graph_span: 72h span: start: day offset: ‘-24h’ apex_config: xaxis: labels: format: dd.MM chart: zoom: enabled: true toolbar: show: true tools: zoom: true zoomin: false zoomout: false pan: false reset: true tooltip: fixed: enabled: true position: bottomLeft yaxis: – id: first apex_config: min: 0 opposite: true forceNiceScale: true decimalsInFloat: 2 labels: show: true – id: second apex_config: opposite: false forceNiceScale: true decimalsInFloat: 1 labels: show: true all_series_config: stroke_width: 4 series: – entity: sensor.nordpool_kwh_oslo_nok_3_10_025 yaxis_id: first name: Yesterday type: area curve: stepline float_precision: 2 stroke_width: 2 opacity: 0.05 extend_to: false offset: ‘-1min’ show: in_header: false legend_value: false in_chart: true extremas: true offset_in_name: false color: ‘#00FF00’ – entity: sensor.nordpool_kwh_oslo_nok_3_10_025 yaxis_id: first name: Today type: area curve: stepline float_precision: 2 stroke_width: 2 opacity: 0.5 extend_to: false offset: ‘-1min’ show: in_header: false legend_value: false extremas: true offset_in_name: false color: ‘#0080FF’ data_generator: | return entity.attributes.raw_today.map((p) => { return [new Date(p.start), p.value]; }); – entity: sensor.nordpool_kwh_oslo_nok_3_10_025 yaxis_id: first name: Tomorrow type: area curve: stepline float_precision: 2 stroke_width: 2 opacity: 0.2 offset: ‘-1min’ show: in_header: false legend_value: false extremas: true offset_in_name: false color: ‘#FF7F00’ data_generator: | return entity.attributes.raw_tomorrow.map((p) => { return [new Date(p.start), p.value]; }); – entity: sensor.accumulated_consumption_current_hour yaxis_id: second name: Power Usage type: line float_precision: 2 stroke_width: 2 opacity: 1 color: ‘#FF0000’ extend_to: false show: in_header: true legend_value: false group_by: func: max – entity: sensor.nordpool_kwh_oslo_nok_3_10_025 yaxis_id: first name: Price Now type: area curve: stepline float_precision: 2 stroke_width: 0 opacity: 0.1 extend_to: false show: in_header: true legend_value: false in_chart: true color: ‘#0080FF’ – entity: sensor.average_of_3_highest_hourly_consumption yaxis_id: second name: 3 Highest Avarage type: line float_precision: 2 stroke_width: 2 opacity: 1 color: ‘#800080’ extend_to: false show: in_header: true legend_value: false in_chart: false
type: custom:apexcharts-card
header:
  show: true
  title: Power Usage Hourly vs Electricity Price
  show_states: true
  colorize_states: true
now:
  show: true
  label: Now
graph_span: 72h
span:
  start: day
  offset: '-24h'
apex_config:
  xaxis:
    labels:
      format: dd.MM
  chart:
    zoom:
      enabled: true
    toolbar:
      show: true
      tools:
        zoom: true
        zoomin: false
        zoomout: false
        pan: false
        reset: true
  tooltip:
    fixed:
      enabled: true
      position: bottomLeft
yaxis:
  - id: first
    apex_config:
      min: 0
      opposite: true
      forceNiceScale: true
      decimalsInFloat: 2
      labels:
        show: true
  - id: second
    apex_config:
      opposite: false
      forceNiceScale: true
      decimalsInFloat: 1
      labels:
        show: true
all_series_config:
  stroke_width: 4
series:
  - entity: sensor.nordpool_kwh_oslo_nok_3_10_025
    yaxis_id: first
    name: Yesterday
    type: area
    curve: stepline
    float_precision: 2
    stroke_width: 2
    opacity: 0.05
    extend_to: false
    offset: '-1min'
    show:
      in_header: false
      legend_value: false
      in_chart: true
      extremas: true
      offset_in_name: false
    color: '#00FF00'
  - entity: sensor.nordpool_kwh_oslo_nok_3_10_025
    yaxis_id: first
    name: Today
    type: area
    curve: stepline
    float_precision: 2
    stroke_width: 2
    opacity: 0.5
    extend_to: false
    offset: '-1min'
    show:
      in_header: false
      legend_value: false
      extremas: true
      offset_in_name: false
    color: '#0080FF'
    data_generator: |
      return entity.attributes.raw_today.map((p) => {
        return [new Date(p.start), p.value];
      });
  - entity: sensor.nordpool_kwh_oslo_nok_3_10_025
    yaxis_id: first
    name: Tomorrow
    type: area
    curve: stepline
    float_precision: 2
    stroke_width: 2
    opacity: 0.2
    offset: '-1min'
    show:
      in_header: false
      legend_value: false
      extremas: true
      offset_in_name: false
    color: '#FF7F00'
    data_generator: |
      return entity.attributes.raw_tomorrow.map((p) => {
        return [new Date(p.start), p.value];
      });
  - entity: sensor.accumulated_consumption_current_hour
    yaxis_id: second
    name: Power Usage
    type: line
    float_precision: 2
    stroke_width: 2
    opacity: 1
    color: '#FF0000'
    extend_to: false
    show:
      in_header: true
      legend_value: false
    group_by:
      func: max
  - entity: sensor.nordpool_kwh_oslo_nok_3_10_025
    yaxis_id: first
    name: Price Now
    type: area
    curve: stepline
    float_precision: 2
    stroke_width: 0
    opacity: 0.1
    extend_to: false
    show:
      in_header: true
      legend_value: false
      in_chart: true
    color: '#0080FF'
  - entity: sensor.average_of_3_highest_hourly_consumption
    yaxis_id: second
    name: 3 Highest Avarage
    type: line
    float_precision: 2
    stroke_width: 2
    opacity: 1
    color: '#800080'
    extend_to: false
    show:
      in_header: true
      legend_value: false
      in_chart: false
type: custom:apexcharts-card header: show: true title: Power Usage Hourly vs Electricity Price show_states: true colorize_states: true now: show: true label: Now graph_span: 72h span: start: day offset: ‘-24h’ apex_config: xaxis: labels: format: dd.MM chart: zoom: enabled: true toolbar: show: true tools: zoom: true zoomin: false zoomout: false pan: false reset: true tooltip: fixed: enabled: true position: bottomLeft yaxis: – id: first apex_config: min: 0 opposite: true forceNiceScale: true decimalsInFloat: 2 labels: show: true – id: second apex_config: opposite: false forceNiceScale: true decimalsInFloat: 1 labels: show: true all_series_config: stroke_width: 4 series: – entity: sensor.nordpool_kwh_oslo_nok_3_10_025 yaxis_id: first name: Yesterday type: area curve: stepline float_precision: 2 stroke_width: 2 opacity: 0.05 extend_to: false offset: ‘-1min’ show: in_header: false legend_value: false in_chart: true extremas: true offset_in_name: false color: ‘#00FF00’ – entity: sensor.nordpool_kwh_oslo_nok_3_10_025 yaxis_id: first name: Today type: area curve: stepline float_precision: 2 stroke_width: 2 opacity: 0.5 extend_to: false offset: ‘-1min’ show: in_header: false legend_value: false extremas: true offset_in_name: false color: ‘#0080FF’ data_generator: | return entity.attributes.raw_today.map((p) => { return [new Date(p.start), p.value]; }); – entity: sensor.nordpool_kwh_oslo_nok_3_10_025 yaxis_id: first name: Tomorrow type: area curve: stepline float_precision: 2 stroke_width: 2 opacity: 0.2 offset: ‘-1min’ show: in_header: false legend_value: false extremas: true offset_in_name: false color: ‘#FF7F00’ data_generator: | return entity.attributes.raw_tomorrow.map((p) => { return [new Date(p.start), p.value]; }); – entity: sensor.accumulated_consumption_current_hour yaxis_id: second name: Power Usage type: line float_precision: 2 stroke_width: 2 opacity: 1 color: ‘#FF0000’ extend_to: false show: in_header: true legend_value: false group_by: func: max – entity: sensor.nordpool_kwh_oslo_nok_3_10_025 yaxis_id: first name: Price Now type: area curve: stepline float_precision: 2 stroke_width: 0 opacity: 0.1 extend_to: false show: in_header: true legend_value: false in_chart: true color: ‘#0080FF’ – entity: sensor.average_of_3_highest_hourly_consumption yaxis_id: second name: 3 Highest Avarage type: line float_precision: 2 stroke_width: 2 opacity: 1 color: ‘#800080’ extend_to: false show: in_header: true legend_value: false in_chart: false
- platform: template
  sensors:
    cheapest_3_hours:
      value_template: >-
        {% set l=state_attr('sensor.nordpool_kwh_no1_nok_3_10_025', 'raw_today')|sort(attribute='value') %}
        {{ (now() >= l[0].start and now() <= l[0].end)
          or (now() >= l[1].start and now() <= l[1].end)
          or (now() >= l[2].start and now() <= l[2].end) }}

- platform: template
  sensors:
    cheapest_4_hours:
      value_template: >-
        {% set l=state_attr('sensor.nordpool_kwh_no1_nok_3_10_025', 'raw_today')|sort(attribute='value') %}
        {{ (now() >= l[0].start and now() <= l[0].end)
          or (now() >= l[1].start and now() <= l[1].end)
          or (now() >= l[2].start and now() <= l[2].end)
          or (now() >= l[3].start and now() <= l[3].end) }}

- platform: template
  sensors:
    cheapest_6_hours:
      value_template: >-
        {% set l=state_attr('sensor.nordpool_kwh_no1_nok_3_10_025', 'raw_today')|sort(attribute='value') %}
        {{ (now() >= l[0].start and now() <= l[0].end)
          or (now() >= l[1].start and now() <= l[1].end)
          or (now() >= l[2].start and now() <= l[2].end)
          or (now() >= l[3].start and now() <= l[3].end)
          or (now() >= l[4].start and now() <= l[4].end)
          or (now() >= l[5].start and now() <= l[5].end) }}
Martin

1 thoughts on “Home Assistant – Electrisity Price Graph”

  1. Fredrik says:

    Hei Martin!

    Først og fremst, kjempeflott fremstilling, og ikke minst supert at du deler.

    Kan du dog dele template sensorene og? Det er lettere å følge guiden om man trinn for trinn skaper de dependencies som er en forutsetning for å bruke guiden og få til samme resultat 🙂

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses cookies to offer you a better browsing experience. By browsing this website, you agree to our use of cookies.
Accept