Save Money Now: Track Dynamic Energy Prices in Home Assistant

Рет қаралды 29,168

Күн бұрын

Energy prices are going through the roof these days. Some energy companies deliver dynamic energy prices so that the price of energy changes every hour. This way, you can turn on your appliances when the prices are low. I am going to show you in this tutorial how you can create a bar chart of the dynamic energy prices in Home Assistant so that you can monitor these prices and see when it's the best time to turn on appliances like your washing machine. And on top of that, you learn more about how to work with templates in Home Assistant.
⭐ You can download the code that I created for this video at: ko-fi.com/s/e937e90ca8 ⭐
The download file also contains some optimizations to the code that is shown in the video.
Links referred to in this video:
* How to install HACS in Home Assistant: • Install HACS in Home A...
* Apex Chart manual: github.com/RomRider/apexchart...
* The ENTSO-e transparency site: transparency.entsoe.eu
* Save Money! Start Appliances at the LOWEST ENERGY PRICE using Home Assistant!
• Save Money! Start Appl...
Blog version: www.smarthomejunkie.net/how-t...
NOTE:
If you install Zonneplan, you have to enable the following entity to make this work: sensor.zonneplan_current_electricity_tariff
* Go to Settings
* Go to Devices and Services
* Go to the entities tab
* Search for Zonneplan
* Click on Zonneplan current electricity tariff
* Select Enable Entity
NOTE 2:
In some cases, the bar chart is not shown for some people. If you experience issues with the Apexchart card that does not show a graph, then change the following code in the template:
replace float by float(0)
NOTE 3:
If you did not fill in the VAT percentage in the integration, you can also choose to multiply the price with your VAT percentage in the template, and on top of that add additional costs. In that case, the formula would be something like this if your VAT is 21%:
{%- set ns.prices = ns.prices + [(hours.value * 1.21) + states('input_number.nordpool_additional_costs') | float] -%}
Special thanks to TheFes for tweaking the code so that it got smaller.
⭐⭐⭐
* Join this channel to get access to perks: 📺 / smarthomejunkie
* Please consider becoming my patron 🏅 at / smarthomejunkie
* Or please support me by buying me a ☕ at ko-fi.com/smarthomejunkie/
⭐⭐⭐
My Devices: github.com/smarthomejunkie/My...
Instagram: / smarthomejunkie
Twitter: / smarth0mejunkie
Facebook: / smarthomejunkie
TikTok: / smarthomejunkie
Discord: / discord
Music by:
* 2TECH-AUDIO: 2tech-audio.bandcamp.com/
00:00:00 Introduction
00:01:11 Install the Nordpool integration in Home Assistant
00:02:48 Show the data that the Norpool integration sends to Home Assistant
00:03:46 Create a template sensor to combine data of today and tomorrow
00:04:38 Create a number helper to store additional costs
00:05:21 Create the template
00:05:51 Install Studio Code Server
00:06:21 Create the templates.yaml file
00:07:01 Add the template code to the templates.yaml file
00:07:47 Retrieve the time from the Nordpool integration
00:08:41 Retrieve the energy prices from the Nordpool integration
00:09:27 Let's test the template
00:09:57 Create the bar-chart
00:11:12 Add the additional costs helper field
00:11:44 Install the ENTSO-e integration
00:12:27 Retrieve the API key from ENTSO-e
00:13:10 Configure ENTSO-e in Home Assistant
00:13:57 Download the code for the ENTSO-e and Zonneplan integration
00:14:16 Conclusion
#homeassistant #variableenergyprices #energyprices #trackenergy #tutorial #smarthome #homeautomation

Пікірлер: 165

@SmartHomeJunkie Жыл бұрын

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 👇

@StefCB25 Жыл бұрын

Engie

@rolfvanderglas5473 Жыл бұрын

Tibber

@bilgyno1 Жыл бұрын

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.

@bilgyno1 Жыл бұрын

@encostablanca Жыл бұрын

esios ree integration home assistant ( Spain national network of electricity)

@Cptnbond Жыл бұрын

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.

@SmartHomeJunkie Жыл бұрын

Thank you for your support! 🙏🏻

@EsotericArctos Жыл бұрын

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.

