True Odds Calculator

[Evertonboy]

I have decided that I am going to make my true odds calculator available for download (I'm at work at the moment so it will be tonight before it's available) Background I have created a spreadsheet that uses formulae that Kevin Pullien (columnist/ tipster for the Racing Post) has developed using thousands of matches worth of data. All the formulae used can be found in the book "a guide to betting on football" by Pullien. I'm not going to go in to detail into how the formulae work, you'll have to buy the book for that.* I have created an Input sheet where all the relevant data used in the formula needs to be entered and a output sheet, where all the calculated odds are presented. There are numerous hidden tabs in which all the formula and workings out for various markets. (these are hidden as you'll never need to edit any of them and all the results are on te output page) So, what can the spreadsheet work out? At the moment, I can find true odds on the following markets; 90 mims betting (12X)) Under/ Over 1.5 Goals Under/ Over 2.5 Goals Under/ Over 3.5 Goals Total booking points Total corners First team to score First player to score Correct score What do I need to input? For all markets to be calculated the following needs to be input on the input page: (For all stats I tend to use data from current and previous season) Both teams WDL record Both teams goals for and against average (home team FA at home and away team FA away) Both teams corners for and against average*(home team FA at home and away team FA away) Both teams bookings for and against average*(home team FA at home and away team FA away) (for teams promoted or relegated the previous season, there is a table showing the values to be entered in WLD section rather than the previous seasons data) As well as this data for both teams, I need to enter the following data about the match; Is it at a neutral venue? Y/ N Referee average bookings per game Average bookings per game for the league Average corners per game for the league (the corners and bookings average are on the input page in a separate table, you simply copy the relevant leagues data) At the moment, I'm getting all the data I need for corners, bookings and the referee from the *football-data website. However, I then have to work out all the averages myself (using the sort function and alot of cutting and pasting). The other data such as WLDFA I'm getting from statto but again I have to work the averages for te FA myself. I feel this area can be improved as it can be quite time consuming. So any suggestions welcome. *I would also appreciate any other suggestions that people may have. (spreadsheet to follow...)

[Evertonboy]

Re: True Odds Calculator Link: Http://alturl.com/5xpmj