THE REINSURANCE ACTUARY
  • Blog
  • Project Euler
  • Category Theory
  • Disclaimer

NASA - GISS Surface Temperature Analysis (GISTEMP v4)

26/2/2025

 

​NASA produces a monthly dataset which estimates global surface temperature change. It's part of a number of datasets which can be used to track climate change. They kindly provide the python source code to run or edit the analysis, but unfortunately the fetch functions no longer work. Below I've posted code which I've corrected.

The below image, which is derived from this dataset, shows the temperature difference between Oct 2024, and the average temp in October from 1951-1980. From an insurance context, two significant changes are the Gulf of Mexico and Atlantic coast being 1-2 degrees warmer than the historic average, which impacts hurricane severity, and California being 2-4 degrees warmer which has contributed to the wildfire conditions in California.
Picture
Source: https://data.giss.nasa.gov/gistemp/maps/

Read More

Why do brokers always seem to think an ADC should cost 20% on line?

29/2/2024

 

​Okay, that's a bit of an exaggeration, but there’s a quirky mathematical result related to these deals which means the target loss cost can often end up clustering in a certain range. Let’s set up a dummy deal and I’ll show you what I mean.
Picture
Source:  Jim Linwood, Petticoat Lane Market, https://www.flickr.com/photos/brighton/4765025392
​

I found this photo online, and I think it's a cool combo - it's got the modern City of London (the Gherkhin), a 60s brutalist-style estate (which when I looked it up online has been described as "a poor man's Barbican Estate"), and a street market which dates back to Tudor times (Petticoat lane). 

Read More

When chain ladders goes wrong

8/2/2024

 

I received a chain ladder analysis a few days ago that looked roughly like the triangle below, but there's actually a bit of a problem with how the method is dealing with this particular triangle, have a look at see if you can spot the issue. 
Picture

Read More

Modelling Extremal Events - Cramer-Lundberg theorem under LogN

3/11/2023

 

I’ve had the textbook 'Modelling Extremal Events: For Insurance and Finance’ sat on my shelf for a while, and last week I finally got around to working through a couple of chapters. One thing I found interesting, just around how my own approach has developed over the years, is that even though it’s quite a maths heavy book my instinct was to immediately build some toy models and play around with the results. I recall earlier in my career, when I had just got out of a 4-year maths course, I was much more inclined to understand new topics via working through proofs step-by-step in long hand, pen to paper. 

In case it’s of interest to others, I thought I’d upload my Excel version I built of the classic ruin process. In particular I was interested in how the Cramer-Lundberg theorem fails for sub-exponential distributions (which includes the very common  Lognormal distribution). Therefore the Spreadsheet contains a comparison of this theorem against the correct answer, derived from monte carlo simulation.

The Speadsheet can be found here:​
https://github.com/Lewis-Walsh/RuinTheoryModel

The first tab uses an exponential distribution, and the second uses a Lognormal distribution. Screenshot below.

​​I also coded a similar model in Python via Jupyter Notebook, which you can read about below.
Picture

Read More

Nuclear Verdicts and shenanigans with graphs part 2

26/10/2023

 

I was thinking more about the post I made last week, and I realised there’s another feature of the graphs that is kind of interesting. None of the graphs adequately isolates what we in insurance would term ‘severity’ inflation. That is, the increase in the average individual verdict over time.

You might think that the bottom graph of the three, tracking the ‘Median Corporate Nuclear Verdict’ does this. If verdicts are increasing on average year by year due to social inflation, then surely the median nuclear verdict should increase as well right?!?

​Actually, the answer to this is no. Let's see why.​

Picture

Read More

Nuclear Verdicts and shenanigans with graphs

18/10/2023

 

​If you have seen the below graphs before, it’s probably because they've cropped up quite a few times in various insurance articles recently.
Picture
They were used by IBNR Weekly [2], Insurance Insider [3], Munich Re [4], Lockton Re [5], and those were just the ones I could remember or which I found with a 5 minute search. The graphs themselves are originally from a report on US social inflation by an organisation called Marathon Strategies (MS for short in the rest of the post) [1].

