Introducing Historical Ratings
Finally, you might say, but I have updated the sql database of test results. It is much the same as it was, but has a number of indexes and duplicate columns, to improve search speeds.
It also includes two tables with historical ratings:
gamerating - which shows the calculation for each game.
rating - which, for each team, shows the change to their rating on a certain date.
Finally, because I put this online, there is now a search function to show ratings at any point in time. Further improvements will be forthcoming, but suggestions/requests are welcome.
Cricket - Ratings - Test
27th January, 2011 23:43:54