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.

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 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.

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 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.

I will try deuces cracked,ty.

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.

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.

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.