Daily average

template:
  - trigger:
      - trigger: time
        at: "01:05:00"
        variables:
          price: "{{ states('sensor.nord_pool_se4_daily_average') | float(0) }}"
          first: |
            {% set d = state_attr('sensor.dynamic_electricity_price', 'date') %}
            {{ d is none or as_datetime(d).strftime('%Y-%m') != now().strftime('%Y-%m') }}        
    condition: "{{ price > 0 }}"
    sensor:
      - name: "dynamic electricity price"
        unique_id: dynamic_electricity_price
        state: | 
          {% set sum = 0 if first else this.attributes.sum %}
          {% set count = 1 if first else 1 + this.attributes.count %}
          {{ ((sum + price) / count) | round(4) }}
        attributes:
          date: "{{ now() }}"
          sum: "{{ price if first else price + this.attributes.sum }}"
          count: "{{ 1 if first else 1 + this.attributes.count }}"