[HU srp] CBet on T-high rainbow

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

[HU srp] CBet on T-high rainbow

Postby mr_maxxx » Mon Aug 06, 2018 9:31 am

I am trying to build stats for different board textures. There are probably many mistakes in it. Please help me out.
This one is supposed to be CBet% in a HU srp on a T-high rainbow board:

(cnt_f_cbet_thigh_r / cnt_f_cbet_opp_thigh_r) * 100

cnt_f_cbet_thigh_r
sum(if[cash_hand_player_statistics.flg_f_cbet AND cash_hand_summary.cnt_players = 2 and not cash_hand_player_statistics.flg_p_3bet and cash_hand_player_statistics.cnt_p_face_limpers = 0
and ((cash_hand_summary.card_1 % 13 <= 9) and (cash_hand_summary.card_2 % 13 <= 9) and (cash_hand_summary.card_3 % 13 <= 9)) and
(((cash_hand_summary.card_1 - 1) - ((cash_hand_summary.card_1 - 1) % 13)) / 4) <> (((cash_hand_summary.card_2 - 1) - ((cash_hand_summary.card_2 - 1) % 13)) / 4) <> (((cash_hand_summary.card_3 - 1) - ((cash_hand_summary.card_3 - 1) % 13)) / 4), 1, 0])

cnt_f_cbet_opp_thigh_r
sum(if[cash_hand_player_statistics.flg_f_cbet_opp AND cash_hand_summary.cnt_players = 2 and not cash_hand_player_statistics.flg_p_3bet and cash_hand_player_statistics.cnt_p_face_limpers = 0
and ((cash_hand_summary.card_1 % 13 <= 9) and (cash_hand_summary.card_2 % 13 <= 9) and (cash_hand_summary.card_3 % 13 <= 9)) and
(((cash_hand_summary.card_1 - 1) - ((cash_hand_summary.card_1 - 1) % 13)) / 4) <> (((cash_hand_summary.card_2 - 1) - ((cash_hand_summary.card_2 - 1) % 13)) / 4) <> (((cash_hand_summary.card_3 - 1) - ((cash_hand_summary.card_3 - 1) % 13)) / 4), 1, 0])


How can I add a rule for paired-ness, saying the board is paired or is not paired?

Are there options to say it´s a 3 connected board, like J97 or can you just do specific boards?

How to specifiy 2-Flush or 3-Flush (Monotone) Boards.

Thanks for helping with board structures, it seems complicated to me.

Edit: If only comparing first and second board card for suits it validates, how do I add the third one?

This validates:
sum(if[cash_hand_player_statistics.flg_f_cbet AND cash_hand_summary.cnt_players = 2 and not cash_hand_player_statistics.flg_p_3bet and cash_hand_player_statistics.cnt_p_face_limpers = 0
and ((cash_hand_summary.card_1 % 13 <= 9) and (cash_hand_summary.card_2 % 13 <= 9) and (cash_hand_summary.card_3 % 13 <= 9)) and (((cash_hand_summary.card_1 - 1) - ((cash_hand_summary.card_1 - 1) % 13)) / 4) <> (((cash_hand_summary.card_2 - 1) - ((cash_hand_summary.card_2 - 1) % 13)) / 4), 1, 0])

My guess for checking if all 3 board cards are rainbow is this, but it doesnt validate:
(((cash_hand_summary.card_1 - 1) - ((cash_hand_summary.card_1 - 1) % 13)) / 4) <> (((cash_hand_summary.card_2 - 1) - ((cash_hand_summary.card_2 - 1) % 13)) / 4) <> (((cash_hand_summary.card_3 - 1) - ((cash_hand_summary.card_3 - 1) % 13)) / 4)
mr_maxxx
 
Posts: 17
Joined: Mon Jan 12, 2009 4:45 pm

Re: [HU srp] CBet on T-high rainbow

Postby mr_maxxx » Mon Aug 06, 2018 11:21 am

I found the definition for not paired board:

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

Would this be the definition for a paired board?

(cash_hand_summary.card_1 % 13 = cash_hand_summary.card_2 % 13) or (cash_hand_summary.card_1 % 13 = cash_hand_summary.card_3 % 13) or (cash_hand_summary.card_2 % 13 = cash_hand_summary.card_3 % 13)

And would this be A 2 Flush Board with unknown third card?

(((cash_hand_summary.card_1 - 1) - ((cash_hand_summary.card_1 - 1) % 13)) / 4) = (((cash_hand_summary.card_2 - 1) - ((cash_hand_summary.card_2 - 1) % 13)) / 4)


Is this a 2 Flush Board?

(((cash_hand_summary.card_1 - 1) - ((cash_hand_summary.card_1 - 1) % 13)) / 4) <> (((cash_hand_summary.card_2 - 1) - ((cash_hand_summary.card_2 - 1) % 13)) / 4)= (((cash_hand_summary.card_2 - 1) - ((cash_hand_summary.card_2 - 1) % 13)) / 4)

Also, does the sequence of board cards matter? For example, would it qualify as 2 Flush if Card 1 and Card 3 are of the same suit, but not Card 2 and Card 3?

I though I made the ultimate Board Texture stat, but the results are 100%, like all flops are considered. Please find my bug, its supposed to be CBet% in 3bp, 3 broadways, paired, 2 Flush:

(cnt_f_cbet_3bet_pot_3BW_2Flush_Paired / cnt_f_cbet_opp_3bet_pot_3BW_2Flush_Paired) * 100

