(Free Software) 3-bet Shoving Equity Calculator

83 replies [Last post]
genher's picture
genher
Offline
Veteran
Joined: Feb 12 2009

3-bet Shoving Equity Calculator

Created by Genher, this 3-bet Shoving Equity Calculator is both effective and easy to use.

Click Here to download the Excel version of the calculator.

Click Here to download the Open Office version of the calculator. (works for versions 3.3 or higher of the free Open Office software)

Note: Both versions are in .zip file formats and need to be unzipped (extracted) before they are opened in Excel or Open Office.

Updated Version by user StormTrooper with bug fixes, a visual of villains calling range, filter the results by Chip ev, $ev and the org bbev

>>>> here

 

TwistedFantasy's picture
TwistedFantasy
Offline
New User
Joined: Sep 1 2011
this is just awsome!! loved

this is just awsome!!

loved the video music ;D

how simple is that :D

pocaja's picture
pocaja
Offline
Veteran
Joined: Feb 23 2011
The excel file seems
The excel file seems protected. Do i need a password?
genher's picture
genher
Offline
Veteran
Joined: Feb 12 2009
The sheets are protected

The sheets are protected because of the enormous amount of formulas in it, but the excel file isn't. You should be able to use it but you need  to unable the macros! Let me know if you have any problems 

I have also open a thread on 2+2 http://forumserver.twoplustwo.com/185/heads-up-sng/new-free-3-bet-shovin...

About the music, it's funny that everyone seems to like it. Not much thought went into it, I had just changed my PC and windows media player comes with 3 song samples, it's one of them! :)

kVect's picture
kVect
Offline
New User
Joined: Dec 16 2013
slider does not work

Hello calculator your cool, thank you!! but I have a problem sending big blinds screen slider is visible, I need to make that slider appeared. many thanks

 


phl500's picture
phl500
Offline
New User
Joined: Feb 10 2011
Very cool.   Thx very much

Very cool.

 

Thx very much for this!

Gio's picture
Gio
Offline
New User
Joined: Jan 31 2011
good job sir

good job sir

But it ain’t about how hard you hit. It’s about how hard you can get hit, and keep moving forward. How much you can take, and keep moving forward. That’s how winning is done!

Rapidload's picture
Rapidload
Offline
Veteran
Joined: Oct 31 2009
Thank you.

Thank you.

mrbambocha's picture
mrbambocha
Offline
Elite
Joined: Sep 11 2009
Awesome work bro!!  Wish you

Awesome work bro!! 

Wish you alot of god mode..

Mrbambocha

lol_math's picture
lol_math
Offline
New User
Joined: Jan 13 2012
Holy shit, extremely good, ty

Holy shit, extremely good, ty ty ty

genher's picture
genher
Offline
Veteran
Joined: Feb 12 2009
Thanks! I am glad you like

Thanks! I am glad you like it!

Just to clarify what "taking into account card removal" means:

If you take AA for instance in the grid, the spreadsheet goes and count all of the opening range combos possible without these 2 Aces (cause villain can't have them), then it goes and count every combos in the raisecalling range (once again without the 2 Aces) and calculate the chances we are getting called by comparing the number of combos in the raisecalling range by the number of combos in villain's opening range. It does that for every single hand in the grid at the same time. So for KK in the grid it will count combos without these 2 Kings and so on...

Also there is a small bug. It's only cosmetic but still...When you exclude 22-55 from the opening range all PP disappear from the calling range text under the drop down box (where you choose your opponent's calling range) 66+ should still be there OBV! thankfully they are only omitted in the text and not in the calculations!. I will fix that.

 

EDIT: i have just fixed that and I am sending the new versions. I' let you know when it's up.

KobyPT's picture
KobyPT
Offline
New User
Joined: Apr 5 2009
having a problem.

I am having a trouble for 2 days now, i cant get to the numbers right for example :

