Skip to main content
October 8, 2023
Can't be done yet

Download a month's worth of half-hourly usage data via the existing CSV download link on the online account

  • October 8, 2023
  • 32 replies
  • 735 views

The current data download facility seems to only allow me to download the current view of the data. To get half hourly figures for a month (for Power Move monitoring) I would have to download a separate file for each day. Please can we have one click to get half hourly data for the month to date (or a previous month) and please can we have it on the Web as well as in the app. 

 

Thanks. 

32 replies

Jeffus
Rank 20
Rank 20
October 8, 2023

A must have feature. 

 

Firedog
Super User
Super User
October 8, 2023

That would be nice.

The sources I’ve tried can do this, but a month’s worth of readings is probably a set of columns each with a long list of 1500 numbers. However these numbers are delivered, it’s likely that some massaging will be necessary before they can be plugged into a spreadsheet. 

To monitor daily usage, e.g. when taking part in a Power Move challenge, it might be best to do a catch up of the missed days, then aim to add a day’s worth of numbers at a time.

Noel | I have no official status; I'm just a volunteer who comes here to help other customers. My gear: Aclara SGM 1416-B Electricity-only E7 meter; Chameleon IHD3-PPMID-AAA | It may look as if I know what I’m talking about, but don’t let that fool you. |
Super User
October 9, 2023

There are a couple of other ways to get your data.

You can register with https://data.n3rgy.com/consumer-login. You can download 90 days worth of data (gas and/or electricity) and import into a spreadsheet or database. You will need your meter's MPAN (Meter Point Administration Number) or your MPRN (Meter Point Reference Number) plus your IDH MAC address. The data is of the form

timestamp (UTC)    energyConsumption (m3)
08/07/2023 00:30    0
08/07/2023 01:00    0
08/07/2023 01:30    0

Sadly I have never managed to download my electricity data from this website but others have managed. Also the gas data is in m3 so you will need to know the Calorific Value of the gas for your region (which can be obtained from https://data.nationalgas.com/ ) It takes at least a day for the Cv of the gas to be available (they need to collate information from many gas chromatographs around each local distribution zone). The data may be revised several days later.

Alternatively you can register on https://glowmarkt.com/ where you can download your data. Mine went back to the start of the year. 
The data is of the form

epochTimestamp    kWh    dateTime
1672529400    0.093    2022-12-31T23:30:00.000Z
1672531200    0.113    2023-01-01T00:00:00.000Z
1672533000    0.113    2023-01-01T00:30:00.000Z

The epochTimestamp is actually seconds from 1-Jan-1970 (sometimes known as Unixtime?).

Both are free services.

It would be nice to have the same information direct from OVO both for convenience and privacy.

Annually: Petrol 1315l to 442l, Electricity 3779 kWh to 2465 kWh, Gas 17,853 kWh to 9128 kWh. 20 years of monitoring and tweaking.
Tim_OVO
OVO Staff
OVO Forum Legend
October 9, 2023
NewOpen for votes
Carbon neutral - we need a community to get there! My green tech: Aclara SGM 1411-B smart meter, Chameleon IHD6
Jeffus
Rank 20
Rank 20
November 22, 2023

It would also be useful if the download could have the 30min consumption data to 3 decimal places. 

This will then be consistent with all the 3rd party data sources and the OVO meter reading page.

At the moment it is definitely not easy for people to replicate the ovo figures

 

Jeffus
Rank 20
Rank 20
November 22, 2023

Do you know if thus is being worked on @Tim_OVO

Am sure it would be preferable to customers going to other sites.

Tim_OVO
OVO Staff
OVO Forum Legend
November 24, 2023

Just picking this up and finding the right person to flag it to. In short we’re looking for:

 

  1. CSV downloads of half hourly usage for the whole month not just the individual day
  2. For that half hourly data to be to 3 decimal points rather than 2

 

Correct me if I’m wrong, otherwise I’ll get this raised and pass on any feedback or update I can. 

Carbon neutral - we need a community to get there! My green tech: Aclara SGM 1411-B smart meter, Chameleon IHD6
Jeffus
Rank 20
Rank 20
November 24, 2023

Just picking this up and finding the right person to flag it to. In short we’re looking for:

 

  1. CSV downloads of half hourly usage for the whole month not just the individual day
  2. For that half hourly data to be to 3 decimal points rather than 2

 

Correct me if I’m wrong, otherwise I’ll get this raised and pass on any feedback or update I can. 

Perfect @Tim_OVO 

waltyboy
Rank 8
Rank 8
November 24, 2023

That sounds brilliant @Tim_OVO …I’m trying out the Bright site (via their glowmrkt.com) and the gas data are brilliant, nice histograms; their nice (and very helpful) tech people assure me there’s every chance the electricity data will follow, but it’s only been a few days. I did download the .csv file but it is indeed massive and would definitely need “massaging”.

 

I’m with the other cats on here who’ve expressed a preference: it would indeed be wonderful if something were visible to OVO consumers in-house. Even over a shorter time period (monthly would be brilliant). Even the “simplest” (I know! I know!) histogram would be luxury.

Walt. 2013: 3.2kW PV East/West + Fronius IG, >26MWh (of which, to date mid-2025, 20MWh exported). 2023: 2.4kWh LiFePo4 battery. 2024: Tadö wireless smart stat v3; Electriq split unit 2.6kW AAHP (“air conditioner”).
Firedog
Super User
Super User
November 24, 2023

I did download the .csv file but it is indeed massive and would definitely need “massaging”.

 

I’ll say it again: try Smart Meter Reports (guylipman.com). Once you’ve got the hang of it, there’s no fuss at all. When the latest data are loaded, this is the screen I get:
  

 

The 3kB CSV file looks like this when I open it in Excel (probably the default if Excel is installed):

  

 

The right-hand column is all ready to be copied and pasted into my PM worksheet. The whole process takes just a minute or so each morning.

 

Noel | I have no official status; I'm just a volunteer who comes here to help other customers. My gear: Aclara SGM 1416-B Electricity-only E7 meter; Chameleon IHD3-PPMID-AAA | It may look as if I know what I’m talking about, but don’t let that fool you. |