Issue
The client is a prominent leading renewable energy owner and operator, actively trading, scheduling and settling over 7,800 MW of wind, solar and storage assets across multiple ISO / RTO markets in North America.
The client relied on a manual process to track trade changes and price-curve valuation updates due to a limitation in their ETRM system’s ability to version trade records. This daily process, managed via Excel spreadsheets, was time-consuming, inefficient, and prone to human error.
Solution
MidDel Consulting was engaged by the client to design and implement an automated system for tracking changes to long-term trades and curves. in their portfolio. Our consultants developed a transaction version control system with the following key features:
- Trade Snapshot & Versioning: Capturing snapshots of trades and curves and versioning them for comparison.
- Automated Nightly Processing: Comparing current trades and curves in the ETRM system against a baseline, generating a detailed change report.
- Comprehensive Change Detection: Identifying modifications to trades, contracts, and curve assignments.
- Secure Version Control Database: Storing version histories of trade and curve changes.
- Automated Notifications: Sending daily email reports highlighting changes in forward delivery periods and historical pricing adjustments.
Result
The Client realized significant efficiency gains through the implementation of MidDel’s automation and process optimization
- 1,000+ annual labor hours saved by reducing manual daily spreadsheet processes from 4 hours to just 15 minutes.
- Enhanced operational visibility with daily detailed and automated tracking of portfolio changes.
Key Takeaways
- When an ETRM can't version records, the answer isn't to replace it. An external version-control layer restores a full trade-and-curve audit trail at a fraction of the cost and risk of a platform migration — extending the system's life instead of retiring it.
- Monitoring should be a passive control, not a daily task — the labor savings are a byproduct, not the point. A nightly baseline comparison that surfaces only exceptions is what lets a lean team oversee a large portfolio, here collapsing four hours of manual diffing into a 15-minute review and reclaiming 1,000+ hours a year.
Ready to do the same?
If your ETRM can't version trades and your team is reconciling curves by hand, MidDel can layer automated version control on top of your existing platform. Schedule a trade & curve monitoring assessment to see where it fits your portfolio.
