Search:

You can use the function from my template:


=US2Res(<USOdds>, <WagerQuantity>, <Outcome>)where <Outcome> is a string that starts with "W" for a winning bet and with "L" for a losing bet.

If...

It's an array formula.

You need to enter it with CTRL+SHIFT+ENTER.

Also ... if you just want to calculate win probability you should use US2REAL rather than US2FAIR.

http://www.sportsbookreview.com/forum/handicapper-think-tank/594429-new-vba-sports-betting-functions-excel-demo.html

This above link contains a workbook with a considerably more up to date version of these...

VBA function for converting gross US Matchbook odds to net US Odds (i.e., odds after commission):

Public Function MB2US(ByVal dUSOdds As Double, Optional ByVal dCommission = 0.01) As Double
...

I'm not actually following.

Could you be a bit more specific?

Have you tried hitting the F9 (Calc Now) key?

Not sure exactly for what you're looking but do check out http://www.sportsbookreview.com/forum/handicapper-think-tank/38968-asian-handicap-kelly-betting.html#post332398 and Asian Handicap Middles.

Those are risk quantities not win quantities.

Spurs Risk/Win @-114 = $4,931.49/$4,325.87
Pacers Risk/Win @ -121 = $5,068.51/$4,188.85

Spurs win by 6 net profit = +$8,514.72 ($4,325.87 +...

Putting aside Kelly, if you were simply looking to equalize losses should your middle not hit, you'd wager as follows:


Spurs -4.5 -114

=10000*us2dec(-121)/(us2dec(-121)+us2dec(-114))
=...

Added for Version: 1.0.1.13:

SBRVer(): Displays current template version number.
{US2Fair(range of US Odds)} or {Dec2Fair(range of Decimal Odds)}: (array function) Returns an array of fair...

Added:

MB2US(US Matchbook Exchange Odds, Commission {default=1%})
MB2Dec(Decimal Matchbook Exchange Odds, Commission {default=1%})

These calculate sportsbook equivalent US or Decimal odds...

One might think I'd be more familiar with my own spreadsheets ...

If by payout ratio you mean the synthetic fractional odds on the middle then:

To win = 2*dopen - 1 - dopen / dnew
At risk = dopen - 1 - dopen / dnew

So the win to risk ratio would be:
dopen *...

Let dopen = decimal odds on open bet
Let dnew = decimal odds on new bet
Let M = money wagered on open bet
Let X = necessary money to wager on new bet in order to equalize losses

M*(dopen-1) - X...

I'm sorry Pancho, but I don't understand your question.

Makes use of a new (still undocumented) function I just added: {=ENUMCOMBIN3(Range, Size, "WinLabel", "DrawLabel")}.

WinLabel and DrawLabel default to values of "WIN" and "DRAW" respectively.
...

Could you please provide an example of what you've tried as well as be more specific about what you're looking to accomplish?

Are you sure you've properly entered the formula as an array function?...

I assume you mean Excel 2007.

From http://support.microsoft.com/kb/822107:


And then place the Book.xlt file in the above folder as appropriate.

To see if it's working open up a new...

Glad to hear it. :)

Just make sure not to make any changes to the Book.xlt file (or even open it in the first place) unless you absolutely positively know what you're doing. :grrr:

I don't think you're understanding me. The cells in that file will always be blank.

That's an Excel template file and not a worksheet. The file isn't intended to ever be opened by users.
...

Ok ... and then what happens when you open a new spreadsheet, enable Macros, and attempt to use one of the functions?

You'll need to be more specific. Just saying "it doesn't work" doesn't really give me much to go on, I'm afraid.

In what manner doesn't it work? What happens when you attempt to use in the manner...

Firefox has nothing to do with it.

What do you mean when you say "it won't work"? What happens when you open a new spreadsheet, enable Macros, and attempt to use one of the functions?

I assume...

Because it's not an Excel spreadsheet (an .xls file), but rather an Excel template (an .xlt file). You don't open the file you save it as described above in the initial post after the function...

Could you be more specific as to what actually occurred when you attempted your download?

If anyone cares to redownload I added a few more minor functions.

US2Par(range of USOdds): Converts an array or Excel range of US-style odds to US parlay odds. So US2Par(-110,-110,-110) asymp...

New function added:

{P2L(range of win probabilities)}: (array function) Returns an array of likelihoods such that the i^th element of the output array (i &isin; [0, 1, 2, ..., n], where...

Good catch. This template doesn't actually use solver at all, so the reference is probably just an artifact from some old spreadsheet of mine.

Feel free to de-select the reference if you like.
...

Added two sets of functions to calculate sportsbook-equivalent lines and theoretical hold inclusive of sports exchange commissions:

Exch2US(US Odds, Commission {default = 2%}) or Exch2Dec(Decimal...

Yeah that was my bad (although I'm not sure why you'd see the -0.00527. Just remember to enter as an array formula -- using ALT-ENTER).

I've fixed this it in the latest version, which you can...

Latest Version: 1.0.2.1

Download here

If you're like me, you frequently reuse many of the same excel sports betting formulas. I've compiled a few related to odds manipulation into this Excel...