diff --git a/sensors/energy.yaml b/sensors/energy.yaml index dd4c704..e0e1531 100644 --- a/sensors/energy.yaml +++ b/sensors/energy.yaml @@ -45,3 +45,27 @@ unit_prefix: k unit_time: h round: 4 + +- platform: statistics + name: Average energy price last 30d mean + entity_id: sensor.energi_data_service + state_characteristic: mean + sampling_size: 760 + max_age: + days: 30 + +- platform: statistics + name: Energy price last 30d (std) + entity_id: sensor.energi_data_service + state_characteristic: standard_deviation + sampling_size: 512 + max_age: + days: 30 + +- platform: statistics + name: Energy price last 30d (mean) + entity_id: sensor.energi_data_service + state_characteristic: mean + sampling_size: 512 + max_age: + days: 30 diff --git a/template/historic_energy_price.yaml b/template/historic_energy_price.yaml new file mode 100644 index 0000000..68ebdb7 --- /dev/null +++ b/template/historic_energy_price.yaml @@ -0,0 +1,12 @@ +- sensor: + - name: Historic Energy Price Percentiles + unique_id: historic_energy_price_percentiles + state: OK + attributes: + 25th: "{{ states('sensor.average_energy_price_last_30d_mean') | float(0) + states('sensor.energy_price_last_30d_std') | float(0) * -0.63 }}" + 50th: "{{ states('sensor.average_energy_price_last_30d_mean') | float(0) + states('sensor.energy_price_last_30d_std') | float(0) * 0 }}" + 75th: "{{ states('sensor.average_energy_price_last_30d_mean') | float(0) + states('sensor.energy_price_last_30d_std') | float(0) * 0.57 }}" + 90th: "{{ states('sensor.average_energy_price_last_30d_mean') | float(0) + states('sensor.energy_price_last_30d_std') | float(0) * 1.29 }}" + 95th: "{{ states('sensor.average_energy_price_last_30d_mean') | float(0) + states('sensor.energy_price_last_30d_std') | float(0) * 1.65 }}" + 99th: "{{ states('sensor.average_energy_price_last_30d_mean') | float(0) + states('sensor.energy_price_last_30d_std') | float(0) * 2.33 }}" + 100th: "{{ states('sensor.average_energy_price_last_30d_mean') | float(0) + states('sensor.energy_price_last_30d_std') | float(0) * 3.9 }}"