-
-
Save klaasnicolaas/ccfd1cd3da62a13b3199ff378480bdbb to your computer and use it in GitHub Desktop.
- type: custom:apexcharts-card | |
graph_span: 1d | |
header: | |
show: true | |
title: Electriciteitsprijzen Vandaag (€/kwh) | |
span: | |
start: day | |
now: | |
show: true | |
label: Now | |
yaxis: | |
- id: price | |
decimals: 2 | |
apex_config: | |
tickAmount: 5 | |
series: | |
- entity: sensor.energy_prices_today | |
name: Price this hour | |
yaxis_id: price | |
data_generator: | | |
return entity.attributes.prices.map((entry) => { | |
return [new Date(entry.timestamp).getTime(), entry.price]; | |
}); | |
type: column | |
show: | |
extremas: true | |
opacity: 0.8 | |
float_precision: 2 |
--- | |
# Today - Hourly energy prices | |
template: | |
- trigger: | |
- platform: homeassistant | |
event: start | |
- platform: time_pattern | |
hours: "*" | |
action: | |
- service: energyzero.get_energy_prices | |
response_variable: response | |
data: | |
config_entry: PUT_HERE_YOURS | |
incl_vat: True | |
sensor: | |
- name: Energy prices - Today | |
device_class: timestamp | |
state: "{{ now() }}" | |
attributes: | |
prices: '{{ response.prices }}' | |
# Tomorrow - Hourly energy prices | |
- trigger: | |
- platform: homeassistant | |
event: start | |
- platform: template | |
value_template: "{{ now() > today_at('14:00') and now().minute == 0 }}" | |
action: | |
- service: energyzero.get_energy_prices | |
response_variable: response | |
data: | |
config_entry: PUT_HERE_YOURS | |
start: "{{ now() + timedelta(days=1) }}" | |
end: "{{ now() + timedelta(days=1) }}" | |
incl_vat: True | |
sensor: | |
- name: Energy prices - Tomorrow | |
device_class: timestamp | |
state: "{{ now() + timedelta(days=1) }}" | |
attributes: | |
prices: '{{ response.prices }}' |
I updated the chart myself a bit like this to improve the y-axis:
type: custom:apexcharts-card
graph_span: 48h
header:
show: true
title: Electriciteitsprijzen Vandaag EnergyZero (€/kwh)
span:
start: day
now:
show: true
label: Now
yaxis:
- id: price
decimals: 3
min: -0.2
max: 0.3
apex_config:
tickAmount: 5
series:
- entity: sensor.energy_prices_today
name: Price this hour
yaxis_id: price
data_generator: |
return entity.attributes.prices.map((entry) => {
return [new Date(entry.timestamp).getTime(), entry.price];
});
type: column
show:
extremas: true
opacity: 0.8
float_precision: 3
Would be great if these charts could be combined in one.
Why would you want to combine them? I don't really see an advantage/improvement in that.
Mainly cosmetics
Just one chart instead of 2
Learning how this needs to be done.
Hi
Not required anymore.
I managed to create it myself..
type: custom:apexcharts-card
graph_span: 48h
header:
show: true
title: Electriciteitsprijzen Vandaag en Morgen EnergyZero (€/kwh)
span:
start: day
now:
show: true
label: Now
yaxis:
- id: price
decimals: 3
min: -0.2
max: 0.3
apex_config:
tickAmount: 10
series:
- entity: sensor.energy_prices_today
name: Price this hour
yaxis_id: price
data_generator: |
return entity.attributes.prices.map((entry) => {
return [new Date(entry.timestamp).getTime(), entry.price];
});
type: column
show:
extremas: true
opacity: 0.8
float_precision: 3
- entity: sensor.energy_prices_tomorrow
name: Price this hour
yaxis_id: price
data_generator: >-
return entity.attributes.prices.map((entry) => { return [new
Date(entry.timestamp).getTime(), entry.price]; });
type: column
show:
extremas: true
opacity: 0.8
float_precision: 3
Thanks
Hi @klaasnicolaas I've run into some Yaml validation error when including the https://gist.github.com/klaasnicolaas/ccfd1cd3da62a13b3199ff378480bdbb#file-price_template_sensors-yaml file in configuration.yaml
. As far as I can tell from looking at the official documentation, everything should work, but I keep getting the error "Invalid config for 'sensor' at configuration.yaml, line 12: required key 'platform' not provided"
The file is included on line 12, so that's logical, but I don't see how the platform
key is missing, as it's clearly right there. I'm using your gist version almost literally (only the ID is filled in with my own). What could I be missing here?
I'll paste my file as-is anyway.
---
# Today - Hourly energy prices
template:
- trigger:
- platform: time_pattern
minutes: 1
- platform: homeassistant
event: start
action:
- service: energyzero.get_energy_prices
response_variable: response
data:
config_entry: 86c311fb791184eec3ee798d27997b3d
incl_vat: True
sensor:
- name: Energy prices - Today
device_class: timestamp
state: "{{ now() }}"
attributes:
prices: '{{ response.prices }}'
# Tomorrow - Hourly energy prices
- trigger:
- platform: time_pattern
minutes: 1
- platform: homeassistant
event: start
action:
- service: energyzero.get_energy_prices
response_variable: response
data:
config_entry: 86c311fb791184eec3ee798d27997b3d
start: "{{ now() + timedelta(days=1) }}"
end: "{{ now() + timedelta(days=1) }}"
incl_vat: True
sensor:
- name: Energy prices - Tomorrow
device_class: timestamp
state: "{{ now() + timedelta(days=1) }}"
attributes:
prices: '{{ response.prices }}'
@MariellevDijk my suspicion is that you did something wrong with your include in configuration.yaml
🤷♂️
Hi @klaasnicolaas I've run into some Yaml validation error when including the https://gist.github.com/klaasnicolaas/ccfd1cd3da62a13b3199ff378480bdbb#file-price_template_sensors-yaml file in
configuration.yaml
. As far as I can tell from looking at the official documentation, everything should work, but I keep getting the error "Invalid config for 'sensor' at configuration.yaml, line 12: required key 'platform' not provided"The file is included on line 12, so that's logical, but I don't see how the
platform
key is missing, as it's clearly right there. I'm using your gist version almost literally (only the ID is filled in with my own). What could I be missing here?I'll paste my file as-is anyway.
--- # Today - Hourly energy prices template: - trigger: - platform: time_pattern minutes: 1 - platform: homeassistant event: start
For sure it makes no sense to request the prices each minute. EnergyZero made a statement that when exceeding more than 20 requests per hour they will block the requests.
@mhoeneveld The provided trigger:
- platform: time_pattern
minutes: 1
Matches every hour one minute past whole.
See https://www.home-assistant.io/docs/automation/trigger/#time-pattern-trigger for more information.
Hello i am beginner with home assistant and wanted to get this work.
but keep getting stuck i have energyzero installed and apexchart.
when trying like to change sensor when copying a yaml from above.
it get stuck with Loading. i only changed a one yaml i copied from Maartendrenth.
but it says missng
apexcharts-card
Entity not available: sensor.energy_prices_today <---- where to get this and the one under i tried change it to
energyzero_today_energy_current_hour_price.
this one is also missing
Entity not available: sensor.energy_prices_tomorrow
type: custom:apexcharts-card
graph_span: 48h
header:
show: true
title: Electriciteitsprijzen Vandaag en Morgen EnergyZero (€/kwh)
span:
start: day
now:
show: true
label: Now
yaxis:
- id: price
decimals: 3
min: -0.2
max: 0.3
apex_config:
tickAmount: 10
series:
- entity: sensor.energy_prices_today
name: Price this hour
yaxis_id: price
data_generator: |
return entity.attributes.prices.map((entry) => {
return [new Date(entry.timestamp).getTime(), entry.price];
});
type: column
show:
extremas: true
opacity: 0.8
float_precision: 3
- entity: sensor.energy_prices_tomorrow
name: Price this hour
yaxis_id: price
data_generator: >-
return entity.attributes.prices.map((entry) => { return [new
Date(entry.timestamp).getTime(), entry.price]; });
type: column
show:
extremas: true
opacity: 0.8
float_precision: 3
@GofranAy You have only copied the apexcharts code, but without the template sensors (which retrieve the data) you will not get the correct entities.
./Klaas
@klaasnicolaas can you please share where to go add that entities i have anwb for energy.
I live in holland/dutch/netherland
@GofranAy in your configuration.yaml
?
@klaasnicolaas i am sorry do you mean i need to add.
hourly_price_charts.yaml and price_template_sensors.yaml
So just copy paste in to configuration.yaml.
Only the YAML of price_template_sensors.yaml to get the 2 trigger template sensors in Home Assistant. You use the apex code snippet where you created your dashboard in YAML.
Side note: everyone uses YAML differently in their Home Assistant instance, without context (how you organize your config) it's impossible to give advice on where to put the code snippets and I assume that people know where you should place these.
Didn't work: defining the template sensor under Settings > Devices & Services > Helpers
Keep getting error "response is undefined"
What works: copy/pasting the template sensor code into configuration.yaml
Hi
Thanks. Updating the ID indeed worked!
I also got the 2 charts working properly. One for the prices of today and one for tomorrow.
Would be great if these charts could be combined in one.
Is it easy for you to update the apexchart code to get this done? 😉