Spreadsheet for correct scores / true odds

[uknowsit]

Hi all, well I’ve been lurking around these forums for a while now. I’ve learned a fair bit from reading several threads and replies to my threads and have also received a great deal of help along the way. I’d consider my excel skills to be quite good and I’ve developed a spreadsheet that can predict the scoreline of fixtures and also generate “true odds” of each game. I’ve managed to adapt the sheets to enable me to backtest results in real time (as they would’ve happened). I have done this for the following leagues: Belgian x 1 Czech x 1 German x 2 English x 4 French x 2 Greek x 1 Italian x 2 Japanese x 1 Dutch x 1 Norwegian x 1 Polish x 1 Portuguese x 1 Spanish x 1 Swedish x 1 Turkish x 1 Each file is about 4.5mg in size, and have been built in excel 2007. I have uploaded an example one of the French 1st division from last season (09-10) to a web hosting site http://www.woofiles.com/dl-239767-Vs6Unkbk-FR1Example.xlsm I have displayed just the main screen of results for this example. The normal sheets also contain league tables (both actual, predicted, and user predicted), as well as previous h2h scores. I’m not stuck as to what to do. I’ve complied all the data, and am trying to find profitable ways of using the data going forward – being wary of data mining and back fashioning things. The one set of data not readily available is the correct score data for previous games, so its hard to analyse just how profitable correct score betting would’ve been. I’m also contemplating setting up a website or email circular where people could obtain the sheets (possibly for a low fee to cover the hosting costs). Would just like to hear people’s views, questions or suggestions. (just to explain the sheet columns from left to right, date of game, home team, away team, home goals scored, away goals scored, full time result, full time prediction, user predict home score, user predict away score, home odds, draw odds, away odds – all odds from bet explorer, home “true” odds, draw “true” odds, away “true” odds, goals galore odds – odds of both teams scoring).

[Evertonboy]

Re: Spreadsheet for correct scores / true odds Link doesnt't work :eyes