Two Plus Two Poker Forums how to use excel to work out ICM?
 Register FAQ Search Today's Posts Mark Forums Read Video Directory TwoPlusTwo.com

 Notices

 STT Strategy Discussion about the play of single table tournaments.

 11-14-2017, 05:26 AM #1 zhouxx123 newbie   Join Date: Apr 2017 Posts: 20 how to use excel to work out ICM? I have been reading about ICM stuff and using EXCEl to build a ICM model. ICM requires to workout your probability of finishing in nth(n=1、2、3、4....) place, it is easy to workout your probability of finishing in 1st and 2nd, but it's quite complicate when 3rd 4rd 5th come in. Dose anyone has any idea how to use EXCEL to workout the problem easier? If you have a VBA code，I hope you can share with me. Thanks a lot.
 11-14-2017, 11:20 AM #2 Solidthought veteran     Join Date: Jan 2012 Location: Turning bluffs into bluffcatchers Posts: 2,539 Re: how to use excel to work out ICM? there are programmes that do it all for you. i respect that you want to find out how to do it the long way, a google search should help you. http://www.icmpoker.com/icmcalculator/ if you want mtt icm stuff, that exists too
 11-14-2017, 07:13 PM #3 Weird Fish enthusiast   Join Date: Mar 2014 Posts: 91 Re: how to use excel to work out ICM? I believe there was a video on deuces cracked by vandweller teaching just this. Im looking for one too, I was half way though it when I was a deuces cracked member but never finished it. Needless to say it is fairly tedious.
 11-14-2017, 08:31 PM #4 Ronny Mahoni Pooh-Bah   Join Date: Oct 2008 Location: Rizzle Kicking Posts: 4,020 Re: how to use excel to work out ICM? ICM is pretty straightforward. Your chance of getting first is Your Stack / Total Chips. Your chance of getting second is (Your Stack / ( Total Chips - Stack A)) * (Your Stack / ( Total Chips - Stack B)) .... Your chance of getting third is (Your Stack / ( Total Chips - Stack A - Stack B)) * (Your Stack / ( Total Chips - Stack A - Stack C)) ... (Your Stack / ( Total Chips - Stack B - Stack C)) * (Your Stack / ( Total Chips - Stack B - Stack D)) ............. Everything beyond the payout place doesnt matter. Unfortunately Im not an Excel expert and this brute force solution is the only I know. Took me 1 or 2 days to set up a satisifing ICM sheet this way. Which unfortunately I dont have anymore. Hope this helps. If you have further questions, ask.
11-14-2017, 10:15 PM   #5
zhouxx123
newbie

Join Date: Apr 2017
Posts: 20
Re: how to use excel to work out ICM?

Quote:
 Originally Posted by Solidthought there are programmes that do it all for you. i respect that you want to find out how to do it the long way, a google search should help you. http://www.icmpoker.com/icmcalculator/ if you want mtt icm stuff, that exists too
I had subscribe ICMIZER, I know that ICMIZER can solve my problem, but I still want to build a model by myself and I believe that will help me understanding the ICM deeper.

11-14-2017, 10:48 PM   #6
zhouxx123
newbie

Join Date: Apr 2017
Posts: 20
Re: how to use excel to work out ICM?

Quote:
 Originally Posted by Weird Fish I believe there was a video on deuces cracked by vandweller teaching just this. Im looking for one too, I was half way though it when I was a deuces cracked member but never finished it. Needless to say it is fairly tedious.
I will try deuces cracked,ty.

11-14-2017, 11:08 PM   #7
zhouxx123
newbie

Join Date: Apr 2017
Posts: 20
Re: how to use excel to work out ICM?

Quote:
 Originally Posted by Ronny Mahoni ICM is pretty straightforward. Your chance of getting first is Your Stack / Total Chips. Your chance of getting second is (Your Stack / ( Total Chips - Stack A)) * (Your Stack / ( Total Chips - Stack B)) .... Your chance of getting third is (Your Stack / ( Total Chips - Stack A - Stack B)) * (Your Stack / ( Total Chips - Stack A - Stack C)) ... (Your Stack / ( Total Chips - Stack B - Stack C)) * (Your Stack / ( Total Chips - Stack B - Stack D)) ............. Everything beyond the payout place doesnt matter. Unfortunately Im not an Excel expert and this brute force solution is the only I know. Took me 1 or 2 days to set up a satisifing ICM sheet this way. Which unfortunately I dont have anymore. Hope this helps. If you have further questions, ask.
