set of stats for wet/dry flops

[js2002]

puke
who build them? Is there no documentary?
(I have to combine serveral board filters and it would take hours to find everything in the logs.)

[kraada]

Our development team did. My understanding is that the main trick is to compare board cards by using modulo as that gives you the rank.

[mkk6]

Code for Boards where a Straight is possible on the flop:

Code: Select all

(((cash_hand_summary.card_1 %13 = 0 AND cash_hand_summary.card_2 %13 >=9 AND cash_hand_summary.card_3 %13>=9) OR
(cash_hand_summary.card_2 %13 = 0 AND cash_hand_summary.card_1 %13 >=9 AND cash_hand_summary.card_3 %13>=9) OR
(cash_hand_summary.card_3 %13 = 0 AND cash_hand_summary.card_1 %13 >=9 AND cash_hand_summary.card_2 %13>=9) AND
(not(cash_hand_summary.card_1 %13 = cash_hand_summary.card_2 %13) OR not(cash_hand_summary.card_1 %13 = cash_hand_summary.card_3 %13) OR
not(cash_hand_summary.card_2 %13 = cash_hand_summary.card_3 %13))) OR
(((cash_hand_summary.card_1 %13 > cash_hand_summary.card_2%13 AND cash_hand_summary.card_1 %13 > cash_hand_summary.card_3%13)
AND (cash_hand_summary.card_2 %13 > cash_hand_summary.card_3%13) AND ((cash_hand_summary.card_1 %13 - cash_hand_summary.card_3%13) <5)) OR
((cash_hand_summary.card_1 %13 > cash_hand_summary.card_2%13 AND cash_hand_summary.card_1 %13 > cash_hand_summary.card_3%13)
AND (cash_hand_summary.card_3 %13 > cash_hand_summary.card_2%13) AND ((cash_hand_summary.card_1 %13 - cash_hand_summary.card_2%13) <5)) OR 
((cash_hand_summary.card_2 %13 > cash_hand_summary.card_1%13 AND cash_hand_summary.card_2 %13 > cash_hand_summary.card_3%13)
AND (cash_hand_summary.card_1 %13 > cash_hand_summary.card_3%13) AND ((cash_hand_summary.card_2 %13 - cash_hand_summary.card_3%13) <5)) OR 
((cash_hand_summary.card_2 %13 > cash_hand_summary.card_1%13 AND cash_hand_summary.card_2 %13 > cash_hand_summary.card_3%13)
AND (cash_hand_summary.card_3 %13 > cash_hand_summary.card_1%13) AND ((cash_hand_summary.card_2 %13 - cash_hand_summary.card_1%13) <5)) OR
((cash_hand_summary.card_3 %13 > cash_hand_summary.card_1%13 AND cash_hand_summary.card_3 %13 > cash_hand_summary.card_2%13)
AND (cash_hand_summary.card_2 %13 > cash_hand_summary.card_1%13) AND ((cash_hand_summary.card_3 %13 - cash_hand_summary.card_1 %13) <5)) OR
((cash_hand_summary.card_3%13 > cash_hand_summary.card_1%13 AND cash_hand_summary.card_3%13 > cash_hand_summary.card_2%13)
AND (cash_hand_summary.card_1%13 > cash_hand_summary.card_2%13) AND ((cash_hand_summary.card_3%13 - cash_hand_summary.card_2%13) <5))))

Basically checking for an Ace on the flop, and so if the other cards are also Broadways->Str8 possible
The second Part is checking if the gap between the lowest and highest card is <5->Str8 possible.

Maybe not the fastest way but at least it should give you a start.
Have fun

[js2002]

Well I would check:

- max of 3 card difference to min of 3 cards, but then I saw that cardrank 13 (Ace) can also make str8s. So we have to add a check for that.

...since I want "str8draw" possible checks: I need to compare all cards....

[kraada]

You guys need to remember that aces can be both high (in broadway straights) and low (in wheel straights). I don't think that was accounted for in the above code

[mkk6]

You guys need to remember that aces can be both high (in broadway straights) and low (in wheel straights). I don't think that was accounted for in the above code

its checked in my code.
I am checking for an all Broadway flop incl. Ace. ->Broadway Str8s covered. The Gap<5 works for the rest.

[js2002]

you got a stat ready?

[mkk6]

Just add the Code to your preferred Stat:
CBet Flop Str8:
(cnt_f_cbet_str8/cnt_f_cbet_str8_opp)*100

cnt_f_cbet_str8

Spoiler: show

Code: Select all

