Betting on the footie.
For some years now I've been betting on the footie; the correct scores and outcomes (win, lose or draw) "markets" as the bookies euphemistically refer to them. Originally this was just the English and Scottish leagues, but more recently I've extended this to the the top divisions of the Bundesliga (x2), French league (x2), Spanish (x2), Italian (x2), Dutch and Portugese. To support my endeavours I've used what started out as a relatively simple series of spreadsheets but which over the last three seasons I've enhanced with various features, bells and whistles. Fundimentally I make selections as to the outcome of a match based upon the competing teams' recent performance and league table position. Over the last three seasons I've achieved a smidgeon less than breakeven (around 3%) which I think is fairly respectable bearing in mind the bookies' built in margins on the prices they quote. Goals scored in the last ten minutes of play and in injury time account for just about all of my losses and have a lot to answer for; the worst case was an equaliser scored in the 8th minute of injury time - I kid you not!
If betting on the football is your thing then you're very welcome to download my Excel efforts and use it yourself - with my compliments. It's free to use and is offered at no cost and with no conditions.
I've just updated it with the current table positions and forthcoming fixtures for all of the leagues mentioned above, as well as dropped in the finishing positions for the 19/20 season. You can download the file from the link at the bottom of this page.
As well as the current season's tables, recent team form data and last season's finishing positions, the file also contains a comprehensive set of instructions on how to use it, a running profit and loss summary and a dataset of comparative data extracted from five seasons' results and over 32,000 matches - so plenty to take account of when putting your pennies on the line. You'll need a 64-Bit version of Windows running Excel 2010 or later to be be able to use the workbook, and you'll also need to enable macros as the functionality is heavily automated. The file sitting on my web server has been thoroughly virus-checked using AVG, although I can't vouch for its safety if you obtain it from another source.
Below are some links to a few screenshots to whet your appetite (best viewed on an eighteen inch or wider monitor). Click on each for an enlarged view: