How to get the hour of lowest price?

[bilalhp]

I want to get the hour of lowest price for today, to use it as a condition in an automation. How can I do that?

[dummyax]

Hi @bilalhp, did you find out how to do this? I would like to do something similar with high, low and mid prices per day (8 hours of each)

[bilalhp]

Hello, yes. All of them can be retrieved from the attributes. The following will give you some impression:

  - sensor:
      - name: "Energy Tomorrow Highest Price Before Noon"
        unique_id: "energy_tomorrow_highest_price_before_noon"
        unit_of_measurement: "Euro"
        state: >-
             {% for t in state_attr('sensor.nordpool_kwh_be_eur_4_10_0', 'raw_tomorrow')|sort(attribute='value', reverse=true)
                  if t.start.strftime('%H') | int < 12 %}
                  {{ t.value }}
                  {% break %}
             {% endfor %}
  - sensor:
      - name: "Energy Tomorrow Highest Price Before Noon Hr"
        unique_id: "energy_tomorrow_highest_price_before_noon_hr"
        unit_of_measurement: "Hour"
        state: >-
             {% for t in state_attr('sensor.nordpool_kwh_be_eur_4_10_0', 'raw_tomorrow')|sort(attribute='value', reverse=true)
                  if t.start.strftime('%H') | int < 12 %}
                  {{ t.start.strftime('%H') }}
                  {% break %}
             {% endfor %}
  - sensor:
      - name: "Energy Today Highest Price Before Noon"
        unique_id: "energy_today_highest_price_before_noon"
        unit_of_measurement: "Euro"
        state: >-
             {% for t in state_attr('sensor.nordpool_kwh_be_eur_4_10_0', 'raw_today')|sort(attribute='value', reverse=true)
                  if t.start.strftime('%H') | int < 12 %}
                  {{ t.value }}
                  {% break %}
             {% endfor %}
  - sensor:
      - name: "Energy Today Highest Price Before Noon Hr"
        unique_id: "energy_today_highest_price_before_noon_hr"
        unit_of_measurement: "Hour"
        state: >-
             {% for t in state_attr('sensor.nordpool_kwh_be_eur_4_10_0', 'raw_today')|sort(attribute='value', reverse=true)
                  if t.start.strftime('%H') | int < 12 %}
                  {{ t.start.strftime('%H') }}
                  {% break %}
             {% endfor %}
  - sensor:
      - name: "Energy Today Highest Price Morning Hr"
        unique_id: "energy_today_highest_price_morning_hr"
        unit_of_measurement: "Hour"
        state: >-
             {% for t in state_attr('sensor.nordpool_kwh_be_eur_4_10_0', 'raw_today')|sort(attribute='value', reverse=true)
                  if t.start.strftime('%H') | int < 12 and t.start.strftime('%H') | int > 6 %}
                  {{ t.start.strftime('%H') }}
                  {% break %}
             {% endfor %}
  - sensor:
      - name: "Energy Today Highest Price After Noon"
        unique_id: "energy_today_highest_price_after_noon"
        unit_of_measurement: "Euro"
        state: >-
             {% for t in state_attr('sensor.nordpool_kwh_be_eur_4_10_0', 'raw_today')|sort(attribute='value', reverse=true)
                  if t.start.strftime('%H') | int >= 12 %}
                  {{ t.value }}
                  {% break %}
             {% endfor %}
  - sensor:
      - name: "Energy Today Highest Price Rest of the Day"
        unique_id: "energy_today_highest_price_rest_today"
        unit_of_measurement: "Euro"
        state: >-
             {% for t in state_attr('sensor.nordpool_kwh_be_eur_4_10_0', 'raw_today')|sort(attribute='value', reverse=true)
                  if t.start.strftime('%H') | int >= now().strftime('%H') | int %}
                  {{ t.value }}
                  {% break %}
             {% endfor %}
  - sensor:
      - name: "Energy Today Highest Price After Noon Hr"
        unique_id: "energy_today_highest_price_after_noon_hr"
        unit_of_measurement: "Hour"
        state: >-
             {% for t in state_attr('sensor.nordpool_kwh_be_eur_4_10_0', 'raw_today')|sort(attribute='value', reverse=true)
                  if t.start.strftime('%H') | int >= 12 %}
                  {{ t.start.strftime('%H') }}
                  {% break %}
             {% endfor %}
  - sensor:
      - name: "Energy Today Lowest Price After Noon"
        unique_id: "energy_today_lowest_price_after_noon"
        unit_of_measurement: "Euro"
        state: >-
             {% for t in state_attr('sensor.nordpool_kwh_be_eur_4_10_0', 'raw_today')|sort(attribute='value')
                  if t.start.strftime('%H') | int >= 12 and t.start.strftime('%H') | int <= 17 %}
                  {{ t.value }}
                  {% break %}
             {% endfor %}
  - sensor:
      - name: "Energy Today Lowest Price After Noon Hr"
        unique_id: "energy_today_lowest_price_after_noon_hr"
        unit_of_measurement: "Hour"
        state: >-
             {% for t in state_attr('sensor.nordpool_kwh_be_eur_4_10_0', 'raw_today')|sort(attribute='value')
                  if t.start.strftime('%H') | int >= 12 and t.start.strftime('%H') | int <= 17 %}
                  {{ t.start.strftime('%H') }}
                  {% break %}
             {% endfor %}
  - sensor:
      - name: "Energy Tomorrow Lowest Price After Noon"
        unique_id: "energy_tomorrow_lowest_price_after_noon"
        unit_of_measurement: "Euro"
        state: >-
             {% for t in state_attr('sensor.nordpool_kwh_be_eur_4_10_0', 'raw_tomorrow')|sort(attribute='value')
                  if t.start.strftime('%H') | int >= 12 %}
                  {{ t.value }}
                  {% break %}
             {% endfor %}
  - sensor:
      - name: "Energy Tomorrow Lowest Price After Noon Hr"
        unique_id: "energy_tomorrow_lowest_price_after_noon_hr"
        unit_of_measurement: "Hour"
        state: >-
             {% for t in state_attr('sensor.nordpool_kwh_be_eur_4_10_0', 'raw_tomorrow')|sort(attribute='value')
                  if t.start.strftime('%H') | int >= 12 and t.start.strftime('%H') | int <= 17 %}
                  {{ t.start.strftime('%H') }}
                  {% break %}
             {% endfor %}
  - sensor:
      - name: "Energy Today Lowest Price Before Noon"
        unique_id: "energy_today_lowest_price_before_noon"
        unit_of_measurement: "Euro"
        state: >-
             {% for t in state_attr('sensor.nordpool_kwh_be_eur_4_10_0', 'raw_today')|sort(attribute='value')
                  if t.start.strftime('%H') | int < 12 %}
                  {{ t.value }}
                  {% break %}
             {% endfor %}
  - sensor:
      - name: "Energy Today Lowest Price Before Noon Hr"
        unique_id: "energy_today_lowest_price_before_noon_hr"
        unit_of_measurement: "Hour"
        state: >-
             {% for t in state_attr('sensor.nordpool_kwh_be_eur_4_10_0', 'raw_today')|sort(attribute='value')
                  if t.start.strftime('%H') | int < 12 %}
                  {{ t.start.strftime('%H') }}
                  {% break %}
             {% endfor %}

[dummyax]

Thank you! Saved me a lot of time (and probably money as well!)