Reserving Events

Formulas

=ANT.ACT.Live.Reserving_Events_Analytics()

Examples

For a full list of available parameters see Inputs.

Description

This below formula returns the live reserving events for the company. This is the formula you should if you require the latest data. This data is not signed off and changes in data between daily metrics are due to information entered into Prequel. You should not use this formula for external reporting.

The analytics version of this formula returns the live reserving events data associated with the Fidelies IG for the company. At this point the time has been aggregated to the level of the class code, entity, MGA and broker.

The below formula returns reserving events data for RDF class code grouped up by entity, mga and broker.
```
 A1 = 'RDF'
=ANT.ACT.Live.Reserving_Events_Analytics(A1)
```

Inputs

Tip

The best practise for once you have used this formula is to create a table from the results and use this table within your analysis. This ensures that your data changes only when you want it to and you are not dependent on the table columns being in the same order each exercise.

1. Use the formula to get the data you need

2. Select all the data that the formula returns (including headings)

3. Go to Data >> Get Data >> From Other Sources >> From Table/Range

4. Right click on the 'Array' name and rename it to something sensible

5. Check to see if the first row has been promoted to headers, this is usually done automatically but
if not  on the "Home" tab you can select "Use the first row as headers".

6. If you are seeing errors in the layer_id or program_id columns then you need to change the data type.
To do this go to the Applied Steps on the right hand side, choose 'Changed Type' and change
{'layer_id', Int.64.Type} to {'layer_id', type text} and {'program_id', Int.64.Type} to {'program_id', type text}.

7. Click Close & Load.

This will create a table in your worksheet. If the data changes you will need to refresh the table by going to Data >> Refresh All or Data >> Queries & Connections >> right click on your table and refresh.

By default, data will not be split by entity, MGA or broker, but you can use the parameter values if these splits are required.

PARAMETER	DESCRIPTION
`class_ids`	The 3 letter class code. This can be a single cell, or multiple cells to return more than one class code. If left blank this will default to all available class codes. TYPE: `str`
`show_entities`	A boolean value to show data split by Entity. This can be either True or False. If left blank this will default to False and show data combined by Entity. TYPE: `bool`
`show_mgas`	A boolean value to show data split by Fidelis / Pine Walk / Third Party MGAs. This can be either True or False. If left blank this will default to False and show data combined into all TFP. TYPE: `bool`
`show_years`	Year. This can be a single cell, or multiple cells to return more than one year. If left blank this will default to the last 5 years. TYPE: `str`

Note

To return all class ids you can leave class_ids blank.
show_entities, show_mgasare optional and default to False if left blank. It is possible to omit these from your formula if you do not need them split out in your data.

Outputs

