Skip to main content

I will shortly be having my Smets1 meter upgraded to Smets2.  What happens to the historical usage stats associated with my MyOVO account.  Will they still be available? In the future, I may be considering installing battery storage so that I can charge the batteries overnight (cheap rate) and then use the stored energy during the day (avoiding peak rate). To cost justify this project, it would be dependent on the historical stats I have over the past 18 months.  I don’t think that a download of the usage stats is available yet.  Will I need to manually record them myself before the upgrade to avoid them disappearing?

Howdy!

You’ll probably still have access to it under the Usage tab. But the Meter Readings tab would be reset to zero.


Thanks for the prompt reply - “Probably” suggests that I’m going to have to manually copy them across to a spreadsheet, as without them it would not be possible to assess whether a “storage battery project” would be cost-effective.


I will shortly be having my Smets1 meter upgraded to Smets2.  What happens to the historical usage stats associated with my MyOVO account.  Will they still be available? In the future, I may be considering installing battery storage so that I can charge the batteries overnight (cheap rate) and then use the stored energy during the day (avoiding peak rate). To cost justify this project, it would be dependent on the historical stats I have over the past 18 months.  I don’t think that a download of the usage stats is available yet.  Will I need to manually record them myself before the upgrade to avoid them disappearing?

Are you having your physical meter swapped or is this a software upgrade? 


Physical meter swap


In that case, the Meter Readings will definitely be reset to zero.

If memory serves, I still had historical usage after a physical swap two years ago


I’m going to have to manually copy them across to a spreadsheet, ...

That’s a tedious exercise if you’re using the account’s Meter readings page. You can get the (almost) raw data from the pages behind the UI. This one gives you the readings for the past 400 days* in JSON format: https://smartpaymapi.ovoenergy.com/orex/api/meter-readings/{account} where {account} is your OVO account no. You get permission by signing in at account.ovo.com to cache the access token, then open the URL in a new tab. Copy the entire page, then paste it into - for example - https://data.page/json/csv to get it neatly sorted into CSV for your spreadsheet.

Any good?

 

* That’s the limit of what the meter stores. I’m not sure if older data are available at the website.


Nice workaround, @Firedog!


I’m going to have to manually copy them across to a spreadsheet, ...

That’s a tedious exercise if you’re using the account’s Meter readings page. You can get the (almost) raw data from the pages behind the UI. This one gives you the readings for the past 400 days* in JSON format: https://smartpaymapi.ovoenergy.com/orex/api/meter-readings/{account} where {account} is your OVO account no. You get permission by signing in at account.ovo.com to cache the access token, then open the URL in a new tab. Copy the entire page, then paste it into - for example - https://data.page/json/csv to get it neatly sorted into CSV for your spreadsheet.

Any good?

 

* That’s the limit of what the meter stores. I’m not sure if older data are available at the website.

@Firedog

I wonder if the 30min data on the usage page may be useful to assess battery storage solutions? 

I can't remember if you posted about looking at something similar for the usage page before to extract the data to a csv file?

Interesting the data on the usage page goes back further than that on the readings page where the older historical data looks like it is stripped out.

OVO are working on a csv download function, hopefully in 2023

 


I wonder if the 30min data on the usage page may be useful to assess battery storage solutions? 

  
@Jeffus @AlanW The 30-minute data are returned one day at a time, so it would take some automation to retrieve them for a period of days. They’re there, though, from time immemorial:
smartpaymapi.ovoenergy.com/usage/api/half-hourly/{account}?date=2017-03-10

{account} being the account number, as usual. That was the day after my smart meter was installed! 

It looks as if usage data are stored indefinitely, but readings only for the 400 days of mandatory meter storage; I’d be happy to be proved wrong. Of course, if you had the time and inclination, readings could be reconstructed from the usage figures. There’s a caveat to that: the GMT/BST switch twice a year might introduce inaccuracies*, depending (I think) on the type of meter. You’d have to look at a few sample days to establish whether the usage recorded for, say, 00:00-01:00 belonged to today or yesterday according to the readings, and correspondingly for 23:00-00:00. Once the pattern is established, the appropriate adjustments could be made to the collated data. 

 

These could be significant in situations where, for example, a power-hungry appliance is set to switch on at midnight on some days only.
It’s interesting that the DCC data (as retrieved by Bright, for example) don’t always tally with OVO’s, although the variations are rarely more than 0.2kWh/h and balance out over a few hours. 


Reply