Wednesday, December 25, 2013

Soccer - Converting 1x2 Moneyline Into Asian Handicap

Variables
P(Aw) = Probability of team A winning
P(d) = Probability of draw
P(Bw) = Probability of team B winning
P(A|1) = Probability of Team A winning by exactly 1 goal = 0.191856-0.30565416*x+1.42165*x^2-1.21885522*x^3, where x=P(Aw)
P(A|2) = Probability of Team A winning by exactly 2 goals = 0.13482-0.553848*x+1.71645*x^2-1.08417508*x^3, where x=P(Aw)
TO(A|X) = True decimal odds of team A with handicap X

True Odds, A[1]










Notes and Sources
[1] To find true odds of Team B, use the following equation: 1-TO(A|X).

443 comments:

  1. I'm curious how you derived these equations. They don't include a game total, which affects the scoring distribution (the higher the total, the more likely a team is to win by more than one goal).

    ReplyDelete
    Replies
    1. The data was given to me by Mark Taylor of bettingexpert.com, and I used excel to make the trendline.

      Delete
    2. This comment has been removed by the author.

      Delete
    3. to Moose Jester. please send me the excel to. Suntisouk95@gmailcom. because i don't know how to put the formulars into excel. thank you very much

      Delete
    4. please send me the formula 1x2 excel to thanakom2017@gmail.com thank you

      Delete
    5. please send me the formula 1x2 excel to oom1596@gmail.com thank you very much.

      Delete
    6. please send me the formula 1x2 excel to yamashita_horse@hotmail.com thank you very much.

      Delete
    7. to Moose Jester. please send me the excel to. theung8736@gmailcom. because i don't know how to put the formulars into excel. thank you very much

      Delete
    8. to Moose Jester. please send me the excel to. bangkok2600@gmailcom. because i don't know how to put the formulars into excel. thank you very much

      Delete
    9. to Moose Jester. please send me the excel to. smigo16781@gmailcom. because i don't know how to put the formulars into excel. thank you very much

      Delete
    10. to Moose Jester. please send me the excel to. russynb@gmailcom. because i don't know how to put the formulars into excel. thank you very much

      Delete
    11. To Moose Jester,please send me the Excel File to pockfedx@gmail.com ,Thank you so much

      Delete
    12. Please send me the formula 1x2 excel to
      kung1987kung@gmail.com
      thank you very much. I want this formula so much.Thanks

      Delete
    13. Please send me the formula 1x2 excel to wasan.non024@gmail.com thank you very much. I want this formula so much.Thanks

      Delete
    14. Please send me the formula 1x2 excel to ufo.few@gmail.com thank you very much. I want this formula so much.Thanks

      Delete
    15. Please send me the formula 1x2 excel narin.sriyothee@gmail.com thank you very much. I want this formula so much.Thanks.

      Delete
    16. please send me the formula 1x2 excel to aunjio48@gmail.com than you very much.

      Delete
    17. please send me the formula 1x2 excel to sakulwong.jasmine@gmail.com Thank you so much

      Delete
    18. please send me the formula 1x2 excel to nuttiszview@gmail.com than you very much.

      Delete
    19. ปรดส่งสูตร 1x2 excel ให้กับ toot254130@gmail.com

      Delete
    20. Please send me the formula 1x2 excel tanakornmeesomboon@gmail.com thank you very much. I want this formula so much.Thanks.

      Delete
    21. Moose Jester. please send me the formula 1x2 excel file to imfinishz@gmail.com

      thank you very much

      Delete
    22. This comment has been removed by the author.

      Delete
    23. please Forward mail to me at boonloso@gmail.com thank you very much.

      Delete
    24. please send me the formula 1x2 excel to mafrong98@gmail.com thank you very much.

      Delete
    25. please send me the formula 1x2 excel to pepudfr2@gmail.com Thank you so much

      Delete
  2. The formula P (A | 1). You put the number 1.42165 with 1.21885522 from where I do not understand these two.

    ReplyDelete
  3. I don't understand. 1-TO(A|X)
    Can you please give me an example?

    ReplyDelete
  4. This comment has been removed by the author.

    ReplyDelete
  5. Can you understand the formula P (A | 1)? 1-TO (A | X) to find the probability and then take the formula to calculate the cleansing.

    ReplyDelete
    Replies
    1. This comment has been removed by the author.

      Delete
  6. I find the probability already. But I do not know how to enter the recipe. How do I write equations? 1- to A | X

    ReplyDelete
    Replies
    1. You teach how to think Formula P (A | 1) let me I think I can tell you.

      Delete
    2. I do not know how to enter the recipe. How do I write equations? 1- to A | X

      Delete
    3. ช่วยทีครับ

      Delete
    4. สรุปพิมพ์สูตร1- to A | X ยังไงหรอครับ รบกวนบอกหน่อยครับ

      Delete
    5. 1- to A | X ทำยังไงครับ

      Delete
  7. Replies
    1. This comment has been removed by the author.

      Delete
  8. Hey bro , I interesting your Converter. But i don't know. how it's working? and How to Make excel table? Can u give example trendline for me? Thanks bro.

    ReplyDelete
  9. [1] To find true odds of Team B, use the following equation: 1-TO(A|X)

    can u give equation team B?

    ReplyDelete
    Replies
    1. Replace P(Aw) by P(Bw) in all equations. Want to chat with you to find true equation in AH -1.75.

      Delete
    2. hi Phanas Taos
      I try to replace as your said but they have started wrong since -0.25. Please recommend or send me your file at asiaartwork.sales@gmail.com. Thank you very much.

      Delete
    3. please send me the formula 1x2 excel to mafrong98@gmail.com thank you very much.

      Delete
    4. please send me the formula 1x2 excel to mafrong98@gmail.com thank you very much.

      Delete
  10. Who can give me true odds of Team B equation ?? plz

    ReplyDelete
  11. sorry plese you send formula1x2 excel to aof.2539@hotmail.com thnakyou

    ReplyDelete
  12. please send me the formula 1x2 excel to suntisouk95@gmail.com than you very much.

    ReplyDelete
  13. please send me formula 1x2 excel to makun_bkk@hotmail.com thank you sir ^^

    ReplyDelete
  14. Please describe in detail this message. To find true odds of Team B, use the following equation: 1-TO(A|X) thank you

    ReplyDelete
  15. This comment has been removed by the author.

    ReplyDelete
  16. please send me the formula 1x2 excel to ternchat@gmail.com than you very much.

    ReplyDelete
  17. please send me the formula 1x2 excel to phouttasone.bo16@gmail.com thank you very much.

    ReplyDelete
  18. This formula is not right because odds 1x2noOf course
    I tried it already.
    If you guys know the time Odds1x2 at Of course
    tell me the formula 1x2 excel Contact tonlove.hf@gmail.com
    for you Go try it out

    ReplyDelete
  19. Formula "TO(A|-1.75)" is wrong ?

    ReplyDelete
  20. please send me the formula 1x2 excel to kai.sonrak@gmail.com than you very much.

    ReplyDelete
  21. sorry plese you send formula1x2 excel to paphot71745@gmail.com thnakyou

    ReplyDelete
  22. to Moose Jester. please send me the excel to. Borrasit.pamoota@gmailcom. because i don't know how to put the formulars into excel. thank you very much

    ReplyDelete
  23. to Moose Jester please send me the formula 1x2 excel to toty47859@gmail.com than you very much.

    ReplyDelete
    Replies
    1. to Moose Jester please send me the formula 1x2 excel to toty47859@gmail.com thank you very very much.

      Delete
    2. please send me the formula 1x2 excel to mafrong98@gmail.com thank you very much.

      Delete
  24. sorry plese you send formula1x2 excel to gootangGuitar@gmail.com thankyou.

    ReplyDelete
  25. This comment has been removed by the author.

    ReplyDelete
  26. Please send me the formula 1x2 excel to goodlytak2537@gmail.com
    thank you very much. I want this formula so much.Thanks

    ReplyDelete
  27. please send me the formula 1x2 excel to sawat_sin@hotmail.co.th thank you

    ReplyDelete
  28. Please send me the formula 1x2 excel to Gking59zi@gmail.com
    thank you very much. I want this formula so much.Thanks

    ReplyDelete
  29. please send me the formula 1x2 excel to san_p19@hotmail.co.th

    ReplyDelete
  30. This comment has been removed by the author.

    ReplyDelete
  31. please send me the formula 1x2 excel to thanakom2017@gmail.com thank you

    ReplyDelete
  32. Hey bro , I interesting your Converter. But i don't know.
    thanks for sharing...

    www.golden-slot.com
    gclub
    GCLUB CASINO
    gclub online

    ReplyDelete
  33. please send me the formula 1x2 excel to lyvongsapao@gmail.com thank you very much.

    ReplyDelete
  34. please send me the formula 1x2 excel to lyvongsapao@gmail.com thank you very much.

    ReplyDelete
  35. This comment has been removed by the author.

    ReplyDelete
  36. please send me the formula 1x2 excel to bunchoo2802@gmail.com thank you

    ReplyDelete
  37. please send me the formula 1x2 excel to 6x9pen54@gmail.com thank you

    ReplyDelete
  38. please send me the formula 1x2 excel to jirapat31130@gmail.com thank you

    ReplyDelete
  39. please send formula 1x2 excel to seoinw1@gmail.com thank you.

    ReplyDelete
  40. please send me the formula 1x2 excel to boomashi@gmail.com than you very much.

    ReplyDelete
  41. please send formula 1x2 excel to yut14409@gmail.com thank you.

    ReplyDelete
  42. please send me the formula 1x2 excel to onlytengg@gmail.com than you very much

    ReplyDelete
  43. please send me the formula 1x2 excel to noombcc@hotmail.com thank you

    ReplyDelete
  44. please send me the formula 1x2 excel to po_jack@hotmail.com
    thank you very much.

    ReplyDelete
  45. please send me the formula 1x2 excel to yothkt@gmail.com
    thank you very much.

    ReplyDelete
  46. please send me the formula 1x2 excel to guitar-nantasuk@hotmail.com
    thank you very much.

    ReplyDelete
  47. please send me the formula 1x2 excel to c.noppawat@gmail.com
    thank you very much.

    ReplyDelete
  48. please send me the formula 1x2 excel to theung8736@gmail.com
    thank you very much.

    ReplyDelete
  49. กับมูสเจสเตอร์ กรุณาส่งฉันไปที่ excel
    tonzacnw1978@gmail.com เพราะฉันไม่รู้ว่าจะใส่สูตรให้เป็น excel ได้อย่างไร ขอบคุณมาก

    ReplyDelete
  50. please send the formula 1x2 convert excel to taosphanas@gmail.com

    ReplyDelete
  51. This comment has been removed by the author.

    ReplyDelete
    Replies
    1. plese you send formula1x2 excel to onkham.success999@gmail.com thank you.

      Delete
  52. please send me the formula 1x2 excel to onkham.success999@gmail.com
    thank you very much.

    ReplyDelete
  53. Please send me the formula 1x2 excel to mo_adirek@hotmail.com
    thank you very much. I want this formula so much.Thanks

    ReplyDelete
  54. please send me the formula 1x2 excel to por1251@gmail.com
    thank you very much.

    ReplyDelete
  55. please send me the formula 1x2 excel to Rangsiman.tom@gmail.com
    thanks you very much. I want that so much.

    ReplyDelete
  56. please send me the formula 1x2 excel to tonkao2535@gmail.com
    thanks you very much. I want that so much.

    ReplyDelete
  57. please send me the formula 1x2 excel to svtautomax@gmail.com thank you very much.

    ReplyDelete
  58. please send me the formula 1x2 excel to joun.com@gmail.com

    ReplyDelete
  59. please semd me the formula to anzero191@gmail.com i dont know how to make it in excel

    ReplyDelete
  60. please send me the formula 1x2 excel to tong_treephet@hotmail.com thank you very much.

    ReplyDelete
  61. please send me the formula 1x2 excel to tong_treephet@mail.com thank you very much.

    ReplyDelete
  62. what do you mean: 1- to A | X please explain to me

    ReplyDelete
  63. please send me the formula 1x2 excel to channarong_v@hotmail.com thank you very much.

    ReplyDelete
  64. please send me formula 1x2 excel to kruengthip@gmail.com thank you sir

    ReplyDelete
  65. please send me the formula 1x2 excel to "jug.preaw@gmail.com" thank you very much.

    ReplyDelete
  66. please send me the formula 1x2 excel to Nuttapongcream@gmail.com thank you very much.

    ReplyDelete
  67. please send me the formula 1x2 excel to natdanai255530@gmail.com thank you very much.

    ReplyDelete
  68. Please send me the formula 1x2 excel to rawanna.withaya@gmail.com
    thank you very much. I want this formula so much.Thanks

    ReplyDelete
  69. please send me formula 1x2 excel to phaen004too@hotmail.com thank you sir

    ReplyDelete
  70. please send me formula 1x2 excel to golfe45@hotmail.com thank you sir

    ReplyDelete
  71. Please send me the formula 1x2 excel to
    kung1987kung@gmail.com
    thank you very much. I want this formula so much.Thanks

    ReplyDelete
  72. please send me the formula 1x2 excel to sarawoot.max@gmail.com thank you very much.

    ReplyDelete
  73. This comment has been removed by the author.

    ReplyDelete
  74. Please send me the formula 1x2 excel to wasan.non024@gmail.com thank you very much. I want this formula so much.Thanks

    ReplyDelete
    Replies
    1. ได้ทีม B ยังครับ

      Delete
    2. Please send me the formula 1x2 excel to kalato_joe@hotmail.com

      Delete
  75. 1-TO(A|X) สมการนี้ยังไงครับ ทีม B

    ReplyDelete
    Replies
    1. ยากหน่อยครับ คนที่ได้ทีมBก็ไม่ยอมปล่อย งมกันต่อไป ผมก็เช่นกัน

      Delete
    2. ได้ทีม B ถึงแค่ 0.5 เองใครได้มากกว่านี้ แชร์หน่อยครับ

      Delete
    3. ขอสูตรทีม B บ้างสิค่ะ

      Delete
    4. TO(B|0)=
      TO(B|-0.25)=
      TO(B|-0.5)=
      TO(B|-0.75)=
      TO(B|-1)=
      TO(B|-1.25)=
      TO(B|-1.5)=
      TO(B|-1.75)=
      TO(B|-2)=

      Delete
    5. ช่วยแชร์ สูตร 0.5 ให้ที่ครับ ผมได้แค่ 0 เอง จะได้เอามาช่วยวิเคราะห์แนวทางต่อครับ asiaartwork.sales@gmail.com

      Delete
    6. ส่งสูตรให้หน่อยครับ เพื่อช่วยแกะ
      atiwadboonkum@gmail.com

      Delete
    7. ส่งสูตรให้หน่อยครับ เพื่อช่วยแกะ
      atiwadboonkum@gmail.com

      Delete
    8. มีใครห่าทีมB ได้บ้างแล้ว รบกวนช่วยกันโพสต์ให้ดูหน่อยครับ ได้ช่วยกันตรวจสอบว่าถูกต้องหรือไม่ ขอบคุณครับ

      Delete
    9. please send me the formula 1x2 excel to mafrong98@gmail.com thank you very much.

      Delete
    10. This comment has been removed by the author.

      Delete
    11. TO(A-1.75)=[1-P(Al2)/2] / [P(Aw)-P(Al1)-P(Al2)/2]

      TO(B-0.00)=[1-P(d)] / P(Bw)
      TO(B-0.25)=[1-P(d)/2] / [P(Bw)+P(d)/2]
      TO(B-0.50)=1- / [P(Bw)+P(d)]

      Delete
    12. This comment has been removed by the author.

      Delete
    13. https://drive.google.com/file/d/0B0OrqhVJH4fqTFExVWJ1OGtFeXM/view?usp=sharing

      Delete
  76. Your blog is very useful for me.I really like you post,Thanks for sharing.

    ดูหนัง

    ReplyDelete
  77. to Moose Jester. please send me the excel to nmjtt4321@gmail.com. because i don't know how to put the formulars into excel. thank you very much

    ReplyDelete
  78. to Moose Jester, i created an excel to use this formula but in AH -1.75 was error. How can be fix it?

    ReplyDelete
  79. I try again. and i find another way to calculate in AH -1.75.
    there is: {1-P(A|2)/2}/{P(Aw)-P(A|1)-P(A|2)/2}
    example: P(Aw)=39.2% Pd=28.4% so AH -1.75 is 8.06.
    Is it true? Please tell me, thanks a lot.

    ReplyDelete
    Replies
    1. TO(B|0)=
      TO(B|-0.25)=
      TO(B|-0.5)=
      TO(B|-0.75)=
      TO(B|-1)=
      TO(B|-1.25)=
      TO(B|-1.5)=
      TO(B|-1.75)=
      TO(B|-2)=

      Delete
  80. ขอ สูตร excell 1x2 ด้วยครับ thanayu.peu@gmail.com

    ReplyDelete
  81. กรุณาส่งสูตร 1x2 excel มาที่ bas_liverpool@hotmail.com

    ReplyDelete
  82. Please send me the formula 1x2 excel to pkritgaming@gmail.com

    ReplyDelete
  83. This comment has been removed by the author.

    ReplyDelete
  84. please send me the formula 1x2 excel to aunjio48@gmail.com than you very much.

    ReplyDelete
  85. กรุณาส่งสูตร 1x2 excel มาที่ witthayatoto2533@gmail.com ขอบคุณมากค่ะ ฉันอยากได้สูตรนี้มาก

    ReplyDelete
  86. please send me the formula to ton450cc@gmail.com thank you very much.

    ReplyDelete
  87. Please send me the formula 1x2 excel to usarmyman_cj@hotmail.com thank you very much. I want this formula so much.Thanks

    ReplyDelete
  88. please send me the formula 1x2 excel to tui8882@gmail.com thank you very much.

    ReplyDelete
  89. Pls. send excel file to me.
    yanaungmaungmaungtoke@gmail.com

    ReplyDelete
  90. This comment has been removed by the author.

    ReplyDelete
  91. Pls. send excel file to me. Thanks
    yanaungmaungmaungtoke@gmail.com

    ReplyDelete
  92. This comment has been removed by the author.

    ReplyDelete
  93. Please send me the formula 1x2 excel to
    waan504@gmail.com
    thank you very much. I want this formula so much.Thanks

    ReplyDelete
  94. please send me the formula to pol.giffarine@gmail.com thank you very much.

    ReplyDelete
  95. Please send me the formula 1x2 excel to jaysiam45@gmail.com
    thank you very much. I want this formula so much.Thanks

    ReplyDelete
  96. Please send formula excel to merfy@gmail.com

    ReplyDelete
  97. Please send formula excel to
    tumstiyabut@gmail.com

    ReplyDelete
  98. Please send formula excel to
    Praphaphrsarakic512@gmail.com

    ReplyDelete
  99. to Moose Jester. please send me the excel to. apiyooth45@gmail.com. because i don't know how to put the formulars into excel. thank you very much

    ReplyDelete
  100. please send me the formula 1x2 excel to mac_2528@hotmail.com thank you very much

    ReplyDelete
  101. please send me the formula 1x2 excel to thanakrit3552@hotmail.com thank you very much

    ReplyDelete
  102. please send me the formula 1x2 excel to apinadchantasen@gmail.com
    thank you very much

    ReplyDelete
  103. please send me the formula 1x2 excel to thanak krisada369@gmail.com thank you very much

    ReplyDelete
  104. Dear Moose Jester,

    Please send me the excel to sup.saelee@gmail.com, because i don't know how to put the formulars into excel.

    Thank you very much
    James

    ReplyDelete
  105. please send me the formula 1x2 excel to thanak to_p007@hotmail.com thank you very much

    ReplyDelete
  106. Please send me the formula 1x2 excel to sithuwailinn@gmail.com thank you very much. I want this formula so much.Thanks

    ReplyDelete
  107. This comment has been removed by the author.

    ReplyDelete
  108. ขอสูตรทีมรองหน่อยค่ะ
    TO(B|0)=
    TO(B|-0.25)=
    TO(B|-0.5)=
    TO(B|-0.75)=
    TO(B|-1)=
    TO(B|-1.25)=
    TO(B|-1.5)=
    TO(B|-1.75)=
    TO(B|-2)=

    ReplyDelete
    Replies
    1. ได้ยังครับ ขอด้วยคนครับ ตอนนี้เล่นแต่ทีมต่อ

      Delete
  109. This comment has been removed by the author.

    ReplyDelete
  110. please send excel to azhizaa01@gmail.com
    thank you very much

    ReplyDelete
  111. please send excel to amornchai.pu@gmail.com
    thank you very much

    ReplyDelete
  112. Please send me the formula 1x2 excel to nattawadee222@hotmail.com thank you very much. I want this formula so much.Thanks

    ReplyDelete
  113. sorry plese you send formula1x2 excel to benzza5400@gmail.com thnakyou

    ReplyDelete
  114. sorry plese you send formula1x2 excel to benzza5400@gmail.com thnakyou

    ReplyDelete
  115. sorry plese you send formula1x2 excel to benzza5400@gmail.com thnakyou

    ReplyDelete
  116. sorry plese you send formula1x2 excel to benzza5400@gmail.com thnakyou

    ReplyDelete
  117. sorry plese you send formula1x2 excel to benzza5400@gmail.com thnakyou

    ReplyDelete
  118. ไปยัง Moose Jester กรุณาส่งฉันไปที่ excel ekkaratsingto@gmail.com เพราะฉันไม่รู้ว่าจะใส่สูตรให้เป็น excel ได้อย่างไร ขอบคุณมาก

    ReplyDelete
  119. please send me the formula 1x2 excel to mintmomay19015@gmail.com
    thank you very much.

    ReplyDelete
  120. This comment has been removed by the author.

    ReplyDelete
  121. send me the formula 1x2 excel to polozon1900@gmail.com
    thank you very much.

    ReplyDelete
  122. Send me the formula 1×2 excel to nawin881@gmail.com
    Thank you.

    ReplyDelete
  123. กรุณาส่งสูตร 1x2 excel มาที่ phakphumsrikuson14@gmail.com ขอบคุณมากค่ะ ฉันอยากได้สูตรนี้มาก

    ReplyDelete
  124. please explain to me
    TO(B|-1)=
    TO(B|-1.25)=
    TO(B|-1.5)=
    TO(B|-1.75)=
    TO(B|-2)=

    ReplyDelete
    Replies
    1. please give me 0 , 0.25 , 0.5 , 0.75 at asiaartwork.sales@gmail.com

      Thank you a lot

      Delete
  125. Could you send me the Excel File, please? xaybanpa@gmail.com

    ReplyDelete
  126. please send me the formula 1x2 excel to thanak rungsan.tfo@gmail.com thank you very much

    ReplyDelete
  127. please send me the formula 1x2 excel to mafrong98@gmail.com thank you very much.

    ReplyDelete
  128. please send me the formula 1x2 excel to thanak vittie.1980@gmail.com thank you very much

    ReplyDelete
  129. please send me the formula 1x2 excel to odicon177@gmail.com thank you very much

    ReplyDelete
  130. please send me the formula 1x2 excel to rsanoo.phanudath@gmail.com thank you

    ReplyDelete
  131. please send me the formula 1x2 excel to pubaonoi@gmail.com thank you very much

    ReplyDelete
  132. This comment has been removed by the author.

    ReplyDelete
  133. please send me the formula 1x2 excel to roommate_shop@hotmail.com thank you

    ReplyDelete
  134. please send me the formula 1x2 excel to ti_adsl@msn.com thank you

    ReplyDelete
  135. please send me the formula 1x2 excel to natee012@hotmail.com thank you

    ReplyDelete