Aim:
- The company wanted to set up risk management (from scratch)
- Valuation and marked-to-market
- Risk measures: Value-at-risk, liquidity risk (when trading outside the liquid periods of the market exchange)
- The risk management was not only related to market risk, it also included credit risk, and regulatory reporting
My role
- My role was acting as:
- Project manager:
- Made sure that the aim of the project was clear for all involved parties (e.g. trading /sales manager, risk management, legal, IT)
- I made sure that the requirements were understood within the project group
- I made sure that the tasks were set in with proper priority
- If new tasks came up change the priorities if needed
- Developer: developed the new risk management framework in Python
- I updated the project team on a frequent basis
- Document each step of the process and present the progress to the project owners
Tasks:
The company wanted to set up an in-house ETRM system for the PPA trading
The company was using Python to large extent already, which lead me to use Python too
I made sure that the relevant data was in place e.g.:
Wind data (from SCADA) for the locations each wind parks.
German power futures (from EEX)
Guarantees of Origins (GoO)
Feed-in-tariff
The time frame of PPA’s are often extends the time frame of EEX’s German power futures, which means that OTC prices are also needed
The company wanted to have the opportunity to trade different PPA structures e.g. corporate PPA’s with fixed base load, with variable base load, pay as produced.
I started with setting up templates for the different PPA contract structures
Based on the templates and data I developed Python codes for the valuation and risk management. The output from Python was then exported to Excel using VBA (in future in Power BI).
Regulatory reporting:
REMIT: Made sure that the PPA’s are incorporated into existing REMIT reporting structure.
EMIR: Exchange traded and OTC traded contracts/deals used for hedging the PPA’s needs to be reported (there are exceptions that legal needed to clarify). I made sure that the correct format, content was set up for the contracts/deals that have to be reported.
Documented the IT process and GAP analyses
Outputs
- Full documentation of:
- The different templates (containing the contract structure the company was looking for)’
- The Python code I developed for the valuation and risk management
- The IT-process and performed GAP analysis e.g.:
- How to incorporate the PPA’s into the short-term trading desk
- The need to enhance the back-office process to handle PPA’s
- The need to enhance the regulatory IT-landscape (to include e.g. EMIR)
- The need to enhance the credit risk management in case deals are not cleared in a centralised clearing house