Belgium: Elia current price in Home Assistant

[BartVanHerreweghe]

Belgium: Elia current price in Home Assistant

SITUATION
I want to activate some adaptors when prices are negative.
I try to build 3 sensors
will do the rest = triggers later

NEEDED
I want to have 3 sensors based on data in api url
- marginalincrementalprice
- marginaldecrementalprice
- imbalanceprice
Both 3 sensors should have value “Positive”, “Negative”, “Unknown”

BASE INFORMATION
from url
https://opendata.elia.be/api/explore/v2.1/catalog/datasets/ods161/records?order_by=datetime%20DESC&limit=1
the typical output is:
{
“total_count”: 622,
“results”: [
{
“datetime”: “2024-09-25T08:21:00+00:00”,
“resolutioncode”: “PT1M”,
“quarterhour”: “2024-09-25T08:15:00+00:00”,
“qualitystatus”: “DataIssue”,
“ace”: -7.901,
“systemimbalance”: -282.251,
“alpha”: 6.996,
“alpha_prime”: 0,
“marginalincrementalprice”: 228.9,
“marginaldecrementalprice”: -416.985,
“imbalanceprice”: 235.896
}
]
}

AS IS
This is what I have

# Elia current price
#
# /homeassistant/configuration.yaml updated with
# Load self made sensor for elia from the sensor folder
#sensor: !include_dir_merge_list sensor/
#
# Location of file: /homeassistant/sensor/elia.yaml

- platform: rest
  scan_interval: 60
  resource: https://opendata.elia.be/api/explore/v2.1/catalog/datasets/ods161/records?order_by=datetime%20DESC&limit=1
  name: "Elia current price"
  json_attributes_path: "$.results"
  json_attributes:
    - marginalincrementalprice
    - marginaldecrementalprice
    - imbalanceprice

- platform: template
  sensors:
    elia_current_marginalincrementalprice:
      icon_template: "mdi:tree-outline"
      friendly_name: "marginalincrementalprice"
      value_template: >-
        {% set state = state_attr('sensor.elia_current_marginalincrementalprice', 'marginalincrementalprice') %}
        {% if state | float(0) >= 0 %}Positive
        {% elif state | float(0) < 0 %}Negative
        {% else %}Unknown
        {% endif %}

- platform: template
  sensors:
    elia_current_marginaldecrementalprice:
      icon_template: "mdi:nature"
      friendly_name: "marginaldecrementalprice"
      value_template: >-
        {% set state = state_attr('sensor.elia_current_marginaldecrementalprice', 'marginaldecrementalprice') %}
        {% if state | float(0) >= 0 %}Positive
        {% elif state | float(0) < 0 %}Negative
        {% else %}Unknown
        {% endif %}

- platform: template
  sensors:
    elia_current_imbalanceprice:
      icon_template: "mdi:grass"
      friendly_name: "imbalanceprice"
      value_template: >-
        {% set state = state_attr('sensor.elia_current_imbalanceprice', 'imbalanceprice') %}
        {% if state | float(0) >= 0 %}Positive
        {% elif state | float(0) < 0 %}Negative
        {% else %}Unknown
        {% endif %}

PROBLEM
All is looking good in the “Developper tools > Template”
I can’t get the values (in state) correctly evaluated.
What could be the fix to do so?

[BartVanHerreweghe]

meanwhile I changed the icons to:

icon_template: "mdi:currency-eur"

[koying (Chris B)]

First debugging step is to check the logs.
You will see a message stating that the state of an entity cannot be larger than 255 chars.
Also, “results” is an array, so:

...
  value_template: "{{ 'ok' }}"
  json_attributes_path: "$.results[0]"
...

Next your “state_attr” should refer sensor.elia_current_price

[BartVanHerreweghe]

@koying

"{{ 'ok' }}"

Currently no success. As so far I have (with a little tweaks/help of chagGPT)

# Elia current price
#
# /homeassistant/configuration.yaml updated with
# Load self made sensor for elia from the sensor folder
#sensor: !include_dir_merge_list sensor/
#
# Location of file: /homeassistant/sensor/elia.yaml

- platform: rest
  scan_interval: 60
  resource: https://opendata.elia.be/api/explore/v2.1/catalog/datasets/ods161/records?order_by=datetime%20DESC&limit=1
  name: "Elia current price"
  value_template: "{{ 'ok' }}"
  json_attributes_path: "$.records[0]"  # Adjusted to access the first record
  json_attributes:
    - marginalincrementalprice
    - marginaldecrementalprice
    - imbalanceprice

