Useful Reports ?

Hi

With all the APIs and things available for us GivEnergy and Octopus users, does anyone know of a source of useful reports ?

I am looking for a simple report that takes my Home kWh usage (from GivEnergy source) and my Grid kWh import (from Octopus source) along with the tariff rate (on Flux) and shows a cost comparison as to the cost I have spent against the cost I would have spent if I drew all my home usage from the Grid. Hope this makes sense?

I know I can manually do this every month, but I am hoping there is a simple automatic way to get this data

Thanks

Phil89a there are some reports from the GE portal that, if you have entered your tariff info, will give you what you need - you can schedule them daily, weekly, monthly or annually. You get an email that takes you to the report.

Cdent Thanks I will have a look at these in more detail.

I like to get the raw data via the API and manipulate myself in spreadsheets.

https://github.com/roberttidey/GivEnergyScripts

contains some powershell scripts to extract data from the API.

In particular, GE-DaysIntervalDataPoints.ps1 can extract data over a range of days to match the Flux periods. FluxData.ods is a spreadsheet that you can paste this data into and it then does some calculations on it using Flux import and export pricing rates. The Cost column shows the net cost of electricity (negative being profit from Octopus). The fixed daily charge is not used in the calculations as that is a fixed unavoidable cost.

Rtidey Thanks but I am a Mac user so these won't work me me 🙁

I have added a python version of the GE-DaysIntervalDataPoints script which means it may run on other platforms although I have only tested on Windows.

I may produce python versions of the others although the Intervals one is the most useful.

I have now added python equivalents for all the scripts.