I've written a script that looks at the half-hour energy grid import from givenergy API (same data you see on the energy charts). I'm merging it with Octopus Agile today cost to give me a sense of how much money I've spent today so far.
Works great, the problem is the kWh usage for the half hour slots constantly changes! Example today at approx 8.30am:
2024-01-05 05:00:00 Usage: 0.090kWh
2024-01-05 05:30:00 Usage: 1.510kWh
2024-01-05 06:00:00 Usage: 0.110kWh
and now at 10am:
2024-01-05 05:00:00 Usage: 0.090kWh
2024-01-05 05:30:00 Usage: 1.500kWh
2024-01-05 06:00:00 Usage: 0.110kWh
I know its small discrepancy here, but then multiple slots change randomly over time. Not life or death as I get billed what I get billed, it just doesn't really help put any faith in the data if it changes after the fact.
I could understand if it was the most recent slot, as it takes some time to "process" and appear... it seems really odd to commit to a meter reading value of x, then many hours later change it to y