i have AcAd and villain is opening 64% of hands (actually 63,8%) and calling loose 1 (22+,A2s+, K9s+, QTs+, A5o+, KTo+, QJo+ (23.08%)

if i got AcAd villain will open 56,18% and call my shove with 16,8% (my equity vs his range is 85,7%) ,so:

(0.168/0.562)*(0.857*(+21)+(1-0.857)*(-19))+(1-0.168/0.562)*3 = +6.67.

here is the problem, on the 3bet shoving equity i am getting +6.79 (i know that with 64% all the aces are included so the card removal is not the matter)

 

why are my values so different? can you help me?

 

ps: i am using Pokerprotools.

RyPac13's picture
RyPac13
Online
Site Administrator
Joined: Oct 21 2008
Version 4.02 is now updated

Version 4.02 is now updated into the OP to fix the cosmetic bug.

Dunk7's picture
Dunk7
Offline
New User
Joined: May 10 2009
Card Removal

When you say "card removal" and give the example A6o. I can see how it effects the Combos. But are you removing "whole ranges" when you say "card removal." Also is it important to take your own hand into consideration? Say for instance you did have A6o.


genher's picture
genher
Offline
Veteran
Joined: Feb 12 2009
I do apologize but I am not

When you say "card removal" and give the example A6o. I can see how it effects the Combos. But are you removing "whole ranges" when you say "card removal." Also is it important to take your own hand into consideration? Say for instance you did have A6o.

I do apologize but I am not sure I understand your question!?

What I mean by "taking into account card removal" is that when we have for instance A6o (or any other hand in the grid), then there is one less Ace and one less 6 that villain can have in his range and this is taken into account when doing the calculation.

Can you explain please what is AllInternalPasswords in macros section?

No, I have no idea. Is this in excel or Open office? may be add a screenshot and i'll try to find out.

Thanks for this! However i still cant double click on the cells without it saying 'protected cells can not be modified' in openoffice. How do i change this?

make sure you have open office 3.3 and that the macros are enabled. if you still have trouble with that PM me so I can help you

Tim182's picture
Tim182
Offline
New User
Joined: Feb 8 2010
Any change you could tell me

Any change you could tell me how to remove macros? Sorry to sound to stupid, i have never used open office before. 

Tim182's picture
Tim182
Offline
New User
Joined: Feb 8 2010
Thanks for this!

Thanks for this! However i still cant double click on the cells without it saying 'protected cells can not be modified' in openoffice. How do i change this? 

Dark_0n3's picture
Dark_0n3
Offline
New User
Joined: Jun 7 2010
Thanks

Can you explain please what is AllInternalPasswords in macros section?

genher's picture
genher
Offline
Veteran
Joined: Feb 12 2009
Can you explain please what

Can you explain please what is AllInternalPasswords in macros section?

Just looked into that. it's an excel password cracking subroutine I used to recover my excel password after forgeting it during the holiodays. I didn't realize I left it in there. It's harmless but If you are worried about it go in the developer tab, visual basic and delete the subroutine. There is no need for it

Dunk7's picture
Dunk7
Offline
New User
Joined: May 10 2009
Card Removal

Take any range say Super Tight. Are you taking every card in that range as part of the "Card Removal?" Also as a side issue we are not taking Hero's cards into consideration as part of the "card removal."


genher's picture
genher
Offline
Veteran
Joined: Feb 12 2009
Take any range say Super

Take any range say Super Tight. Are you taking every card in that range as part of the "Card Removal?" Also as a side issue we are not taking Hero's cards into consideration as part of the "card removal."

ok you obviously misunderstood something. I am ONLY taking hero's card into consideration!

Let me try to explain: The ranges in the drop down box (like the super tight you mentioned)are the Raisecalling range (meaning the range our villain calls our shove with). Take for instance this same "supertight" raise calling range 66+, A9s, KQs, ATo. It is made up of 126 combos. Now if our villain preflop raises his top 52.04% that's 690 combos. so villain will calls 126/690=18.26% of the time and therefore folds 81.74% of the time (100%-18.26%). Right?

Now to make it clearer, lets do the same calculations but this time with card removal. Hero has any hand in the grid. For instance A6o. Now if villain Raisecall with this same "supertight" Raisecalling range 66+, A9s, KQs, ATo, this range is NOW only made up of 103 combos because we have one Ace and one 6 he cannot call our shove with. Also if he still raises his top 52.04% that's now 620 combos only because once again there is one ace and one 6 he cannot raise with (cause they are in our hand). so villain calls 103/620=16.61% of the time and therefore folds 83.39% of the time. Including card removal like in this second calculation is just more accurate (but a pain in the neck to do on a spreadsheet :) )

I hope this help. Don't hesitate if you need more clarification.

spilveni's picture
spilveni
Offline
New User
Joined: Jan 20 2010
numbers

Thanks alot for this!

In relation to the numbers in the chart - is folding assumed to be 0BB or -1BB?

Dunk7's picture
Dunk7
Offline
New User
Joined: May 10 2009
Card Removal

Thank you I can follow that O.K. Does that mean you are taking every possible combo (1326) in the grid working out the % difference & then taking an "average." Because obviously there is no way of imputing Hero's particular hand? 

Also as aside issue how do you translate that into BB's won or lost?

Thanks for your help to date


genher's picture
genher
Offline
Veteran
Joined: Feb 12 2009
Does that mean you are taking

Does that mean you are taking every possible combo (1326) in the grid working out the % difference & then taking an "average." Because obviously there is no way of imputing Hero's particular hand?

 

Hero's hands are the hands in the grid!

how do you translate that into BB's won or lost?

There is a very good and detailed explanation of 3 bet shoving calculations here :

 

http://forumserver.twoplustwo.com/58...ective-444194/

Dunk7's picture
Dunk7
Offline
New User
Joined: May 10 2009
Card Removal

Thank you for taking the time to answer my Q's on card removal. All is clear now. I have been applying your calc to my games and it's just fantastic.

I can't believe your put in all that effort for no money. Not many of those types left in the world. You deserve all the accolades you get.


genher's picture
genher
Offline
Veteran
Joined: Feb 12 2009
Any change you could tell me

Any change you could tell me how to remove macros? Sorry to sound to stupid, i have never used open office before

if you remove the macros it won't work :) PM me with your skype contact and I'll try to help you.

Tim182's picture
Tim182
Offline
New User
Joined: Feb 8 2010
Hey i have sorted it now -

Hey i have sorted it now - Thanks anyhow  :)

