Hi, I am looking at how I can download the usage data from Octopus and match it with the Agile rate for that time slot. It looks like all I can do is grab the usage data from Octopus but not what I was charged during that time slot?
Has anyone seen a way to do this? - I will continue to try and solve it but someone might have already cracked what to do?
Thanks in Advance...
M_J One thing you could try is https://energy.guylipman.com/sm/admin - it can fetch your Octopus data and apply tariff information. Pretty sure it can do agile, though I've not tried that myself.
Thanks that looks like it should work. Will give it a go later this week.
You could also try one of these if you can get one...
https://octopus.energy/blog/octopus-home-mini/
I've only had mine a few days but if you have 0.5 hour smart meters it uploads the readings in real time giving you a current price estimate for your actual usage as it happens (on the Octopus app under usage). If you look at the day usage it will display KWh or £ for each 30 minute slot right up to date. As I write it is currently 3.50pm and my usage for 3-3.30pm is showing 0.43KW and 6.21p. It is displaying my live usage is currently 5.8Wh and 0.0967p. Reads update every 10 seconds.
It's not perfect as it has some gaps in the data which I think occurs when the little pink box loses its link to the smart meter (which my IHD's also do occasionally). Probably should move them closer to the meter box but they're not much use sitting in the garage where I can't see them!
I'm pretty sure there is a CSV download option somewhere but I can't find it at the moment.
Windy Miller Great idea I have registered my interest. Thanks for the reminder about it...
I just today signed up to https://forum.octopus.energy/login where I read a long thread about the upcoming Octopus Home Pro
Agile is pretty easy to do.
1) Downlioad the usage data from your Octopus account (explore my usage)
2) Download the historical Agile rates from https://agile.octopushome.net/historical-data
You now have 2 CSV files (or 3 if you got both import and export usage).
Open up the historical rates CSV file. You have the import and export rates at 30 minute intervals.
Open up the Usage CSV in a separate spreadsheet. Copy and paste the "consumption" column data into a new column on the rates spreadsheet matching up the half hour periods. Repeat for the other usage CSV if you did both import and export.