PARAMETER	DESCRIPTION
`layer_id`	Alias: Layer Id The layer id of the reserving event. TYPE: `int`
`parent_layer_id`	Alias: Parent Layer Id The parent layer id of the reserving event. TYPE: `int`
`program_id`	Alias: Program Id The program id of the reserving event. TYPE: `str`
`class_id`	Alias: Class Id The 3 letter class code of the reserving event. TYPE: `str`
`class_id_reserving`	Alias: Class Id Reserving The 3 letter class code of the reserving event in Prequel. TYPE: `Optional[str]`
`class_id_prequel`	Alias: Class Id Prequel The 3 letter class code of the reserving event in Prequel. TYPE: `Optional[str]`
`claim_id`	Alias: Claim Id The claim id of the reserving event. TYPE: `int`
`reserving_asat`	Alias: Reserving Asat The reserving asat of the reserving event. Should be in the format YYYYQQ e.g 2025Q1. TYPE: `str`
`reserving_version`	Alias: Reserving Version The reserving version of the reserving event. TYPE: `str`
`fx_set`	Alias: FX Set The fx set of the reserving event. TYPE: `str`
`uw_year`	Alias: UW Year The underwriting year of the reserving event. TYPE: `int`
`is_latest`	Alias: Is Latest The is latest flag of the reserving event. TYPE: `int`
`entity`	Alias: Entity The entity of the reserving event. Can be one of the following: 'FUL', 'FIID', 'FIBL'. TYPE: `str`
`event_name_ig`	Alias: Event Name IG The event name of the reserving event as defined by IG. TYPE: `str`
`event_name_tfp`	Alias: Event Name TFP The event name of the reserving event as defined by TFP. TYPE: `str`
`claim_name`	Alias: Claim Name The claim name of the reserving event. TYPE: `str`
`claim_type`	Alias: Claim Type The claim type of the reserving event. Can be ATT OR EXT. TYPE: `str`
`master_carrier_grouping`	Alias: Master Carrier Grouping The master carrier grouping of the reserving event. For the purpose of this data, it relates to the the Fidelis IG carrier group i.e. IG. TYPE: `str`
`business_segment`	Alias: Business Segment The business segment of the reserving event. Can be REIN or INS. TYPE: `str`
`pillar`	Alias: Pillar This pillar definition is consistent with the definition between the IG and TFP and should be used in most scenarios. TYPE: `str`
`mgup_split_pillar`	Alias: MGUP Split Pillar This class definition is used in MGUP Production meetings, similar to Minor Class. It will split, e.g. P,C&E MGUP class into Construction, Non-Renewable, Renewables, Property and D&F. TYPE: `str`
`minor_class`	Alias: Minor Class The minor class of the reserving event. TYPE: `str`
`major_class`	Alias: Major Class The major class of the reserving event. TYPE: `str`
`mgup_split_light`	Alias: MGUP Split Light The MGUP split light of the reserving event. TYPE: `str`
`mgup_split_master`	Alias: MGUP Split Master The MGUP split master of the reserving event. TYPE: `str`
`mgup_split`	Alias: MGUP Split The MGUP split of the reserving event. TYPE: `str`
`mgup_reporting`	Alias: MGUP Reporting The MGUP reporting of the reserving event. TYPE: `str`
`dom_simon_class`	Alias: DOM Simon Class The DOM Simon class of the reserving event. TYPE: `str`
`dom_simon_lob`	Alias: DOM Simon LOB The DOM Simon line of business of the reserving event. TYPE: `str`
`broker_master_group`	Alias: Broker Master Group The broker master group of the reserving event. TYPE: `str`
`mga_code`	Alias: MGA Code The MGA code of the reserving event. TYPE: `str`
`is_pinewalk_flag`	Alias: Is Pine Walk Flag The Pine Walk flag of the reserving event. 1 = Pine Walk, 0 = Non Pine Walk TYPE: `int`
`gross_os_claims_usd`	Alias: Gross OS Claims USD The gross outstanding claims in USD of the reserving event. TYPE: `float`
`gross_paid_claims_usd`	Alias: Gross Paid Claims USD The gross paid claims in USD of the reserving event. TYPE: `float`
`gross_specific_ibnr_usd`	Alias: Gross Specific IBNR USD The gross specific IBNR in USD of the reserving event. TYPE: `float`
`gross_general_ibnr_usd`	Alias: Gross General IBNR USD The gross general IBNR in USD of the reserving event. TYPE: `float`
`gross_incurred_claims_usd`	Alias: Gross Incurred Claims USD The gross incurred claims in USD of the reserving event. TYPE: `float`
`gross_total_specific_usd`	Alias: Gross Total Specific USD The gross total specific in USD of the reserving event. TYPE: `float`
`gross_earned_claims_usd`	Alias: Gross Earned Claims USD The gross earned claims in USD of the reserving event. TYPE: `float`
`ceded_os_claims_usd`	Alias: Ceded OS Claims USD The ceded outstanding claims in USD of the reserving event. TYPE: `float`
`ceded_paid_claims_usd`	Alias: Ceded Paid Claims USD The ceded paid claims in USD of the reserving event. TYPE: `float`
`ceded_specific_ibnr_usd`	Alias: Ceded Specific IBNR USD The ceded specific IBNR in USD of the reserving event. TYPE: `float`
`ceded_general_ibnr_usd`	Alias: Ceded General IBNR USD The ceded general IBNR in USD of the reserving event. TYPE: `float`
`ceded_incurred_claims_usd`	Alias: Ceded Incurred Claims USD The ceded incurred claims in USD of the reserving event. TYPE: `float`
`ceded_total_specific_usd`	Alias: Ceded Total Specific USD The ceded total specific in USD of the reserving event. TYPE: `float`
`ceded_earned_claims_usd`	Alias: Ceded Earned Claims USD The ceded earned claims in USD of the reserving event. TYPE: `float`
`net_os_claims_usd`	Alias: Net OS Claims USD The net outstanding claims in USD of the reserving event. TYPE: `float`
`net_paid_claims_usd`	Alias: Net Paid Claims USD The net paid claims in USD of the reserving event. TYPE: `float`
`net_specific_ibnr_usd`	Alias: Net Specific IBNR USD The net specific IBNR in USD of the reserving event. TYPE: `float`
`net_general_ibnr_usd`	Alias: Net General IBNR USD The net general IBNR in USD of the reserving event. TYPE: `float`
`net_incurred_claims_usd`	Alias: Net Incurred Claims USD The net incurred claims in USD of the reserving event. TYPE: `float`
`net_total_specific_usd`	Alias: Net Total Specific USD The net total specific in USD of the reserving event. TYPE: `float`
`net_earned_claims_usd`	Alias: Net Earned Claims USD The net earned claims in USD of the reserving event. TYPE: `float`