Download your smart meter data

Just a flag for those that may not know this, you can download up to the last years worth of half hourly gas and electric (import and export) data for your smart meter from n3rgy. All you need is your MPAN and Mac address from your in house display (Label on the back of mine). I put my data in a spreadsheet and do a calculation "=SUM(A6803-A6802)2460" in a new column that shows the time difference between two adjacent data points. The answer should be 30 but I have had occasional missing data which shows a larger answer than 30.

"=SUM(A6803-A6802)2460"

There should be a star before 24 and 60 !

EricIoW If you are on Octopus you can use the octoprice app to see whether Octopus has any missing data from your smart meter.

Doing this just now shows shows I’m missing 133 half hour import blocks from August (23rd, 27th, 28th, 29th). This is probably why I’ve received an export bill for last month but not the import yet

geoffreycoan
This is a bug associated with an API change at Octopus.

It can be addressed by a simple email to hello@octopus.energy. Mine read:

Hi Octopus team,

I have gaps in my API data for the period 20-29 Aug inclusive. I believe this was caused by the zero data deletion bug a few weeks ago.

Please can you re-pull the data. Thanks.

I got the response

Thanks for getting in touch and sorry for the delay in getting back to you.

I have requested the data for the 20th - 29th August 2024 from the data communication company. If they have not come through by the end of Monday, let me know.

and the data arrived pretty much immediately

PianSom Thanks, good tip. You’d hope that they would be looking for such data gaps and resolving them themselves without having the customer chase them.

Anyway, I have sent them the same message on X. I found emails went into a black hole but messaging on Twitter was quite responsive. Probably a different team handling social media than email comms

Cheers

geoffreycoan I had 90 missing slots for the same dates.
As I am billed on 8th/9th of the month, I waited for the bill to emerge before contacting Octopus.
In the bill, all the missing slots had disappeared and I had no entries in Octoprice. 😃

Rob

geoffreycoan You’d hope that they would be looking for such data gaps and resolving them themselves without having the customer chase them.

Hahahahaha! Thank you, I needed a good laugh today.

Vestas 😁

Reply back from Octopus, 1:20 after I messaged them

“Thanks for your message Geoffrey, we will repull the data for you, it should arrive within 48 hours.

All the best,
Carl”

geoffreycoan I’ve made exactly the same point some months ago to someone called Conrad, who claims to be from the Senior Leadership Team. He assures me it is being treated seriously, but nothing ever happens & I have missing data every month, which after notifying them eventually gets recovered. I do however have a block of missing data (mainly Gas) in mid August which is not showing on Octoprice. I have refused to close a complaint because of this.

As an aside I’ve noticed the Gas data Octopus report has now changed (from 2nd September) to kWh, rather than the previous measurement (units?).

idrobbo I don’t get any missing data issues normally which is why I was surprised to see it and then to see 133 missing blocks.

Looking back I am missing 1 half hour block from 3/1/24. and 6 blocks from November 2023, and that’s it in my history. Both import and export are missing from those historical blocks, unlike the August data which is missing just for import.

I had wondered why I hadn’t received an import bill for August, only the export, and was going to get around to chasing it up but it was only for £20 or so so I was probably going to wait to get a double month in September. Probably the missing data caused the no bill, but again you’d think they’d spot it and sort it out.

idrobbo As an aside I’ve noticed the Gas data Octopus report has now changed (from 2nd September) to kWh, rather than the previous measurement (units?).

cubic metres, I think.

PianSom This is a bug associated with an API change at Octopus.

It can be addressed by a simple email to [hello@octopus.energy](mailto:hello@octopus.energy)

Update on my missing data from August (principally 23rd, 27th, 28th and 29th).

I had an export bill for August but no import bill. Guessing it was the 133 blocks of data showing as missing in the Octoprice app I sent a message as PianSom suggested to Octopus on X asking for a re-pull of the data and they responded that they’d get it done.

Kept periodically checking in the octoprice app, still showing 133 missing blocks of data.

Today I got my electricity bill covering import for all of August and September and export for September.

The Octoprice app still believes that I have 133 blocks of missing data in August and sure enough when I check the specific days data in my bill, it only shows import in the non-missing blocks. Cross checking to the import data in Home Assistant from my inverter though, the daily totals for those days match the figures that Octopus have to 1 decimal place of a kWh, and in the “missing data periods” there’s no import showing on my inverter, it looks like genuinely zero import as shown on my Octopus bill.

So no consumption estimation at standard variable rate was done which is what I feared, and quite why the Octoprice app thinks there is missing data when Octopus doesn’t, I guess is down to the Octoprice app.

Anyway all good. Average import rate for the 727kWh imported in August and September was 6.16p. Predbat doing its thing well

idrobbo Scroll all the way to the bottom for this

Jellybaby are you meaning for the old consumption page, or the graph in cubic metres? If the latter then yes thanks, became aware of that.

idrobbo yeah, old page still has the m3 thing