Downloadable Programs, Spreadsheets and Workbooks

GitHub

The CAS maintains an active organizational account on GitHub. What's GitHub? It's a cloud-based version control system that allows actuaries and others to share and enhance code. Note that code encompasses more than just software. By writing in a format like RMarkdown, we can also share research papers, and other human-readable items.

If you'd like to learn more about git and GitHub, the CAS has a series of microlearning videos which give an overview.

Downloadable tools

This software is provided as a zipped file of size 6.5MB. It unpacks into 10 files; double-click setup.exe to run the program. This updated software is designed to build aggregate loss distributions based on the collective risk model. Most calculations can be completed in less than 10 seconds (with a Pentium II 450/64 MB memory). You have the choice of using either Simulation or two approximation methods - Recursion and Fast Fourier Transform - to build your aggregate loss distributions.

  • The two choices for frequency distributions are Poisson and Negative Binomial while there are five severity distributions -Exponential, Gamma, LogNormal, Weibull, and Pareto- for the user to choose from. The software presents the results in both tabular and graphic forms. The user can print the summary results or export the results to MS Excel. If you need more specific information about the resulting aggregate loss distributions, please contact Hou-wen Jeng at hjeng@columbus.rr.com.
  • Property Per Risk Exposure Rating (162K)
    Freeware Excel Spreadsheet that does property per risk exposure rating for Commercial (Lloyds & Hartford Scales) and Homeowners (Salzmann & Hartford Scales).

Option Trading Strategy Spreadsheets with Profit/Payoff Diagrams
by Thomas P. Hughes

The files listed below are self-extracting ZIP files containing a brief explanatory text file and fourteen spreadsheets demonstrating option strategies as described in Hull's textbook (John C. Hull, "Options, Futures, and Other Derivative Securities," Second Edition, Prentice Hall, Englewood Cliffs, NJ, 1993). Download the version(s) appropriate for your system. The file sizes range from 53k to 124k.

  • .wk1 files - prepared with Lotus 1-2-3 Rel. 2.2
    .wk4 files - prepared with Lotus 1-2-4 Rel. 5
    .123 files - prepared with Lotus 1-2-3 97
    .xls files - Excel 5/95 Workbook, prepared with Excel 97
    .xls files - Excel 97, prepared with Excel 97
  • Software for Fourier Methods of Calculating Aggregate Loss Distributions
    by Glenn Meyers

    The spreadsheet FFTCalc provides an introduction to Fourier methods for aggregate loss distributions. It provides a step by step explanation of the process. It also illustrates the FFT methodology developed by Shaun Wang to include correlation beween the frequency distribution of two lines of insurance.
  • Bond Analytics Program, Version 2.03a
    by Thomas P. Hughes

    The Bond Analytics Program is a fixed income analytics program for computing bond yields, price-yield volatility metrics and horizon analyses. Options include an external reinvestment rate, tax rates, horizon and call calculations and odd first coupon periods. The program has an easy to use single screen user interface featuring pop-up Help windows and extensive diagnostic messages. A User Guide text file gives more detailed information about the program and bond analytics in general. This is not a .pdf file, it is a zipped file (77KB) containing a .txt file and an executable file.

Seabury and Smith Experience Analysis System (SSEAS)

  • SSEAS is a complete loss reserving system able to do side-by-side comparisons using chain-ladder, Bornhuetter-Ferguson and numerous other estimators. It can perform Monte-Carlo simulations extending Stanard's model in PCAS LXXII. It runs under DOS or in a DOS session under OS/2 or Windows 3.1 or higher. This is the complete DOS version of SSEAS, release 7.24, and may be used for study or research with no restrictions. The software is provided as a zipped file of size 1,169,013 bytes. It unpacks into the files sseas.exe and readme.1st; to install, follow the instructions in the latter file.

Stochastic Reserving Track Readings from 2006 Spring Meeting
Bootstrap Method (E&V) handout (.xls)
This spreadsheet is an example of the bootstrap method described in England & Verrall paper, "Analytic and Bootstrap Estimates of Prediction Errors in Claims Reserving."

Copulas Tool

  • The tool's installation is a windows installer program provided as a zipped file. The tool has functions of correlation calculation, bivariate copulas, FFT, bivariate IC modeling, Simulations, Distributions and their Expected Values, Limited Expected Values, etc.. Hopefully it can bring conveniences and enlightenment to research activities. Please send questions to copula@goouon.com.
  • Risk Margins in Fair Value Reserves from the 2008 Fall E-Forum
    by Michael Wacek
    Template for Calculations Described in Paper (.xls)

 

Keep up with the latest CAS news