Simple VBA Sports Betting Functions Template for Excel

[RaginCajun]

Ganchrow, is all of this for excel? i just tried to do the first command in a cell in excel. i typed in US2Dec(-110,-110) and nothing happened. do i need to do anything else?

[RickySteve]

You have to install the functions before you can use them.

[Kraghen]

Hi there! Does it work on Macintosh's excel version?

[Flight]

If the Mac version supports VBA then yes. I believe it does. Open Excel and push ALT+F11 and see if the VB editor comes up. If it does, you're in business.

[sharpcat]

Hi there! Does it work on Macintosh's excel version?

Excel 2008 for Mac does not support VBA but all other versions do including the upcoming 2010 version.

[Shonner]

Anyone have an idea of when the Demo Ganch posted back in August will be ready?

[Flight]

Anyone have an idea of when the Demo Ganch posted back in August will be ready?

What are you referring to?

[Blacke]

nice work, thx

[cant call it]

does this work on excel 2010?

[blackf1re]

Doesn't seem to work on Excel 2010. And when trying to open the .xlt I get this:

"This workbook has lost its VBA project, ActiveX controls and any other programmability-related features."

[ArcadeFire]

Yes, I cannot get it to work in current Excel version, bummer.

Whatever happened to Ganchrow?

[hubie69]

Excellent work on these Ganchrow, amazingly helpful.

[Ramster]

Thank you OP..I downloaded

[Ganchrow]

http://forum.sbrforum.com/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 functions and more.

The VBA code was greatly refactored with much rewritten in C++ for added speed. WIN32 I'm afraid. .

[mjespoz]

Ganchrow! I have learnt so much from your Kelly posts (amongst others). Welcome back!

[frankzig]

yea solid we ca axt uamytng

[frankzig]

proper english baby your not in the street

[jhol3990]

awesome, thanks for this. Just trying to find the gold in this forum and looks like i've struck some here. Thanks again.

[jjgold]

Nice work Ganch

Anyone else would charge for this stuff

[cant call it]

how do I translate this to english? I dont know anything about this

[RickySteve]

Ganchrow is the final boss.

[demens]

Can these be used in OO Calc?

[Sacamano]

Great work..thank you

[Inkwell77]

Awesome! Thank you!

[allin1]

bump and thanks!

[mikeorta20]

how come when i us the 'us2fair' function it gives me a negative number for the dog and the favorite. so both cells have a "-184" instead of one +/-. its messing me up when calculating win probablity.

[Ganchrow]

how come when i us the 'us2fair' function it gives me a negative number for the dog and the favorite. so both cells have a "-184" instead of one +/-. its messing me up when calculating win probablity.

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.

[bmurphy003]

Great thread, bit of an excel nerd here but I'm trying to come up with an if function that will return the change in units for each game betted on. Ex: (column 1, column 2, column 3, etc.) = (
line, result, base amount of units, unit change) = (-1.10, W, 1.00, *should return +1.00)

works fine unless betting a favorite with a losing result. Tried many combinations of

=if(AND(line<0,result ="W"),[base amount]* line....etc
buthavent quite figured it out.

Any thoughts/comments would be helpful

[Ganchrow]

I'm trying to come up with an if function that will return the change in units for each game betted on. Ex: (column 1, column 2, column 3, etc.) = (
line, result, base amount of units, unit change) = (-1.10, W, 1.00, *should return +1.00)

works fine unless betting a favorite with a losing result. Tried many combinations of

=if(AND(line<0,result ="W"),[base amount]* line....etc
buthavent quite figured it out.

Any thoughts/comments would be helpful

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 you have your quantities listed as "base" rather than "risk" quantities, then you could use something like:

=quantity*IF(result="W", MAX(1,USOdds/100), (result="L")*MIN(-1,USOdds/100))

[gauchojake]

Nice bump hoopy. Gotta get prepped for nfl

[satana]

does this work on google docs spreadsheet?

[Lo$t]

Can I input Izzo any # into this thing?

[kzee89]

I like the idea of applying VBA knowledge to sports.

[satana]

does this work on google docs spreadsheet?

Ok, I take it as no since I have to save the book.xlt file.
I've office '07 installed on this old laptop, why can't I find find the Microsoft Office folder under C:\Program Files?
edit found it

[satana]

Type the following in cell A1:

=us2prob(-110)

Hit enter. If the result is 0.52381 then you know the function is working properl

don't know if Granchow is still around here, but when I try this it doesn't work.
all macros are enabled, I'm using office '07 and the file has been copied in the right folder.