Page 1 of 1

turn middle overcard to the flop

PostPosted: Mon May 24, 2021 7:48 am
by duxika
Hello,

i have a problem when i would like to make an expression filter.

My goal is that i would like to search that hand where flop is paired and the kicker is not bigger than 7. I could make it:

((tourney_hand_summary.card_1 % 13 = tourney_hand_summary.card_2 % 13
AND tourney_hand_summary.card_3 % 13 BETWEEN 1 AND 6)

OR (tourney_hand_summary.card_1 % 13 = tourney_hand_summary.card_3 % 13
AND tourney_hand_summary.card_2 % 13 BETWEEN 1 AND 6)


OR (tourney_hand_summary.card_2 % 13 = tourney_hand_summary.card_3 % 13
AND tourney_hand_summary.card_1 % 13 BETWEEN 1 AND 6))


than i would like to filter that hands where the TURN card is higher than the flop middle over card (for example: flop is 733 and the turn have to be between 4 and A.
But i cant set that how i can identify which is the middle card on the flop in this case the 3. (its just an example but it coud be 266 where the middle is 2 and the turn have to be between 3 and A.

please help me the make it.

Thx.

Re: turn middle overcard to the flop

PostPosted: Mon May 24, 2021 8:11 am
by duxika
and the other situation where i just would like to search that hands where i have higher card than the flop single card (not paired card)

733 i looking for that hands where the turn card is higher then 7.
or 466 i looking for that hands where the turn card is higher than 4!!

Re: turn middle overcard to the flop

PostPosted: Wed May 26, 2021 4:47 am
by Flag_Hippo
You can add a check for the turn card with something like this:

Code: Select all
((tourney_hand_summary.card_1 % 13 = tourney_hand_summary.card_2 % 13 AND tourney_hand_summary.card_3 % 13 BETWEEN 1 AND 6 AND (tourney_hand_summary.card_4 - 1) % 13 > (tourney_hand_summary.card_3 - 1) % 13 AND NOT (tourney_hand_summary.card_4 - 1) % 13 = (tourney_hand_summary.card_1 - 1) % 13)
OR (tourney_hand_summary.card_1 % 13 = tourney_hand_summary.card_3 % 13 AND tourney_hand_summary.card_2 % 13 BETWEEN 1 AND 6 AND (tourney_hand_summary.card_4 - 1) % 13 > (tourney_hand_summary.card_2 - 1) % 13 AND NOT (tourney_hand_summary.card_4 - 1) % 13 = (tourney_hand_summary.card_1 - 1) % 13)
OR (tourney_hand_summary.card_2 % 13 = tourney_hand_summary.card_3 % 13 AND tourney_hand_summary.card_1 % 13 BETWEEN 1 AND 6 AND (tourney_hand_summary.card_4 - 1) % 13 > (tourney_hand_summary.card_1 - 1) % 13 AND NOT (tourney_hand_summary.card_4 - 1) % 13 = (tourney_hand_summary.card_2 - 1) % 13))
AND NOT ((tourney_hand_summary.card_1 % 13 = tourney_hand_summary.card_2 % 13) AND (tourney_hand_summary.card_2 % 13 = tourney_hand_summary.card_3 % 13))

This specifies that the turn is higher than the unpaired card and that it is not the same as one of the paired cards but you can change that as you see fit. At the end I've also added a check to make sure the flop isn't three of a kind as it looks like you wouldn't want that either.