ICFS-Plus: Actuarial Software for the Property and Causality Insurance Industry

Videos marked with an (*) contain discussion of new content in ICRFS-Plus™ 12.

If for any reason you are unable to view the training or demonstration videos, please contact our support staff at support@insureware.com and we will arrange to send you a copy of the videos on CD-ROM. You will be able to run the videos from the CD.

The training videos should be used for hands on training. We suggest you run the videos on a separate computer using a data projector, and train as a group.

The only way you will learn all the new concepts and be able to exploit all the immense benefits is by using the system. Experiential learning is imperative.

It is important that you study the videos in sequential order as set out below.

Table of Contents

1. Introduction to ICRFS-Plus™ 12 and modelling modules

    2. Modelling using the Link Ratio Techniques and Extended Link Ratio Family modelling framework

      3. Introduction to the Probabilistic Trend Family modelling framework

        4. Modelling real data (CTP) in the PTF modelling framework

          5. TG CS5: heteroscedasticity and varying parameters

            6. TG ABC: modelling wizard, simulations, and release of capital as profit

              7. Importing of data from other applications and COM Automation

              8. Further PTF Modelling Examples

                9. Layers and the PALD Module

                  10. Introduction to MPTF

                    11. Clusters and MPTF Concepts

                      12. Capital Management of long tail liabilities

                        13. Solvency II one year risk horizon: SCR, Best Estimate of Liabilities (BEL), Technical Provisions (TP), and Market Value (Risk) Margins (MVM) for the aggregate of long-tail LOBs

                          14. Other applications of the MPTF modelling framework

                            15. The Bootstrap: how it shows the Mack method doesn't work

                              16. Updates from 10.6 to 11

                                7. Importing of data from other applications and COM Automation

                                7.1 Importing triangular data from other databases and manipulating objects in the ICRFS-Plus™ database

                                This chapter illustrates the simplicity of using COM automation to import triangular data from Excel spreadsheets into an ICRFS-Plus™ database. COM scripts are also used to manipulate objects in the database and run the modelling Wizard. The data can be imported from any other database including MS Access, Oracle and SQL Server.

                                In a similar way data is imported from A. M. Best and NAIC Schedule P CD, and S&P Syn Thesys CD.

                                7.2 Importing triangular data from unit record transactional data

                                This chapter illustrates the importing of triangular data from unit record transactional data into an ICRFS-Plus™ database using COM scripts. The example involves unit record data that reside in an MS Access database, but similar COM script can be written if the data reside in Excel, Oracle or SQL Server.

                                A COM script is also used to manipulate objects in the ICRFS-Plus™ database. Amongst other object manipulations, Quarter*Quarter arrays are collapsed to year*year. We collapse quarter*quarter to accident year by quarter development (and) calendar periods.

                                The COM script is shown to be flexible and different layers can be extracted from the unit record transactional data. It is easy to add, remove, or modify queries.