Spot Pricing with Octopus

189 views
Skip to first unread message

sk

unread,
Aug 31, 2024, 4:27:41 AM8/31/24
to Loxone English
It looks like due to data restrictions Loxone no longer provide a template for accessing the Octopus Agile rates. I noticed that their recent update now includes 30minute windows for prices. 

Programmatically, the block only offers 1 hour pricing.   So still all quite frustrating. 

In the meantime I have ended up creating my own nodejs app that connects to the Octopus Agile APIs, Glow Metering for live consumption and the miniserver via Loxone's Github communicator library to inject the 24 hour pricing, workout lowest price periods and show a live consumption price per minute/hour/24 hour.   

I really wish I didn't have to do this given Octopus' APIs are public.  If anyone has a better solution please do let me know. 

David

unread,
Sep 1, 2024, 3:08:50 AM9/1/24
to Loxone English
Loxone have a spot price optimizer option with a 30 minute window specifically for use with Octopus.
They have a knowledge base article and video about it here: https://www.loxone.com/enen/kb/spot-price-optimizer-uk/

David

g...@camleyphotographic.com

unread,
Sep 1, 2024, 1:16:59 PM9/1/24
to David, Loxone English

Yeah, there was an octopus guide a while ago that was total and utter rubbish and does not work. I mean… it did not even handle the clocks changing. It is appalling and should not have been published.

 

That may have been corrected/republished since.

 

I gave up on any loxxone guide and wrote a python script to integrate directly into the SPO via the API input. This has been working flawlessly for about a year. I run the script every thirty minutes via a cron job.

 

George

--
You received this message because you are subscribed to the Google Groups "Loxone English" group.
To unsubscribe from this group and stop receiving emails from it, send an email to loxone-englis...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/loxone-english/d36240f9-834b-43b4-b703-0a9f98a79064n%40googlegroups.com.

sk

unread,
Sep 2, 2024, 11:05:24 AM9/2/24
to Loxone English
That works a treat! 

This is much more of what I expect from Loxone - proper engineering. They took it one step further rather than relying on the octopus APIs.

Thank you!

Daniel Feist

unread,
Sep 4, 2024, 2:03:49 AM9/4/24
to sk, Loxone English
I don't think you need to access octopus for the rates do you?  Can't you use "GB 30 minutes Epex" spot rate and octopus formula.


--
You received this message because you are subscribed to the Google Groups "Loxone English" group.
To unsubscribe from this group and stop receiving emails from it, send an email to loxone-englis...@googlegroups.com.

JohnR

unread,
Sep 5, 2024, 10:12:18 AM9/5/24
to Loxone English
I think Loxone have missed something with their spot price optimiser. They have elected to use Octopus Agile calculator for the spot price rather than use the customers personal API key, which provides the customer specific contracted tariff rate. The key allows the customer to retrieve their billing rate and standing charge regardless of the Octopus tariff they use. So, whilst the Loxone SPO will collect the Agile price it is nonetheless a calculation based on a generic Octopus' pricing formula for that tariff. So I expect it will not collect the price if the customer are on one of the dual rate tariffs that Octopus offer, for example. 

It would have been a lot neater (and quicker) to simply use the customer API key rather than the implementation of the calculation of the Octopus pricing formula. Plus, if the customer does change from Agile to Go, as I have done, then the Loxone SPO is rendered useless whilst still providing tariff rates for a tariff no longer applicable to the customer.

I think this function block needs a bit of a re-think! 

Daniel Feist

unread,
Sep 5, 2024, 11:56:39 AM9/5/24
to JohnR, Loxone English
Yes, in theory Loxone has reached out to Octopus, but last I saw they were blaming each other (on X) for the fact this was happening.

--
You received this message because you are subscribed to the Google Groups "Loxone English" group.
To unsubscribe from this group and stop receiving emails from it, send an email to loxone-englis...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages