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?
Answer
Historical usage data after physical Smets2 upgrade
Best answer by 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.
+1- Plan Zero Hero
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.
+2- Plan Zero Hero
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?
+1- Plan Zero Hero
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
- Plan Zero Hero
- Answer
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.
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. |
Nice workaround,
+2- Plan Zero Hero
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.
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
- Plan Zero Hero
I wonder if the 30min data on the usage page may be useful to assess battery storage solutions?
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.
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. |
Log in to the OVO Forum
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.