Reserving Events

Formula

=ANT.ACT.Live.Reserving_Events_Analytics()

Examples

For a full list of available parameters see Inputs.

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.

1. 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

1. To return all class ids you can leave class_ids blank.
2. 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. TYPE: int
parent_layer_id	Alias: Parent Layer Id Unique identifier for the parent layer. TYPE: int
program_id	Alias: Program Id The Program Id. TYPE: str
class_id	Alias: Class Id The 3 letter class code. TYPE: str
class_id_reserving	Alias: Class Id Reserving The 3 letter class code as used in reserving. TYPE: Optional[str]
class_id_prequel	Alias: Class Id Prequel The 3 letter class code as defined in Prequel. TYPE: Optional[str]
claim_id	Alias: Claim Id Unique identifier for the claim. TYPE: Optional[int]
reserving_asat	Alias: Reserving As At The reserving as-at period, e.g. 2025Q1. TYPE: str
reserving_version	Alias: Reserving Version The reserving version. TYPE: str
fx_set	Alias: FX Set The FX set used to convert the figures to USD. TYPE: str
uw_year	Alias: Underwriting Year The Underwriting Year of the policy. TYPE: Optional[int]
is_latest	Alias: Is Latest Flag: 1 = row belongs to the latest reserving version, 0 = historical. TYPE: int
entity	Alias: Entity The Entity (FUL, FIID, FIBL). TYPE: str
event_name_ig	Alias: Event Name IG The event name as defined by the IG. TYPE: str
event_name_tfp	Alias: Event Name TFP The event name as defined by TFP. TYPE: str
claim_name	Alias: Claim Name The name of the claim. TYPE: str
claim_type	Alias: Claim Type The claim type (e.g. ATT or EXT). TYPE: str
master_carrier_grouping	Alias: Master Carrier Grouping The capacity provider. This can be the IG, F3123, Consortium, Allianz. TYPE: str
business_segment	Alias: Business Segment This is the IG's mapping to business segment (INS / REIN). 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 Pillar This pillar definition is used in MGUP Production meetings. The main difference is the how RI classes are mapped from Speciality / Bespoke to Reinsurance and how some Reinsurance classes are mapped back to Specialty / Bespoke. Unless you want to tie up with MGUP pillar definitions, you should not use this pillar. TYPE: str
minor_class	Alias: Minor Class This is consistent with the IG definition of minor classes. TYPE: str
major_class	Alias: Major Class This is consistent with the IG definition of major classes. TYPE: str
mgup_split_light	Alias: MGUP Light Class 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
mgup_split_master	Alias: MGUP Master Class This class definition is used in MGUP Production meetings, similar to Major Class. TYPE: str
mgup_split	Alias: MGUP Split This is the full list of MGUP master and MGUP light classes combined together separated by a hyphen. TYPE: str
mgup_reporting	Alias: MGUP Reporting Class This is the MGUP Master class broken down into the main reporting classes. TYPE: str
dom_simon_class	Alias: Dom Simon Class The Dom Simon class grouping used in reserving analysis. TYPE: str
dom_simon_lob	Alias: Dom Simon LOB The Dom Simon line of business grouping used in reserving analysis. TYPE: str
broker_master_group	Alias: Broker Grouped This is a high level mapping of brokers. Brokers have been grouped together for reporting purposes from their lowest granularity. For example, all GC and Marsh broker names have been grouped together into GC Marsh. To see the mapping refer to ANT.ACT.Mappings.get_broker_mapping() TYPE: str
mga_code	Alias: MGA Code This is a high level mapping of MGAs / Third Party binders based on their Layer Id. If the value is Fidelis this means that the business is Fidelis sourced, an example of a MGA would be Navium. To see the mapping refer to ANT.ACT.Mappings.get_mga_mapping() TYPE: str
is_pinewalk_flag	Alias: Is Pinewalk Flag You can use this flag to separate Pine Walk business from the rest of TFP. TYPE: int
gross_os_claims_usd	Alias: Gross Outstanding Claims USD The gross outstanding claims in USD. TYPE: float
gross_paid_claims_usd	Alias: Gross Paid Claims USD The gross paid claims in USD. TYPE: float
gross_specific_ibnr_usd	Alias: Gross Specific IBNR USD The gross specific (case-level) IBNR reserve in USD. TYPE: float
gross_general_ibnr_usd	Alias: Gross General IBNR USD The gross general (bulk) IBNR reserve in USD. TYPE: float
gross_incurred_claims_usd	Alias: Gross Incurred Claims USD The gross incurred claims in USD. TYPE: float
gross_total_specific_usd	Alias: Gross Total Specific Claims USD The gross total specific claims in USD. TYPE: float
gross_earned_claims_usd	Alias: Gross Earned Claims USD The gross earned claims in USD. TYPE: float
ceded_os_claims_usd	Alias: Ceded Outstanding Claims USD The ceded outstanding claims in USD. TYPE: float
ceded_paid_claims_usd	Alias: Ceded Paid Claims USD The ceded paid claims in USD. TYPE: float
ceded_specific_ibnr_usd	Alias: Ceded Specific IBNR USD The ceded specific (case-level) IBNR reserve in USD. TYPE: float
ceded_general_ibnr_usd	Alias: Ceded General IBNR USD The ceded general (bulk) IBNR reserve in USD. TYPE: float
ceded_incurred_claims_usd	Alias: Ceded Incurred Claims USD The ceded incurred claims in USD. TYPE: float
ceded_total_specific_usd	Alias: Ceded Total Specific Claims USD The ceded total specific claims in USD. TYPE: float
ceded_earned_claims_usd	Alias: Ceded Earned Claims USD The ceded earned claims in USD. TYPE: float
fac_os_claims_usd	Alias: Fac Outstanding Claims USD The Facultative reinsurance share of outstanding claims in USD. TYPE: float
fac_paid_claims_usd	Alias: Fac Paid Claims USD The Facultative reinsurance share of paid claims in USD. TYPE: float
fac_specific_ibnr_usd	Alias: Fac Specific IBNR USD The Facultative reinsurance share of specific (case-level) IBNR reserve in USD. TYPE: float
fac_general_ibnr_usd	Alias: Fac General IBNR USD The Facultative reinsurance share of general (bulk) IBNR reserve in USD. TYPE: float
fac_incurred_claims_usd	Alias: Fac Incurred Claims USD The Facultative reinsurance share of incurred claims in USD. TYPE: float
fac_total_specific_usd	Alias: Fac Total Specific USD The Facultative reinsurance share of total specific claims in USD. TYPE: float
fac_earned_claims_usd	Alias: Fac Earned Claims USD The Facultative reinsurance share of earned claims in USD. TYPE: float
xol_os_claims_usd	Alias: XOL Outstanding Claims USD The Excess-of-Loss reinsurance share of outstanding claims in USD. TYPE: float
xol_paid_claims_usd	Alias: XOL Paid Claims USD The Excess-of-Loss reinsurance share of paid claims in USD. TYPE: float
xol_specific_ibnr_usd	Alias: XOL Specific IBNR USD The Excess-of-Loss reinsurance share of specific (case-level) IBNR reserve in USD. TYPE: float
xol_general_ibnr_usd	Alias: XOL General IBNR USD The Excess-of-Loss reinsurance share of general (bulk) IBNR reserve in USD. TYPE: float
xol_incurred_claims_usd	Alias: XOL Incurred Claims USD The Excess-of-Loss reinsurance share of incurred claims in USD. TYPE: float
xol_total_specific_usd	Alias: XOL Total Specific USD The Excess-of-Loss reinsurance share of total specific claims in USD. TYPE: float
xol_earned_claims_usd	Alias: XOL Earned Claims USD The Excess-of-Loss reinsurance share of earned claims in USD. TYPE: float
qs_os_claims_usd	Alias: QS Outstanding Claims USD The Quota Share reinsurance share of outstanding claims in USD. TYPE: float
qs_paid_claims_usd	Alias: QS Paid Claims USD The Quota Share reinsurance share of paid claims in USD. TYPE: float
qs_specific_ibnr_usd	Alias: QS Specific IBNR USD The Quota Share reinsurance share of specific (case-level) IBNR reserve in USD. TYPE: float
qs_general_ibnr_usd	Alias: QS General IBNR USD The Quota Share reinsurance share of general (bulk) IBNR reserve in USD. TYPE: float
qs_incurred_claims_usd	Alias: QS Incurred Claims USD The Quota Share reinsurance share of incurred claims in USD. TYPE: float
qs_total_specific_usd	Alias: QS Total Specific USD The Quota Share reinsurance share of total specific claims in USD. TYPE: float
qs_earned_claims_usd	Alias: QS Earned Claims USD The Quota Share reinsurance share of earned claims in USD. TYPE: float
net_os_claims_usd	Alias: Net Outstanding Claims USD The net outstanding claims in USD. TYPE: float
net_paid_claims_usd	Alias: Net Paid Claims USD The net paid claims in USD. TYPE: float
net_specific_ibnr_usd	Alias: Net Specific IBNR USD The net specific (case-level) IBNR reserve in USD. TYPE: float
net_general_ibnr_usd	Alias: Net General IBNR USD The net general (bulk) IBNR reserve in USD. TYPE: float
net_incurred_claims_usd	Alias: Net Incurred Claims USD The net incurred claims in USD. TYPE: float
net_total_specific_usd	Alias: Net Total Specific Claims USD The net total specific claims in USD. TYPE: float
net_earned_claims_usd	Alias: Net Earned Claims USD The net earned claims in USD. TYPE: float