Reserving

Formulas

=ANT.ACT.Live.Reserving_Master_Analytics()

Examples

For a full list of available parameters see Inputs.

Description

This formula returns the live reserving master data associated with the Fidelies IG for the company. This is the formula you should if you require the latest data. This is the latest data, associated with latest quarter reporting per the IG. 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.
```
 A1 = 'RDF'
=ANT.ACT.Live.Reserving_Master_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
`entity`	Alias: Entity The entity code. Can be: FUL, FIID, FIBL TYPE: `str`
`uw_year`	Alias: UW Year The underwriting year. TYPE: `int`
`fx_set`	Alias: FX Set The FX set code. TYPE: `str`
`reserving_asat`	Alias: Reserving As At The reserving ASAT date. TYPE: `str`
`reserving_version`	Alias: Reserving Version The reserving version. TYPE: `str`
`class_id`	Alias: Class ID The 3 letter class code. TYPE: `str`
`pillar`	Alias: Pillar The pillar code. TYPE: `str`
`master_carrier_grouping`	Alias: Master Carrier Grouping The master carrier grouping code. Capacity provider, for this data it is entirely IG. TYPE: `str`
`business_segment`	Alias: Business Segment The business segment code. Can be: REIN, INS TYPE: `str`
`mgup_split_pillar`	Alias: MGUP Split Pillar The MGUP split pillar code. TYPE: `str`
`minor_class`	Alias: Minor Class The minor class code. TYPE: `str`
`major_class`	Alias: Major Class The major class code. This can be a single cell, or multiple cells to return more than one major class code. If left blank this will default to all available major classes. TYPE: `str`
`mgup_split_light`	Alias: MGUP Split Light The MGUP split light code. This can be a single cell, or multiple cells to return more than one MGUP split light code. If left blank this will default to all available MGUP split lights. TYPE: `str`
`mgup_split_master`	Alias: MGUP Split Master The MGUP split master code. This can be a single cell, or multiple cells to return more than one MGUP split master code. If left blank this will default to all available MGUP split masters. TYPE: `str`
`mgup_split`	Alias: MGUP Split The MGUP split code. This can be a single cell, or multiple cells to return more than one MGUP split code. If left blank this will default to all available MGUP splits. TYPE: `str`
`mgup_reporting`	Alias: MGUP Reporting The MGUP reporting code. This can be a single cell, or multiple cells to return more than one MGUP reporting code. If left blank this will default to all available MGUP reportings. TYPE: `str`
`dom_simon_class`	Alias: Dom Simon Class The Dom Simon class code. This can be a single cell, or multiple cells to return more than one Dom Simon class code. If left blank this will default to all available Dom Simon classes. TYPE: `str`
`dom_simon_lob`	Alias: Dom Simon LOB The Dom Simon LOB code. This can be a single cell, or multiple cells to return more than one Dom Simon LOB code. If left blank this will default to all available Dom Simon LOBs. TYPE: `str`
`broker_master_group`	Alias: Broker Master Group The broker master group code. This can be a single cell, or multiple cells to return more than one broker master group code. If left blank this will default to all available broker master groups. TYPE: `str`
`mga_code`	Alias: MGA Code The MGA code. This can be a single cell, or multiple cells to return more than one MGA code. If left blank this will default to all available MGA codes. TYPE: `str`
`is_pinewalk_flag`	Alias: Is Pinewalk Flag A flag to indicate if the data is for Pine Walk or not. This can be either 0 or 1. TYPE: `int`
`gross_acq_earned_premium_usd`	Alias: Gross Acquired Earned Premium USD The gross acquired earned premium in USD. TYPE: `float`
`gross_acq_unearned_premium_usd`	Alias: Gross Acquired Unearned Premium USD The gross acquired unearned premium in USD. TYPE: `float`
`gross_acq_unwritten_premium_usd`	Alias: Gross Acquired Unwritten Premium USD The gross acquired unwritten premium in USD. TYPE: `float`
`gross_gn_earned_premium_usd`	Alias: Gross GN Earned Premium USD The gross GN earned premium in USD. TYPE: `float`
`gross_gn_written_premium_usd`	Alias: Gross GN Written Premium USD The gross GN written premium in USD. TYPE: `float`
`gross_gn_unearned_premium_usd`	Alias: Gross GN Unearned Premium USD The gross GN unearned premium in USD. TYPE: `float`
`gross_gn_unwritten_premium_usd`	Alias: Gross GN Unwritten Premium USD The gross GN unwritten premium in USD. TYPE: `float`
`gross_gg_earned_premium_usd`	Alias: Gross GG Earned Premium USD The gross GG earned premium in USD. TYPE: `float`
`gross_gg_written_premium_usd`	Alias: Gross GG Written Premium USD The gross GG written premium in USD. TYPE: `float`
`gross_gg_unearned_premium_usd`	Alias: Gross GG Unearned Premium USD The gross GG unearned premium in USD. TYPE: `float`
`gross_gg_unwritten_premium_usd`	Alias: Gross GG Unwritten Premium USD The gross GG unwritten premium in USD. TYPE: `float`
`gross_gg_ultimate_premium_usd`	Alias: Gross GG Ultimate Premium USD The gross GG ultimate premium in USD. TYPE: `float`
`gross_gn_ultimate_premium_usd`	Alias: Gross GN Ultimate Premium USD The gross GN ultimate premium in USD. TYPE: `float`
`gross_reinstatement_premium_usd`	Alias: Gross Reinstatement Premium USD The gross reinstatement premium in USD. TYPE: `float`
`ceded_acq_earned_premium_usd`	Alias: Ceded Acquired Earned Premium USD The ceded acquired earned premium in USD. TYPE: `float`
`ceded_acq_unearned_premium_usd`	Alias: Ceded Acquired Unearned Premium USD The ceded acquired unearned premium in USD. TYPE: `float`
`ceded_acq_unwritten_premium_usd`	Alias: Ceded Acquired Unwritten Premium USD The ceded acquired unwritten premium in USD. TYPE: `float`
`ceded_gn_earned_premium_usd`	Alias: Ceded GN Earned Premium USD The ceded GN earned premium in USD. TYPE: `float`
`ceded_gn_written_premium_usd`	Alias: Ceded GN Written Premium USD The ceded GN written premium in USD. TYPE: `float`
`ceded_gn_unearned_premium_usd`	Alias: Ceded GN Unearned Premium USD The ceded GN unearned premium in USD. TYPE: `float`
`ceded_gn_unwritten_premium_usd`	Alias: Ceded GN Unwritten Premium USD The ceded GN unwritten premium in USD. TYPE: `float`
`ceded_gg_earned_premium_usd`	Alias: Ceded GG Earned Premium USD The ceded GG earned premium in USD. TYPE: `float`
`ceded_gg_written_premium_usd`	Alias: Ceded GG Written Premium USD The ceded GG written premium in USD. TYPE: `float`
`ceded_gg_unearned_premium_usd`	Alias: Ceded GG Unearned Premium USD The ceded GG unearned premium in USD. TYPE: `float`
`ceded_gg_unwritten_premium_usd`	Alias: Ceded GG Unwritten Premium USD The ceded GG unwritten premium in USD. TYPE: `float`
`ceded_gg_ultimate_premium_usd`	Alias: Ceded GG Ultimate Premium USD The ceded GG ultimate premium in USD. TYPE: `float`
`ceded_gn_ultimate_premium_usd`	Alias: Ceded GN Ultimate Premium USD The ceded GN ultimate premium in USD. TYPE: `float`
`ceded_reinstatement_premium_usd`	Alias: Ceded Reinstatement Premium USD The ceded reinstatement premium in USD. TYPE: `float`
`gross_paid_claims_usd`	Alias: Gross Paid Claims USD The gross paid claims in USD. TYPE: `float`
`gross_os_claims_usd`	Alias: Gross OS Claims USD The gross OS claims in USD. TYPE: `float`
`gross_ultimate_claims_usd`	Alias: Gross Ultimate Claims USD The gross ultimate claims in USD. TYPE: `float`
`gross_reinstatement_claims_usd`	Alias: Gross Reinstatement Claims USD The gross reinstatement claims in USD. TYPE: `float`
`ceded_paid_claims_usd`	Alias: Ceded Paid Claims USD The ceded paid claims in USD. TYPE: `float`
`ceded_os_claims_usd`	Alias: Ceded OS Claims USD The ceded OS claims in USD. TYPE: `float`
`ceded_ultimate_claims_usd`	Alias: Ceded Ultimate Claims USD The ceded ultimate claims in USD. TYPE: `float`
`ceded_reinstatement_claims_usd`	Alias: Ceded Reinstatement Claims USD The ceded reinstatement claims in USD. TYPE: `float`
`net_paid_claims_usd`	Alias: Net Paid Claims USD The net paid claims in USD. TYPE: `float`
`net_os_claims_usd`	Alias: Net OS Claims USD The net OS claims in USD. TYPE: `float`
`net_ultimate_claims_usd`	Alias: Net Ultimate Claims USD The net ultimate claims in USD. TYPE: `float`
`net_reinstatement_claims_usd`	Alias: Net Reinstatement Claims USD The net reinstatement claims in USD. TYPE: `float`
`gross_specific_ibnr_usd`	Alias: Gross Specific IBNR USD The gross specific IBNR in USD. TYPE: `float`
`gross_general_ibnr_usd`	Alias: Gross General IBNR USD The gross general IBNR in USD. TYPE: `float`
`ceded_specific_ibnr_usd`	Alias: Ceded Specific IBNR USD The ceded specific IBNR in USD. TYPE: `float`
`ceded_general_ibnr_usd`	Alias: Ceded General IBNR USD The ceded general IBNR in USD. TYPE: `float`
`net_specific_ibnr_usd`	Alias: Net Specific IBNR USD The net specific IBNR in USD. TYPE: `float`
`net_general_ibnr_usd`	Alias: Net General IBNR USD The net general IBNR in USD. TYPE: `float`
`gross_incurred_claims_usd`	Alias: Gross Incurred Claims USD The gross incurred claims in USD. TYPE: `float`
`ceded_incurred_claims_usd`	Alias: Ceded Incurred Claims USD The ceded incurred claims in USD. TYPE: `float`
`net_incurred_claims_usd`	Alias: Net Incurred Claims USD The net incurred claims in USD. TYPE: `float`
`gross_total_specific_usd`	Alias: Gross Total Specific USD The gross total specific in USD. TYPE: `float`
`ceded_total_specific_usd`	Alias: Ceded Total Specific USD The ceded total specific in USD. TYPE: `float`
`net_total_specific_usd`	Alias: Net Total Specific USD The net total specific in USD. TYPE: `float`
`gross_earned_claims_usd`	Alias: Gross Earned Claims USD The gross earned claims in USD. TYPE: `float`
`ceded_earned_claims_usd`	Alias: Ceded Earned Claims USD The ceded earned claims in USD. TYPE: `float`
`net_earned_claims_usd`	Alias: Net Earned Claims USD The net earned claims in USD. TYPE: `float`