I know the formulas, but it consume too much time to get the answer.I had read about Ben Roberts's <A new algorithm for the approximation of ICM>, it might help to find a easier way to solve the problem.

 11-18-2017, 09:26 PM #8 statmanhal Pooh-Bah   Join Date: Jan 2009 Posts: 3,983 Re: how to use excel to work out ICM? Check out this link. https://forumserver.twoplustwo.com/2...orithm-346317/ I wasn’t good enough to translate the algos to Excel VBA I wrote a SNG analysis program where the ICM part was embedded. The heart of the VBA ICM code follows: '1st Place For i = 1 To n P1(i) = S(i) / stacks P2(i) = 0: P3(i) = 0: PWIN(i) = 0 Next '2nd Place For i = 1 To n For j = 1 To n If j <> i Then P2(i) = P2(i) + S(j) * S(i) / (stacks * (stacks - S(j))) End If Next Next '3rd Place For i = 1 To n For j = 1 To n For k = 1 To n If k <> i And k <> j And j <> i Then P3(i) = P3(i) + S(j) * S(k) * S(i) / (stacks * (stacks - S(j)) * (stacks - S(j) - S(k))) End If Next Next Next If someone can program the more exotic code in VBA, it would be good to publish it.
 Yesterday, 12:02 PM #9 LektorAJ Carpal \'Tunnel     Join Date: May 2014 Location: none Posts: 6,140 Re: how to use excel to work out ICM? I've done this in VBA. You need to keep calling the same function recursively. I didn't do a 6000th post so I might put that up when I can dig it out. Anyone know which forum it should belong in? (I'll put a link ITT when I post it) EDIT - just seen the link above, I'll put it in there later today.

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Forum Rules
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Links to Popular Forums     News, Views, and Gossip     Beginners Questions     Marketplace & Staking     Casino & Cardroom Poker     Internet Poker     NL Strategy Forums     Poker Goals & Challenges     Las Vegas Lifestyle     Sporting Events     Politics     Other Other Topics Two Plus Two     About the Forums     Two Plus Two Magazine Forum     The Two Plus Two Bonus Program     Two Plus Two Pokercast     The Best of Two Plus Two Marketplace & Staking     Commercial Marketplace     General Marketplace     Staking - Offering Stakes     Staking         Staking - Offering Stakes         Staking - Seeking Stakes         Staking - Selling Shares - Online         Staking - Selling Shares - Live         Staking Rails         Transaction Feedback & Disputes     Transaction Feedback & Disputes Coaching & Training     Coaching Advice     Cash Game Poker Coach Listings     Tournament/SNG Poker Coach Listings Poker News & Discussion     News, Views, and Gossip     Poker Goals & Challenges     Poker Beats, Brags, and Variance     That's What She Said!     Poker Legislation & PPA Discussion hosted by Rich Muny     Twitch - Watch and Discuss Live Online Poker     Televised Poker     Two Plus Two Videos General Poker Strategy     Beginners Questions     Books and Publications     Poker Tells/Behavior, hosted by: Zachary Elwood     Poker Theory     Psychology No Limit Hold'em Strategy     Medium-High Stakes PL/NL     Micro-Small Stakes PL/NL     Medium-High Stakes Full Ring     Micro-Small Stakes Full Ring     Heads Up NL     Live Low-stakes NL Limit Texas Hold'em Strategy     Mid-High Stakes Limit     Micro-Small Stakes Limit Tournament Poker Strategy     STT Strategy     Heads Up SNG and Spin and Gos     Mid-High Stakes MTT     Small Stakes MTT     MTT Community     Tournament Events Other Poker Strategy     High Stakes PL Omaha     Small Stakes PL Omaha     Omaha/8     Stud     Draw and Other Poker Live Poker     Casino & Cardroom Poker         Venues & Communities         Regional Communities     Venues & Communities     Tournament Events         WPT.com     Home Poker     Cash Strategy     Tournament Strategy Internet Poker     Internet Poker         Winning Poker Network         nj.partypoker.com         Global Poker     Commercial Software     Software         Commercial Software         Free Software General Gambling     Backgammon Forum hosted by Bill Robertie.     Probability     Sports Betting     Other Gambling Games 2+2 Communities     Other Other Topics         OOTV         Game of Thrones     The Lounge: Discussion+Review     EDF     Las Vegas Lifestyle     BBV4Life         omg omg omg     House of Blogs Sports and Games     Sporting Events         Single-Team Season Threads         Fantasy Sports     Fantasy Sports         Sporting Events     Wrestling     Golf     Chess and Other Board Games     Video Games         League of Legends         Hearthstone     Puzzles and Other Games Other Topics     Politics     History     Business, Finance, and Investing     Science, Math, and Philosophy     Religion, God, and Theology     Travel     Health and Fitness     Laughs or Links!     Computer Technical Help     Programming International Forums     Deutsch         BBV [German]     Français     Two Plus Two en Espańol

All times are GMT -4. The time now is 01:35 AM.

 Contact Us - Two Plus Two Publishing LLC - Privacy Statement - Top