As many will know by getting the Bright app and registering your meters, you can then download your meter data directly (via glow/DCC) from their website glowmarkt.com
They also have an API programming interface, where you can dynamically access your data - they provide a user-interface called Swagger UI where you can test particular commands etc.
I've been doing some geeky tinkering 🤓, and have written some python code on a raspberryPi which will
run in cron (scheduler) to do a daily read of my meter data and
upload this into a mySql database on the Pi.
then I can access the Pi:mySql from the laptop in excel to do any required analysis etc
Latest update - this has all worked out rather well....😁
In addition to creating the main 'electricity' table which automatically updates every day via the GlowAPI and contains the raw 1/2 hourly readings (h01 thru h48: shown above ⤴️), and the tariff-rate table
I have created a view on the 'electricity' data table combining the ½ hourly values to show just hourly hr01 thru hr24 values (which makes it easier to compare to values in say the EOn app which are hourly totals)
Then created a view joining the "electricity" & "tariff" tables which calculates all the individual daily costs, and the total cost per day including VAT
So to validate the EOn bill: in excel I can simply select the relevant month's 28, 30 or 31 rows from this view and sum the daily totals costs to compare to the bill 😁
I don’t have to go down this route as I don’t have the drive tariff, but I suspect most who do will not want to go to these lengths.
what, apart from the obvious delight in your achievements does this actually do to benefit you?
Current Eon Next customer, ex EDF, Zog and Symbio. Don't think dual fuel saves money and think the smart meter programme is a waste of our money. Chronologically Gifted. If I offend let me know by private message, but I’ll continue to express my opinions nonetheless.
@geoffers ...
what, apart from the obvious delight in your achievements does this actually do to benefit you?
Loads of reasons for doing this, including...
"because it was there" - I was aware of the Glow API but had no understanding what could be achieved with it and interested in finding out. A lot of tecchies extend their usage incorporating them into home-automation/IoT using MQQT, but don't think I'll be going down that route (yet 🙂)
automatic recording of meter reads - a lot of "old-schoolers" on here apparently maintain excel spreadsheets by manually reading their meters and entering the values into excel, but this is now achieved without any manual intervention
validation of bills - used to do this by downloading monthly CSV of energy usage then running excel macros to do the cost calculation, but up to date data is now already available with daily cost values pre-calculated
intellectual challenge; learning new skills as a lot of the development was in areas I was unfamiliar with
already had a raspberryPi running 24/7 monitoring a weather station, so interested to create another application to add to this
ultimately considering investing in solar with a planned new-build garage, so hopefully can extend to monitoring solar capture/export as well
@geoffers...what, apart from the obvious delight in your achievements does this actually do to benefit you?
Here's how quickly I can calculate/reproduce my bills now 😎🤣 - now using direct ODBC connection in VBA for excel to run SQL statement (rather than via the mySQL for Excel add-in which was a bit clunky)
you are doing others a great favour by verifying you bills on a complicated tariff that most don’t have. Normal bills are, by comparison, relatively easy to check, but those on your tariff would be beyond the vast majority.
I’m sure you’ll be onto Eon Next if you discover an error!
you are doing others a great favour by verifying you bills on a complicated tariff that most don’t have. Normal bills are, by comparison, relatively easy to check, but those on your tariff would be beyond the vast majority.
I’m sure you’ll be onto Eon Next if you discover an error!
As with every diverse community, there is always a mixture of opinions, knowledge as well as understanding - that’s what makes it such a great place to be! To make sure everyone gets the most out of our Community and feels good doing it, we’ve created some values below on how to be an awesome, positive member. So, take a read and then go for it!
We love having you all here in the Community and really hope you find some great advice and help from our other amazing members. As a community team, our main role here is keeping things ticking over, everyone safe and getting involved in some great conversations! We know many of you will have specific queries about your accounts and we want to keep your personal details safe so please don't post them here.
• Saying thanks goes a long way
• The community is a public website, so be careful
• Be kind, respectful and supportive
• It's a family-friendly community
• If you’re in a specific section or discussion, try to stay on topic
• One post is normally enough
• Be cool, don’t spam
We want to ensure that the community is safe and fair for everyone…
We all work hard to ensure everyone feels respected and supported while using the community, and keep that positive energy flowing. If a member or group is disrupting your experience without a genuine reason, you can report this to the community team quickly and easily by clicking the 3 dots on the post. Don’t worry about a thing, we’ll take it from there. If you get a message from the team about your behaviour, please try to work with us, as all we want to do is make this a positive place for everyone. In order to this, we have to uphold these Community Values and the Community Team has the final say.
The full Community Values can be viewed here
If you agree, please click the 'I agree' checkbox and press the 'Complete Registration' button below. If you would like to cancel the registration, click here to return to the Community homepage.
Although the administrators and moderators of E.ON Next Community will attempt to keep all objectionable messages off this site, it is impossible for us to review all messages. All messages express the views of the author, and neither the owners of E.ON Next Community, nor vBulletin Solutions Inc. (developers of vBulletin) will be held responsible for the content of any message.
By agreeing to these rules, you warrant that you will not post any messages that are obscene, vulgar,sexually-oriented, hateful, threatening, or otherwise violative of any laws.
The owners of E.ON Next Community reserve the right to remove, edit, move or close any content item for any reason.
