set of stats for wet/dry flops

[js2002]

I forgot, sure,

[bruzi]

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])

Guys is this stats completed ?
Thx..

[js2002]

not yet, will do it in April

[Uhlvar]

Anyone done any work in coding the dry and wet flops?

Just a thought I had. Wouldnt it be easier to define a dry flop (check that there is enough gaps, no monotone board, no paired or trips) and then define all the other boards as wet?

Im also not sure how a board like J43tt would be defined, dry or wet? Maybe also have a check for how high the connected cards are, lower is certainly "dryer".

[kraada]

It's definitely a tricky thing to divide up the space of possible boards. I'd expect that reasonable minds would disagree on the edge cases.