Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Software & Technology
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions


Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 07-21-2019, 08:16 PM
Mitsu96 Mitsu96 is offline
Member
Non-Actuary
 
Join Date: Jan 2017
Studying for IFM
Posts: 74
Default Loss Development Triangles - Development Period (Age) in R

Hello everyone,

I am trying to create a loss development triangle in R using the 'ChainLadder' package. What I am getting stuck is how to create a formula for the 'Development Period (Age)' variable. My dataframe consist of accident date (mm/dd/yyyy), accident year(yyyy), valuation date(mm/dd/yyyy) and valuation year(yyyy), in individual columns. While, I can easily create 'Age' for a 12 months period, for example,


Name:  Screen Shot 2019-07-21 at 7.57.14 PM.jpg
Views: 83
Size:  27.3 KB

Age = (ValuationYear - AccidentYear)*12

Using the formula, I can call the paid losses for the Accident Year 2005, evaluated on 12/31/2005 due to the 12 months development period. And the paid losses for the Accident Year 2003, evaluated on 12/31/2005 due to the 36 months development period.

However, I can't seem to create the right formula for a 6 months period, such as,

Name:  Screen Shot 2019-07-21 at 7.49.29 PM.jpg
Views: 81
Size:  28.0 KB

So, in this example, I am trying to call the paid losses for the Accident Year of 2005, as of 6/31/2005, corresponding to the 6 months interval. Also, I am trying to call the paid losses for the Accident Year of 2004, as of 12/31/2004, in reference to the 12 months interval. I don't know how to create a formula for such a development period.

Similarly, I am not sure how to create formulas for 3 or 4 months development period. So, pretty much apart from 12 months of development, I have no clue on how to proceed with other periods. Is there any other easier way to create loss triangles in R? Any help is appreciated! Thank you so much!
Reply With Quote
  #2  
Old 07-21-2019, 09:56 PM
Vorian Atreides's Avatar
Vorian Atreides Vorian Atreides is offline
Wiki/Note Contributor
CAS
 
Join Date: Apr 2005
Location: As far as 3 cups of sugar will take you
Studying for ACAS
College: Hard Knocks
Favorite beer: Most German dark lagers
Posts: 65,332
Default

  1. Check your 12 month formula. Consider that AD = 11/01/2011 with ED = 12/31/2011 will give you age 0 when it should be age 12.

  2. What you want to do here, I think, is calculate the number of months of development and then bin accordingly.
__________________
I find your lack of faith disturbing

Why should I worry about dying? Itís not going to happen in my lifetime!


Freedom of speech is not a license to discourtesy

#BLACKMATTERLIVES
Reply With Quote
Reply

Tags
age, chainladder, development, loss triangle

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT -4. The time now is 11:26 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.12558 seconds with 10 queries