Do you have a way of calculating daily agile export paymets?

#1 GribinIsaf 2022-09-26

Has anyone made or procured a spreadsheet that works out daily payments for Octopus Agile Export?

I have a google spreadsheet, which I obtained via the Octopus site, that pulls my half-hourly import stats and I can see all the api stuff here put I don’t (yet) have the skills to modify or create what I want.

I would like a sheet that pulls my export data and the agile export half-hourly rates and combines them into a daily payment…

#2 THALL 2022-09-26

Check out the phone app Octopus Go Agile which will do what you want.

#3 GribinIsaf 2022-09-26

THALL Check out the phone app Octopus Go Agile which will do what you want.

Thanks. We are only on our first day of Agile, having moved from Fixed, so I don't yet know what stats Octopus supply. I have the app and on Fixed could see each days export by 30 min intervals. When on Agile I will have to see if that converts it into actual payments...

#4 GribinIsaf 2022-09-26

THALL Check out the phone app Octopus Go Agile which will do what you want.

Ah...sorry... you are talking about an independent app!

Got it.

Thanks!!

#5 hamilton 2022-09-27

Octopus watch has the ability to show you the data you need including export and import. The latest version also has gas tracked.
The free version is ok but the paid one (under £10 per year) allows you to go indepth with the data analysis.

#6 THALL 2022-09-27

GribinIsaf Yes sorry. You can see how much you have made from the previous days generation and see todays rates. You can see historic data too. The chap that makes it keeps it up to date with the tarif changes too.

#7 GribinIsaf 2022-09-27

THALL You can see how much you have made from the previous days generation and see todays rates. You can see historic data too. The chap that makes it keeps it up to date with the tarif changes too

So far I can see this app works for Agile import and export. I am on a Fixed import tariff but an Agile export one, I guess with different rates. So far, can't see how to configure this app for that tariff.

#8 GribinIsaf 2022-09-27

hamilton Octopus watch has the ability to show you the data you need

I had this installed all the time! Thanks.
Looking to see what it can tell me....

#9 GribinIsaf 2022-09-27

hamilton the paid one (under £10 per year) allows you to go indepth with the data analysis.

Have paid. Lots of lovely stuff...

But what I still want is a way of dumping daily stats (including combining half-hourly export amount with export rate) on to a spreadsheet automatically!

#10 GribinIsaf 2022-09-27

Ah, Octopus Watch - export to CSV - save to drive - bingo.

I will stop talking to myself now