It's an interesting way of analyzing social inflation, so I recreated their analysis, which lead me to realize MS may have been a little creative in how they’ve presented the data, let me explain.

Read More

Inflation modelling - median of top 10 losses, under exposure growth

18/7/2023

 

I previously wrote a post in which I backtested a method of deriving large loss inflation directly from a large loss bordereux. This post is an extension of that work, so if you haven't already, it's probably worth going back and reading my original post. Relevant link:
www.lewiswalsh.net/blog/backtesting-inflation-modelling-median-of-top-x-losses
​
In the original post I slipped in the caveat that that the method is only unbiased if the underlying exposure doesn’t changed over the time period being analysed. Unfortunately for the basic method, that is quite a common situation, but never fear, there is an extension to deal with the case of changing exposure.

Below I’ve written up my notes on the extended method, which doesn't suffer from this issue. Just to note, the only other reference I’m aware of is from the following, but if I've missed anyone out, apologies! [1]
Picture
St Paul's, London. Photo by Anthony DELANOIX

Read More

What is a 'Net' Quota Share?

7/10/2022

 

I recently received an email from a reader asking a couple of questions :

"I'm trying to understand Net vs Gross Quota shares in reinsurance. Is a 'Net Quota Share' always defining a treaty where the reinsurer will pay ceding commissions on the Net Written Premium? ... Are there some Net Quota Shares where the reinsurer caps certain risks (e.g. catastrophe)?"

It's a reasonable question, and the answer is a little context dependent, full explanation given below.


Picture
Source: https://unsplash.com/@laurachouette, London

