It does! Very dramatic part of the book.
25 karma · joined June 2, 2017
Some good risk controls suggested here though: https://medium.com/@Austerity_Sucks/thoughts-on-110m-mango-m...
I think there could be scope to use ML on the pricing side however, while leaving the reserving models explainable to regulators.
But I have also had actuarial work that was closer to accounting than I would have liked. Certainly you have to pick your roles carefully - which is perhaps only feasible in large markets.
I have used excel as a data source using VBA before so one problem I had there that I'm curious how you approached was how to automatically determine data types? IIRC the ODBC engine in VBA scans a set amount of rows to guess. Are you doing anything different?