MIDAS - California Energy Prices, right from the regulator

Thanks @MattDahEpic , just tried and some of them now have data. The doc I posted above from Oct 2023 is useless; those aren’t the RINs they use. I’m trying to find tariff BEV-1 (should be 0022 according to that filing). Here’s what I’ve found:

USCA-PGPG-0100-0000 is E-TOU-C
USCA-PGPG-0200-0000 is E-TOU-D
USCA-PGPG-0300-0000 is EV-B
USCA-PGPG-0400-0000 is EV-2A
USCA-PGPG-0500-0000 is E-ELEC
USCA-PGPG-0600-0000 is B-1
USCA-PGPG-0700-0000 is B-6
USCA-PGPG-0800-0000 is B-10S
USCA-PGPG-0900-0000 is B-10P
USCA-PGPG-1000-0000 is B-10T
USCA-PGPG-1100-0000 is B-19S
USCA-PGPG-1200-0000 is B-19P
USCA-PGPG-1300-0000 is B-19T
USCA-PGPG-1400-0000 is B-20S
USCA-PGPG-1500-0000 is B-20P
USCA-PGPG-1600-0000 is B-20T
USCA-PGPG-1700-0000 is AG-A1
USCA-PGPG-1800-0000 is AG-A2
USCA-PGPG-1900-0000 is AG-BS
USCA-PGPG-2000-0000 is AG-BP
USCA-PGPG-2100-0000 is AG-BT
USCA-PGPG-2200-0000 is AG-CS
USCA-PGPG-2300-0000 is AG-CP
USCA-PGPG-2400-0000 is AG-CT ($6.9 usd/kWh right now?!?)
USCA-PGPG-2500-0000 is AG-FAS
USCA-PGPG-2600-0000 is AG-FBS
USCA-PGPG-2700-0000 is AG-FBP
USCA-PGPG-2800-0000 is AG-FBP
USCA-PGPG-2900-0000 is AG-FCS
USCA-PGPG-3000-0000 is AG-FCP
USCA-PGPG-3100-0000 is AG-FCT
USCA-PGPG-3200-0000 is BEV-1 FOUND IT!
USCA-PGPG-3300-0000 is BEV-2-S
USCA-PGPG-3400-0000 is BEV-2-P

It looks like you found it but I did a bulk iteration of all the PGPG RID’s and there are quite a few that have “BEV1” or similar in their rate names. Hopefully one of these is correct if the one you found isn’t:
USCA-PGPG-0022-0000 (BEV1)
USCA-PGPG-0076-0000 (BEV1)
USCA-PGPG-3200-0000 (BEV-1, you found)
USCA-PGPG-3212-0000 (BEV-1)

Thanks Matt. Last night 0022 had no data (“unknown”) and 3200 had data; tonight the only one of the four on your list with tariff info is 3212. Seems like PG&E isn’t playing nice with MIDAS.

Does anyine know how to get the export RIN for sdge? I have 1 RIN on my bill.

Details from my bill:
Detail of Current Charges - Continued

Electric Service - Solar Billing Plan

Rate: Time of Use EVTOU5-Residential

Climate Zone: Coastal

Export Pricing: Legacy 2025 Pricing

RIN: USCA-SDXX-0300-0000

Do you happen to have a RIN for the basic PG&T E-1 Tiered plan (the top one in their rate card here)?

I just got on the SCE Solar Billing Program (SBP), and I have one RIN on my account page, which is for the TOU-D-PRIME pricing USCA-SCSC-0605-0000. I’m trying to get the buy back (selling/EEC) prices for excess solar energy. I eventually found a sharepoint that Edison has set up with some MIDAS zips, but the RIN listed in the CSV causes a 404 error in the integration.
USCA-XXSC-NB00-0000

I’ve also tried USCA-SCSC-NB00-0000 and USCA-SCSC-NB25-0000 but they all have the same error.

Does this integration work with Energy Export Credits as well? If so, does anyone know what the SCE SBP NEM 3 EEC RIN is? I’m hoping to avoid making a custom sensor based on the spreadsheet data.

2 Likes

This looks incredibly useful. Unfortunately, apparently only time of use (TOU) plans have an RIN, or at least that is what I am told by SDGE. I am on a legacy two-tier non-time of use plan with community choice aggregation (CCA) and net-metering that trues up once per year. With so many moving parts, it is really difficult to compute the rate.

