- triggers:
    - trigger: time_pattern
      minutes: /1
    - trigger: homeassistant
      event: start
  actions:
    - action: nordpool.get_prices_for_date
      data:
        config_entry: 01K7PAVN48Z69VKFJAW9V6X0P8
        date: "{{ now().date() }}"
        areas: FI
        currency: EUR
      response_variable: today_price
    - action: nordpool.get_prices_for_date
      data:
        config_entry: 01K7PAVN48Z69VKFJAW9V6X0P8
        date: "{{ now().date() + timedelta(days=1) }}"
        areas: FI
        currency: EUR
      response_variable: tomorrow_price
    - action: nordpool.get_prices_for_date
      data:
        config_entry: 01K7PAVN48Z69VKFJAW9V6X0P8
        date: "{{ now().date() - timedelta(days=1) }}"
        areas: FI
        currency: EUR
      response_variable: yesterday_price
  sensor:
    - name: Electricity prices
      unique_id: electricity_prices
      unit_of_measurement: "c/kWh"
      icon: mdi:cash
      state: >
        {%- set region = (this.attributes.get('region', 'FI') | string) -%}
        {%- set vat = (this.attributes.get('vat', 25.5) | float) -%}
        {%- set electricity_tax = (this.attributes.get('electricity_tax', 0.0) | float) -%}
        {%- set transmission_day = (this.attributes.get('transmission_day', 0.0) | float) -%}
        {%- set transmission_night = (this.attributes.get('transmission_night', 0.0) | float) -%}
        {%- set margin = (this.attributes.get('margin', 0.0) | float) -%}

        {%- set additional_cost_day = (electricity_tax+transmission_day+margin | float)  -%}
        {%- set additional_cost_night = (electricity_tax+transmission_night+margin | float)  -%}

        {%- set is_dst = (this.attributes.get('is_dst') | bool)  -%}

        {% if (today_price is mapping) and (tomorrow_price is mapping)  %}
          {% set data = namespace(prices=[]) %}
          {% if is_dst and (yesterday_price is mapping) %}
            {% for state in yesterday_price[region] %}
                {% if as_datetime(state.start).hour == 21 and as_datetime(state.start).hour < 22 %}
                  {% set data.prices = data.prices + [(((state.price/10 | float) * (1+(vat/100))  + additional_cost_night)) | round(3, default=0)] %}
                {% endif %}
            {% endfor %}
          {% endif %}
          {% for state in today_price[region] %}
              {% if as_datetime(state.start).astimezone().hour >= 7 and as_datetime(state.start).astimezone().hour < 22 %}
                {% set data.prices = data.prices + [(((state.price/10 | float) * (1+(vat/100))  + additional_cost_day)) | round(3, default=0)] %}
              {% else %}
                {% set data.prices = data.prices + [(((state.price/10 | float) * (1+(vat/100))  + additional_cost_night)) | round(3, default=0)] %}
              {% endif %}
          {% endfor %}
          {% for state in tomorrow_price[region] %}
              {% if as_datetime(state.start).astimezone().hour >= 7 and as_datetime(state.start).astimezone().hour < 22 %}
                {% set data.prices = data.prices + [(((state.price/10 | float) * (1+(vat/100))  + additional_cost_day)) | round(3, default=0)] %}
              {% else %}
                {% set data.prices = data.prices + [(((state.price/10 | float) * (1+(vat/100))  + additional_cost_night)) | round(3, default=0)] %}
              {% endif %}
          {% endfor %}
          {{min(data.prices)}}
        {% else %}
          unavailable
        {% endif %}
      attributes:
        region: FI
        vat: >
          {{states("input_number.electricity_vat")|float}}
        electricity_tax: >
          {{states("input_number.electricity_tax")|float}}
        transmission_day: >
          {{states("input_number.transmission_day")|float}}
        transmission_night: >
          {{states("input_number.transmission_night")|float}}
        margin: >
          {{states("input_number.porssisahko_margin")|float}}
        is_dst: >
          {{ now().timetuple().tm_isdst == 1 }}
        tomorrow_valid: >
          {%- set region = (this.attributes.get('region', 'FI') | string) -%}
          {%- if (tomorrow_price is mapping) %}
            {%- if tomorrow_price[region] | list | count > 0 -%}
              {{ true | bool }}
            {%- else %}
              {{ false | bool }}
            {%- endif %}
          {%- else %}
            {{ false | bool }}
          {%- endif %}
        data: >
          {%- set region = (this.attributes.get('region', 'FI') | string) -%}
          {%- set vat = (this.attributes.get('vat', 25.5) | float) -%}
          {%- set electricity_tax = (this.attributes.get('electricity_tax', 0.0) | float) -%}
          {%- set transmission_day = (this.attributes.get('transmission_day', 0.0) | float) -%}
          {%- set transmission_night = (this.attributes.get('transmission_night', 0.0) | float) -%}
          {%- set margin = (this.attributes.get('margin', 0.0) | float) -%}

          {%- set additional_cost_day = (electricity_tax+transmission_day+margin | float) -%}
          {%- set additional_cost_night = (electricity_tax+transmission_night+margin | float) -%}

          {%- set is_dst = (this.attributes.get('is_dst') | bool)  -%}

          {% if (today_price is mapping) and (tomorrow_price is mapping) %}
            {% set data = namespace(prices=[]) %}
            {% if is_dst and (yesterday_price is mapping) %}
              {% for state in yesterday_price[region] %}
                {% set local_start = as_datetime(state.start).astimezone().strftime('%Y-%m-%d %H:%M:%S') %}
                {% set local_end = as_datetime(state.end).astimezone().strftime('%Y-%m-%d %H:%M:%S') %}
                {% if as_datetime(state.start).hour == 21 and as_datetime(state.start).hour < 22 %}
                  {% set data.prices = data.prices + [{'start':local_start, 'end':local_end, 'price': (((state.price/10 | float) * (1+(vat/100))  + additional_cost_night)) | round(3, default=0)}] %}
                {% endif %}
              {% endfor %}
            {% endif %}
            {% for state in today_price[region] %}
              {% set local_start = as_datetime(state.start).astimezone().strftime('%Y-%m-%d %H:%M:%S') %}
              {% set local_end = as_datetime(state.end).astimezone().strftime('%Y-%m-%d %H:%M:%S') %}
              {% if as_datetime(state.start).astimezone().hour >= 7 and as_datetime(state.start).astimezone().hour < 22 %}
                {% set data.prices = data.prices + [{'start':local_start, 'end':local_end, 'price': (((state.price/10 | float) * (1+(vat/100))  + additional_cost_day)) | round(3, default=0)}] %}
              {% else %}
                {% set data.prices = data.prices + [{'start':local_start, 'end':local_end, 'price': (((state.price/10 | float) * (1+(vat/100))  + additional_cost_night)) | round(3, default=0)}] %}
              {% endif %}
            {% endfor %}
            {% for state in tomorrow_price[region] %}
              {% set local_start = as_datetime(state.start).astimezone().strftime('%Y-%m-%d %H:%M:%S') %}
              {% set local_end = as_datetime(state.end).astimezone().strftime('%Y-%m-%d %H:%M:%S') %}
              {% if as_datetime(state.start).astimezone().hour >= 7 and as_datetime(state.start).astimezone().hour < 22 %}
                {% set data.prices = data.prices + [{'start':local_start, 'end':local_end, 'price': (((state.price/10 | float) * (1+(vat/100))  + additional_cost_day)) | round(3, default=0)}] %}
              {% else %}
                {% set data.prices = data.prices + [{'start':local_start, 'end':local_end, 'price': (((state.price/10 | float) * (1+(vat/100))  + additional_cost_night)) | round(3, default=0)}] %}
              {% endif %}
            {% endfor %}
            {{data.prices}}
          {% else %}
            []
          {% endif %}