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.