# \[APP\]\[Pro\] Power by the Hour: Insights per hour, day, month and year **URL:** \ **Category:** Apps\ **Tags:** app, tools\ **Created:** [November 10, 2019, 10:06pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535 "2019-11-10T22:06:03Z")\ **Posts on this page:** 20\ **Page:** 70
**Author:** ![Daniel\_S](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/daniel_s/32/24881_2.png) [@Daniel\_S](https://community.homey.app/u/Daniel_S)\ **Post date:** [February 16, 2023, 1:53pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1412 "2023-02-16T13:53:24Z")
Since todays midnight I am not getting any updates on el. CZ spot prices ☹ ![Screenshot_2023-02-16-14-30-09-798_app.homey](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/0/8/0841c42f864fac6911d6f985fa7bcf0d8388df71.jpeg) Thanks for taking a look. ---
**Author:** ![Sharkys](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/sharkys/32/54029_2.png) [@Sharkys](https://community.homey.app/u/Sharkys)\ **Post date:** [February 16, 2023, 2:15pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1413 "2023-02-16T14:15:42Z")
> [@Daniel\_S](#): > > I am not getting any updates on el. CZ I can confirm. ---
**Author:** ![Gruijter](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/gruijter/32/1973_2.png) [@Gruijter](https://community.homey.app/u/Gruijter)\ **Post date:** [February 16, 2023, 5:22pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1414 "2023-02-16T17:22:19Z")
If the data source is down nothing can be done other then wait… [https://transparency.entsoe.eu/transmission-domain/r2/dayAheadPrices/show](https://transparency.entsoe.eu/transmission-domain/r2/dayAheadPrices/show) But when I check for CZ I do see prices showing up. So is it solved now? ---
**Author:** ![Sharkys](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/sharkys/32/54029_2.png) [@Sharkys](https://community.homey.app/u/Sharkys)\ **Post date:** [February 16, 2023, 5:35pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1415 "2023-02-16T17:35:59Z")
Hmm, strange, I still see last update 2 days ago. Tried even restart of the PbH, no change. ---
**Author:** ![Daniel\_S](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/daniel_s/32/24881_2.png) [@Daniel\_S](https://community.homey.app/u/Daniel_S)\ **Post date:** [February 16, 2023, 7:53pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1416 "2023-02-16T19:53:48Z")
I checked the source too but device does not update anyway. Maybe they made some changes in API? ---
**Author:** ![Ria\_Banis](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/ria_banis/32/7966_2.png) [@Ria\_Banis](https://community.homey.app/u/Ria_Banis)\ **Post date:** [February 17, 2023, 9:48am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1417 "2023-02-17T09:48:52Z")
For every measurement you make a device in the pbth app. I only have solar panels and electric. ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/7/5/75e790dbf854b8ec97ce833bf9291e7a37206062.jpeg) I export a file to Sheets: ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/7/5/7510b4a985b51881cbcd90cdca525cddbffd6f99.jpeg) The flow is: [https://homey.app/f/PwVMup](https://homey.app/f/PwVMup) I use the value “day before” ---
**Author:** ![Gruijter](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/gruijter/32/1973_2.png) [@Gruijter](https://community.homey.app/u/Gruijter)\ **Post date:** [February 17, 2023, 12:03pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1418 "2023-02-17T12:03:27Z")
Yes, it does look like an API change. Will need to dig into this further. Edit: They changed the API url. I fixed it in the new version PBTH. ---
**Author:** ![Gruijter](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/gruijter/32/1973_2.png) [@Gruijter](https://community.homey.app/u/Gruijter)\ **Post date:** [February 17, 2023, 12:28pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1419 "2023-02-17T12:28:28Z")
new version 5.4.5 was just released as stable. - Fixed ENTSOE new API url. - homey-api@1.10.18 ---
**Author:** ![JonE](https://avatars.discourse-cdn.com/v4/letter/j/f9ae1b/32.png) [@JonE](https://community.homey.app/u/JonE)\ **Post date:** [February 17, 2023, 9:36pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1420 "2023-02-17T21:36:18Z")
Nice, thanks for the follow up @Ria_Banis! ---
**Author:** ![Bulletcather](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/bulletcather/32/13738_2.png) [@Bulletcather](https://community.homey.app/u/Bulletcather)\ **Post date:** [February 19, 2023, 9:46pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1421 "2023-02-19T21:46:02Z")
Is there a way to get the information to a MQTT server. I use Nodered for a dashboard ---
**Author:** ![Steefph](https://avatars.discourse-cdn.com/v4/letter/s/c37758/32.png) [@Steefph](https://community.homey.app/u/Steefph)\ **Post date:** [February 21, 2023, 4:52pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1422 "2023-02-21T16:52:47Z")
Would you mind sharing your script? ---
**Author:** ![Torch1969](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/torch1969/32/33305_2.png) [@Torch1969](https://community.homey.app/u/Torch1969)\ **Post date:** [February 21, 2023, 6:39pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1423 "2023-02-21T18:39:52Z")
Hello @Steefph , sure that is possible, I’m happy to share. But only if you’re experienced homeyscript user who can understand what’s needed and can make variables and flows to use the script. If that’s the case i can share by PM Not for coming day’s, I’m in hospital at this moment, recovering from a serious issue, but going home tomorrow, so will have lots of time later on this week. ---
**Author:** ![Gruijter](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/gruijter/32/1973_2.png) [@Gruijter](https://community.homey.app/u/Gruijter)\ **Post date:** [February 21, 2023, 6:42pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1424 "2023-02-21T18:42:01Z")
> [@Torch1969](#): > > recovering from a serious issue Take care of yourself Gert! Hope you have a speedy recovery. ---
**Author:** ![Steefph](https://avatars.discourse-cdn.com/v4/letter/s/c37758/32.png) [@Steefph](https://community.homey.app/u/Steefph)\ **Post date:** [February 21, 2023, 6:59pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1425 "2023-02-21T18:59:36Z")
Homey Script is not an issue. But it is always easier to borrow someone’s wheel than reinventing it 🙂 Hope you recover quickly and, no rush! ---
**Author:** ![Torch1969](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/torch1969/32/33305_2.png) [@Torch1969](https://community.homey.app/u/Torch1969)\ **Post date:** [February 23, 2023, 6:41pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1426 "2023-02-23T18:41:27Z")
@Steefph , i’m back. See PM with instructions and script. Have fun. ---
**Author:** ![Ria\_Banis](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/ria_banis/32/7966_2.png) [@Ria\_Banis](https://community.homey.app/u/Ria_Banis)\ **Post date:** [February 24, 2023, 10:02am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1427 "2023-02-24T10:02:20Z")
@Gruijter It seems like the “device” for my solar panels doesn’t reset at midnight to zero: ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/f/c/fc7e43467f2eed09514af1524dccba1475599955.jpeg) ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/f/0/f071f2f997377a89b885807e186f79eeb19081ec.jpeg) After restart it gives the correct values ( for the time being a use a restart flow just after midnight) The restart does not work anymore. Now also the other device (Electricity) is also not working anymore 😢 ---
**Author:** ![HanZ](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/hanz/32/18371_2.png) [@HanZ](https://community.homey.app/u/HanZ)\ **Post date:** [February 24, 2023, 2:28pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1428 "2023-02-24T14:28:21Z")
Hi developer and community, Is there already a clear manual to guide me step by step to setup “Power by the hour” in combination with Plugwise P1 (v3) and ANWB daily prices for gas and electric? Can’t see the forest trough the trees no more… 😊 grtz Hans ---
**Author:** ![Eternity](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/eternity/32/102113_2.png) [@Eternity](https://community.homey.app/u/Eternity)\ **Post date:** [February 25, 2023, 9:42am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1429 "2023-02-25T09:42:01Z")
Would it be possible to allow this value to be negative: ![IMG_20230225_103811](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/d/f/df020d66cfcc443706709598be7685e92e1180d2.jpeg) When Power used becomes lower than Power generated due to solar panels, this value drops to zero, but Power is actually negative (generated). ---
**Author:** ![Gruijter](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/gruijter/32/1973_2.png) [@Gruijter](https://community.homey.app/u/Gruijter)\ **Post date:** [February 25, 2023, 10:35am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1430 "2023-02-25T10:35:31Z")
That is already supported. ![Screenshot_20230225_113402_Homey](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/0/6/06f2cc4823ce33bb6d8c2701a75ba45283f5397f.jpeg) What is the source device and app you are using? ---
**Author:** ![Gruijter](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/gruijter/32/1973_2.png) [@Gruijter](https://community.homey.app/u/Gruijter)\ **Post date:** [February 25, 2023, 10:50am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1431 "2023-02-25T10:50:06Z")
> [@Ria\_Banis](#): > > solar panels doesn’t reset at midnight to zero Hi Ria, can you post a screenshot of the PBTH device settings (top part), and insights graphs of past 24 hrs for: - PBTH ‘this\_hour’ - the source device (solarEdge) energy (kWh) [Previous page](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535.md?page=69) [Next page](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535.md?page=71)