I've created an Access database for storing soccer results and spitting out Poisson spreadsheets for individual matches. If anyone wants to try it here are the instructions:-
- Download the two attached 7z files and extract their contents to a suitable location. They were just slightly over the single file limit. They contain the following files:-
- Soccer Poisson.accdb - Front end database containing the forms and code.
- Soccer Poisson_BackEnd.accdb - Backend database containing empty tables for storing match data.
- 4 CSV files - Sample files containing current league results for importing into the database. I created 3 of them from data downloaded at https://fixturedownload.com
- Soccer Poisson.xltm - Excel template for outputting match data, must be stored in the same folder as Soccer Poisson.accdb
- Open your Access VBA editor and make sure the 6 reference libraries below are selected, otherwise the code won't compile.
- Make a copy or copies of Soccer Poisson_BackEnd.accdb, one for each league you're interested in.
- Open Soccer Poisson.accdb, the 'Connect Database' form should automatically open.
- Click ADD, select your backend database file and enter a name for your league.
- Select the database from the list box and click connect or double-click on the list box. You may receive four security warnings, one for each table that gets linked. You can then close the database connect form.
- Database
- Connect Database - Allows you to add, connect and remove backend databases.
- Import Matches - Allows you to import the sample CSV files. If you wish to create your own, the CSV must be without a header and in the form:
[D]D/[M]M/[YY]YY, home team, home score, away team, away score - Teams - Allows you to enter team names if you want to enter data manually at the start of a league. If you import results you may want to edit the team abbreviations. By default, West Brom and West Ham both abbreviate to WEST, and Arsenal becomes ARSE!
- Database Edit
- Results Entry - Manually enter results
- Last 7/30 Days and All - Allows you to view, edit and delete individual matches
- Delete Matches - For deleting old matches before a selected date
- Information
- League/Home/Away Table - Displays league tables. Can be used for verifying the accuracy of the match data.
- Calculate Poisson Dist - Allows you to select two teams and produce a Poisson spreadsheet.
Note for newbies: Don't have high expectations of these spreadsheets. It's just a tool that I made mainly as a toy to play with. It may help to give insight into a match or find inconsistencies in the market but it's certainly not designed to accurately predict what the odds should be.