MortData ‐ IFOA Database - hnlearndev/rslife GitHub Wiki

Institute and Faculty of Actuaries (IFOA) Mortality and Morbidity Database

Introduction

Currently, the database is fully available under subscription.

Only data issued before 1st March 2013 are available to public access

In the best effort, RSLife package makes it easily to access to the below data:

More information can be found on the official website

Guide

from_ifoa_url_id method

let am92 = MortData::from_ifoa_url_id("AM92")?;

This can only be used on public available tables mentioned in Introduction.

from_ifoa_url method

Right click on Table ID as shown above to obtain a full url link.

This can be used on both subscribed and public available tables.

let am92 = MortData::from_ifoa_url("https://www.actuaries.org.uk/documents/am92-permanent-assurances-males")?;

from_ifoa_xls_file_path_str method

let am92 = MortData::from_ifoa_xls_file_path_str("data/AM92.xls")?;

IFOA XLS file has a consistent structure:

  • Sheet name is the ID
  • Cell A1 is a table description
  • Row 3 is header row including
    • Age x
    • Duration 0, Duration 1, ..., Duration n+
  • Row 5 is where data starts

Tip and trick to use custom data with _from_ifoa_xls_file_path_str method

User can replace actual data from IFOA with their custom data and use method to setup their own mortality table.

  • Must keep the structure intact
  • Header must remain Age x, Duration 0, Duration 1, ..., Duration n+
  • Be aware of metadata if the procedure needs reference in future.
let custom_data = MortData::from_ifoa_xls_file_path_str("data/custom.xls")?;

from_ifoa_custom method

The two tables below are using C20 projection. They are classified into different category but still using the base values from PFA92 and PMA92. They are classified to be called using a seperate method.

More on custom data will be updated in the future.

let pfa92c20 = MortData::from_ifoa_custom("PFA92C20")?;
let pma92c20 = MortData::from_ifoa_custom("PMA92C20")?;