cnt_f_cbet_3bet_pot_3BW_2Flush_paired

sum(if[cash_hand_player_statistics.flg_f_cbet AND (cash_hand_player_statistics.flg_p_3bet or cash_hand_player_statistics.flg_p_4bet) and ((cash_hand_summary.card_1 % 13 >=9) and (cash_hand_summary.card_2 % 13 >=9) and (cash_hand_summary.card_3 % 13 >=9)) and (((cash_hand_summary.card_1 - 1) - ((cash_hand_summary.card_1 - 1) % 13)) / 4) = (((cash_hand_summary.card_2 - 1) - ((cash_hand_summary.card_2 - 1) % 13)) / 4) and
(cash_hand_summary.card_1 % 13 = cash_hand_summary.card_2 % 13) or (cash_hand_summary.card_1 % 13 = cash_hand_summary.card_3 % 13) or (cash_hand_summary.card_2 % 13 = cash_hand_summary.card_3 % 13), 1, 0])

cnt_f_cbet_opp_3bet_pot_3BW_2Flush_paired

sum(if[cash_hand_player_statistics.flg_f_cbet_opp AND (cash_hand_player_statistics.flg_p_3bet or cash_hand_player_statistics.flg_p_4bet) and ((cash_hand_summary.card_1 % 13 >=9) and (cash_hand_summary.card_2 % 13 >=9) and (cash_hand_summary.card_3 % 13 >=9)) and (((cash_hand_summary.card_1 - 1) - ((cash_hand_summary.card_1 - 1) % 13)) / 4) = (((cash_hand_summary.card_2 - 1) - ((cash_hand_summary.card_2 - 1) % 13)) / 4) and
(cash_hand_summary.card_1 % 13 = cash_hand_summary.card_2 % 13) or (cash_hand_summary.card_1 % 13 = cash_hand_summary.card_3 % 13) or (cash_hand_summary.card_2 % 13 = cash_hand_summary.card_3 % 13), 1, 0])

Thanks for feedback.
mr_maxxx
 
Posts: 17
Joined: Mon Jan 12, 2009 4:45 pm

Re: [HU srp] CBet on T-high rainbow

Postby WhiteRider » Tue Aug 07, 2018 3:32 am

mr_maxxx wrote:Would this be the definition for a paired board?

(cash_hand_summary.card_1 % 13 = cash_hand_summary.card_2 % 13) or (cash_hand_summary.card_1 % 13 = cash_hand_summary.card_3 % 13) or (cash_hand_summary.card_2 % 13 = cash_hand_summary.card_3 % 13)

That will be true if any two cards have the same rank, but it will also be true if all three cards are the same, so if you want only a pair (and not 3 of a kind) the you'll need to add in a test for the third card being different for each pair.
WhiteRider
Moderator
 
Posts: 53961
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: [HU srp] CBet on T-high rainbow

Postby WhiteRider » Tue Aug 07, 2018 3:39 am

mr_maxxx wrote:And would this be A 2 Flush Board with unknown third card?

(((cash_hand_summary.card_1 - 1) - ((cash_hand_summary.card_1 - 1) % 13)) / 4) = (((cash_hand_summary.card_2 - 1) - ((cash_hand_summary.card_2 - 1) % 13)) / 4)


Is this a 2 Flush Board?

(((cash_hand_summary.card_1 - 1) - ((cash_hand_summary.card_1 - 1) % 13)) / 4) <> (((cash_hand_summary.card_2 - 1) - ((cash_hand_summary.card_2 - 1) % 13)) / 4)= (((cash_hand_summary.card_2 - 1) - ((cash_hand_summary.card_2 - 1) % 13)) / 4)

Also, does the sequence of board cards matter? For example, would it qualify as 2 Flush if Card 1 and Card 3 are of the same suit, but not Card 2 and Card 3?

I'll start with the last question, kind of. You're only testing cards 1 and 2, and you need to test all three cards like you do for the pairs. Cards can be in any order.

The easiest way to get these expressions is to enable logging (Configure > Options) and restart PT4, then apply the filter you're interested in using the built-in filters, and check the log file where you can see the full query.

For example this is a 2-flush board:

Code: Select all
(cash_hand_summary.card_1 - ((cash_hand_summary.card_1 - 1) % 13) = cash_hand_summary.card_2 - ((cash_hand_summary.card_2 - 1) % 13) and cash_hand_summary.card_2 - ((cash_hand_summary.card_2 - 1) % 13) != cash_hand_summary.card_3 - ((cash_hand_summary.card_3 - 1) % 13)) OR (cash_hand_summary.card_1 - ((cash_hand_summary.card_1 - 1) % 13) = cash_hand_summary.card_3 - ((cash_hand_summary.card_3 - 1) % 13) and cash_hand_summary.card_2 - ((cash_hand_summary.card_2 - 1) % 13) != cash_hand_summary.card_3 - ((cash_hand_summary.card_3 - 1) % 13)) OR (cash_hand_summary.card_3 - ((cash_hand_summary.card_3 - 1) % 13) = cash_hand_summary.card_2 - ((cash_hand_summary.card_2 - 1) % 13) and cash_hand_summary.card_1 - ((cash_hand_summary.card_1 - 1) % 13) != cash_hand_summary.card_3 - ((cash_hand_summary.card_3 - 1) % 13))
WhiteRider
Moderator
 
Posts: 53961
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: Ventilatorrr and 25 guests

cron
highfalutin