Exporting Loss Results To Company Loss Files

You can export loss results to company loss files (CLFs) by line of business (LOB), area, and subarea, for each event included in an analysis. You can subsequently use the CLFs to run analyses in CATRADER® and Touchstone Re if you license the applications.

You have three options for saving the exported CLFs:

1.     Save the CLFs in a directory that is accessible to Touchstone.

2.     Save the CLF data in the AIRCompanyLoss database, which is accessible to both Touchstone and Touchstone Re.

3.     Do both 1 and 2.

Option 2 enables you to transfer CLFs directly to Touchstone Re rather than exporting and then importing the files.

A CLF comprises:

•       two encoded files (*.clf and *.evt) and

•       a summary file (*.evi) that describes the data in the two encoded files

For each peril, model, and loss type combination in the loss results, Touchstone generates a one set of encoded files (*.clf and *.evt). Peril and model combinations share the summary *.evi files for each loss types.

The names of related files include a prefix that you specify.

CLFs are especially useful for analyzing non-standard books with unusually high deductibles or unique geographic concentrations, per risk and surplus share treaties, and facultative contracts.

You can export losses that were saved by layer & geography and by layer & location if the geographic resolution is equal to or finer than the sub area resolution.

If you selected the Maximum Any One Life (MAOL) option when you configured the loss analysis, Touchstone generates separate files for each selected MAOL limit.

You can view and export loss results from previous product versions. However, if the event IDs or LOBs have have changed since Touchstone generated the losses, the exported report does not include the IDs or LOBs. If the version of the product, catalog, and model appropriately marked and the event IDs have not changed, CATRADER can accept CLFs from the preceding version of a model.

Touchstone exports loss results in the *Saved Currency with two exceptions:

•       MXN losses: Touchstone supports MXN, while CATRADER supports MXP. When you export a CLF, Touchstone converts MXN losses to MXP. The exchange rate between the currencies is always equal to prevent discrepancies. If you create a new currency template, Touchstone automatically sets the rate for MXN to be equal to MXP.

•       UF losses: You can import exposures coded as UF (Unidad de fomento) into Touchstone without issue. However, when you export a CLF, Touchstone converts UF to CLP, which is a currency supported in CATRADER. UF and CLP are different currencies. Therefore, you should consider consistency among the rates when you create currency tables.

To export loss analysis results to a Company Loss File:

4.     In the global menu, click Export, select Results, and then select Company Loss File (CLF)/Associate Loss File.

5.     In the Source Results tab:

a.     Select the analysis to export.

b.     Optionally, in the Comments field, provide some information about the export job.

c.     In the Number of Cores fields, specify minimum and maximum number of cores to use.

6.     In the Options tab:

a.     Select the financial perspectives and treaty losses to export.

Touchstone generates a separate CLF for each perspective.

You can scroll down the list to view additional options.

b.     If you included MAOL in the output, optionally select MAOL to include the MAOL data in the CLF.

c.     In the Target area, specify whether to export a CLF for 10,000 years, 50,000 years, or 500,000 years.

7.     In the LOB Mapping tab, map each unrecognized, user-specified LOB in the loss results to an industry LOB:

•     To map all of the user-specified LOBs to one industry LOB, select an LOB in the Set All Countries To field, and then click Apply.

Touchstone applies the LOB you selected for all countries where the LOB is valid.

•       Alternatively, click each Industry LOB cell, and then select an LOB.

8.     Optionally, select Associate Loss to Company, and then specify the details of the Touchstone Re company to transfer the losses to.

9.     Optionally, select Save to CLF, and then specify the destination for the exported data.