1. #1
    laxbrah420
    laxbrah420's Avatar Become A Pro!
    Join Date: 10-29-10
    Posts: 210
    Betpoints: 505

    Calculating (show) pool payouts

    I'm using Xpressbet's toteboard and coming with different results...
    Take Churchill for instance here's my calculation for show on the 7th race today:
    Track Takeout Pool Horse1 Horse2 Horse3 Show1 Show2 Show3 Churchill 0.16 45451 7714 2570 10710 3.485164636 6.457805447 3.069706816
    Actual was $3.40, $7, $2.80

    My formula is:
    ((Pool*(1-takeout))-Horse1-Horse2-Horse3)/3)/Horsen)*2+2.

    Is it that xpressbet is publishing inaccurate pools, my method is off, or something else? Even if im using the wrong takeout, it wouldnt account for the fact that Horse2 was overpaid and Horse3 was underpaid according to my calculations...

  2. #2
    laxbrah420
    laxbrah420's Avatar Become A Pro!
    Join Date: 10-29-10
    Posts: 210
    Betpoints: 505

    Ok found out about breakage, but still, new formula doesn't work.
    So for race #7 on churchill on 4/30 here's my calculations with the takeout, total pool, pool and expected show payouts for those horses. I'm geting closer but it's still not right. My formula is =FLOOR((((($C2*(1-$B2))-$D2-$E2-$F2)/3)/D2), 0.1)*2+2
    CD 0.16 45451 7714 2570 10710 3.4000000 6.4000000 3.0000000

    What am i missing?

Top