@rapha5586 Жыл бұрын

Another great video, thank you so much!

@ietsmetcomputers Жыл бұрын

Awesome, was waiting for this. I'm using Tibber, if this could be added I would be very grateful!

@renemller4175 Жыл бұрын

Thank you for yet another useful video

@NickyNiclas Жыл бұрын

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.

@ted8718 Жыл бұрын

Very nice video. Works perfectly also with core HA. Prices (excl. VAT) match 1:1 with NextEnergy for today :). Additional costs also calculated nicely!

@SmartHomeJunkie Жыл бұрын

Nice!

@bjornhagberg6178 Жыл бұрын

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? 😃

@stephanlans 4 ай бұрын

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!

@SmartHomeJunkie 4 ай бұрын

Dank je wel!!!

@edwinhaas4571 Жыл бұрын

Thanks...code works perfectly from the download!! Next step would be a nice graph that uses this data in an actual cost overview

@SmartHomeJunkie Жыл бұрын

Great suggestion!

@marksysplace3435 7 ай бұрын

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.

@steffenoh 4 ай бұрын

Thank you! I would love a tutorial on how you can control your heating etc. automatically, based on energy prices :)

@SmartHomeJunkie 4 ай бұрын

Your wish is my command... Save Money! Start Appliances at the LOWEST ENERGY PRICE using Home Assistant! kzfaq.info/get/bejne/q9OPpbhlmb2og6c.html

@87vortex87 6 ай бұрын

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.

@jaap7374 Жыл бұрын

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 Жыл бұрын

@Gladers How do yo do this? If I add another Nordpool integration under Settings / Devices & Services it will not give me another device to use.

@magnuserlandsson1327 Жыл бұрын

@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.

@nulfe1 Жыл бұрын

my provider add an extra tarif from 17 to 20, how can i get the helper to calculate all day additional cost and an extra cost for this time.

@Blyxnis Жыл бұрын

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?

@SmartHomeJunkie Жыл бұрын

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.

@AndriusNera Жыл бұрын

Hi, need help, how to write: that be added hours.value and states('input_number.nordpool_additional_costs) and then the amount received multiply 1.21

@fdksdk4843 Жыл бұрын

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)

@RobinDeBecker Жыл бұрын

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 🙂

@SmartHomeJunkie Жыл бұрын

Great to hear. I don't know an option for the gas prices yet unfortunately.

@Mauz1 Жыл бұрын

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]; });

@SmartHomeJunkie Жыл бұрын

Nice.

@vitalyrepin 6 ай бұрын

Indeed! Thanks!

@OnnoBorkes 3 ай бұрын

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.

@simonemastellonephotography 5 ай бұрын

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

@brianj2029 Жыл бұрын

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 :)

@SmartHomeJunkie Жыл бұрын

Interesting subject! Let me think about it.

@ictstelucjam3604 Жыл бұрын

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.

@SmartHomeJunkie Жыл бұрын

Ah yes. Sorry. I have to add it to the code. Can you DM me on Discord?

@sebasmoustache 8 ай бұрын

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?

@SmartHomeJunkie 8 ай бұрын

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.

@sebasmoustache 8 ай бұрын

thanks for this quick resolve! keep up the good work.@@SmartHomeJunkie

@christianpelegrie 4 ай бұрын

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?

@SmartHomeJunkie 4 ай бұрын

Yes, see the link in the description of this video.

@fredericfaure5958 4 ай бұрын

@@SmartHomeJunkiethanks!!

@alwinbakema Жыл бұрын

Bedankt Ed! Money well spend... Met de je gekochte script was het een fluitje van een cent. Zo wordt Zonneplan nog leuker om te gebruiken.

@SmartHomeJunkie Жыл бұрын

That's great to hear!!!

@imisterets Жыл бұрын

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?

@SmartHomeJunkie Жыл бұрын

I think you'll need something else unfortunately.

@KIA_E-NIRO_MY20 Жыл бұрын

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'

@SmartHomeJunkie Жыл бұрын

Thanks. This is a bug in Apexcharts. There's an issue reported on the Apexcharts Github about it.

@guntherkuess1444 Жыл бұрын

Tack!

@SmartHomeJunkie Жыл бұрын

