Instructor Led Excel Training in Uk, uk

Dodd-Frank Act Implications for Derivatives Trading Investing and Hedging Activities Two-day workshop presented by William Allen The Dodd-Frank Act (DFA) mandates comprehensive changes to a wide range of financial institutions and products. This course explores in detail one major area impacted by several parts of the DFA: the trading, investing and hedging activities using a wide range of derivatives and related products. These products may be used by many different types of  more...

Index Linked Bonds and Inflation Derivatives The market for index-linked bonds and inflation derivatives is growing rapidly. The program covers the mechanics of the instruments, their valuation and how they can be used to take or hedge inflation exposure alone or embedded in other structures. Traders, risk managers, fund managers, project finance and structured finance practitioners, accountants, auditors, consultants and anyone interested  more...

Strategic ALM, Treasury and Capital Asset and Liability Management (ALM) is a key function of growing importance in financial markets. ALM involves a number of techniques that maximise the use of an organisation's assets and liabilities to improve performance. The course provides a deep understanding of the subject, offering an overview of traditional ALM and detailing the more recently applied risk measures, their modelling and use  more...

Hedge Funds Risk Management Trade Performance Analysis Review the key fundamentals of the hedge fund industry and develop a deep understanding of the quantitative principles of hedge fund modelling and analysis through applied problem solving and implementation using key techniques and methods. Computer-based workshops (Excel and VBA) are very hands-on building on the basics through to some advanced hedge fund modelling and risk management  more...

Numerical Techniques 1 Monte Carlo Simulation Course Outline Over the past two decades increased changes in the complexity of financial products and increasing computational capacity has meant that Monte Carlo methods have become the mainstay of any financial engineer's toolkit. This course illustrates how Monte Carlo can be used in modern finance for both pricing and risk management purposes. The course uses a combination of theoretical  more...

Convertible Bonds and Securities ...egies. Exercises and pricing models are implemented using Excel functions and macros and participants will be able to take away all worked examples. Who The Course is For * Traders * Credit and equity risk managers * IT * Middle office * Quantitative researchers * Hedge funds * Portfolio managers * Structured products desk Prior Knowledge * Numerate background (basic)  more...

Interest Rate Derivatives 2 Second Generation Techniques ...de fully worked scenario spreadsheets containing relevant Excel functions and macros for participants to take away. Who The Course is For This course is designed for anyone who wishes to be able to price, use and manage second-generation interest rate derivatives: * Quantitative Analysts * Risk Managers * Financial Engineers * Traders and Structurers * Researchers and others who  more...

Equity Derivatives Valuation and Management Course Outline Equity derivatives have been growing in importance over a number of years and are now well established in the financial marketplace. This seminar is for anyone who wishes to be able to price, use, manage or evaluate equity derivatives and exotic equity options. More than half of the seminar is devoted to practical small group sessions. Who The Course is For Anyone who wishes  more...

Risk Management and Modelling Course Outline This course develops a set of tools essential for the accurate management of the wide range of risks encountered in capital markets. Techniques are applied cumulatively in a sequence of workshops that include Value at Risk and its limitations, practical uses of Monte Carlo simulations and the Merton and Gaussian approaches for estimation of probabilities. Who The Course is For  more...

Asset Backed Securities Assessment and Management of Risk Course Outline This intensive and participative 2-day programme covers the key elements of asset-backed securities and in particular mortgage backed securities. Terminology, procedures, models and applications of ABS concepts will be included along with the latest products used for hedging the risks and for developing new markets. The first day will cover the risk factors, prepayment models  more...

Using Inflation Derivatives in Today s Market ...e intensive exercises include simulations using Microsoft Excel or other industry standard software. Participants will be able to take away worked examples including a number of Excel functions and macros. Who the Course is for Traders, risk managers, fund managers, project finance and structured finance practitioners, accountants, auditors, consultants and anyone interested in the use  more...

Maths Refresher Course Outline Mathematics is at the heart of financial techniques, but many finance texts and courses assume a lot of prior knowledge. This programme aims to bridge the gap between mathematical theory and financial practice by providing a practical and visual approach to the most useful theories and methods. Calculations will be fully explained, and Excel spreadsheets will be used as a  more...

Volatility Trading and Managing Risk Course Outline The course starts by providing an understanding of how to estimate volatility and the consequences of the various ways of describing volatile asset prices. This leads into sessions on the application of a range of standard volatility derivatives such as VIX futures and options and volatility swaps. The final part of the programme covers the treatment of volatility in the more  more...

Property Derivatives Course Outline Terminology, procedures, models and applications related to the latest real-estate derivatives will be covered in this course. The first day is dedicated to forwards and futures and to the introduction of a new type of modelling based on mean-reverting models with nonlinear trend. Day two covers total return swaps and options pricing and risk calculations based on value-at-risk  more...

Managing Exotic Risk Course Outline New market conditions have changed forever the way in which managers need to think about complex risk. In this course we look at lessons from the recent financial crisis and how to avoid explosions of risk from illiquid and complex products during times of financial stress. Lessons learned call for a re-assessment of tools available for the management of exotic risk. More than  more...

Counterparty Risk, Credit Exposure and CVA ...les and additional exercises and models implemented using Excel functions and macros. All delegates will receive a copy of Jon Gregory's recent published book "Counterparty Credit Risk: The New Challenge for Global Financial Markets" (Wiley). Who The Course is For * Credit traders and credit officers * Risk managers and credit risk practitioners * Structurers and salespeople *  more...

Correlation Trading and Risk Management ...g the weaknesses and pitfalls where needed. During the Excel based workshops students will have access to proprietary status-of-the-art professional software for exotic and multi-underlying pricing, thus gaining an understanding of multifactor pricing models and higher order exotic effects on risk exposures. Who The Course is For Senior managers that need to understand risk Junior  more...