by Astron8 » Mon Jul 23, 2018 12:04 pm
There seems to be a problem using this method. I created a new stat I called Avg Won = amt_bb_won / cnt-hands, as you suggest.
If I filter for MTT, Blinds = 10/20, not including Split pots, I find the Average Pot = 41.0 BBs for all players. If I add the filter "Player Won Hand", the Average Pot stays nearly the same and my "Avg Won" stat = 23.4 BB, or 57% of the average pot. This seems reasonable to me.
But now I want to find these values for a raised pot, so I add the filter "Raised Prefop Any 2Bet" to my initial filter and get Avg Pot = 55.4 BBs, which is reasonable since I expect pots to be bigger when raised preflop. (Though not necessarily, since some hands will end preflop.)
But when I then add the "Player Won Hand" to the filter, the results don't make sense. The Avg pot now drops from 55.4 BB to only 39.0 BB and the Avg Won = 22.3 BB. The avg pot should be the same whether I filter for "Player Won Hand" or not. (This was true without the 2Bet filter.) If I divide the 22.3 BB by 39.0 BB, the profit is about 57%, but when I divide the 22.3 BB by the 55.4 BB value, the profit is only 40%, which is not possible. What is going on when I use these filters?
Can you recommend a stat that gives me the global profit without using a filter?