busted_draw's picture
busted_draw
Offline
New User
Joined: Mar 3 2012
anyone to explain me pls what

anyone to explain me pls what to do when i double click the cells,and it tells me that the macros are protected?

kiroman's picture
kiroman
Offline
New User
Joined: Sep 7 2010
Thank you very much for it!

Thank you very much for it! :)

RaiseDaAce's picture
RaiseDaAce
Offline
New User
Joined: Apr 23 2012
technical issues

I dont know why, but the sheet doesnt work. I use open office version 3.3 the sheet loads but I cant use it because when I the figures dont change.

 

genher's picture
genher
Offline
Veteran
Joined: Feb 12 2009
@ raisedaAce I have posted an

@ raisedaAce

I have posted an answer to your problem in the 2+2 thread, let me know.

RyPac13's picture
RyPac13
Online
Site Administrator
Joined: Oct 21 2008
Updated to version 5. OP

Updated to version 5. OP links are updated.

genher's picture
genher
Offline
Veteran
Joined: Feb 12 2009
Update 5.0: There was a bug
Update 5.0:There was a bug in one of the hand calc (T6o). When I checked it all, I also found an other small one in the "call your shove calc" formula (luckily it made the results a bit too conservative and not the opposite! ).I fixed it all and while I was at it I also removed the slider for the effective stack. I figured out that it was easier and quicker to type than click endlessly on the slider . That way you guys can also use it for stack> at 25BB if you wish or use more precise effective stacks (decimals other than .5).I also ran many more tests to make sure there wasn't any other bug hanging around. All good!Enjoy it!
FeralAce's picture
FeralAce
Offline
New User
Joined: Mar 25 2012
Thanks heaps for developing

Thanks heaps for developing this.

I haven't used it before but just downloaded the Open Office version. When I unzip it the file has an extension .7z which doesn't seem to open in OO. I've only just installed OO so maybe I'm doing something wrong?

genher's picture
genher
Offline
Veteran
Joined: Feb 12 2009
yes you need to unzip it

yes you need to unzip it first :)

if you have windows, right click and choose "exctract all" in the menu

FeralAce's picture
FeralAce
Offline
New User
Joined: Mar 25 2012
Yes, I have extracted it. The

Yes, I have extracted it.

The download is a .zip file. When I extract that it contains a .7z file which doesn't seem to be able to be openning by the OO spreadsheet program.

genher's picture
genher
Offline
Veteran
Joined: Feb 12 2009
.7z is a zip extension. you

.7z is a zip extension. you need to exctract it

