Open Side Menu Go to the Top
FAQ Today's Posts Search Twitter Discord
Register
Excel tutorial Excel tutorial
Post Reply Subscribe
...
03-11-2011 , 10:27 PM
#1
hoopla65
View Profile Send Message Find Posts By hoopla65 Find Threads By hoopla65
journeyman
Join Date: Jan 2008 Posts: 220
I'm trying to figure out optimal shoving strategies vs players' ranges. i.e. I have Q9 vs a min raise at 25/50 1k stack, I would like to find a quick way to figure out how light I should be shoving in certain situations based on my hand, the bb to stack ratio, Villain's opening frequency and his call range. Can excel or some other program help me with this? I would like to come up with something I could post on 2+2.
Excel tutorial Quote
03-11-2011 , 10:36 PM
#2
Tamas6
View Profile Send Message Find Posts By Tamas6 Find Threads By Tamas6
See my staking thread
Join Date: Feb 2010 Posts: 1,854
%fold * $wonF + [ %called * %W * $wonC + %L * $lostC ]
(.809 * 150) + [ ( (.191) * (.31 * 1300) + (.69 * -1200) ) ]


terms: $wonF = Money Won when they Fold
%called = Percentage called
%W = Percentage your hand wins vs their range (or the equity your hand has vs their range)
%L = 1-%W (or the equity their range has vs your hand)
$wonC = Money won when called and you win
$lostC = Money lost when called and you lose
Excel tutorial Quote
03-11-2011 , 10:45 PM
#3
hoopla65
View Profile Send Message Find Posts By hoopla65 Find Threads By hoopla65
journeyman
Join Date: Jan 2008 Posts: 220
Quote:
Originally Posted by Tamas6
%fold * $wonF + [ %called * %W * $wonC + %L * $lostC ]
(.809 * 150) + [ ( (.191) * (.31 * 1300) + (.69 * -1200) ) ]


terms: $wonF = Money Won when they Fold
%called = Percentage called
%W = Percentage your hand wins vs their range (or the equity your hand has vs their range)
%L = 1-%W (or the equity their range has vs your hand)
$wonC = Money won when called and you win
$lostC = Money lost when called and you lose
Okay, I understand how to do the math, but how would I streamline this so I could do it in Excel without taking 3 hours to pencil and paper it + have something that is well organized. I've never used Excel so can you explain to a complete noob?
Excel tutorial Quote
03-12-2011 , 12:12 AM
#4
Tamas6
View Profile Send Message Find Posts By Tamas6 Find Threads By Tamas6
See my staking thread
Join Date: Feb 2010 Posts: 1,854
em try the computer help forum or youtube maybe
Excel tutorial Quote
03-12-2011 , 12:14 AM
#5
Insane_Steve's Avatar
Insane_Steve
View Profile Send Message Find Posts By Insane_Steve Find Threads By Insane_Steve
Pooh-Bah
Join Date: Mar 2006 Posts: 5,843
http://forumserver.twoplustwo.com/sh...3&postcount=18

oh hay guise did someone ask about shoving ranges in excel
Excel tutorial Quote
03-12-2011 , 12:55 AM
#6
MayTheFlopBeWithU's Avatar
MayTheFlopBeWithU
View Profile Send Message Find Posts By MayTheFlopBeWithU Find Threads By MayTheFlopBeWithU
journeyman
Join Date: May 2009 Posts: 272
Quote:
Originally Posted by Insane_Steve
http://forumserver.twoplustwo.com/sh...3&postcount=18

oh hay guise did someone ask about shoving ranges in excel
genius!
Excel tutorial Quote
Post Reply Subscribe
...
      
Feedback is used for internal purposes. LEARN MORE
Contact Us Privacy Statement TOS
Top
Powered by:  Hand2Note
Copyright ©2008-2022, Hand2Note Interactive LTD
m