Sit N Go Analysis

[imcastleman]

I’m developing a program that reads through a given set of my tournament hand histories and writes out an excel spreadsheet where each line item contains details surrounding hands where I am all in. I’m doing this so that I can take a particular days work and find out a few things. One, to find out how often I’m going all in as the underdog and two, to find out if I was lucky or unlucky on certain types of all ins(i.e./ coinflips, 60/40s, dominating hands and over-dominating hands) that day. I’ve got most of it complete but I’m having a difficult time with the probabilities for a given situation. What I’m hoping someone can do for me is the following:

If I give you 2 hands in the format just like www.twodimes.net/poker and say hand one is in cell A1 and hand 2 is in cell A2. I’d like there to be a formula in cell A3 that calculates the probability that the hand from cell A1 wins. If this cannot be done easily, then for each day that I analyze, I will just manually go into the file and place the approximate probabilities for each situation, although I’d really like it to be dynamic if possible.

For those interested in seeing a sample spreadsheet, PM me your email address, and I’ll send a copy.