- platform: template
  sensors:
    elia_current_marginalincrementalprice:
      icon_template: "mdi:currency-eur"
      friendly_name: "Marginal Incremental Price"
      value_template: >-
        {% set state = state_attr('sensor.elia_current_price', 'marginalincrementalprice') %}
        {% if state is not none %}
          {% if state | float >= 0 %}Positive
          {% elif state | float < 0 %}Negative
          {% else %}Unknown
          {% endif %}
        {% else %}None
        {% endif %}

    elia_current_marginaldecrementalprice:
      icon_template: "mdi:currency-eur"
      friendly_name: "Marginal Decremental Price"
      value_template: >-
        {% set state = state_attr('sensor.elia_current_price', 'marginaldecrementalprice') %}
        {% if state is not none %}
          {% if state | float >= 0 %}Positive
          {% elif state | float < 0 %}Negative
          {% else %}Unknown
          {% endif %}
        {% else %}None
        {% endif %}

    elia_current_imbalanceprice:
      icon_template: "mdi:currency-eur"
      friendly_name: "Imbalance Price"
      value_template: >-
        {% set state = state_attr('sensor.elia_current_price', 'imbalanceprice') %}
        {% if state is not none %}
          {% if state | float >= 0 %}Positive
          {% elif state | float < 0 %}Negative
          {% else %}Unknown
          {% endif %}
        {% else %}None
        {% endif %}

#for testing purposes
- platform: template
  sensors:
    elia_full_state:
      friendly_name: "Full Elia State"
      value_template: "{{ states('sensor.elia_current_price') }}"

[BartVanHerreweghe]

this is what I get in the 'States" tab of Developer tools:

[koying (Chris B)]

@BartVanHerreweghe

  json_attributes_path: "$.results"

@BartVanHerreweghe

  json_attributes_path: "$.records[0]"  # Adjusted to access the first record

@BartVanHerreweghe

with a little tweaks/help of chagGPT

Give your brain a shot

[BartVanHerreweghe]

off course
but no luck yet!

[koying (Chris B)]

Did you see the mistake, “records” in place of “results”?

[BartVanHerreweghe]

yes
still no succes.
tried a lot already

[koying (Chris B)]

Well, works for me

- platform: rest
  scan_interval: 60
  resource: https://opendata.elia.be/api/explore/v2.1/catalog/datasets/ods161/records?order_by=datetime%20DESC&limit=1
  name: "Elia current price"
  value_template: "{{ 'ok' }}"
  json_attributes_path: "$.results[0]"  # Adjusted to access the first record
  json_attributes:
    - marginalincrementalprice
    - marginaldecrementalprice
    - imbalanceprice

[BartVanHerreweghe]

And if a want an entity with a value. Should this work too?

sensor:
  - platform: template
    sensors:
      elia_current_price_imbalance:
        friendly_name: Elia imbalance price
        icon_template: "mdi:currency-eur"
        entity_id: 
          - sensor.elia_current_price
        value_template: "{{ states.sensor.elia_current_price.attributes.imbalanceprice }}"

[koying (Chris B)]

@BartVanHerreweghe

        entity_id: 
          - sensor.elia_current_price

If you remove that (not sure where you got that from), then yes

[BartVanHerreweghe]

This is now active:

sensor:
  - platform: template
    sensors:
      elia_current_price_imbalance:
        friendly_name: Elia imbalance price
        icon_template: "mdi:currency-eur"
        value_template: "{{ states.sensor.elia_current_price.attributes.imbalanceprice }}"

But I still don’t see the entity in the entity list.

For your information
I have put th file called imbalanceprice.yaml in the sensor directory:
/homeassistant/sensor/imbalanceprice.yaml

That should do it, no?
Or did I miss something else.

I have restarted HA also.

[koying (Chris B)]

Just put the template in the same file as the previous one. I don’t know how you split your YAML’s

[BartVanHerreweghe]

like this?

- platform: rest
  scan_interval: 60
  resource: https://opendata.elia.be/api/explore/v2.1/catalog/datasets/ods161/records?order_by=datetime%20DESC&limit=1
  name: "Elia current price"
  value_template: "{{ 'ok' }}"
  json_attributes_path: "$.results[0]"  # Adjusted to access the first record
  json_attributes:
    - marginalincrementalprice
    - marginaldecrementalprice
    - imbalanceprice
    
- platform: template
  sensors:
    elia_current_price_imbalance:
      friendly_name: Elia imbalance price
      icon_template: "mdi:currency-eur"
      value_template: "{{ states.sensor.elia_current_price.attributes.imbalanceprice }}"

Still no success.

Sorry, I’m a newbee

[koying (Chris B)]

Yes. Did you reload templates/restarted HA?

[BartVanHerreweghe]

the restart did it!

Tx (again)!

[BartVanHerreweghe]

how do I get it to display a graph in stead of prices in a line?

[BartVanHerreweghe]

I add this in the same yaml?

type: history-graph
title: Elia Imbalance Price
entities:
  - sensor.elia_current_price_imbalance
hours_to_show: 24  # Adjust the time range as needed
refresh_interval: 60  # Refresh interval in seconds

[koying (Chris B)]

Use appropriate device_class and unit_of_measurement for the sensor

Sensor

For long-term-statistics, also use state_class: measurement