Electricity Futures Data Workshop
The workshop aims to provide a practical guide to retrieving and analysing electricity futures and options market data. Particular emphasis is placed on providing quick and effective techniques of interpreting, filtering and reporting relevant futures market information critical to decision making in the electricity and carbon trading sector.
Tuesday 20 Jan 2009
|Futures Data Workshop Agenda||PDF, 195Kb|
ABOUT THE WORKSHOP
This workshop has been designed to raise awaresness of the widespread practical uses of electricity futures market data for commercial purposes, ranging from trade decision making and OTC hedge accounting purposes to regulated retail price cap setting and energy project investment decisions. The workshop aims to provide a practical guide to retrieving and analysing electricity futures and options market data. Particular emphasis is placed on providing quick and effective techniques of interpretting, filtering and reporting relevant futures market information critical to decision making in the electricity and carbon trading sector.
WHO SHOULD ATTEND
The workshop will be of benefit to electricity traders and their market analysts, risk analysts, hedge accountants and project analysts at electricity trading companies. Prime brokers, Clearing Participants and hedge fund risk managers will also find the price and volume data analysis techniques to be useful for risk monitoring. Investment and commercial banks, rating agencies and equity analysts will gain a practical understanding of the relevance of the electricity forward curve to the financial performance of companies and investment projects in the electricity and carbon sectors.
- SYDNEY: TBA
- MELBOURNE: TBA
- BRISBANE: TBA
DURATION: 9AM - 4PM
FEES: AU $1,195 (exc GST)
MATERIALS: Workshop notes, USB preloaded with sample excel spreadsheets, refreshments and lunch provided.
- Course Introduction and Objectives
- DC Online Information resources
- Trade Log history, Online price calculator, Data Mine queries, Individual Product History, Charting, Market bid/offer snapshot
- Using Excel with DC data
- Importing DC data into Excel, Charting volume and price data, Price volatility Analysis, Sorting and filtering DC data using TEXT functions, Analysing option trades using “Option Greek formulas”, using VLOOKUP to determine trade MW Hours
- Excel Pivot Table queries for electricity
- Creating a DC data Pivot Table with electricity field lists
- Analysing trade history by region, duration, shape
- Analysing Liquidity by trade type (Block, EFP, Strip)
- Analysing Traded Price ranges over time
- Commercial Uses of DC data – putting it all together
- Traders, Market Analysts & Industrial electricity consumers
- Contract price history and trend analysis
- Calculating & analysing historical v.s. implied option volatility
- Online strip-trade calculator for brokers, traders and reporting
- Trading Risk Management/Settlements
- Daily P&L and margin calculation, Liquidity analysis, VaR analysis using futures price history
- Treasury and Credit Risk Managers
- Hedge accounting for OTC using futures and options
- OTC Credit Risk benchmarking using futures curve
- Measuring Trading Performance/opportunity costs
- NEMMCO Futures Offset savings calculations for NEM Retailers
- Project Financing, Equity Analysts & Ratings Agencies
- Implications/considerations for banks/project financiers
- Profit and cash flow forecasting using DC data
- Electricity hedge costs/revenues for retailers, generators and electricity-exposed industrials
- Comparing regulated tariffs (retailers) to “hedge cost reality”
- Indentifying cash flow/profitability “danger periods” using futures prices
- Valuing the Emissions Trading Scheme impact (now) on energy participants
- Regulators/government agencies
- Using DC data to set regulated retail price tariffs;
- Using DC data to identify/pre-empt:
- Physical Market power/control issues;
- Incentives for power market misconduct;
- Appropriate regulatory response
- Emissions Trading Regulation - quantifying financial impact on electricity consumers, retailers and generators
- Other challenges/insights for regulators
For further information or to enrol for any workshop please contact a member of d-cyphaTrade via:
Domestic (toll free): 1800 330 101
International: +61 2 9237 0900
Please email firstname.lastname@example.org and a representative will be in touch with you shortly.
Please download the registration form below and return to +61 2 9233 1745.
To organise an in-house workshop please call a member of the d-cyphaTrade Team on 1800 330 101 to discuss your specific requirements.