# \[APP\]\[Pro\] Power by the Hour: Insights per hour, day, month and year

**URL:** <https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535>\
**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:** 90

<div class="post-metadata">

**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:** [November 4, 2023, 12:30pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1819 "2023-11-04T12:30:13Z")

</div>

New version 5.8.0 is ready for testing [Power by the Hour App for Homey | Homey](https://homey.app/a/com.gruijter.powerhour/test/)

- Fixed Gas DAP (please check @EdNL )
- Fixed Gas summarizer for ZTATZ (please check @anon61197305)
- homey-api@3.0.25.

Fixing the Gas DAP was a PITA, so I hope it is fixed for a while to come…

---

<div class="post-metadata">

**Author:** ![anon61197305](https://avatars.discourse-cdn.com/v4/letter/a/8baadc/32.png) [@anon61197305](https://community.homey.app/u/anon61197305)\
**Post date:** [November 4, 2023, 2:13pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1820 "2023-11-04T14:13:49Z")

</div>

There are two Gas Summerizer devices now.  
Stroom\_Σgas  
VIRTUAL\_VIA\_FLOW\_Σ-gas

The first one is added, migrated and still empty.  
The second one is added, migrated and also empty.

Edit: now I have data! Yay!

---

<div class="post-metadata">

**Author:** ![staeff](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/staeff/32/79712_2.png) [@staeff](https://community.homey.app/u/staeff)\
**Post date:** [November 4, 2023, 2:25pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1821 "2023-11-04T14:25:31Z")

</div>

I tried to add a new Power Summarizer device (HOMEY\_ENERGY\_DEVICE\_Σpower), that just displayed 0kWh all the time. Which makes sense if my understanding is correct since my devices don’t report kWh usage but just Watt. But when I change the setting to “Use Watt as source” the device just shows an error “Source device is missing.”, am I misunderstanding something here and I need to do things differently or is this a bug? I also tried the current test version, but also doesn’t fix this.

 ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/b/d/bdb9095cd0c8f3799ae0123cefbf2c4dd21642ac.png)  
 ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/a/9/a92029a859c6da55a95627ac944a3330fc81a368.png)

**EDIT:** Ok turns out that it just showed 0 because of how little kWh a few lamps produce, after letting it run for some time it seems to be correct. Still a bit confused about the “Use Watt as source” option though.

---

<div class="post-metadata">

**Author:** ![CaptainVoni](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/captainvoni/32/3549_2.png) [@CaptainVoni](https://community.homey.app/u/CaptainVoni)\
**Post date:** [November 6, 2023, 1:36pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1822 "2023-11-06T13:36:48Z")

</div>

At what time are the electricity prices usually updated? Today the Austrian prices for tomorrow were generally available shortly after 13:00, but updated in Homey at 14:04.

---

<div class="post-metadata">

**Author:** ![EdNL](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/ednl/32/90603_2.png) [@EdNL](https://community.homey.app/u/EdNL)\
**Post date:** [November 7, 2023, 7:52am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1823 "2023-11-07T07:52:36Z")

</div>

Hi @Gruijter  
It is working now, thank you 🙂

But I have a little problem to get the correct price. It have to be (today 07-11) 116,24 cent. And when I put the information to get it, in the app, I get an other price. I don’t know what I do wrong.

I do something wrong, but I don’t know what.  
Zonneplan Price: 1,1624 euro  
My price in the app: 1,644 euro

This is the correct price today:  
 ![Scherm­afbeelding 2023-11-07 om 08.46.57](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/f/6/f6ef20bbe32d08047822ae11dbd09ede47775d79.png)

This is what I have put in the App:

 ![IMG_7370](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/f/d/fdc76e5ee3b9d439f366aceaa4b52dd6dbe005bb.jpeg)

This is how I get it:

 ![Scherm­afbeelding 2023-11-07 om 08.50.22](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/a/0/a002808b1faa997cc8d87222ee60f85f2bd87bd7.png)

---

<div class="post-metadata">

**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:** [November 7, 2023, 9:19am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1824 "2023-11-07T09:19:53Z")

</div>

The fixed markup you enter in PBTH must have BTW included.

So, according to the info you provided:  
(0,48980 + 0,08) x 1,21 = 0,689458

---

<div class="post-metadata">

**Author:** ![EdNL](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/ednl/32/90603_2.png) [@EdNL](https://community.homey.app/u/EdNL)\
**Post date:** [November 7, 2023, 9:38am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1825 "2023-11-07T09:38:16Z")

</div>

Thank you @Gruijter  
When I do that, I get 1.1792 and it is 1.1624 (from Zonneplan)

I use TTF\_EGSI, is this correct?

---

<div class="post-metadata">

**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:** [November 7, 2023, 4:25pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1826 "2023-11-07T16:25:55Z")

</div>

Zonneplan gas:

 ![Schermafbeelding 2023-11-07 om 17.24.34](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/c/4/c4b0a21d3e1e0a0e55100dd086a0939a5cda3774.png)

Komt precies op 1.1624 uit.

---

<div class="post-metadata">

**Author:** ![staeff](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/staeff/32/79712_2.png) [@staeff](https://community.homey.app/u/staeff)\
**Post date:** [November 7, 2023, 5:02pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1827 "2023-11-07T17:02:17Z")

</div>

As far as I can see from the source code the fetching of new data happens at a random point of time once an hour. And when the prices are available on the APIs (entsoe/nordpool) potentially could also have a bit of an delay. So after 15:00 you probably should always have tomorrows prices, but before that its’s not guaranteed to have been updated/published yet.

> <https://github.com/gruijter/com.gruijter.powerhour/blob/e29038f82f6fd488a54ae2bed06a04cf966a0816/drivers/generic_dap_device.js#L80>

---

<div class="post-metadata">

**Author:** ![EdNL](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/ednl/32/90603_2.png) [@EdNL](https://community.homey.app/u/EdNL)\
**Post date:** [November 8, 2023, 6:50am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1828 "2023-11-08T06:50:46Z")

</div>

> [@Gruijter](#):
>
> So, according to the info you provided:  
> (0,48980 + 0,08) x 1,21 = 0,689458

Het bedrag dat jij geeft @Torch1969, klopt. Het bedrag, dat ik van @Gruijter kreeg klopt niet. Daar zat de fout in. Bedankt voor de hulp!

---

<div class="post-metadata">

**Author:** ![EdNL](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/ednl/32/90603_2.png) [@EdNL](https://community.homey.app/u/EdNL)\
**Post date:** [November 8, 2023, 11:45am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1829 "2023-11-08T11:45:36Z")

</div>

I have another question and hope someone can help me with it.

On the topic: CEMM CEDEL Energyverbruik manager  
I have a question that I can’t figure out. Someone has already helped me a lot on that topic, but I am still stuck with one last piece. This contains a Power by the Hour flow that I need to create. But I don’t know how and I hope someone can help me here. What matters is this, can anyone help me?

I have a question that I can’t figure out. Someone has already helped me a lot on that topic, but I am still stuck with one last piece.

![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/c/7/c717bb2c5cc1b45903d040d474d3469abb2d60bd.png)  
and this is the result:  
 ![Scherm­afbeelding 2023-11-08 om 12.44.57](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/d/a/daf5ceb4314d31101a3685d1276d93c3726d1acd.png)

This contains a Power by the Hour flow that I need to create. But I don’t know how and I hope someone can help me here. What matters is this, can anyone help me?

[https://community.homey.app/t/cemm-cedel-energieconsumption-manager/25261/44](https://community.homey.app/t/cemm-cedel-energieconsumption-manager/25261/44)

---

<div class="post-metadata">

**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:** [November 8, 2023, 4:13pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1830 "2023-11-08T16:13:07Z")

</div>

> [@EdNL](#):
>
> Het bedrag dat jij geeft @Torch1969, klopt. Het bedrag, dat ik van @Gruijter kreeg klopt niet. Daar zat de fout in. Bedankt voor de hulp!

This is because @Gruijter calculated 21% btw over this amount, but because this 21% is also a separate factor, that way it is calculated twice. Nonetheless great you have the right amount now 😀.

---

<div class="post-metadata">

**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:** [November 8, 2023, 4:29pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1831 "2023-11-08T16:29:37Z")

</div>

> [@Torch1969](#):
>
> calculated 21% btw over this amount

I based this on the info supplied by Ed:  
[![](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/a/0/a002808b1faa997cc8d87222ee60f85f2bd87bd7.png) ](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/a/0/a002808b1faa997cc8d87222ee60f85f2bd87bd7.png)

In PBTH the % entered in advanced settings is not calculated over the fixed amount. So BTW should be added manually before entering the fixed markup.  
But it seems the info from Zonneplan is incorrect. Doesnt matter. Torch got the right number.

---

<div class="post-metadata">

**Author:** ![CaptainVoni](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/captainvoni/32/3549_2.png) [@CaptainVoni](https://community.homey.app/u/CaptainVoni)\
**Post date:** [November 9, 2023, 9:15am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1832 "2023-11-09T09:15:03Z")

</div>

Thanks for the info. I wonder if I can somehow influence that to get the prices as soon as possible.

Background of this is, that I control the charging/discharging behaviour of my PV battery based on the electricity prices, and in winter PV yield is quite low compared to consumption and the hour from 13:00 to 14:00 is often one of the cheapest hours. On the day I asked the question, I received the prices shortly after 14:00 and - as Murphy’s law predicted - it turned out based on tomorrows prices then, that if would be best to charge the battery with all the PV yield and cover consumption purely from the grid between 13:00 and 14:00. 😁

---

<div class="post-metadata">

**Author:** ![staeff](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/staeff/32/79712_2.png) [@staeff](https://community.homey.app/u/staeff)\
**Post date:** [November 9, 2023, 9:48am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1833 "2023-11-09T09:48:32Z")

</div>

@CaptainVoni depending on your technical knowledge you could write some HomeyScript which tries to pull the data every 5 minutes from one of the apis yourself and then act depending on that.

For example originally I queried the Awattar API for Austria, but I switched to PBTH since they show the same prices.

> **[API Datenfeed - Synchronisieren Sie Ihren Stromverbrauch mit der Natur](https://www.awattar.at/services/api/)**
>
> Der aWATTar Datenfeed stellt die aktuellen Strompreise über eine Datenschnittstelle zu Verfügung.

---

<div class="post-metadata">

**Author:** ![staeff](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/staeff/32/79712_2.png) [@staeff](https://community.homey.app/u/staeff)\
**Post date:** [November 9, 2023, 12:20pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1834 "2023-11-09T12:20:50Z")

</div>

Just a heads up for everyone who is using some of the “Price is lowest…”/“Price is highest…” When-triggers. Those currently don’t work correctly if any of your prices are bigger than 1 or negative.

I have submitted a PR to fix this, but just in case anyone is wondering why the flows are triggering at a time when the price is actually not the cheapest/highest.

[Fix sort of prices for `priceIs...` functions by stefan-schweiger · Pull Request #154 · gruijter/com.gruijter.powerhour (github.com)](https://github.com/gruijter/com.gruijter.powerhour/pull/154)

---

<div class="post-metadata">

**Author:** ![Geronimo206](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/geronimo206/32/29921_2.png) [@Geronimo206](https://community.homey.app/u/Geronimo206)\
**Post date:** [November 10, 2023, 8:47am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1835 "2023-11-10T08:47:43Z")

</div>

Hi all,

I’m using this amazing app to get an overview of my energy consumption, and it works quite nicely:

 ![Schermafbeelding 2023-11-10 om 08.56.30](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/9/9/999e41f83f668eabeb2b6ed4930a15187100ac85.png)  
(showing daily values)

As you can see in the image above, I’m also trying to visualize the total solar yield (“opbrengst”) of my recently installed solar panels, but I can’t seem to get the value right.

I’m using the [zonnepanelen](https://homey.app/nl-be/app/it.diederik.solar/Zonnepanelen/) app to integrate my solar panels with Homey trough the “Enphase Enlighten” device:

 ![Schermafbeelding 2023-11-10 om 09.20.37](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/f/9/f94fcf2b1f6e4ca3e6c0bf2093399f5efa39e840.png)

What I’m doing is using a virtual device that I update when the above “Energie-opwek vandaag” changes:

 ![Schermafbeelding 2023-11-10 om 09.05.32](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/b/2/b277740252d4fc7eebf8acd634cec37cfd2eca3a.png)

What I’ve also done is check the daily reset box, because “Energie-opwek vandaag” resets to 0 every day:

 ![Schermafbeelding 2023-11-10 om 09.21.18](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/9/6/967542e2c2ab4fe0a3cc6b35f34f715d1e334b77.png)

I’ve checked insights and I’m seeing really weird and seemingly random values for daily and total yield:

 ![Schermafbeelding 2023-11-10 om 09.29.34](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/e/5/e545568858f2ce6e6d3bd73d26661e37c82443db.jpeg)  
I would expect that the purple and the blue graph are the same here, but they’re totally different somehow.

TL;DR:  
What I’m trying to do is get my total solar yield:

 ![Schermafbeelding 2023-11-10 om 09.08.03](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/d/8/d83b25c2f117f9e85a1de8f9226307e0740d6936.jpeg)  
(“Geproduceerd” in the image above) into Homey, preferably by using the Power by the Hour app 😁.

I’m probably missing something super obvious, so sorry in advance 🫠.

Any idea what I’m doing wrong?  
Or is there a different way I can make this work?

Thanks for the help!

---

<div class="post-metadata">

**Author:** ![Rajt](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/rajt/32/80642_2.png) [@Rajt](https://community.homey.app/u/Rajt)\
**Post date:** [November 10, 2023, 11:19am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1836 "2023-11-10T11:19:56Z")

</div>

Hello and thank you for this great app.

I’m trying to use the Home Battery Monitor, but it doesnt have the same settings as Energy Summarize.

Since in charging and discharging my battery everyday I want to see how much money I save, with the help of PBTH.

- How do I change the currency?
- Is the tariff only updated once a month?

Whislist:

- Since I (here in Sweden) have hourly changed electricity-prices I want my Home Battery Monitor to update the tariff every hour.
- Also I would like to change € Kr.

Home Battery Device:

 ![Screenshot_20231110_120220_Homey](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/c/7/c76413115dce8e2393c3f6f4ed36aa8614a1b392.jpeg)

Or is there any other ways?

---

<div class="post-metadata">

**Author:** ![CaptainVoni](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/captainvoni/32/3549_2.png) [@CaptainVoni](https://community.homey.app/u/CaptainVoni)\
**Post date:** [November 10, 2023, 3:43pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1837 "2023-11-10T15:43:50Z")

</div>

I already do that to get my monthly feed-in tariff, but I want to rely as much as possible on builtin functionality. It was my main reason for Homey and e.g. against Home assistant.

---

<div class="post-metadata">

**Author:** ![staeff](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/staeff/32/79712_2.png) [@staeff](https://community.homey.app/u/staeff)\
**Post date:** [November 10, 2023, 5:17pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/1838 "2023-11-10T17:17:25Z")

</div>

PBTH is a community app so I wouldn’t exactly describe it as “builtin functionality” 😄 From what I have been able to gather from the source code the reason that this is done this way is to not run into API rate limiting (and probably also not waste your Homeys resources).

That said I don’t think it’s currently possible purely through PBTH, so your options are:

- Make a _detailed_ feature request what you expect PBTH to do differently and hope that someone will implement it
- Implement the functionality yourself in a way that it’s beneficial for everyone and create a PR
- Fork the project, implement the functionality in a hacky way and just install it for yourself (with the cli and `homey app install`)
- Create some scripts which query the API
- Live with the status quo

[Previous page](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535.md?page=89)

[Next page](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535.md?page=91)
