I have not completely reviewed your approach, but the first thing that jumps off the page at me is what appears to be a seasonal pattern that your method is not accounting for... look at June of each year for example. There is a significant drop off in roll rate each year at that time. I see this post is over two years old.. I am sure you have figured this out by now.
... View more