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
November 24, 2023

It will be useful to have the ovo csv file to compare to the n3rgy data via the guylipman link provided 

Especially for the numerous ovo customers who currently haven't got great 30min consumption data from ovo.

 

waltyboy
Rank 8
Rank 8
November 24, 2023

I like the ease of this guylipman.com presentation, @Firedog, I should have said that it’s quite a few years now since I finished work and stopped using my (now ancient) laptop. My current device has no Excel…but I might just dust off the old laptop one of these days!

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”).
waltyboy
Rank 8
Rank 8
November 24, 2023

Actually, have just spotted iSpreadsheet, which apparently is free…

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

It will be useful to have the ovo csv file to compare to the n3rgy data via the guylipman link provided 

 

Whenever I’ve compared the 3DP OVO data (retrieved via the API) with the ones I get from n3rgy, they’ve been identical. They come from the same place, after all, so there’s no reason why they should be different. I’ve tacked on OVO’s figures to the last column of the table above:
  

  

… the numerous ovo customers who currently haven't got great 30min consumption data from ovo.

 

🙋🏼

 

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. |
Jeffus
Rank 20
Rank 20
November 24, 2023

It will be useful to have the ovo csv file to compare to the n3rgy data via the guylipman link provided 

 

Whenever I’ve compared the 3DP OVO data (retrieved via the API) with the ones I get from n3rgy, they’ve been identical. They come from the same place, after all, so there’s no reason why they should be different. I’ve tacked on OVO’s figures to the last column of the table above:
  

  

… the numerous ovo customers who currently haven't got great 30min consumption data from ovo.

 

🙋🏼

 

Yep. I know you are OK @Firedog 

Firedog
Super User
Super User
November 25, 2023

…I’m trying out the Bright site

 

 

Always look on the Bright site … 😊

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. |
Firedog
Super User
Super User
November 25, 2023

My current device has no Excel…

 

You should be able to use Excel in the browser. Have a go: OVO-PM-Nov.xlsx

If you manage to open this workbook, you’ll find it populated with my data. Just paste your own on top of mine to see what happens. 

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. |
waltyboy
Rank 8
Rank 8
November 25, 2023

That’s very kind of you @Firedog, many thanks, I’ll give that a whirl…and actually earlier today I’ve been looking at the Apple version of MS Office (iWorks), which is freely available when you’ve bought an iPad or iPhone.  Their iWorks spreadsheet equivalent of Excel, called Numbers (comprehensively enough!!) seems interesting and I’ll be having a go playing with that over the next week or so.

 

But in the meantime I’ll very gladly avail myself of your kind offer, thank you, and I’ll let you know how it goes! Give me a day or so to get my spreadsheet brain in gear, it’s been a long while!!

 

All the very best, cheers….

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”).
Tim_OVO
OVO Staff
OVO Forum Legend
November 29, 2023
Open for votesCan't be done yet
Carbon neutral - we need a community to get there! My green tech: Aclara SGM 1411-B smart meter, Chameleon IHD6
Tim_OVO
OVO Staff
OVO Forum Legend
November 29, 2023

I have changed this idea to indicate that we can’t consider it for our roadmap any time soon. 

 

The reason is that the billing platform that OVO gets your half hourly usage data from only provides access (API endpoints to be precise) to this data in daily intervals. So for a monthly view that would be 31 requests for data per customer. Not a very scalable solution until that changes. 

 

Thanks for everyone’s votes and for the idea. One to watch...

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