Wed, 22 May|
Čopova ulica 11
Actuarial Engineering - Ljubljana, Slovenia
The workshop aims at learning or refreshing some actuarial techniques used in the insurance and in the financial industry and their implementation in Excel® and/or VBA. These relatively simple and quick calculations can be used to test more sophisticated softwares, etc.
Time & Location
22 May 2019, 08:00 – 23 May 2019, 17:30
Čopova ulica 11, Čopova ulica 11, 1000 Ljubljana, Slovenia
About The Event
Prime Re Academy is pleased to invite you to attend its workshop in Ljubljana, Slovenia in May 2019. Focus will be set on the following topic:
The workshop aims at learning or refreshing some actuarial techniques used in the insurance and in the financial industry and their implementation in Excel® and/or VBA. These relatively simple and quick calculations can be used to test more sophisticated softwares, to build prototypes or only to understand how methods work in practice.
The topics addressed in the workshop will include:
- Fundamental programing hygiene in Excel and VBA
- Data smoothing (Whittaker–Henderson, …)
- Calibrations and model fitting (max likelihood, χ^2, …)
- Stochastic simulations (collective models, …)
- Risk aggregation (copulas, …)
- Pricing ((G)LM, …)
- Stochastic reserving (bootstrapping, …)
- Claims development (neural networks, …)
- Market risks (cellular automata, …)
It addresses both, the underlying theory and concepts, as well as their practical implementations with Excel® and VBA templates. In particular, it enables participants to implement the techniques directly on their laptop, to later apply them in their daily assignments.
The workshop is designed for all professionals who are interested in actuarial and financial modelling. Participants do not need to be fully qualified actuaries, however, they will benefit from a good command of Excel® (excluding VBA). In addition, they should be familiar with elementary concepts of insurance, statistics and stochastic modelling.
The Prime Re Academy workshops are of technical nature and structured so that theory and practice alternately complement each other, creating a lively learning platform. We simultaneously present on two separate screens the theoretical foundations in PowerPoint® format and the matching practical applications on an Excel® platform. Thanks to the interlocking of theory and practice, the course contents can be taught in a most efficient manner and the participants can be challenged intensively.
Participants should bring along their own laptops so that they can implement and test the theoretical concepts with the Excel® prototypes we will hand over to them.
Moreover, to enhance the international learning experience and networking, the workshop starts in the afternoon and includes joint dinners: this way the participants quickly get to know each other and the lecturers, so that promptly a dynamic atmosphere of mutual challenge and know-how transfer sets in. In particular we encourage the participants to steer the focus of the workshop according to their current needs, e.g. with more emphasis on life or property & casualty business.
Dates and Schedule
Tuesday, 21 May 2019
13.30 – 14.00 registration
14.00 – 18.30 workshop
18.30 – dinner
Wednesday, 22 May 2019
09.00 – 12.30 workshop
12.30 – 14.00 lunch
14:00 – 18.30 workshop
18.30 – dinner
Thursday, 23 May 2019
09.00 – 12.30 workshop
12.30 – lunch
Registration will be closed after 7 May 2019.
This workshop will be held in Čopova ulica 11, 1000 Ljubljana, Slovenia, in the large conference hall of the main Ljubljana post office (the entrance is opposite the Muller’s shop).
Dress casual and comfortable. We suggest that participants from abroad reserve their hotel room in Ljubljana well in advance. Alternatively, they can ask us for assistance with booking a room at a convenient location.
EUR 450 for members of the Slovenian Actuarial Association if registering before 26.3.2019
EUR 600 for members of the Slovenian Actuarial Association if registering after 26.03.2019
EUR 700 for non-members if registering before 26.3.2019
If at least 10 participants register from one organizational unit, the fee for each of them is 100 EUR lower.
These fees are binding.
The fees include:
- the workshop
- the documentation
- the prototypes in Excel®
- the lunches and snacks in between brakes
The fees will be refunded in total in case of cancellation before 7 May 2019 or if the workshop must be cancelled.
If you wish to redeem a voucher, opt to pay manually at the checkout section and enter the voucher number you wish to redeem. We will then send you an invoice via email.
The participants of the seminar will receive 50 credits for CPD for SAA. Members of the Swiss Actuarial Association will automatically be credited with 14 CPD points.
Prime Re Academy
Phone: +41 (41) 725 32 10
Dr Frank Cuypers
Has led numerous actuarial engineering and modeling courses and workshops in Europe and Latin America. He comes with a vast lecturing experience and a prominent scientific track-record in modeling complex systems. As a Swiss Re Executive and Chief Actuary at the former Zurich Re in Cologne, he has wide experience in most actuarial disciplines and lines of business, which he has deployed at KPMG and PwC to advise leading providers of financial services and Government Agencies. He is a fully qualified member of the German and Swiss Actuarial Associations (DAV and SAV), which he has served on numerous committees.