Your No.1 Betting & Poker Community 

Results 1 to 37 of 37
  1. #1
    Join Date
    16 Apr 2010
    Location
    Parts Unknown
    Age
    26
    Posts
    351
    Thanks
    10
    Thanked 59 Times in 38 Posts

    Default True Odds Calculator

    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...)

  2. Thanks from: 2

    Anka (13-08-2012),SilkBC (02-07-2012)

  3. #2
    Join Date
    16 Apr 2010
    Location
    Parts Unknown
    Age
    26
    Posts
    351
    Thanks
    10
    Thanked 59 Times in 38 Posts

    Default Re: True Odds Calculator

    Link:

    Http://alturl.com/5xpmj -- To see the rest of this message, please register. --

  4. #3
    Join Date
    15 Sep 2008
    Location
    The Restaurant at the End of the Universe
    Age
    37
    Posts
    195
    Thanks
    7
    Thanked 3 Times in 2 Posts

    Default Re: True Odds Calculator

    Quote Originally Posted by jamiedavies02 Link: Http://alturl.com/5xpmj Link didn't working
    -- To see the rest of this message, please register. --
    The mind is like a parachute. It doesn’t work unless it’s open.

  5. #4
    Join Date
    23 Oct 2003
    Location
    Belgium
    Age
    50
    Posts
    7,496
    Thanks
    15
    Thanked 91 Times in 63 Posts

    Default Re: True Odds Calculator

    I'd say your title is a bit misleading,
    it's not a true odds calculator is it,
    it is "an" odds calculator, but it doesn't give the "true" odds does it, they will forever remain part of the land of -- To see the rest of this message, please register. --
    If you stay in the game long enough, you'll see everything, win everything, and lose everything. www.punterindex.info

  6. #5
    Join Date
    16 Apr 2010
    Location
    Parts Unknown
    Age
    26
    Posts
    351
    Thanks
    10
    Thanked 59 Times in 38 Posts

    Default Re: True Odds Calculator

    The odds are true to me -- To see the rest of this message, please register. --

  7. #6
    Join Date
    10 Jun 2010
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Re: True Odds Calculator

    Link don't work..

    Datapunter I add u to msn live but seem u don't sign on.. -- To see the rest of this message, please register. --

  8. #7
    Join Date
    16 Apr 2010
    Location
    Parts Unknown
    Age
    26
    Posts
    351
    Thanks
    10
    Thanked 59 Times in 38 Posts

    Default Re: True Odds Calculator

    Alturl.com/yc52k and click download in the middle -- To see the rest of this message, please register. --

  9. #8
    Join Date
    15 Sep 2008
    Location
    The Restaurant at the End of the Universe
    Age
    37
    Posts
    195
    Thanks
    7
    Thanked 3 Times in 2 Posts

    Default Re: True Odds Calculator

    Quote Originally Posted by jamiedavies02 Alturl.com/yc52k and click download in the middle Ok now, I've just downloaded it, and I hope you
    -- To see the rest of this message, please register. --
    The mind is like a parachute. It doesn’t work unless it’s open.

  10. #9
    Join Date
    23 Oct 2003
    Location
    Belgium
    Age
    50
    Posts
    7,496
    Thanks
    15
    Thanked 91 Times in 63 Posts

    Default Re: True Odds Calculator

    @ jamiedavies, fair enough , good luck with it.



    @ buttasparks, my mother told me not to talk to strangers use the email adress from my profile -- To see the rest of this message, please register. --
    If you stay in the game long enough, you'll see everything, win everything, and lose everything. www.punterindex.info

  11. #10
    Join Date
    09 Feb 2009
    Posts
    367
    Thanks
    2
    Thanked 2 Times in 2 Posts

    Default Re: True Odds Calculator

    If your getting the data from football-data why not just do a screen dump into your file and let excel do the calculations?

    I made a databse using excel based on pulleins equations but found no -- To see the rest of this message, please register. --

  12. #11
    Join Date
    16 Apr 2010
    Location
    Parts Unknown
    Age
    26
    Posts
    351
    Thanks
    10
    Thanked 59 Times in 38 Posts

    Default Re: True Odds Calculator

    What is a screen dump and how do I do that? -- To see the rest of this message, please register. --

  13. #12
    Join Date
    02 Jul 2007
    Posts
    4,137
    Thanks
    3
    Thanked 11 Times in 8 Posts
    Awards: 2

    Default Re: True Odds Calculator

    Jamie,

    I don't see anything about what players are in the teams, is it a full strength squad? Whether each individual player is in form, out of form, coming back from injury, plays well with a
    -- To see the rest of this message, please register. --
    Last edited by Gingertipster; 22-09-2010 at 02:34.

  14. #13
    Join Date
    27 Nov 2006
    Posts
    284
    Thanks
    3
    Thanked 8 Times in 7 Posts

    Default Re: True Odds Calculator

    Just signing to thank jamie for the spreadsheet, I've been meaning to do one for the pullein stuff for a while as a useful benchmark for some of the models I have produced recently.

    Re. Pullein, he
    -- To see the rest of this message, please register. --

  15. #14
    Join Date
    19 Jul 2009
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Re: True Odds Calculator

    Really thanks for posting this, will be looking into it and hopefully testing it soon :-) I read the book too so this caught my eye. -- To see the rest of this message, please register. --

  16. #15
    Join Date
    09 Feb 2009
    Posts
    367
    Thanks
    2
    Thanked 2 Times in 2 Posts

    Default Re: True Odds Calculator

    A screen dump is basically a big copy and paste job.

    It will take the data from the football data sheets (already in excel) and you can then extract what you want from it. Saves a lot of time and -- To see the rest of this message, please register. --

  17. #16
    Join Date
    16 Apr 2010
    Location
    Parts Unknown
    Age
    26
    Posts
    351
    Thanks
    10
    Thanked 59 Times in 38 Posts

    Default Re: True Odds Calculator

    Thats what I've been doing! What I meant was once all the stats are copied and pasted, I was manually inputting the formula to calculate the averages every time. However since posting I have edited
    -- To see the rest of this message, please register. --

  18. #17
    Join Date
    09 Feb 2009
    Posts
    367
    Thanks
    2
    Thanked 2 Times in 2 Posts

    Default Re: True Odds Calculator

    The best site I found for referees was bbc.co.uk -- To see the rest of this message, please register. --

  19. #18
    Join Date
    16 Apr 2010
    Location
    Parts Unknown
    Age
    26
    Posts
    351
    Thanks
    10
    Thanked 59 Times in 38 Posts

    Default Re: True Odds Calculator

    Linkage? Can't seem to find the referees! -- To see the rest of this message, please register. --

  20. #19
    Join Date
    16 Apr 2010
    Location
    Parts Unknown
    Age
    26
    Posts
    351
    Thanks
    10
    Thanked 59 Times in 38 Posts

    Default Re: True Odds Calculator

    Forgot to add, I you open the how many goals/ corners/ bookings tabs, the expectations can be used to squeeze some value on the spreads -- To see the rest of this message, please register. --

  21. #20
    Join Date
    16 Apr 2010
    Location
    Parts Unknown
    Age
    26
    Posts
    351
    Thanks
    10
    Thanked 59 Times in 38 Posts

    Default Re: True Odds Calculator

    It's been a month since I posted the spreadsheet, has anybody got any suggestions to improve it? Or just any feedback in general? -- To see the rest of this message, please register. --

  22. #21
    Join Date
    08 Feb 2005
    Location
    Newcastle Upon Tyne.
    Age
    41
    Posts
    8,273
    Thanks
    14
    Thanked 30 Times in 26 Posts

    Default Re: True Odds Calculator

    You know, I've only just looked at this.

    Interesting, I might think about incorporating the value aspect of match odds from this into my football system. -- To see the rest of this message, please register. --
    "You're just another Internet crazy, or village idiot, claiming that cows fly at night when nobody sees them, Elvis Presley is working as a sales clerk in Millwall, that George Bush was frequently abducted by aliens during his time as president."

    http://forum.punterslounge.com/threads/152264-Fleet-s-Trebles-amp-Perms

  23. #22
    Join Date
    17 May 2010
    Posts
    616
    Thanks
    80
    Thanked 122 Times in 107 Posts

    Default Re: True Odds Calculator

    Quote Originally Posted by jamiedavies02 It's been a month since I posted the spreadsheet, has anybody got any suggestions to improve it? Or just any
    -- To see the rest of this message, please register. --

  24. #23
    Join Date
    27 May 2010
    Posts
    26
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Smile Re: True Odds Calculator

    I would just like to say a big thank you as this will greatly help my analysis cant thank you enough

    i have downloaded the excel sheet a few of the terms I am not sure of when inputting data such as -- To see the rest of this message, please register. --

  25. #24
    Join Date
    08 Jan 2010
    Posts
    132
    Thanks
    1
    Thanked 5 Times in 5 Posts

    Default Re: True Odds Calculator

    Damn, when I try to open it it just opens an IE window with all this:


    -
    -- To see the rest of this message, please register. --

  26. #25
    Join Date
    08 Jan 2010
    Posts
    132
    Thanks
    1
    Thanked 5 Times in 5 Posts

    Default Re: True Odds Calculator


    -

    -- To see the rest of this message, please register. --

  27. #26
    Join Date
    08 Jan 2010
    Posts
    132
    Thanks
    1
    Thanked 5 Times in 5 Posts

    Default Re: True Odds Calculator

    Ok well I can't paste it but it's a load of jumbled up text ?? -- To see the rest of this message, please register. --

  28. #27
    Join Date
    16 Apr 2010
    Location
    Parts Unknown
    Age
    26
    Posts
    351
    Thanks
    10
    Thanked 59 Times in 38 Posts

    Default Re: True Odds Calculator

    Quote Originally Posted by Gooner80 I would just like to say a big thank you as this will greatly help my analysis cant thank you enough i have downloaded
    -- To see the rest of this message, please register. --

  29. #28
    Join Date
    26 Sep 2008
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Re: True Odds Calculator

    Thank you for the spreadsheet Jamie,

    There seems to be something wrong with the correct score odds. I see they're taken from a table in which the lowest 0:0 odds are >11 which cannot be right, or am -- To see the rest of this message, please register. --

  30. #29
    Join Date
    11 Jun 2009
    Posts
    98
    Thanks
    0
    Thanked 1 Time in 1 Post

    Default Re: True Odds Calculator

    Sheet looks good and easy to use.

    The only suggestion I would make is to change the input sheet a bit, if you added a P (played) column, then you could avoid having to calculate all the averages
    -- To see the rest of this message, please register. --

  31. #30
    Join Date
    16 Apr 2010
    Location
    Parts Unknown
    Age
    26
    Posts
    351
    Thanks
    10
    Thanked 59 Times in 38 Posts

    Default Re: True Odds Calculator

    Since posting the spreadsheet a few months ago, Ive made some change with regards the input. You can now copy and paste goals, corners and bookings straight from the football-data spreadsheet and all
    -- To see the rest of this message, please register. --

  32. #31
    Join Date
    09 Nov 2011
    Posts
    99
    Thanks
    32
    Thanked 4 Times in 4 Posts

    Default Re: True Odds Calculator

    Good afternoon,

    I am trying to download the spreadsheet and is corrupt, can anyone upload it again?

    Thank you. -- To see the rest of this message, please register. --

  33. #32
    Join Date
    23 Feb 2012
    Posts
    26
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Default Re: True Odds Calculator

    indeed, anyone? -- To see the rest of this message, please register. --

  34. #33
    Join Date
    08 Feb 2005
    Location
    Newcastle Upon Tyne.
    Age
    41
    Posts
    8,273
    Thanks
    14
    Thanked 30 Times in 26 Posts

    Default Re: True Odds Calculator

    Think I've uploaded the right file:

    http://filebeam.com/0c8526bcd2b0ecabfad955a370440b21 -- To see the rest of this message, please register. --
    "You're just another Internet crazy, or village idiot, claiming that cows fly at night when nobody sees them, Elvis Presley is working as a sales clerk in Millwall, that George Bush was frequently abducted by aliens during his time as president."

    http://forum.punterslounge.com/threads/152264-Fleet-s-Trebles-amp-Perms

  35. Thanks from: 4

    adigordon (15-02-2013),Anka (13-08-2012),benzi (05-01-2013),froment (28-03-2012)

  36. Join Date
    22 Jan 2012
    Location
    Kazakhstan
    Age
    35
    Posts
    21
    Thanks
    19
    Thanked 1 Time in 1 Post

    Default Re: True Odds Calculator

    hi have anybody test this true odds calculator? -- To see the rest of this message, please register. --

  37. #35
    Join Date
    02 Sep 2008
    Posts
    10
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Default Re: True Odds Calculator

    Hi Jamie.

    I have been able to download this spreadsheet and have a look at it. Most of it makes sense, except for the "First Goalscorer" calculations. The "FIRSTGOALSCORER" -- To see the rest of this message, please register. --

  38. #36
    Join Date
    09 Nov 2011
    Posts
    99
    Thanks
    32
    Thanked 4 Times in 4 Posts

    Default Re: True Odds Calculator

    Good afternoon,

    I like this utility. I would like to complete a bit if this were possible, automaticando data capture. I ask.

    Does anyone know where to get site data such as which positions are
    -- To see the rest of this message, please register. --

  39. #37
    Join Date
    12 Oct 2012
    Age
    29
    Posts
    45
    Thanks
    5
    Thanked 1 Time in 1 Post

    Default Re: True Odds Calculator


    £50 Free Bet!
    Evertonboy Where can I get the data for this soft? I want to calculate a few matches.sorry for my English.

    -- To see the rest of this message, please register. --

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

PuntersLounge.com supports responsible gambling. For more information visit GamCare, Gamble Aware and Gamblers Anonymous. Over 18's only.