How to filter for set vs overset

[Madouch]

Hi,

could anyone please help me to set up the filters so I would have only hands where me and my opponent had a set in the showdown (no Allin preflop, stacks were reasonably deep like 60BB+)
thanks a lot

[kraada]

This is actually a bit complicated. I'll take a look and see what I can put together for you though.

[Madouch]

thanks a lot!

[Madouch]

Would still appreciate any help :-)

thanks a lot to anyone :-)

happy christmas

[kraada]

Sorry for taking so long to get back to you - the holidays ate some of my time :)

I've attached a report to this post which you can download unzip and import and it will show you all times the player in question saw a flop with a pocket pair and when two players showed down flopped sets. This will get you a few false positives, but the number should be quite small. You can double click any hand in the list to see more detail on that hand should you so desire.

Filtering for just undersets or just oversets is actually a whole lot more complicated and I kind of like this report as it is, because you can see quickly if your oversets are more or less cancelling out your undersets - if the amount won (or BB Won) is fairly close to zero, you don't need to worry overmuch about being oversetted more than your fair share.

[PHJJR]

What would it take to convert this to a tourney report??

[kraada]

Change the filter: id_hand in (SELECT hhpc.id_hand from holdem_hand_player_combinations hhpc where hhpc.flg_f_threeoak and hhpc.id_f_hand_strength > 3 group by hhpc.id_hand HAVING COUNT(*) > 1)

to: id_hand in (SELECT hhpc.id_hand from tourney_holdem_hand_player_combinations hhpc where hhpc.flg_f_threeoak and hhpc.id_f_hand_strength > 3 group by hhpc.id_hand HAVING COUNT(*) > 1)

Everything else should be added but doesn't need to be changed at all.

[Madouch]

thanks a lot!

[darlingm]

Sweet report, thanks! It also triggers on a flush scenario where both players had sets, even if we had the higher set. Example, I had KK vs villan's JJ. Board came K8JT5. We got all in on flop, with K8 hearts. (One of his jacks was a heart, and I had none obviously since the K heart was on the board.) T5 were both hearts. Came up in report, even though it's not set over set. No biggie, like you mentioned, there would be some false positives. That hand sucked.

78.44 BB won, without filtering any false positives out. How's everyone else's compare?

[kraada]

Yeah but there were two sets on that flop :)

I'm slightly positive in that report as well over a fairly large sample.