Painful mistakes
The use of spreadsheets remains widespread in the energy trading sector, but the risks are high. Pauline McCallion looks at how these traps can be avoided
Despite the sophistication and bespoke nature of today's energy trading and risk management (ETRM) software, the use of spreadsheets remains widespread, bringing with it a huge increase in operational risk.
Estimates for the number of spreadsheets in use at any one time range from thousands to even millions for larger organisations. A recent survey of 32 energy companies by ETRM software vendor
Only users who have a paid subscription or are part of a corporate subscription are able to print or copy content.
To access these options, along with all other subscription benefits, please contact info@risk.net or view our subscription options here: http://subscriptions.risk.net/subscribe
You are currently unable to print this content. Please contact info@risk.net to find out more.
You are currently unable to copy this content. Please contact info@risk.net to find out more.
Copyright Infopro Digital Limited. All rights reserved.
As outlined in our terms and conditions, https://www.infopro-digital.com/terms-and-conditions/subscriptions/ (point 2.4), printing is limited to a single copy.
If you would like to purchase additional rights please email info@risk.net
Copyright Infopro Digital Limited. All rights reserved.
You may share this content using our article tools. As outlined in our terms and conditions, https://www.infopro-digital.com/terms-and-conditions/subscriptions/ (clause 2.4), an Authorised User may only make one copy of the materials for their own personal use. You must also comply with the restrictions in clause 2.5.
If you would like to purchase additional rights please email info@risk.net
More on Risk management
The changing shape of variation margin collateral
Financial firms are open to using a wider variety of collateral when posting VM on uncleared derivatives, but concerns are slowing efforts to use more non-cash alternatives
Repo clearing: expanding access, boosting resilience
Michel Semaan, head of RepoClear at LSEG, discusses evolving requirements in repo clearing
The state of IMA: great expectations meet reality
Latest trading book rules overhaul internal models approach, but most banks are opting out. Two risk experts explore why
How geopolitical risk turned into a systemic stress test
Conflict over resources is reshaping markets in a way that goes beyond occasional risk premia
Many banks see obstacles to options-based IRRBB hedging
Liquidity, accounting treatment and culture seen as impediments to wider use of swaptions, caps and floors
ALM has no formal role in capital planning at a third of banks
Risk Benchmarking study finds banks split three ways on policy mandates, with G-Sibs as likely as small regionals to assign ALM formal responsibility
Fed pivots to material risk – but what is it, exactly?
Top US bank regulator will prioritise risks that matter most, but they could prove hard to pinpoint
SGX fortifies its defences to ward off tomorrow’s outages
Exchange operator fosters “breach mentality” to help prepare for business disruption, explains risk chief
