1. #1
    George7904
    George7904's Avatar Become A Pro!
    Join Date: 07-28-10
    Posts: 77

    Calculating Edge in 3-way Soccer lines

    How would one calculate the book edge on a soccer line? For instance, Pinnacle has
    Chile - Primera Division Soccer - Fri 3/18

    Universidad Catolica -220
    +639
    Santiago Morning +382


    How would I calcuate the true (no-juice odds?) Using this, I could calculate my edge if I could get Unic Catolica at, let's say -165.

  2. #2
    byronbb
    byronbb's Avatar Become A Pro!
    Join Date: 11-13-08
    Posts: 3,067
    Betpoints: 2284

    look at the sports betting functions for excel in the tools section

  3. #3
    CHUBNUT
    CHUBNUT's Avatar Become A Pro!
    Join Date: 06-30-09
    Posts: 321
    Betpoints: 7628

    its impossible to know the no vig line exactly as you dont know where the book is emphasizing its vig. the only time you can say it with any degree of certainty is on a game where the asian h'cap is pick. pinnys opening price on the draw will then be a at no vig.

  4. #4
    losturmarbles
    losturmarbles's Avatar Become A Pro!
    Join Date: 07-01-08
    Posts: 4,604

    Quote Originally Posted by CHUBNUT View Post
    its impossible to know the no vig line exactly as you dont know where the book is emphasizing its vig. the only time you can say it with any degree of certainty is on a game where the asian h'cap is pick. pinnys opening price on the draw will then be a at no vig.



    Then how do you know the book isn't "emphasizing" it's vig with a pick'em?

    And why would the asian handicap have any relevance to the amount of vig on the draw?

  5. #5
    George7904
    George7904's Avatar Become A Pro!
    Join Date: 07-28-10
    Posts: 77

    I couldn't get that Ganchrow excel template to load into my excel. I read the entire string and tried the advice, but it would not load. Anyone have another excel file or website? I found a vig caculator on the pinny calculator which gives the theoretical vig, but it doesn't backtrack it into a no juice line.

  6. #6
    losturmarbles
    losturmarbles's Avatar Become A Pro!
    Join Date: 07-01-08
    Posts: 4,604

    Quote Originally Posted by George7904 View Post
    I couldn't get that Ganchrow excel template to load into my excel. I read the entire string and tried the advice, but it would not load. Anyone have another excel file or website? I found a vig caculator on the pinny calculator which gives the theoretical vig, but it doesn't backtrack it into a no juice line.
    Just convert each US ml to probability. Then divide each line by the total of all three lines. That will give you a percentage or implied probability. That is the no vig line.
    Last edited by losturmarbles; 03-19-11 at 06:58 PM.

  7. #7
    Blax0r
    Blax0r's Avatar Become A Pro!
    Join Date: 10-13-10
    Posts: 688
    Betpoints: 1512

    Quote Originally Posted by losturmarbles View Post
    Just convert each US ml to probability. Then divide each line by the total of all three lines. That will give you a percentage or implied probability. That is the no vig line.
    This is exactly how to do it; probably only the first step is a little tricky (make sure to use the EV formula).

  8. #8
    goblue12
    goblue12's Avatar Become A Pro!
    Join Date: 02-08-09
    Posts: 1,316
    Betpoints: 453

    No vig odds would be...

    1: -200.56
    X: 661.38
    2: 396.6

  9. #9
    CHUBNUT
    CHUBNUT's Avatar Become A Pro!
    Join Date: 06-30-09
    Posts: 321
    Betpoints: 7628

    Quote Originally Posted by losturmarbles View Post



    Then how do you know the book isn't "emphasizing" it's vig with a pick'em?

    And why would the asian handicap have any relevance to the amount of vig on the draw?

    When the asian h'cap is PK then the action on the draw is at absolute minimum due to bettors not looking for an edge in the 3 way market. So books like Pinny who have little wiggle room go no vig the draw knowing its highly unlikely they will be caught out and keep their margin for movement on the home and away.

    If you need any other advice sonny just ask. Dont believe what all these model geeks on here keep spewing, its all fantasy.

  10. #10
    durito
    escarabajo negro
    durito's Avatar Become A Pro!
    Join Date: 07-03-06
    Posts: 13,173
    Betpoints: 438

    Quote Originally Posted by CHUBNUT View Post
    When the asian h'cap is PK then the action on the draw is at absolute minimum due to bettors not looking for an edge in the 3 way market. So books like Pinny who have little wiggle room go no vig the draw knowing its highly unlikely they will be caught out and keep their margin for movement on the home and away.

    If you need any other advice sonny just ask. Dont believe what all these model geeks on here keep spewing, its all fantasy.
    you are dumber than bigdaddyQH

  11. #11
    CHUBNUT
    CHUBNUT's Avatar Become A Pro!
    Join Date: 06-30-09
    Posts: 321
    Betpoints: 7628

    Quote Originally Posted by durito View Post
    you are dumber than bigdaddyQH
    I got 380 pts off you in one hit whos a dumb ****. instead of piping into posts telling people they're wrong, why dont you answer the question yourself. this place is full of smartasses like you who contribute zilch, constantly blowing hot air. why dont you and that don juan idiot get together for a weekend and bore each other to death and do everyone a favor.

  12. #12
    CHUBNUT
    CHUBNUT's Avatar Become A Pro!
    Join Date: 06-30-09
    Posts: 321
    Betpoints: 7628

    Soccer markets are a weekly thing so its all about info dictating the movements. If Pinnys M/L is within 3% of the true line then nothing is expected, however a margin of over 4-5% would suggest you need to look into the injuries of both teams. Sometimes you will find there is no reason for the difference and if Pinny is laying that, then its worth considering a bet that way, likewise be cautious if the betting is the other way.

  13. #13
    durito
    escarabajo negro
    durito's Avatar Become A Pro!
    Join Date: 07-03-06
    Posts: 13,173
    Betpoints: 438

    you need better translation software

  14. #14
    losturmarbles
    losturmarbles's Avatar Become A Pro!
    Join Date: 07-01-08
    Posts: 4,604

    Quote Originally Posted by CHUBNUT View Post
    When the asian h'cap is PK then the action on the draw is at absolute minimum due to bettors not looking for an edge in the 3 way market. So books like Pinny who have little wiggle room go no vig the draw knowing its highly unlikely they will be caught out and keep their margin for movement on the home and away.

    If you need any other advice sonny just ask. Dont believe what all these model geeks on here keep spewing, its all fantasy.
    Think about what you are saying. If a match has an asain handicap at pk, then the outcome is MORE likely to draw. Why would a sportsbook offer no vig odds on the draw when it's MORE likely to happen? Why would a sportsbook offer no vig odds to begin with?

  15. #15
    jgilmartin
    jgilmartin's Avatar Become A Pro!
    Join Date: 03-31-09
    Posts: 1,119

    Quote Originally Posted by CHUBNUT View Post
    I got 380 pts off you in one hit whos a dumb ****. instead of piping into posts telling people they're wrong, why dont you answer the question yourself. this place is full of smartasses like you who contribute zilch, constantly blowing hot air. why dont you and that don juan idiot get together for a weekend and bore each other to death and do everyone a favor.
    This coming from a guy who believes 'the opening line has already done the math for you'. Even if durito and donjuan never posted anything besides telling people they were wrong (which you will find isn't the case if you try using the search function), it would still be a better contribution than giving people completely wrong information, which you have done in this thread and others.

  16. #16
    CHUBNUT
    CHUBNUT's Avatar Become A Pro!
    Join Date: 06-30-09
    Posts: 321
    Betpoints: 7628

    Quote Originally Posted by losturmarbles View Post
    Think about what you are saying. If a match has an asain handicap at pk, then the outcome is MORE likely to draw. Why would a sportsbook offer no vig odds on the draw when it's MORE likely to happen? Why would a sportsbook offer no vig odds to begin with?
    losturmarbles, I dont want you to lose your marbles but. not everything in betting is mathematical, in fact its mostly psychological and regardless of odds, the draw in soccer is not a popular bet. Thats why years ago the books decided to invent asian h'cap which makes it easier for the bettor to understand but hides the significance of the draw. with the availability of betfair to lay, bettors are now looking for an edge in betting the draw at the best odds in order to maximize an asian bet on minus or plus 1/2 a goal, which increases the interest in the draw odds. outside that the draw is insignificant as a liability to a bookmaker, hence the reason for presenting it at no vig and holding their percentage on the other 2 and more likely bet propositions.

  17. #17
    losturmarbles
    losturmarbles's Avatar Become A Pro!
    Join Date: 07-01-08
    Posts: 4,604

    Quote Originally Posted by CHUBNUT View Post
    losturmarbles, I dont want you to lose your marbles but. not everything in betting is mathematical, in fact its mostly psychological and regardless of odds, the draw in soccer is not a popular bet. Thats why years ago the books decided to invent asian h'cap which makes it easier for the bettor to understand but hides the significance of the draw. with the availability of betfair to lay, bettors are now looking for an edge in betting the draw at the best odds in order to maximize an asian bet on minus or plus 1/2 a goal, which increases the interest in the draw odds. outside that the draw is insignificant as a liability to a bookmaker, hence the reason for presenting it at no vig and holding their percentage on the other 2 and more likely bet propositions.

    Betting may be psychological for some, but that doesn't change the probability of each outcome. Just because HEADS may be more popular than TAILS doesn't mean it's going to happen more or less than 50% of the time and it certainly doesn't mean a sportsbook is going to offer +100 odds on tails.

  18. #18
    CHUBNUT
    CHUBNUT's Avatar Become A Pro!
    Join Date: 06-30-09
    Posts: 321
    Betpoints: 7628

    Quote Originally Posted by jgilmartin View Post
    This coming from a guy who believes 'the opening line has already done the math for you'. Even if durito and donjuan never posted anything besides telling people they were wrong (which you will find isn't the case if you try using the search function), it would still be a better contribution than giving people completely wrong information, which you have done in this thread and others.
    Gilly,
    Ive read a lot of your posts and your not without sensibility. but your also falling into the trap of telling me I'm wrong without stating why and your alternatives, and thats whats wrong with these forums, too many jokers telling others their wrong without giving good reasons. Believe me ive been betting Soccer much longer than anyone on this site, my 79th bday is next month so sit back and take in what I say. if you have any questios then ask, thats what this forum is for. Not for egotistic jokers with no social life to belittle people without giving good reasons.

  19. #19
    CHUBNUT
    CHUBNUT's Avatar Become A Pro!
    Join Date: 06-30-09
    Posts: 321
    Betpoints: 7628

    sorry but I have to go now as I've pissed myself. usually a sign that I need to go to bed

  20. #20
    CHUBNUT
    CHUBNUT's Avatar Become A Pro!
    Join Date: 06-30-09
    Posts: 321
    Betpoints: 7628

    Quote Originally Posted by losturmarbles View Post
    Betting may be psychological for some, but that doesn't change the probability of each outcome. Just because HEADS may be more popular than TAILS doesn't mean it's going to happen more or less than 50% of the time and it certainly doesn't mean a sportsbook is going to offer +100 odds on tails.
    losturmarbles, I love your naivety. believe me, you need to look further than the math to win at sports betting. The human brain is better than any computer model, it just needs the emotional control that comes with it.

  21. #21
    losturmarbles
    losturmarbles's Avatar Become A Pro!
    Join Date: 07-01-08
    Posts: 4,604

    Quote Originally Posted by CHUBNUT View Post
    losturmarbles, I love your naivety. believe me, you need to look further than the math to win at sports betting. The human brain is better than any computer model, it just needs the emotional control that comes with it.
    Chubnut, I love your willful ignorance. You've made several claims in this thread and have yet to back them up. Maybe you should post some examples and I'll stop being so naive.

  22. #22
    CHUBNUT
    CHUBNUT's Avatar Become A Pro!
    Join Date: 06-30-09
    Posts: 321
    Betpoints: 7628

    Quote Originally Posted by losturmarbles View Post
    Chubnut, I love your willful ignorance. You've made several claims in this thread and have yet to back them up. Maybe you should post some examples and I'll stop being so naive.
    Your a fiesty bastard, bit like my grandson. lets look at a few of next weeks games. please dont argue with the numbers.

    true lines for the following M/Ls

    BIRMINGHAM 50.98
    NEWCASTLE 59.23
    WBA 51.59
    WIGAN 43.55

    most of them should be PK on the markets so the Pinny line for the draw will be no vig. come tuesday you use Pinnys draw line and work out the 3 way market. update tuesday

  23. #23
    losturmarbles
    losturmarbles's Avatar Become A Pro!
    Join Date: 07-01-08
    Posts: 4,604

    Quote Originally Posted by CHUBNUT View Post
    Your a fiesty bastard, bit like my grandson. lets look at a few of next weeks games. please dont argue with the numbers.

    true lines for the following M/Ls

    BIRMINGHAM 50.98
    NEWCASTLE 59.23
    WBA 51.59
    WIGAN 43.55

    most of them should be PK on the markets so the Pinny line for the draw will be no vig. come tuesday you use Pinnys draw line and work out the 3 way market. update tuesday
    can't find your matchups


  24. #24
    CHUBNUT
    CHUBNUT's Avatar Become A Pro!
    Join Date: 06-30-09
    Posts: 321
    Betpoints: 7628

    My Birmingham 50.98 equates to the brum vs bolton game in your caption. your caption shows a no vig line of brum 55.15% which has since moved to 53.81%. this basically tells you that at the moment there's no info out there affecting the true line. As the line progresses throughout the week you can tell whether its just general betting changing the odds or significant info, which will move the line at least 3%

  25. #25
    trixtrix
    trixtrix's Avatar Become A Pro!
    Join Date: 04-13-06
    Posts: 1,897

    convert all the (3 in this case but it really does not matter if there are more) lines to their implied probability, add them up and subtract 100%, the remaining portion is the bookie's hold

  26. #26
    CHUBNUT
    CHUBNUT's Avatar Become A Pro!
    Join Date: 06-30-09
    Posts: 321
    Betpoints: 7628

    Quote Originally Posted by trixtrix View Post
    convert all the (3 in this case but it really does not matter if there are more) lines to their implied probability, add them up and subtract 100%, the remaining portion is the bookie's hold
    the minute you use the word implied, you're a lost soul in the real world of betting.

  27. #27
    CHUBNUT
    CHUBNUT's Avatar Become A Pro!
    Join Date: 06-30-09
    Posts: 321
    Betpoints: 7628

    So just to finish off, once Pinny decides to issue they're 3 way line on the birmingham game, their draw odds will be at no vig. Unless the asian line moves over the 54% then the true line is a good pointer. 100% minus pinnys draw percentage x 50.98 = birminghams home price.
    easy stuff really, no need for heiroglifics or math equations that making landing on the moon look easy.

  28. #28
    Melloweitsj
    Melloweitsj's Avatar Become A Pro!
    Join Date: 05-08-08
    Posts: 26
    Betpoints: 1839

    Quote Originally Posted by CHUBNUT View Post
    the minute you use the word implied, you're a lost soul in the real world of betting.
    I fail to see why that is so.

  29. #29
    CHUBNUT
    CHUBNUT's Avatar Become A Pro!
    Join Date: 06-30-09
    Posts: 321
    Betpoints: 7628

    Quote Originally Posted by Melloweitsj View Post
    I fail to see why that is so.
    precisely you will see the light when you start thinking more abstractively

  30. #30
    durito
    escarabajo negro
    durito's Avatar Become A Pro!
    Join Date: 07-03-06
    Posts: 13,173
    Betpoints: 438

    how much $ you up lifetime chubby?

  31. #31
    CHUBNUT
    CHUBNUT's Avatar Become A Pro!
    Join Date: 06-30-09
    Posts: 321
    Betpoints: 7628

    Quote Originally Posted by durito View Post
    how much $ you up lifetime chubby?
    minus $ 1.35 mill

  32. #32
    losturmarbles
    losturmarbles's Avatar Become A Pro!
    Join Date: 07-01-08
    Posts: 4,604

    Quote Originally Posted by CHUBNUT View Post
    My Birmingham 50.98 equates to the brum vs bolton game in your caption. your caption shows a no vig line of brum 55.15% which has since moved to 53.81%. this basically tells you that at the moment there's no info out there affecting the true line. As the line progresses throughout the week you can tell whether its just general betting changing the odds or significant info, which will move the line at least 3%
    You're not making any sense. Brum is not playing Bolton. Wigan isn't listed. And the only pick'em is Birmingham/Bolten at -128/118 or no vig odds of -122.39/+122.39 (55.03%/44.97%)

  33. #33

  34. #34
    jgilmartin
    jgilmartin's Avatar Become A Pro!
    Join Date: 03-31-09
    Posts: 1,119

    Quote Originally Posted by losturmarbles View Post
    You're not making any sense. Brum is not playing Bolton. Wigan isn't listed. And the only pick'em is Birmingham/Bolten at -128/118 or no vig odds of -122.39/+122.39 (55.03%/44.97%)
    To be fair to him, Brum is playing Bolton. Brum is a nickname for Birmingham.

  35. #35
    losturmarbles
    losturmarbles's Avatar Become A Pro!
    Join Date: 07-01-08
    Posts: 4,604

    Quote Originally Posted by jgilmartin View Post
    To be fair to him, Brum is playing Bolton. Brum is a nickname for Birmingham.
    Fair enough. I assumed Brum was WBA.

123 Last
Top