sum(if[cash_hand_player_statistics.flg_f_cbet AND
(((cash_hand_summary.card_1 %13 = 0 AND cash_hand_summary.card_2 %13 >=9 AND cash_hand_summary.card_3 %13>=9) OR
(cash_hand_summary.card_2 %13 = 0 AND cash_hand_summary.card_1 %13 >=9 AND cash_hand_summary.card_3 %13>=9) OR
(cash_hand_summary.card_3 %13 = 0 AND cash_hand_summary.card_1 %13 >=9 AND cash_hand_summary.card_2 %13>=9) AND
(not(cash_hand_summary.card_1 %13 = cash_hand_summary.card_2 %13) OR not(cash_hand_summary.card_1 %13 = cash_hand_summary.card_3 %13) OR
not(cash_hand_summary.card_2 %13 = cash_hand_summary.card_3 %13))) OR
(((cash_hand_summary.card_1 %13 > cash_hand_summary.card_2%13 AND cash_hand_summary.card_1 %13 > cash_hand_summary.card_3%13)
AND (cash_hand_summary.card_2 %13 > cash_hand_summary.card_3%13) AND ((cash_hand_summary.card_1 %13 - cash_hand_summary.card_3%13) <5)) OR
((cash_hand_summary.card_1 %13 > cash_hand_summary.card_2%13 AND cash_hand_summary.card_1 %13 > cash_hand_summary.card_3%13)
AND (cash_hand_summary.card_3 %13 > cash_hand_summary.card_2%13) AND ((cash_hand_summary.card_1 %13 - cash_hand_summary.card_2%13) <5)) OR 
((cash_hand_summary.card_2 %13 > cash_hand_summary.card_1%13 AND cash_hand_summary.card_2 %13 > cash_hand_summary.card_3%13)
AND (cash_hand_summary.card_1 %13 > cash_hand_summary.card_3%13) AND ((cash_hand_summary.card_2 %13 - cash_hand_summary.card_3%13) <5)) OR 
((cash_hand_summary.card_2 %13 > cash_hand_summary.card_1%13 AND cash_hand_summary.card_2 %13 > cash_hand_summary.card_3%13)
AND (cash_hand_summary.card_3 %13 > cash_hand_summary.card_1%13) AND ((cash_hand_summary.card_2 %13 - cash_hand_summary.card_1%13) <5)) OR
((cash_hand_summary.card_3 %13 > cash_hand_summary.card_1%13 AND cash_hand_summary.card_3 %13 > cash_hand_summary.card_2%13)
AND (cash_hand_summary.card_2 %13 > cash_hand_summary.card_1%13) AND ((cash_hand_summary.card_3 %13 - cash_hand_summary.card_1 %13) <5)) OR
((cash_hand_summary.card_3%13 > cash_hand_summary.card_1%13 AND cash_hand_summary.card_3%13 > cash_hand_summary.card_2%13)
AND (cash_hand_summary.card_1%13 > cash_hand_summary.card_2%13) AND ((cash_hand_summary.card_3%13 - cash_hand_summary.card_2%13) <5)))), 1, 0])

cnt_f_cbet_str8_opp

Spoiler: show

Code: Select all

sum(if[cash_hand_player_statistics.flg_f_cbet_opp AND
(((cash_hand_summary.card_1 %13 = 0 AND cash_hand_summary.card_2 %13 >=9 AND cash_hand_summary.card_3 %13>=9) OR
(cash_hand_summary.card_2 %13 = 0 AND cash_hand_summary.card_1 %13 >=9 AND cash_hand_summary.card_3 %13>=9) OR
(cash_hand_summary.card_3 %13 = 0 AND cash_hand_summary.card_1 %13 >=9 AND cash_hand_summary.card_2 %13>=9) AND
(not(cash_hand_summary.card_1 %13 = cash_hand_summary.card_2 %13) OR not(cash_hand_summary.card_1 %13 = cash_hand_summary.card_3 %13) OR
not(cash_hand_summary.card_2 %13 = cash_hand_summary.card_3 %13))) OR
(((cash_hand_summary.card_1 %13 > cash_hand_summary.card_2%13 AND cash_hand_summary.card_1 %13 > cash_hand_summary.card_3%13)
AND (cash_hand_summary.card_2 %13 > cash_hand_summary.card_3%13) AND ((cash_hand_summary.card_1 %13 - cash_hand_summary.card_3%13) <5)) OR
((cash_hand_summary.card_1 %13 > cash_hand_summary.card_2%13 AND cash_hand_summary.card_1 %13 > cash_hand_summary.card_3%13)
AND (cash_hand_summary.card_3 %13 > cash_hand_summary.card_2%13) AND ((cash_hand_summary.card_1 %13 - cash_hand_summary.card_2%13) <5)) OR 
((cash_hand_summary.card_2 %13 > cash_hand_summary.card_1%13 AND cash_hand_summary.card_2 %13 > cash_hand_summary.card_3%13)
AND (cash_hand_summary.card_1 %13 > cash_hand_summary.card_3%13) AND ((cash_hand_summary.card_2 %13 - cash_hand_summary.card_3%13) <5)) OR 
((cash_hand_summary.card_2 %13 > cash_hand_summary.card_1%13 AND cash_hand_summary.card_2 %13 > cash_hand_summary.card_3%13)
AND (cash_hand_summary.card_3 %13 > cash_hand_summary.card_1%13) AND ((cash_hand_summary.card_2 %13 - cash_hand_summary.card_1%13) <5)) OR
((cash_hand_summary.card_3 %13 > cash_hand_summary.card_1%13 AND cash_hand_summary.card_3 %13 > cash_hand_summary.card_2%13)
AND (cash_hand_summary.card_2 %13 > cash_hand_summary.card_1%13) AND ((cash_hand_summary.card_3 %13 - cash_hand_summary.card_1 %13) <5)) OR
((cash_hand_summary.card_3%13 > cash_hand_summary.card_1%13 AND cash_hand_summary.card_3%13 > cash_hand_summary.card_2%13)
AND (cash_hand_summary.card_1%13 > cash_hand_summary.card_2%13) AND ((cash_hand_summary.card_3%13 - cash_hand_summary.card_2%13) <5)))), 1, 0])

[js2002]

The stat def is "made str8" right?
why dont u use this: tourney_hand_player_combinations.flg_f_straight (change it for cash)

[mkk6]

I am only checking the Flopcards, if a straight would be possible. Dont care if the Player has a straight or what are the holecards.
Think the flg_f_straight is checking, if the Player has the straight. (?)