# \[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:** 121
**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:** [August 1, 2024, 2:12pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2454 "2024-08-01T14:12:39Z")
> [@Amersfoort](#): > > Could Power by the hour retroactively gather data Not retroactively. But it does gather summarized info if you keep running it. This is the summary of last year for part of my panels. ![1000003091](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/a/c/acc00beb4786dd4ae3d1c71a2fd86685c3a2a24f.jpeg) ---
**Author:** ![Amersfoort](https://avatars.discourse-cdn.com/v4/letter/a/94ad74/32.png) [@Amersfoort](https://community.homey.app/u/Amersfoort)\ **Post date:** [August 1, 2024, 2:21pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2455 "2024-08-01T14:21:44Z")
Thanks for your reaction. It will cost a year waiting for a nice graph in my external software. How to access this in Homey available year data via an api? Could you technically access this historical data in your Power by the hour app? Exporting to csv is just 30kB, so it’s not too large for an api. What would you suggest? The data is already available on the Homey, but I want to unlock it. ---
**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:** [August 1, 2024, 3:07pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2456 "2024-08-01T15:07:14Z")
> [@Amersfoort](#): > > The data is already available on the Homey, but I want to unlock it. There are several apps that can export data in real time to an external database. You can use my Archive Insights app to automatically export data to csv and/or JSON. [[APP][Pro] Archive Insights - export all your Insights data to a NAS, FTP or web folder](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976) With PBTH you will get the summarised data and Insights per hour/day/month in Homey. You can automatically (e.g. daily) export these Insights with above tool. Without PBTH you will only have the **compressed** (!) actual power or actual cumulative energy in Homey Insights available for export. I say compressed, because the older the data is, the less granular it gets. This is getting off topic though, so please keep this thread about PBTH. ---
**Author:** ![Ron\_Meijsen](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/ron_meijsen/32/29929_2.png) [@Ron\_Meijsen](https://community.homey.app/u/Ron_Meijsen)\ **Post date:** [August 8, 2024, 9:54am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2457 "2024-08-08T09:54:00Z")
Hi I have a problem. I want to show my gasprices in a graph and want to add the tax and the fixed fee per m3. I have set up the power gas app and am receiving data ![1000024540](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/4/0/404366e01c4ee256db42e4ae70fff214a29c5e98.jpeg) But the device to show the graph stays zero ![1000024539](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/a/7/a7d1e05ae32da95044100c45ae5d2d387514a93c.jpeg) And if i want to add the vat and the fixed uplift. I get an error device not ready ![1000024541](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/a/6/a68e234dbb7cbe7c11037d5cfeb86f2bd75d9472.jpeg) Deleted the devices for gas and re installed but still the same. What am i doing wrong? Ron ---
**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:** [August 11, 2024, 7:36am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2458 "2024-08-11T07:36:21Z")
@KentSoderlund Many thx for your kind donation. Much appreciated! 🥰❤ ---
**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:** [August 11, 2024, 7:50am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2459 "2024-08-11T07:50:29Z")
> [@Ron\_Meijsen](#): > > What am i doing wrong? I cannot reproduce your issue. Is it still not working? ---
**Author:** ![KentSoderlund](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/kentsoderlund/32/47804_2.png) [@KentSoderlund](https://community.homey.app/u/KentSoderlund)\ **Post date:** [August 11, 2024, 8:10am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2460 "2024-08-11T08:10:19Z")
Awesome app. I was in thinking to leave Homey for HASS before I found it. Now I will continue with Homey 😂 2 questions: I have electricity from Tibber and that works perfect and updates hourly, but could I add a fixed transfer cost per kWh to the energy price? And 2 - is it a way to export data from the app to for example .csv? /Kent ---
**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:** [August 11, 2024, 8:24am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2461 "2024-08-11T08:24:23Z")
> [@KentSoderlund](#): > > 2 - is it a way to export data from the app to for example .csv? In Homey Insights (web version) you can export any insights to .csv. If you want to automate that export, you can use another app I made: [[APP][Pro] Archive Insights - export all your Insights data to a NAS, FTP or web folder](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976) > [@KentSoderlund](#): > > could I add a fixed transfer cost per kWh to the energy price? In the DAP device settings you can add any fixed costs per kWh. But if the transfer cost is not per kWh, but e.g. per day, you can only add it as fixef cost in the summarizet device. ---
**Author:** ![Ron\_Meijsen](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/ron_meijsen/32/29929_2.png) [@Ron\_Meijsen](https://community.homey.app/u/Ron_Meijsen)\ **Post date:** [August 11, 2024, 8:30am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2462 "2024-08-11T08:30:39Z")
Hi Robin. No it is not. I deleted all devices and did it again. No luck. It just keeps saying device not ready when i want to save anything ---
**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:** [August 11, 2024, 8:43am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2463 "2024-08-11T08:43:28Z")
Can you send me an app diagnostics report? ---
**Author:** ![KentSoderlund](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/kentsoderlund/32/47804_2.png) [@KentSoderlund](https://community.homey.app/u/KentSoderlund)\ **Post date:** [August 11, 2024, 9:14am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2464 "2024-08-11T09:14:36Z")
Sorry, bad explanation I have hourly energy price from Tibber, and that runs and updates as it should. But the I have transfer fee from the company who owns the wires, and that is a fixed price per kWh So I need to add the transfer fee to the hourly energy price. Is that possible in some way? ---
**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:** [August 11, 2024, 9:25am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2465 "2024-08-11T09:25:33Z")
> [@KentSoderlund](#): > > I have hourly energy price from Tibber, and that runs and updates as it should. Do you mean you are getting the hourly prices from the Tibber app itself, and not from a DAP device in PBTH? Because in PBTH DAP you can set any fixed cost per KwH in advanced settings. ![1000003110](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/0/2/025275effbf9595d4bd96a8a8e2f2103deb2eab7.jpeg) ---
**Author:** ![Ron\_Meijsen](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/ron_meijsen/32/29929_2.png) [@Ron\_Meijsen](https://community.homey.app/u/Ron_Meijsen)\ **Post date:** [August 11, 2024, 9:25am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2466 "2024-08-11T09:25:49Z")
Hi I created a report. edb91b86-3ac4-4da1-a0a2-951e492fbc56 Thanks for your help ---
**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:** [August 11, 2024, 9:36am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2467 "2024-08-11T09:36:13Z")
Try a different gas market as source: TTF EOD . I believe that is what ANWB is using. ---
**Author:** ![KentSoderlund](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/kentsoderlund/32/47804_2.png) [@KentSoderlund](https://community.homey.app/u/KentSoderlund)\ **Post date:** [August 11, 2024, 10:03am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2468 "2024-08-11T10:03:16Z")
Strange. I don’t have that under advanced settings? ![IMG_4546](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/e/c/ece8645c0c49357501fb38c48db18b684c9cbf3b.png) ---
**Author:** ![DirkG](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/dirkg/32/118897_2.png) [@DirkG](https://community.homey.app/u/DirkG)\ **Post date:** [August 11, 2024, 10:50am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2469 "2024-08-11T10:50:54Z")
As @Gruijter already mentioned, it’s possible to add fixed costs per kWh in the _ **DAP** _ (Day-Ahead) device. Your screenshot shows the _ **Power Summarizer** _ device. Detailed information about the two different devices can be found in the 1st post of this topic. ---
**Author:** ![KentSoderlund](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/kentsoderlund/32/47804_2.png) [@KentSoderlund](https://community.homey.app/u/KentSoderlund)\ **Post date:** [August 11, 2024, 12:58pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2470 "2024-08-11T12:58:58Z")
Thinks. Didn’t understand that ---
**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:** [August 11, 2024, 1:18pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2471 "2024-08-11T13:18:34Z")
If you want to keep using the prices from your Tibber app, you could add extra costs in a flow before sending it to the PBTH summarizer. But using the PBTH prices gives you many extra features you will miss when using the prices from the Tibber app. ---
**Author:** ![Ron\_Meijsen](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/ron_meijsen/32/29929_2.png) [@Ron\_Meijsen](https://community.homey.app/u/Ron_Meijsen)\ **Post date:** [August 11, 2024, 2:42pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2472 "2024-08-11T14:42:24Z")
Hi Robin, That works thanks Ron ---
**Author:** ![Damian\_Surma](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/damian_surma/32/48817_2.png) [@Damian\_Surma](https://community.homey.app/u/Damian_Surma)\ **Post date:** [August 13, 2024, 10:45pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2473 "2024-08-13T22:45:11Z")
Hello, I don’t know if I’ve read somewhere or not found such an option, but I have a question. Can your app also take into account lighting? or a socket without energy measurement to which a device with constant consumption is connected? For example, a socket with a Sonos speaker? [Previous page](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535.md?page=120) [Next page](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535.md?page=122)