Due to a smart meter failure no consumption or export data has been sent from our system to Octopus for a few months. It's been working through March after a meter restart. I want to try and fill in some of the gaps on half hourly consumption from the Givenergy data, but only seem to be download daily info from the portal.
Is there a way of bulk downloading data for a few months?
Take a look at this which I used to get Octpus to correctly bill my off peak import and my export.
In the end they never acknowledged it was their issue and resolved things by a "goodwill gesture"
https://community.givenergy.cloud/d/2881-report-data-download-as-excel-file
my smart meter finally got correctly working after 4 years by going to Ombudsman and Octo installing a combined GSM/RF comms hub with antenna (I am in RF area in Pennines but Arqiva signal is poor)
SteveCook
Thanks, that was very useful.
I extracted all my historical data from Octopus as well as from Givenergy, and wrote an Excel spreadsheet which has sheets for the raw data from Octopus Import & Export, Givenergy and Flux pricing from https://dashboards.energy-stats.uk/ . The latter source didn't seem to be accurate and has issues with data refresh, but I've corrected it as far as I can.
Anyway, I've been able to reproduce the pricing for the bills I got last year. Even thought the GivEnergy data is only to one decimal, I've calculated those bills to within a pound using the GivEnergy data which gives some confidence in the spreadsheet and GivEnergy data.
So I now have some information to present to Octopus.
Hugh I found that the givenergy inverter import and export registers were very close to my smart meter readings, so form a good basis.
Octopus will probably say they don’t accept non-meter readings, but challenge them to work out the bill in another way that doesn’t disadvantage you. Always worth going to the ombudsman if you don’t get anywhere
This has finally been resolved.
Octopus have managed to retrieve all my missing consumption data starting in Sep 2023 to late Feb 2024. The information was there somewhere, possibly in the meter itself which was still flashing away while no data was coming through to Octopus. The calculations from the GivEnergy data was within 2% of the real bill.
In the meantime they issued various bills, using Flexible Octopus rates. Actual bills are around £200 less so I've got a hefty credit on the account, helped along by lots of export recently.
Next decision is whether to go for the Agile tariff. My average cost per kWh imported is under 19p in winter, and 15p in summer - and will be dropping again in July. I'm using Wonder Watt to export from 17:00 and normally discharge 3.5kWh from the battery, earning about 30p every day if just charging the battery overnight in the cheap period.
I get export from solar as well - about 20kWh yesterday, best ever day with nearly 35kWh generated.
Would I do better on Agile?
Hugh Next decision is whether to go for the Agile tariff. My average cost per kWh imported is under 19p in winter, and 15p in summer - and will be dropping again in July. I'm using Wonder Watt to export from 17:00 and normally discharge 3.5kWh from the battery, earning about 30p every day if just charging the battery overnight in the cheap period.
I get export from solar as well - about 20kWh yesterday, best ever day with nearly 35kWh generated.
Would I do better on Agile?
Well done for finally getting your meter readings through to Octopus. Sometimes it seems to take a lot of perseverance
Agile is a good tariff especially if you can automate the battery activity with Wonder Watt or similar. I was on Agile last winter (with a heat pump) and my monthly average unit rates varied between 19.87p (November) to 11.17p (April). It’s been a bit rubbish so far this summer with import rates around 15p overnight, but plenty of solar means I’m importing very little anyway.
If you have an EV then the EV tariffs are usually better. All depends on your consumption and battery size.
The Octopus Compare app is really good. This is my data so far this year.
