NOTE: If you cannot get Zonneplan to work, read the additional info in the description of the video to enable the Zonneplan current electricity tariff entity to make this work. Do you make use of a provider that uses Variable Energy Prices as well? Let me know which one in the comments so that I can add code for those providers as well 👇
Groene Stroom Lokaal Thanks for this. Was tinkering with some code from Tweakers, but unable to get the correct additional costs for GSL in there after making the chart. Will do it over with this tutorial.
Groene Stroom Lokaal Thanks for this. Was tinkering with some code from Tweakers, but unable to get the correct additional costs for GSL in there after making the chart. Will do it over with this tutorial.
This really makes me want to invest in a big battery I can charge when energy is cheap and draw from when energy is expensive. If the peaks stay this high it could potentially pay for itself within just a few years and even if it doesn't pay off fast, having backup power is valuable too.
This was an awesome episode, and without leaving any critical details. Your presentation style was 5-star! Then top up by sharing your code, you have my support. Thanks, and Cheers.
My energy prices come at wholesalerate plus $15 monthly fee. That works really well. I already get an entity in Home Assistant for the provider as the particular provider has an official integration. I can sort of work with this tutorial, though the whole sale prices supplied by my provider are half hourly rather than today and tomorrow.
Super bedankt voor deze video! Heel mijn Home assistant is met hulp van jou video's gebouwd. Wat mij ook interessant lijkt om de onbalans prijzen erbij te zien. Nu helemaal niet van toepassing. Misschien in de toekomst. Ga zo door man!
When a nordpool entity is created, it has a lengthy name. I recommend to rename the entity to just "nordpool". This way all your automation will keep working if you ever need to recreate the entity.
@@magnuserlandsson1327 Are you sure? I hava totally 9 Nordpools added under the Nordpool Integration. One for each SE with and without VAT and one that came with the integration, dont know what it does.. doesnt contains any Devices.. dont know why I have this.. I just did it like this :D But they do all have the same name "Nordpool" but if you press one and then press the device you will se its unique name!
@@Gladers. Yeah, you have to change something so that the generated name is different cos the integration does not generate unique names. I only added the addon costs with does not change the name. When i let the integration do the VAT by ticking the box it worked as that changed the name.
Thanks for a good video! I'm trying to get the lowest consecutive x hours calculated and to show me the time when these hours start and how many hours remaining until that time. I have a few different machines that only uses timers dishwasher and washing machine etc. Today I use the apex chart to manually check the number of hours and program the appliances acoordanly. Are this something you have solved already? Maybe this is something you can include in the upcoming video? 😃
You don't need to create a template sensor to merge today and tomorrow. You can just do this within the data generator in Apex Charts: return entity.attributes.raw_today .concat(entity.attributes.raw_tomorrow) .map((item) => { return [item.start, item.value]; });
Great video @Smart Home Junkie, thanks a lot! Thanks for the tip @Mauz1: it solves a problem I had with the generator-script from the video: it made the chart only show well on my laptop-browser, not on all other instances (laptop-HA-app, and both the app and the browser in mobile & tablet). For reference to others with similarities: you also need to change the entity to original sensor, in this case: sensor.nordpool_kwh_nl_eur_3_10_021.
Very nice video. Works perfectly also with core HA. Prices (excl. VAT) match 1:1 with NextEnergy for today :). Additional costs also calculated nicely!
Your wish is my command... Save Money! Start Appliances at the LOWEST ENERGY PRICE using Home Assistant! ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-um_rU44WDSs.html
During the day, we have a cost for peak, midpeak and offpeak. I have been able to define the cost/time for each (and thereby know when best to use power hungry appliances) but what I haven't figured out yet is a way to calculated the overall cost per day...per month, etc. Unfortunately, the Energy dashboard in HA only allows one cost to be inputted. Do you have solution and if so, perhaps another video is in order :)
thank you so much, I am a new HA user (about a month) and you have been by far, my most trusted and useful source for info. If I may ask you, I am really fortunate to have my local electrical company (Westario Power) time of use rates as a part of the Ontario Energy board integration (Ontario Canada) in HA. So I have been able to get some great dashboard starts. I tried to replicate yours in this video to display hourly costs, (around the 10:40 mark specifically at the data generator section), copying the YAML exactly as you have it. But when I save it, it just comes up and says "loading". It stays like that for what feels like forever. It never errors on me, but it also never displays any info. I am wondering if the attributes on my integration mean I need to change the YAML code somewhat. YAML is my weakness so far. Any ideas would be greatly appreciated.
Thank a lot for this super integration. Just woundering, have you finally created that tutorial you mention at the end? How to define the cheapest hour to run automations?
Thank you for one more great tutorial! And thank you for making available to download ready to user codes. Although my question is would it be possible to shift chart by one hour to fit my time zone?
The code should support your time zone because it takes your Livan time. Not sure why it wicht work in your time zone. But, you could add one hour to the time in the code I guess.
Hi, nice video, in my country i need to use entsoe configuration, but the daily cost is a bit different from the one you explain in the video , there i no start time but only time and price , i been able to show the diagram with : data_generator: | return entity.attributes.prices .concat(entity.attributes.prices) .map((item) => { return [item.time, item.price]; }); but i am not able to add additional cost howcan i add . the template you show is not working for me
Hi Ed, 1st, great video. Its quick (very quick). I am wondering when the day ahead prices are "known" since it seems that today (29.1) the prices for tomorrow are still null (< 12.00 CET). I just ran into 1 issue, somehow the apex chart only shows 1 day (today) and not tomorrow.. which is odd.. since that data is to be seen in the nordpool and the created sensor.. - I am digging into it.. any suggestions are welcome. aha1... i've found one small issue, the list of prices is merely 24 entries.. the time is 48 (today / tomorrow).. that would explain why it is not showing anything > 23.00 today... aha2.. the integration is also showing "null" for all values tomorrow. The same seems to be the with Entsoe..
Very interesting video. I was already using the entso-e integration, but now I can give it another usefull function. Do you happen to know a similar integration for gas prices? Currently I use a webscraper, but the website is not updated often... Many thanks 🙂
Hi! today here in sweden we changed to summertime. we do this by turning the time forward one hour at 02:00 to 03:00. this means that today is 23 hours long and the price for 02:00 does not exist. this breaks this code showing nothing in the graph both yesterday and today. nordpool integration still has 24 prices and times. but one of them has the start time of 01 and end time as 03. and there is a entry that has the start time of 03:00 and the end time of 03:00. with the price "null" ( this is the annoying one) in the time i added this {% if hours.start != hours.end %} before adding to the ns.times. and in the prices i added {% if hours.value != None %} before adding to the ns.prices. this way i get a graph only showing 23 hours and all is fine again :) i have no idea how the integration will handle a 25 hour day when changing back for winter time though. oh the fun of being in charge of your own code :)
I've been looking into this here, but so far I do not see an issue here. I do see the graphs for Nordpool, ENTSO-e and Zonneplan as well in my overview. 🙄
Informative video Ed. Only my Apexchart isn't working, I have a typo in it and don't know where I made it. I am missing the Apex-Chart code in the download code templates. I typed it over from youtube. But there is an error in the code. (Update) I understood the whole thing wrong. I am a Vattenfall customer and does not having variable prices. But the template thing is very intressting to work with. Thanks.
Hey @SmartHomeJunkie! Thanks for this great tutorial and video -- helped me a lot. I run into a problem momentarily. in NL the prices tomorrow (14/11) are 0 on the market (integration of NordPool) between 02.00, 03.00 and 04.00h. In the list that is created using your code, these prices of full 0 are ignored and not used in the summation of Nordpool + the additional price, resulting in a list that is not correct. Is there a workaround for this?
Thanks for pointing that out! I just fixed it in v1.5 of the code. You can download the update here: ko-fi.com/s/e937e90ca8 Just log in with your ko-fi account and go to your previous orders to download it for free. Or use the e-mail with the link that you got earlier from Ko-Fi to download the latest version.
Hi, thanks for the great video! I have a question which i can't find the answer to. I would like to compare my current electricity usage and fixed prices (all available in energy dashboard) with my current electricity usage and the dynamic prices (the hypothetical situation as if i would have a dynamic contract). To compare if i would be better of having a dynamic contract in stead of having a fixed contract. Best scenario would be if i could recreate the table sources/bronnen table in the energy dashboard, add a colomn with the dynamic prices * consumption, and also retain the filter options that the energy dashboard provides. Any ideas? Thank in advance.
What do you have in the form of ‘smart meters’ in NL? Here in U.K. energy (both natural gas and electricity) are uploaded at regular intervals (~30 min) to a National database if you have a smart meter. There is a private network between the gas meter and the electricity meters, but it is encrypted and secure: there is a product from ‘Glowmarkt’ that can get local and more up to date information and supply it to Home Assistant using MQTT. I’m guessing that the majority of energy you use in NL is actually natural gas rather than electricity? Even without the device from Glowmarkt you can access the number with a phone app (“Bright”), so there might even already be an integration in HA. I’m waiting for a device, which are out of stock, so haven’t searched.
We've got several types of smart meters - i have an ISKRA model - that can provide second updates on numerous parameters (power / voltage / gas consumption). (Some people with older properties still have ferraris meters, but they are slowly disappearing). Using the P1 port you can set up an interface with it. It is also an integration. All used smart meters in NL have a P1 port. I am quite sure its a diagnostics interface too, so my guess, these type of devices are also used in the UK. If it has (diags) port, you should be able to read it.
Because the prices of tomorrow are available from 1PM every day and I didn't want to have a big gap in my graph every morning. But 48 works as well. It's just personal preference.
Thank you, great explanation It's now 20:00 and on the chart I only see the pricis till 12:00 next day. Is it possible to show 2 days completely? even if prices for next day are not published yet?
Hello, is there a tutorial on how to create custom energy dashboard which includes basically energy monitoring using dynamic energy prices(Note- My energy company has a website where they have fixed price for Summer and Winter months)
Thank you for the video. Our tariffs do not change by time, but by the number of kilowatts per month. For example, from 0-10 kW the price is 0.50 cents, from 10-50 kW the price is 0.75 cents, from 50-75 kW the price is 0.85 cents, from 75-100 kW the price is 0.95 cents. Is it possible to set up our tariff with Zonneplan or do I need something else?
nice video again! not using the variable energy jet, but could be interessting in the future :) the only thing is, as mentioned befor, it looks like there is something off whit te configuration of the APAX chart.... if I use the coding display in the video it keeps "loading"
Hi Peter, I created a fix in the download file that should fix your issue. You should be able to download it again if you login to Ko-Fi. Also check the extra information in the description of the video in case you use Zonneplan.
Thanks for your great tutorial! I wonder if it would be possible somehow to have the bars in the chart colored based on the relation to the average value for the day (or some other limit in a variable/sensor). I have tried using a variable in the color_threshold settings with no success. It might not be possible that way. In that case, would it be possible to create several sensors where the values are placed in different sensors depending on whether they are above or below the value in a variable/sensor and then merge these in the same diagram with some kind of stack in card and in this way get different colors?
Yes, that is possible. Use this code within series for that: color: green show: extremas: true color_threshold: - value: 0 color: blue - value: 0.2 color: lightgreen - value: 0.25 color: green - value: 0.3 color: greenyellow - value: 0.35 color: yellow - value: 0.4 color: orange - value: 0.45 color: red
@@SmartHomeJunkie Thanks. Maybe I was a little bad at describing what I was thinking, but I'll try again. I have found these settings. The problem is that I want these values to change for each day depending on what the electricity price looks like that day. One day the high electricity price might be 2 and the next day 4 and so on and would then like to replace these values with variables or if not possible create more sensors according to your example, but where values above a certain level end up in a separate sensor and they below in another, which would perhaps make it possible to show them with different colors in the same chart?
@@PeterLindh Not sure how to do that, but the show: extremas: true option shows a marker at the lowest and highest price in the chart. Maybe that is a solution too?
@@SmartHomeJunkie Thanks, that'll do for a while. I'll see if I can find a way to create two sensors/attributes, one for low and one for high values in relation to the mean for the day, in the future./Peter
i do have downloaded your script for zonneplan all thinks work right, but the only thing is: the 'show states' in the custom apexcard is linked to the latest hour in the graphic. i don't know how to change that to the current hour price? thanks for your good video's! and hopefully you can help me with this 'issue'
Good morning! Are there Zonneplan users which cannot see the tariffs anynmore??? Last week everything worked fine. Is there something changed in the code?
I found the reason. Zonneplan has changed its data. I already fixed it on my side and I am testing this now. The new code will be published on Ko-Fi somewhere today.
Thanks, i've dowloaded your code and got everything setup. One question though. When configuring the Nordpool intergration, 'Include VAT' is selected by default. Does that mean the NP integration knows about the VAT percentage for the region selected and I don't have to specify that myself? You mentioned in the video description under note 3 '..if you did not fill in the VAT percentage in the integration...', but there's nothing to specify there. The Nordpool sensor in my case has _021 at end of the sensor name, does that reflect the VAT percentage? Im in the Netherlands.
@@SmartHomeJunkie I'm in Denmark and has _025 at end of the sensor name - SO is VAT 21% in NL - it's 25 in DK and the numbers doesn't fit the ones on NordPool it looks like the VAT - BUT once when the integration is installed are there a way to get rid of the VAT without deleting and re-installing the integration?
Hi great video and I am Very interested in the coming videos. Templates work but apex chart does not keep getting loading. It does work with the existing sensor from nordpool.Any suggestions?
@@SmartHomeJunkie it is Very weird, in the apexchart, the prices are in the y axis, and change with the additional cost helper. But No columns. The apex chart is working because i added the entity sensor.nordpool_kwh_be_eur_3_10_021, and here I see the columns.
The template doesn’t work. Followed everything in the tutorial but the graph isn’t showing anything. Just vertically the price of the kWh and horizontal it starts with 00:00 and that’s it. no bars or whatsoever. I’ve downloaded the code directly.
That is really strange because it does work here and for other people as well. Can you show me what the values of the attributes of your template sensor are in your case? If the times and prices are filled in the attributes, then the template does work. In that case, I suspect that either the name of the entity is not correct in the apexchart, or that you might have some caching issue in your browser. Can you try to delete your browser cache and see if that helps you?
I created a fix in the download file that should fix your issue. You should be able to download it again if you login to Ko-Fi. Also check the extra information in the description of the video.
Please contact Ko-Fi for this. They handle this for me. Sometimes there's an issue with iDEAL, which means that your payment is not registered (and also not charged from your account).
soooo what to do when you dont get the option to create a UID when right clicking invirtual studio ? (i made the folders as you showed and i copy pasted what you had in the download file )
That shouldn't be the case 🤔 But there's also all UUID generator sure where you can create these UUIDs. And I think you can also do it using crtl-shift-P and search for uuid.
Hi there. I have a problem with the chart. It show a vertical dotted line with NOW on it at the exact time but no data is shown. In the Nordpool Senosr, I can see all dates and prices. It looks like the chart can not get the data from nordpool_kwh_be_eur_30_10_021. I downloaded the file today so the float(0) is used. Where did I go wrong ?
Hi Again, Since it did not work with Norpool I tried with Entso-e and had the same result : Nothing in the graph. Then I changed {{ states('sensor.smart_home_junkie_average_electricity_price_today') in the template with {{ states('sensor.entsoe_average_electricity_price_today') and now it shows a nice graph.
@@dominiquemattelaer3881 As far as I see from your post, you didn't change the entity in my example into your own entity name. That might be the reason why it's not working on your side. You now only see the graph of today. The goal of the video was to learn how you can use a custom template to show the graph of today and tomorrow combined.
You can't. Creating these videos costs a lot of time and I need to pay for my groceries too. This is not a hobby for me, but my main income. But, you can type the code from the screen if you want to spend more time to implement this. If you want to save time and sponsor the work that I do to make your life easier, you can download the code against a small sponsoring fee.
Thanks for this! I bought you a large cup of coffee. ☕ One minor question. What's the story with the strange suffix of the entity name... the "_3_10_021". 🤯 It looked to me like a date, but I guess that's not the case.
Thanks for this tutorial! I am however a little bit stuck. I paid and downloaded your code but when I'm installing the apex card I get this warning: After the download completes, since you are not using Lovelace in storage mode you need to manually add the resource with these settings: url: /hacsfiles/apexcharts-card/apexcharts-card.js type: module My first thought was what is lovelace and how do I run it in storage mode, whatever that is? The card won't show up on my default and only dashboard. My intention with home assistant is to try to avoid doin' sketchy code as much as I can :) This is however an addition that I absolutely need to make automations from later, based on current energy price. So that's why I have now spent three hours googling for an answer about the lovelace stuff, but not found anything usable. I've tried to add the yaml above in the configuration.yaml but I get errors. I remember that you have some videos on making dashboards and maybe in them you show how to run lovelace in storage mode? Would appreciate som help here., thanks!
Hi Tim, I think the message means that you have to add the resource in Settings>Dashboards and then click on the three dots in the right upper corner and click resources. Does that thelp?
@@SmartHomeJunkie Oh yeah, that did it! That was of course too hard for them to write in the warning message... Thanks for the help! Continuing your tutorial now :)
I looked into this issue more. It turns out that the paste option is not shown if your home assistant instance is running via HTTP. If you connect to your Home Assistant server using a safe https connection, the paste option is shown.
Hello, just bought the code, but in safari i cannot download the content. It just gives digital marks … I tried to send a email, but the code to confirm my email is taking very long … i bought it under the name Marcelsjan … could you help me with it. i’ve got it, i wasn’t logged in for the download … i just closed a contract with zonneplan, so it’s very interesting … fijne dag
Hi anyone know what im doing wrong ...i have a problem retrieving times in the template....prices are ok but instead of times i get blank spaces.( , , , , , , and so on)
HI, thanks for the quick response :) Im using the Nordpool integration and followed all steps from Your video and got to the point where You made the NordPool Energyprices sensor in Template.yaml and You have times and i dont :D. Have checked the code numeros times and checked that my HA time is correct. And now im kind of out of ideas what to try next. (...{%- set ns.times = ns.times + [as_local((hours.start))...) Is it possible to change the "as_local" to somehting like GMT or UTC or something other to check if its still my hardware ant its time settings?@@SmartHomeJunkie
Nvm got it working... for others who have the same problem check your code and make sure that u dont have----> "%Y-%m-%d H%:%M:%S" meaning % goes before H(ours) not after it ;).... correct is - %Y-%m-%d %H:%M:%S"
