Octopus Energy now offers an API that serves up current wholesale prices across ERCOT. For our customers who use the wholesale price to automate their home, customers who would like to track the price outside our app, or simply the curious, this API is another tool Octopus offers to monitor the real-time power markets.

This API is a GraphQL endpoint. If you are familiar with curl, a sample request to get the latest LZ_HOUSTON settlement price is included at the end of this post. However, the concept is simple: POST the following GraphQL query to https://api.oeus-kraken.energy/v1/graphql/

query getSettlementPoint{
  getSettlementPoint(
  settlementPoint:LZ_HOUSTON){
      SettlementPoint
      LMP
      LMP5MinuteDifference
      RtorpaRtordpaLmp
      RtorpaRtordpaLmp5MinDifference
      lastUpdatedAt
    }
}
If you live in another Load Zone, simply swap out the settlement point for LZ_SOUTH, LZ_WEST, or LZ_NORTH. 

Some other queries you can run:

Get LMP data for all settlement points:

query getAllLMPdata{
getAllRealTimeLmpData{
SettlementPoint
LMP
LMP5MinuteDifference
RtorpaRtordpaLmp
RtorpaRtordpaLmp5MinDifference
lastUpdatedAt
}
}

Find negative prices:

query getLMP{
  getLmpValue(
  value:0, sort:LESS_THAN){
      SettlementPoint
      LMP
      LMP5MinuteDifference
      RtorpaRtordpaLmp
      RtorpaRtordpaLmp5MinDifference
      lastUpdatedAt
  }
}

Please let us know if you have any questions

curl:

curl --request POST \
--url https://api.oeus-kraken.systems/v1/graphql/ \
--header 'Content-Type: application/json' \
--data '{"query":"query getSettlementPoint{\n getSettlementPoint(\n settlementPoint:LZ_HOUSTON){\n SettlementPoint\n LMP\n LMP5MinuteDifference\n RtorpaRtordpaLmp\n RtorpaRtordpaLmp5MinDifference\n lastUpdatedAt\n }\n}","operationName":"getSettlementPoint"}'