Two Plus Two Publishing LLC Two Plus Two Publishing LLC
 

Go Back   Two Plus Two Poker Forums > >

Notices

STT Strategy Discussion about the play of single table tournaments.

Reply
 
Thread Tools Display Modes
Old 11-14-2017, 05:26 AM   #1
zhouxx123
newbie
 
Join Date: Apr 2017
Posts: 20
Smile 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.
zhouxx123 is offline   Reply With Quote
Old 11-14-2017, 11:20 AM   #2
Solidthought
veteran
 
Solidthought's Avatar
 
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
Solidthought is offline   Reply With Quote
Old 11-14-2017, 07:13 PM   #3
Weird Fish
enthusiast
 
Join Date: Mar 2014
Posts: 87
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.
Weird Fish is offline   Reply With Quote
Old 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.
Ronny Mahoni is offline   Reply With Quote
Old 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 View Post
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.
zhouxx123 is offline   Reply With Quote
Old 11-14-2017, 10:48 PM   #6
zhouxx123
newbie
 
Join Date: Apr 2017
Posts: 20
Smile Re: how to use excel to work out ICM?

Quote:
Originally Posted by Weird Fish View Post
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.
zhouxx123 is offline   Reply With Quote
Old 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 View Post
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.
zhouxx123 is offline   Reply With Quote

Reply
      

Thread Tools
Display Modes

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 Jump


All times are GMT -4. The time now is 01:21 PM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright © 2008-2017, Two Plus Two Interactive
 
 
Poker Players - Streaming Live Online