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

Search Actuarial Jobs by State @ DWSimpson.com:
AL AK AR AZ CA CO CT DE FL GA HI ID IL IN IA KS KY LA
ME MD MA MI MN MS MO MT NE NH NJ NM NY NV NC ND
OH OK OR PA RI SC SD TN TX UT VT VA WA WV WI WY

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 06-24-2017, 01:03 PM
ActuarialTools ActuarialTools is offline
CAS SOA
 
Join Date: Mar 2017
Posts: 5
Default Actuarial Tools For Excel - BETA testing

[updated to reflect beta-testing now closed...]

Website: (will be completed over the next month)
www.actuarialtoolsforexcel.com

Launch date:
End of July 2017. Will make a new post when it's live and downloadable.

---------
Thanks for all the encouragement. I hope you enjoy using the Add-In when it's ready.

Last edited by ActuarialTools; 07-11-2017 at 11:28 PM..
Reply With Quote
  #2  
Old 06-24-2017, 05:18 PM
redearedslider's Avatar
redearedslider redearedslider is offline
Member
CAS
 
Join Date: Oct 2015
Posts: 14,028
Default

Can you summarize what exactly this addin does that other excel addins on the market don't already do (eg Macabacus)?
__________________
Quote:
Originally Posted by Abraham Weishaus View Post
ASM does not have a discussion of stimulation, but considering how boring the manual is, maybe it would be a good idea.
Reply With Quote
  #3  
Old 06-24-2017, 07:21 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: 66,879
Default

OP: Could you also add in your post which actuarial fields that your current material is best suited for?

TIA!
__________________
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
  #4  
Old 06-24-2017, 07:23 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: 66,879
Default

Also, not all companies have access to Google Drive from their work computers.
__________________
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
  #5  
Old 06-24-2017, 07:42 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: 66,879
Default

Actually, you might get more traction by moving this thread to the Software & Technology Forum.
__________________
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
  #6  
Old 06-24-2017, 11:05 PM
ActuarialTools ActuarialTools is offline
CAS SOA
 
Join Date: Mar 2017
Posts: 5
Default

Quote:
Originally Posted by Vorian Atreides View Post
OP: Could you also add in your post which actuarial fields that your current material is best suited for?

TIA!
Hi Vorian:

In terms of actuarial related analysis:
- annuity calculations of essentially any kind and all related items like life expectancies, tpx, etc.
- Ax (insurance) calculations
- searchable access to the SOA mortality database

There are a lot of ready-to-use templates related to calculations on the above items.

So the pension/insurance field primarily. For now. Longer term I'm hoping to partner with actuaries in other fields to provide analysis in those domains (health, etc). Thanks for the question.
Reply With Quote
  #7  
Old 06-25-2017, 04:40 AM
diegol diegol is offline
Member
 
Join Date: May 2002
Posts: 243
Default

Quote:
Originally Posted by ActuarialTools View Post
Hi Vorian:

In terms of actuarial related analysis:
- annuity calculations of essentially any kind and all related items like life expectancies, tpx, etc.
- Ax (insurance) calculations
- searchable access to the SOA mortality database

There are a lot of ready-to-use templates related to calculations on the above items.

So the pension/insurance field primarily. For now. Longer term I'm hoping to partner with actuaries in other fields to provide analysis in those domains (health, etc). Thanks for the question.
First off, congrats on the initiative!

If the time ever comes when you decide that you'll explore applications to P&C, then one thing I've always thought would be cool but never took the time to program (rather solved it manually every time) is a RIGHTMOST() formula, which takes a triangle as an argument and returns a vector with the last diagonal (array formula approach). Or maybe takes a row from the triangle an returns the rightmost cell with non-blank values.

Probably someone has already come up with a good approach to this, not sure if in the form of a UDF.

Good luck!
__________________
Diegol
Reply With Quote
  #8  
Old 06-25-2017, 07:12 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: 66,879
Default

Quote:
Originally Posted by diegol View Post
First off, congrats on the initiative!

If the time ever comes when you decide that you'll explore applications to P&C, then one thing I've always thought would be cool but never took the time to program (rather solved it manually every time) is a RIGHTMOST() formula, which takes a triangle as an argument and returns a vector with the last diagonal (array formula approach). Or maybe takes a row from the triangle an returns the rightmost cell with non-blank values.

Probably someone has already come up with a good approach to this, not sure if in the form of a UDF.

Good luck!
FWIW, R has a package (ChainLadder) that has a lot of useful functionality for working with development triangles, including reading in a "flat file" and developing both an incremental triangle and a cumulative triangle . . . and automatically calculating age-to-age factors.

All stored as convenient objects. I think it already has that RIGHTMOST() functionality already.
__________________
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
  #9  
Old 06-26-2017, 08:25 AM
ActuarialTools ActuarialTools is offline
CAS SOA
 
Join Date: Mar 2017
Posts: 5
Default

Quote:
Originally Posted by diegol View Post
First off, congrats on the initiative!

If the time ever comes when you decide that you'll explore applications to P&C, then one thing I've always thought would be cool but never took the time to program (rather solved it manually every time) is a RIGHTMOST() formula, which takes a triangle as an argument and returns a vector with the last diagonal (array formula approach). Or maybe takes a row from the triangle an returns the rightmost cell with non-blank values.

Probably someone has already come up with a good approach to this, not sure if in the form of a UDF.

Good luck!
Thanks for the well wishes. That is a function I can definitely add in the near future. I am hoping to add triangle related analysis soon though I am not an expert with them as I never used them in my previous line of work.
Reply With Quote
  #10  
Old 06-26-2017, 08:31 AM
Jim Bob Cooter Jim Bob Cooter is offline
Member
SOA
 
Join Date: Jan 2017
Posts: 2,543
Default

Quote:
Originally Posted by Vorian Atreides View Post
Also, not all companies have access to Google Drive from their work computers.
Reply With Quote
Reply

Tags
add-in, excel, software

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 01:50 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, 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.44116 seconds with 9 queries