I installed the MIDAS integration and it seems to be functioning correctly except it is giving prices that are lower than reality. For example, I am on PG&E’s EV2A plan and the off peak, part peak, and peak prices are $0.31026, $0.51228 and $0.62277 respectively, but MIDAS is returning $0.17953, $0.34014, and $0.40619. It switches between the various tiers at the correct time, they are just wrong. I looked at the detailed tariff document with the unbundled prices to see if the price returned matches any combination of sub-prices, but I couldn’t find any correlation. Does anyone have an ideas of why the pricing is off and how to adjust it? Thanks

Thank you for writing and posting your work. It appears your work is the only way to get complete transparency on energy credits from Southern California Edison. I’m a rookie, and successfuly added the api to my HA, but I only can see “current” and “future” prices. They appear to use TOU Prime import from SCE. I do not see specific export generation or transmission prices that vary each hour. Did I do something wrong? My RIN is USCA-SCSC-0605-000. Any clue you can provide would be much appreciated

Hi @MattDahEpic, I’ve been loving having your integration working. One of my “offline entities” automations notified me about this one stopping and, sure enough, it appears that it stopped directly at midnight this morning. Usually when the entities randomly go Unavailable, a simple reload of the integration fixes it, but this appears to be something deeper.

The integration shows a repair with this:

This may mean the utility has changed RINs or has simply stopped submitting data to MIDAS.
Check your latest bill for a new RIN. If this persists, please reach out to your utility and tell them the RIN on your bill is not returning any data for your smart home system to use.
If you need to change the RIN, you can Reconfigure this integration to add and remove RINs.

I checked my bill and the RIN is the same as before (USCA-SCSC-0600-0000 for SCE’s TOU-D-PRIME). I will attempt to call SCE to see if they know more or can fix on their end, but I am not holding my breath.

I didn’t see similar discussion on this thread or the Github issues, so posting here in the hopes someone may have suggestions for how to resolve.

UPDATE: Magically, the integration came back online a few moments ago (5:40 am) without any intervention from me as I saw my “device reconnected” notification and confirmed all entities load as expected. Nothing shows in the raw system logs so not sure whether to be worried or still call SCE to ask about it. I assume there are no easy ways to close any gaps in the data as it integrates into my energy dashboard.

Interesting, I’m glad it came back. I was also able to see a gap during the midnight to about 5:30 time since I happen to have SCSC-0600 on my production HA for testing.

Some utilities put their price data in months in advance while others put it in mere hours in advance. If SCE puts their prices in hours in advance and their process failed it would likely result in this outcome. The California Energy Commission required utilities to put their data in MIDAS but seemingly doesn’t have any user-visible way to alert them of outages. Maybe there’s something behind the scenes and someone got called in to fix it but I’m afraid we won’t figure that out unless some CEC staff are using Home Assistant. You are welcome to call SCE and let them know that the data was missing for a time, maybe if they know people use it they’ll be more inclined to monitor it.

Anyone on tou ev5 know the generation tin for sdge? Only 1 rin on my bill.

I’m currently experiencing the same issue with my RIN USCA-SCSC-0605-0000 SCE TOU-D-PRIME, and it’s been several days without any data. I contacted SCE and they assured me the RIN has not changed for my account and it should still be active. I reached out to the CA Energy Commission IT Help desk to see if there are any problems with the API. Note I do not get any connection issues with the integration, only that it’s not returning any data.

This may mean the utility has changed RINs or has simply stopped submitting data to MIDAS.
Check your latest bill for a new RIN. If this persists, please reach out to your utility and tell them the RIN on your bill is not returning any data for your smart home system to use.
If you need to change the RIN, you can Reconfigure this integration to add and remove RINs.

I’ve reloaded the integration a couple of times per day, but the entities always come back unavailable.

I’ve added my electricity cost (import) prices no problem with my RINs (SCE and CCA) but like others here the RIN for my solar export prices returns a 404 Not Found error in this integration. It must be the MIDAS API, not this integration. It seems like my RIN is supposed to be USCA-XXSC-NB25-0000 but it does not work. I guess I will just wait since it seems like the utilities are maybe still rolling this out? I suspect maybe once it starts showing up on my electricity bill perhaps it will also work in MIDAS. I also saw something about a deadline in May 2026 but not sure if it’s related.