# \[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:** 138
**Author:** ![El\_M](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/el_m/32/121876_2.png) [@El\_M](https://community.homey.app/u/El_M)\ **Post date:** [December 25, 2024, 10:54am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2799 "2024-12-25T10:54:37Z")
Hi - I love the app and have been using it from my start of Homey (switched from years of HA usage). Recently I setup an automated EnergyLogger flow to a google sheet. I automatically log energy usage every hour. When adding up all hours of the day, I get a different result than a full day total. The full day total lines up with my P1 HomeWizard reading. From this I deduce that there is something wrong (or I am doing something wrong) with the hour results. Can you share your insights? E.g. for gas: m3 deze dag: 8.56 sum of m3 dit uur: 7.431 P1 reading: 8.560 Similar results for power (stroom) and water Thanks! ---
**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:** [December 25, 2024, 11:09am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2800 "2024-12-25T11:09:03Z")
> [@El\_M](#): > > sum of m3 dit uur This hour is still counting. Try adding all ‘last hours’. Because that has finished counting. ---
**Author:** ![El\_M](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/el_m/32/121876_2.png) [@El\_M](https://community.homey.app/u/El_M)\ **Post date:** [December 25, 2024, 11:35am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2801 "2024-12-25T11:35:12Z")
Hmm… true, I will change that later today. However it wouldn’t explain that the individual sum would be higher. If the hour is still running then I would expect the total to be (slightly) lower ---
**Author:** ![Erikvl87](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/erikvl87/32/112784_2.png) [@Erikvl87](https://community.homey.app/u/Erikvl87)\ **Post date:** [December 25, 2024, 4:50pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2802 "2024-12-25T16:50:49Z")
For whoever is interested, I’ve created a short tutorial on how to display the current energy price using the Power by the Hour app and DataVista. If you’re curious about visualizing hourly energy prices with a gauge, check it out here: > **[Tutorial: Visualizing hourly energy prices with a Gauge | DataVista](https://datavista.erikvl87.nl/widgets/gauge/tutorial-visualizing-hourly-energy-prices-with-a-gauge)** ---
**Author:** ![Peter\_Kawa](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/peter_kawa/32/173848_2.png) [@Peter\_Kawa](https://community.homey.app/u/Peter_Kawa)\ **Post date:** [December 26, 2024, 1:52am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2803 "2024-12-26T01:52:09Z")
Very nice, Erik, thanks! One thingy about > 1. Do not overwrite the label, unless you prefer to display a fixed value instead of the actual price. In case I want to use the Better Logic currency formatter (good hint!), it’s output tag can’t be used as [value], because it returns a _string_ tag. So I use it as [label], and the original numeric price tag as [value]. It updates every hour @ price change w/o problem: ![1000040058](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/1/d/1d9bd644a4ae218ddc95cba4fd5c60b18effba56.jpeg) ---
**Author:** ![Peter\_Bittner](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/peter_bittner/32/16698_2.png) [@Peter\_Bittner](https://community.homey.app/u/Peter_Bittner)\ **Post date:** [December 26, 2024, 2:23am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2804 "2024-12-26T02:23:02Z")
New to PBTH and have a few questions. I am in Australia and my energy provider sells at wholesale prices. They also have a Buy Price and a Sell Price, both of which can be -ve or +ve. Trying to understand Update Group. From what I read you just enter 1,2,3 etc and track manually what you want to use each group for, although I’m sure I could parameterise them. So is it valid that to track the buy and sell prices I can enter 1 for the Sell price update group and 2 for the buy price? Also is there any issue with these values being -ve? ---
**Author:** ![Erikvl87](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/erikvl87/32/112784_2.png) [@Erikvl87](https://community.homey.app/u/Erikvl87)\ **Post date:** [December 26, 2024, 12:59pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2805 "2024-12-26T12:59:02Z")
Thanks for pointing that out @Peter_Kawa! I’ll update the tutorial and maybe update the DataVista app. To not clutter this thread, lets use the [DataVista topic](https://community.homey.app/t/app-pro-datavista/121482) for further discussion. ---
**Author:** ![HuisCHovens](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/huischovens/32/16973_2.png) [@HuisCHovens](https://community.homey.app/u/HuisCHovens)\ **Post date:** [December 26, 2024, 4:33pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2806 "2024-12-26T16:33:35Z")
Is the gas price from anwb where offline? Al 2 days the same price? ---
**Author:** ![Dijker](https://avatars.discourse-cdn.com/v4/letter/d/b9bd4f/32.png) [@Dijker](https://community.homey.app/u/Dijker)\ **Post date:** [December 26, 2024, 4:42pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2807 "2024-12-26T16:42:53Z")
> [@HuisCHovens](#): > > Al 2 days the same price? That’s what ANWB also says ![Screenshot_20241226_174055_ANWB Energie](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/4/9/495bf6521774a68e8846ebe8dbd7fa52f01afbe8.jpeg) So i see no problems ---
**Author:** ![Theo\_de\_Koning](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/theo_de_koning/32/136062_2.png) [@Theo\_de\_Koning](https://community.homey.app/u/Theo_de_Koning)\ **Post date:** [December 26, 2024, 6:09pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2808 "2024-12-26T18:09:55Z")
That is not the ANWB **gas** price. Also the gas price of Frank Energie is wrong with €0,79 for today.\*\* Zonneplan is asking €1,33\*\* **Edit** That are the graphics here ---
**Author:** ![Dijker](https://avatars.discourse-cdn.com/v4/letter/d/b9bd4f/32.png) [@Dijker](https://community.homey.app/u/Dijker)\ **Post date:** [December 26, 2024, 6:50pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2809 "2024-12-26T18:50:14Z")
> [@Theo\_de\_Koning](#): > > That is not the ANWB **gas** price. It is. ![Screenshot_20241226_194821_ANWB Energie](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/2/d/2d5be335761690ea0257257d0fdd13057352853d.jpeg) ---
**Author:** ![Theo\_de\_Koning](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/theo_de_koning/32/136062_2.png) [@Theo\_de\_Koning](https://community.homey.app/u/Theo_de_Koning)\ **Post date:** [December 26, 2024, 7:15pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2810 "2024-12-26T19:15:30Z")
Oops. This is with more info. Partly due to the low prices looked more E prices. ---
**Author:** ![melectro](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/melectro/32/78999_2.png) [@melectro](https://community.homey.app/u/melectro)\ **Post date:** [December 31, 2024, 5:01am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2811 "2024-12-31T05:01:34Z")
Hi, very nice APP, I already found many nice cards to use, but is there a possibility to get the price in Swedish öre instead of SEK? (100 öre = 1 SEK). The prices are often low, so low that the resolution in SEK is not showing the actual price. ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/7/0/70442e359a911b30ac65d17995053ed769a1bf91.png) ---
**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:** [December 31, 2024, 8:50am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2812 "2024-12-31T08:50:17Z")
In settings you can change the number of decimals. ---
**Author:** ![melectro](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/melectro/32/78999_2.png) [@melectro](https://community.homey.app/u/melectro)\ **Post date:** [December 31, 2024, 12:13pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2813 "2024-12-31T12:13:11Z")
That will not help me much, only more zeroes. I wish to have it in öre ---
**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:** [December 31, 2024, 12:29pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2814 "2024-12-31T12:29:21Z")
Just adjust markups (% and fixed) to result in 100-fold numbers. And change the SEK to ORE. ---
**Author:** ![johan\_W](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/johan_w/32/17556_2.png) [@johan\_W](https://community.homey.app/u/johan_W)\ **Post date:** [December 31, 2024, 1:01pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2815 "2024-12-31T13:01:25Z")
Is it all so posible to make one tag more to use Price -1hour so you can use it on export data to a sheet (google) on every hour (at electricty) and in the first hour off the day to export your gas price . And yes we have all ready Use last hour and price last hour. Ok i can calculate back in the sheet, but if avaible i can export direct. Now I have a flow with a variable for the price (Electricty/gas) last hour/day every 5 min after the hour (for Electricty) Copy the info to a new row in the sheet #date;#Time;#Price-E-1U (the variable);#money lasthour Then I copy the #price now to the variable #price-E-1U It do’s the same but it some extra task/work 🙂 there all all ready a lot off tags for ever + houre in Electicity and gas so maybe one more for the latest hour -1 could be one more. ---
**Author:** ![Theo\_de\_Koning](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/theo_de_koning/32/136062_2.png) [@Theo\_de\_Koning](https://community.homey.app/u/Theo_de_Koning)\ **Post date:** [January 1, 2025, 12:22am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2816 "2025-01-01T00:22:53Z")
Beste wishes for 2025. There information. For Zonneplan E, I have found out that 0,14285 is the Fixed markup. ---
**Author:** ![Michiel](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/michiel/32/16416_2.png) [@Michiel](https://community.homey.app/u/Michiel)\ **Post date:** [January 1, 2025, 11:41am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2817 "2025-01-01T11:41:34Z")
Best wishes to you all! When doing the yearly changes in the app I found out that the TTF\_LEBA\_EasyEnergy has not been updated for weeks. Is something wrong? 🤔 ---
**Author:** ![Theo\_de\_Koning](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/theo_de_koning/32/136062_2.png) [@Theo\_de\_Koning](https://community.homey.app/u/Theo_de_Koning)\ **Post date:** [January 1, 2025, 11:52am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2818 "2025-01-01T11:52:18Z")
Because I was switching to Zonneplan I noticed it 11 days ago. (Post 2719) Now I have take TTF\_EGSI. [Previous page](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535.md?page=137) [Next page](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535.md?page=139)