Thank you for your support 🙏🏻

@erichermansson6849 Жыл бұрын

Great video as usual. How come you use graph_span: 36 and not 48?

@SmartHomeJunkie Жыл бұрын

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.

@thijsclaessens8219 Жыл бұрын

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..

@SmartHomeJunkie Жыл бұрын

Every day at 13:00 the prices will be updated for tomorrow. So, they will be available within the hour from now.

@3dprintingRestored Жыл бұрын

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 )

@SmartHomeJunkie Жыл бұрын

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.

@pippaengroda Жыл бұрын

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 :)

@SmartHomeJunkie Жыл бұрын

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. 🙄

@PeterLindh Жыл бұрын

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?

@SmartHomeJunkie Жыл бұрын

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

@PeterLindh Жыл бұрын

@@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?

@SmartHomeJunkie Жыл бұрын

@@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?

@PeterLindh Жыл бұрын

@@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

@SmartHomeJunkie Жыл бұрын

@@PeterLindh My next video might help you out with this as well 😉

@defisit501 Жыл бұрын

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 Жыл бұрын

Not sure, but you I believe there is an extra screen during setup where you can set that. Or you can add a VAT calculation to the template.

@erikfleron542 Жыл бұрын

@@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?

@mkornel01 Жыл бұрын

I found a small error in the Code-for-Track-Energy-Prices-v1.2.txt file. op regel 258 staat 'float_precision: 2' dubbel.

@SmartHomeJunkie Жыл бұрын

Thank you. You are correct. I fixed in and uploaded version v1.3

@brnsmns Ай бұрын

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?

@SmartHomeJunkie Ай бұрын

No, you cannot show prices when they are not published yet. 🤷🏼‍♂️

@brnsmns Ай бұрын

Found it, graph span up to 48

@manologitech 10 ай бұрын

Great

@peterboudewijn9119 Жыл бұрын

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"

@SmartHomeJunkie Жыл бұрын

There should be something different in your setup then. Look at the attribute values of your template sensors if they contain the correct values.

@peterboudewijn9119 Жыл бұрын

@@SmartHomeJunkie thanx for the quick responce :) will dive in to it and let you know

@SmartHomeJunkie Жыл бұрын

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.

@peterboudewijn9119 Жыл бұрын

@@SmartHomeJunkie my true HA hero!! Now it works :) thanx again!

@SmartHomeJunkie Жыл бұрын

@@peterboudewijn9119 I'm glad I could help. And thank you for making me aware of this issue.

@gilad3121 Жыл бұрын

Thanks for the video Is there anything that also includes the State of Israel?

@Maginone2 Жыл бұрын

Anyone else having nordpool not pulling new day data? Reboot of ha does get new data but the day after the same problem.

@SmartHomeJunkie Жыл бұрын

I just tested it. Still works here.

@mastermaikel Жыл бұрын

I bought a copy but didn’t receive a download link for the files, could you help me?

@SmartHomeJunkie Жыл бұрын

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).

@eberger02 Жыл бұрын

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.

@chunkster29 Жыл бұрын

I'm using shelly em and bright and they pretty close so maybe something could be done with them

@thijsclaessens8219 Жыл бұрын

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.

@borisvanderstraeten6095 Жыл бұрын

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 Жыл бұрын

What are the values of the times and prices in the template entity in the developer tools?

@borisvanderstraeten6095 Жыл бұрын

@@SmartHomeJunkie in developper tools, then template, I see the demo template, ill change to check difference.

@borisvanderstraeten6095 Жыл бұрын

@@SmartHomeJunkie in states , then Sensor.nordpool_energyprices I see all the correct times and prices.

@SmartHomeJunkie Жыл бұрын

@@borisvanderstraeten6095 You can also contact me on Discord if you need help. I am curious what the values of attributes are in the template sensor.

@borisvanderstraeten6095 Жыл бұрын

@@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.

@dominiquemattelaer3881 Жыл бұрын

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 ?

@SmartHomeJunkie Жыл бұрын

Check the values of the entity in the developer tools to see if it contains data.

@SmartHomeJunkie Жыл бұрын

The chart should not get data from the attribute that you are mentioning here, but from the newly created template sensor.