FeralAce's picture
FeralAce
Offline
New User
Joined: Mar 25 2012
OK, thanks. Found the

OK, thanks. Found the required extraction program at http://www.7-zip.org/

Katipo's picture
Katipo
Offline
Video Producer
Joined: May 21 2010
I use PeaZip instead because

I use PeaZip instead because I prefer its interface and find it more versatile.

D0nkMast3r's picture
D0nkMast3r
Offline
New User
Joined: Aug 7 2012
Thank you!!!

This is awesome! I've been working this stuff out using cardrunners ev but have not spent the time to come up with the raise % slider, calling ranges etc. Have you done the same work for SB open jamming and BB jamming when villain limps? If so, I'd be interested in buying a copy from you. Thanks again!

hennerz1's picture
hennerz1
Offline
New User
Joined: Jan 9 2013
Thank you. Math question?

Thank you so much for this!Quick math question

Say a 3bet jam has an expectation of -0.2bb..However folding has a expectation of -1bb

We should jam here as overall ignoring the option to call, our expectation of shoving is 0.8bb better than folding right??

RyPac13's picture
RyPac13
Online
Site Administrator
Joined: Oct 21 2008
You don't want to ignore the

You don't want to ignore the calling option, you want to estimate if it is better than the 3bet jam in this spot or not.

KamikazeMan1's picture
KamikazeMan1
Offline
New User
Joined: Mar 10 2011
Thank you so much Genher

This software is amazing Genher and it is very great to have by my side when playing.  Being a math guy I'm working on some custom 3bet shoving charts of my own but they are very time consuming and require a lot of work.  So while I am building them I'm using this software and I must say it is fantastic.  Keep up the good work man, Cheers!!!!

lindridgeben's picture
lindridgeben
Offline
Veteran
Joined: Oct 29 2012
Problem with opening software

A have unzipped the file and enable macros but when i open it with excel it just opens a load of ramdom numbers and letters

Any suggestions?

kukiszabi123's picture
kukiszabi123
Offline
New User
Joined: Jan 19 2013
Aren't we only winning

Aren't we only winning 2BB-s(facing a minraise) when we 3bet jam, and they fold??

Our stack will grow with 2 BB-s after the hand(1t hand f.e.: we have 25, they minr, we shove, we will have 27BB after this)... 



I am asking this because this calculator counts in 1 more BB-s(the fold equity part), the one BB we put in pre cause we are OOP. That makes the whole calculator worthless...

genher's picture
genher
Offline
Veteran
Joined: Feb 12 2009
First of all my apologies, I

First of all my apologies, I didn't see these last 2 posts.

The calculator calculates the EV of the 3Bet shove move in BB and not in stack growth. The calcs are accurate.

I am not sure why you think they are worthless!?

kukiszabi123's picture
kukiszabi123
Offline
New User
Joined: Jan 19 2013
Aren't we only winning

Aren't we only winning 2BB-s(facing a minraise) when we 3bet jam, and they fold??

Our stack will grow with 2 BB-s after the hand(1t hand f.e.: we have 25, they minr, we shove, we will have 27BB after this)... 



I am asking this because this calculator counts in 1 more BB-s(the fold equity part), the one BB we put in pre cause we are OOP. That makes the whole calculator worthless...

Stig's picture
Stig
Offline
New User
Joined: Mar 29 2013
I'm having the same problem

I cannot enable the scroll bar when trying to alter the opening range %.  Any suggestions?  I'm using Excel for Mac 2011 V14.2.0

Everything else seems to work ok except this.

genher's picture
genher
Offline
Veteran
Joined: Feb 12 2009
Once again, my apologies I

Once again, my apologies I didn't see this post.

I don't know if you have resolved this or moved on since. Let me know if you still need to fix this I will gladly help you.

 

genher

 

it1111's picture
it1111
Offline
Elite
Joined: Jul 12 2012
I had the same problem in

I had the same problem in Office for Mac 2011, then I tried to install Open Office and everything worked fine. 

"If you want to win, you must not lose!"

Stig's picture
Stig
Offline
New User
Joined: Mar 29 2013
  Yeah, it's still a problem.

 

Yeah, it's still a problem. When I open the file I am prompted to enable macros, but the scroll bar is just an image/picture and I cannot manually alter the percentage box as it's protected.