On-Line XTbML Tables (XML and MS Excel)
Welcome to MargusConsulting's free On-Line XTbML Database!
This site features all XTbML Actuarial Tables
on the Society of Actuaries Website,
with more to come!
Contents
Top of Page
Purpose
The Society of Actuaries has a diverse collection of Actuarial Tables
that it maintains on its website. They are in industry-standard XTbML
text format. This format can be examined by human observers,
or parsed by standard software packages.
Here are MargusConsulting's goals for XTbML.
- Right now, to make the existing collection
more accessible to practicing actuaries.
- Each existing XTbML table now has
a standard Microsoft Excel analogue.
- Both XTbML and Excel formats can be located
using a dozen different search criteria.
- Ultimately, to expand and improve the service.
- Modernize existing XTbML tables,
according to the latest industry standards.
- Add new tables (both XTbML and Excel).
- Expand to other lines of business, including
Long Term Care,
Group Insurnce,
and Individual Disability Income.
To get the tables, you have two options . . .
Top of Page
Option 1: Download Tables using Spreadsheet Software
The Spreadsheet Software . . .
- Offers Superior Filter and Search capabilities.
- Operates on a Single Indexed List of All Tables.
- Offers Batch Downloads.
- Downloads XTbML_files you have chosen, directly from
the Society of Actuaries XTbML Site.
- Converts every downloaded file into Excel 1997-2003 format.
Option 1: Get the Software . . .
If you have Microsoft Excel 2007 or 2010,
- Just click XTbMXL.xlsb.
- Save the file to your disk.
- Open the file.
- Enable Microsoft Excel Visual Basic Macros.
- Follow the instructions.
If you encounter any problem, check
Troubleshooting.
Top of Page
Option 2: Download Tables directly from the Web
If you use an earlier version of Excel, or prefer a web-based approach,
then proceed as follows.
- Choose the "Content Type" and "Region", and click
"Display Available Tables . . .".
- This will display another page, where you can specify your own search criteria
(See Search Tips and Other Resources):
- All or Part of Table Name.
- Aggregate or Select & Ultimate (and length of Select Period).
- Content Type (Insured Mortality, Population Mortality, Group Experience, etc.),
- Country (Canada, USA, and over 40 others).
- Age Nearest, Age Last, or Age Next Birthdays.
- Observation Years. Specify a range.
- Sex (Male, Female, Unisex Blend), Nonsmoker/Smoker, and More.
- Once you've located a table, click the format you need:
- XTbML (The XML file, as a direct link to the Society of Actuaries' website).
- Microsoft Excel (1997-2003 format, from this website).
- At the prompt, save it to your disk.
Top of Page