(As an aside, in the last couple of weeks, the UK has lurched from what was a rather pleasant summer into a fairly chilly autumn, to mirror this, here's a photo of London looking a little on the grey side.)


Read More

Backtesting inflation modelling - median of top x losses

29/7/2022

 


I wrote a quick script to backtest one particular method of deriving claims inflation from loss data. I first came across the method in 'Pricing in General Insurance' by Pietro Parodi [1], but I'm not sure if the method pre-dates the book or not.

In order to run the method all we require is a large loss bordereaux, which is useful from a data perspective. Unlike many methods which focus on fitting a curve through attritional loss ratios, or looking at ultimate attritional losses per unit of exposure over time, this method can easily produce a *large loss* inflation pick. Which is important as the two can often be materially different.
Picture
Source: Willis Building and Lloyd's building, @Colin, https://commons.wikimedia.org/wiki/User:Colin

Read More

Converting from a Gross to Net Quota Share

10/6/2022

 

Quota Share contracts generally deal with acquisition costs in one of two ways - premium is either ceded to the reinsurer on a ‘gross of acquisition cost’ basis and the reinsurer then pays a large ceding commission to cover acquisition costs and expenses, or premium is ceded on a ‘net of acquisition’ costs basis, in which case the reinsurer pays a smaller commission to the insurer, referred to as an overriding commission or ‘overrider’, which is intended to just cover internal expenses.

Another way of saying this is that premium is either ceded based on gross gross written premium, or gross net written premium.

I’ve been asked a few times over the years how to convert from a gross commission basis to the equivalent net commission basis, and vice versa. I've written up an explanation with the accompanying formulas  below.

Picture
Source: @ Kuhnmi, Zurich

Read More

Tallying the estimates of Insured Market Loss from the Ukraine Conflict

25/3/2022

 


It's still very early days to understand the true fallout from Russia's invasion of Ukraine, but I thought it would be interesting to tally a few of the estimates for the insured loss we've seen so far, all of the below come from the Insider. 

Please note, I'm not endorsing any of these estimates, merely collating them for the interested reader! 
Picture
Kiv Perchersk Lavra Monastery, Kyiv. @Andriy155

Read More

Cefor Exposure Curves - follow up

7/3/2022

 

The Cefor curves provide quite a lot of ancillary info, interestingly (and hopefully you agree since you're reading this blog), had we not been provided with the 'proportion of all losses which come from total losses', we could have derived it by analysing the difference between the two curves (the partial loss and the all claims curve)

Below I demonstrate how to go from the 'partial loss' curve and the share of total claims % to the 'all claims' curve, but you could solve for any one of the three pieces of info given two of them using the formulas below.
​
Picture
Source: Niels Johannes  ​https://commons.wikimedia.org/wiki/File:Ocean_Countess_(2012).jpg

Read More

Cefor Exposure Curves

3/3/2022

 

I hadn't see this before, but Cefor (the Nordic association of Marine Insurers), publishes Exposure Curves for Ocean Hull risks. Pretty useful if you are looking to price Marine RI. I've included a quick comparison to some London Market curves below and the source links below.

Picture

Read More

German Flooding - tail position – second update

30/9/2021

 

This post is a follow up to two previous posts, which I would recommend reading first:
https://www.lewiswalsh.net/blog/german-flooding-tail-position
https://www.lewiswalsh.net/blog/german-flooding-tail-position-update
 
Since our last post, the loss creep for the July 2021 German flooding has continued, sources are now talking about a EUR 8bn (\$9.3bn) insured loss. [1] This figure is just in respect of Germany, not including Belgium, France, etc., and up from \$8.3bn previously. 

But interestingly (and bear with me, I promise these is something interesting about this) when we compare this \$9.3bn loss to the OEP table in our previous modelling, it puts the flooding at just past a 1-in-200 level. 
Picture
Photo @ Jonathan Kemper - https://unsplash.com/@jupp

Read More

NOAA, Property Cat Reinsurance Pricing, and 5 year burns

21/9/2021

 

Here are two events that you might think were linked:

Every year around the month of May, the National Oceanic and Atmospheric Administration (NOAA) releases their predictions on the severity of the forthcoming Atlantic Hurricane season.

Around the same time, US insurers will be busy negotiating their upcoming 1st June or 1st July annual reinsurance renewals with their reinsurance panel. At the renewal (for a price to be negotiated) they will purchase reinsurance which will in effect offload a portion of their North American windstorm risk.

You might reasonably think – ‘if there is an expectation that windstorms will be particularly severe this year, then more risk is being transferred and so the price should be higher’. And if the NOAA predicts an above average season, shouldn’t we expect more windstorms? In which case, wouldn't it make sense if the pricing zig-zags up and down in line with the NOAA predictions for the year?

Well in practice, no, it just doesn’t really happen like that. 
Picture
Source: NASA - Hurricane Florence, from the International Space Station

Read More

<<Previous

    Author

    ​​I work as an actuary and underwriter at a global reinsurer in London.

    I mainly write about Maths, Finance, and Technology.
    ​
    If you would like to get in touch, then feel free to send me an email at:

    ​[email protected]

      Sign up to get updates when new posts are added​

    Subscribe

    RSS Feed

    Categories

    All
    Actuarial Careers/Exams
    Actuarial Modelling
    Bitcoin/Blockchain
    Book Reviews
    Economics
    Finance
    Forecasting
    Insurance
    Law
    Machine Learning
    Maths
    Misc
    Physics/Chemistry
    Poker
    Puzzles/Problems
    Statistics
    VBA

    Archives

    February 2025
    April 2024
    February 2024
    November 2023
    October 2023
    September 2023
    August 2023
    July 2023
    June 2023
    March 2023
    February 2023
    October 2022
    July 2022
    June 2022
    May 2022
    April 2022
    March 2022
    October 2021
    September 2021
    August 2021
    July 2021
    April 2021
    March 2021
    February 2021
    January 2021
    December 2020
    November 2020
    October 2020
    September 2020
    August 2020
    May 2020
    March 2020
    February 2020
    January 2020
    December 2019
    November 2019
    October 2019
    September 2019
    April 2019
    March 2019
    August 2018
    July 2018
    June 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    June 2017
    May 2017
    April 2017
    March 2017
    February 2017
    December 2016
    November 2016
    October 2016
    September 2016
    August 2016
    July 2016
    June 2016
    April 2016
    January 2016

  • Blog
  • Project Euler
  • Category Theory
  • Disclaimer