@dominiquemattelaer3881 Жыл бұрын

@@SmartHomeJunkie Hi again. I have checked but can not see the problem. Would it help if I would send you screendumps ?

@dominiquemattelaer3881 Жыл бұрын

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.

@SmartHomeJunkie Жыл бұрын

@@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.

@michnl1772 Жыл бұрын

Is it just me that i didn't see the integration of Zonneplan in your setup that you talk about in intro?

@SmartHomeJunkie Жыл бұрын

Is in the download link or you can just install the Zonneplan integration and apply the knowledge in the code that I show in this tutorial.

@michnl1772 Жыл бұрын

@@SmartHomeJunkie Ah thanks i will take a look, i did already setup the Zonneplan Integration with The Energy Dashboard that works with the P1 meter.

@patrickvanlanen4037 Жыл бұрын

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.

@SmartHomeJunkie Жыл бұрын

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?

@SmartHomeJunkie Жыл бұрын

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.

@alwinbakema Жыл бұрын

Good morning! Are there Zonneplan users which cannot see the tariffs anynmore??? Last week everything worked fine. Is there something changed in the code?

@SmartHomeJunkie Жыл бұрын

I notice something similar. Will look into it today

@SmartHomeJunkie Жыл бұрын

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.

@alwinbakema Жыл бұрын

@@SmartHomeJunkie Ed your the best! I will buy you some coffee!

@SmartHomeJunkie Жыл бұрын

@@alwinbakema I just updated the code and uploaded it to Ko-Fi. If you've ordered the code before, you can download it for free.

@alwinbakema Жыл бұрын

@@SmartHomeJunkie off course I already bought it. But i appreciate your effort. Therefore Some extra coffee.

@arnoudnieuwenhuizen1171 11 ай бұрын

Ik heb alles werkend, alles vernieuwd de tabel zich niet. Oftewel, ik kan na vanmiddag 16 uur de prijzen niet meer zien. Is dat op te lossen?

@arnoudnieuwenhuizen1171 11 ай бұрын

Laat maar. De prijzen voor morgen zijn natuurlijk nog niet bekend. Dom!

@SmartHomeJunkie 11 ай бұрын

Inderdaad. Je krijgt de nieuwe prijzen vanaf ongeveer 13:00 uur te zien.

@borisvanderstraeten6095 Жыл бұрын

Ecopower in Belgium

@JAAPOP8 Жыл бұрын

And u think there r guys who understand this...

@SmartHomeJunkie Жыл бұрын

Some videos are for advanced users and some are for beginners. This one is for advanced users.

@Hupihovi Жыл бұрын

I can't be the only one wondering how the hell you download from ko-fi without paying?

@SmartHomeJunkie Жыл бұрын

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.

@JaapKrijgsmanNL Жыл бұрын

apexcharts-card Entity not available: sensor.nordpool_energyprices How do we create this sensor?

@SmartHomeJunkie Жыл бұрын

I think you might have missed something in the video. It's explained how to create these charts in the video.

@TimAlfredsson Жыл бұрын

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!

@SmartHomeJunkie Жыл бұрын

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?

@TimAlfredsson Жыл бұрын

@@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 :)

@SmartHomeJunkie Жыл бұрын

@@TimAlfredsson Awesome!

@MrPeterVanHees Жыл бұрын

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.

@SmartHomeJunkie Жыл бұрын

Thank you so much!!! I don't know why that entity name is so long. It's been created by the integration.

@123berniez Жыл бұрын

I bought the download and it opened in kladblok. How can I copy the code to the templates.yaml? Paste is not available in templates.yaml.

@SmartHomeJunkie Жыл бұрын

Thank you for your support! Try CTRL-V to paste the code.

@SmartHomeJunkie Жыл бұрын

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.

@123berniez Жыл бұрын

Figured it out. Ctrl c and ctrl v

@marcelsjan Жыл бұрын

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

@SmartHomeJunkie Жыл бұрын

Thank you for your support.

@johannes9877536974 8 ай бұрын

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)

@SmartHomeJunkie 8 ай бұрын

Hi! Interesting that you get this. What integration do you use?

@johannes9877536974 8 ай бұрын

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

@johannes9877536974 8 ай бұрын

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"