Facing check-raise report.

[Dan1857]

I would like to create a player report for circumstances when I am cbetting ~half pot and facing a check raise of 2.5x. How can I do this please?

[kraada]

You can create a regular player report for this - the simple filters you want are in Actions & Opportunities -> Flop -> Bet Sizing and Actions Encountered With Sizes.

[Dan1857]

Thanks.

For action encountered, Say pot is 2bb and cbet is 1bb and check-raise is 2.5bb in game. In actions encountered do I set raise to 1.5bb or 2.5bb?

[kraada]

Actually as I think about it the easiest way to do that might be with the a filter expression. This gets you check raises of 2.4 to 2.6 times your flop bet:

cash_hand_player_statistics.amt_f_raise_facing between 2.4 * cash_hand_player_statistics.amt_f_bet_made and 2.6 * cash_hand_player_statistics.amt_f_bet_made

[Dan1857]

Thanks for help so far.

I actually use this for spin and gos/tournaments. I guess I have to change some of the expression from cash_hand_player to something else?

[kraada]

Replace "cash" with "tourney".

[Dan1857]

I think ill leave the filter expressions for another time.

Have worked out how to do it for simple filters now. Thanks for help.

[dave2085]

Hey,

actually topic is about Bluffraising River and the Raisesize occured.
These are my expression for >2x and <2.5x River raise:

Code: Select all

sum(if[((cash_hand_player_combinations.flg_r_highcard)
OR (cash_hand_player_combinations.flg_r_1pair AND cash_hand_player_combinations.id_r_hand_strength < 3)
OR (cash_hand_player_combinations.flg_r_1pair AND cash_hand_player_combinations.id_r_hand_strength = 4)
OR (cash_hand_player_combinations.flg_r_1pair AND cash_hand_player_combinations.id_r_hand_strength = 5)
OR (cash_hand_player_combinations.flg_r_2pair AND cash_hand_player_combinations.id_r_hand_strength < 3)
OR (cash_hand_player_combinations.flg_r_2pair AND cash_hand_player_combinations.id_r_hand_strength = 4)
OR (cash_hand_player_combinations.flg_r_2pair AND cash_hand_player_combinations.id_r_hand_strength = 5)
OR (cash_hand_player_combinations.flg_r_threeoak AND cash_hand_player_combinations.id_r_hand_strength = 0)
OR (cash_hand_player_combinations.flg_r_straight AND cash_hand_player_combinations.id_r_hand_strength = 0)
OR (cash_hand_player_combinations.flg_r_flush AND cash_hand_player_combinations.id_r_hand_strength = 0)
OR (cash_hand_player_combinations.flg_r_fullhouse AND cash_hand_player_combinations.id_r_hand_strength = 0)
OR (cash_hand_player_combinations.flg_r_fouroak AND cash_hand_player_combinations.id_r_hand_strength = 0)
OR (NOT cash_hand_player_combinations.flg_r_strflush AND cash_hand_player_combinations.id_r_hand_strength = 0))
AND (cash_hand_player_statistics.cnt_r_raise > 0) AND (cash_hand_player_statistics.amt_r_raise_made / cash_hand_player_statistics.amt_r_bet_facing >2 AND cash_hand_player_statistics.amt_r_raise_made / cash_hand_player_statistics.amt_r_bet_facing <2.5) AND cash_hand_summary.cnt_players_f = 2 AND NOT cash_hand_player_statistics.flg_r_3bet , 1, 0])

Code: Select all

sum(if[(cash_hand_player_statistics.cnt_r_raise > 0) AND (cash_hand_player_statistics.amt_r_raise_made / cash_hand_player_statistics.amt_r_bet_facing >2 AND cash_hand_player_statistics.amt_r_raise_made / cash_hand_player_statistics.amt_r_bet_facing <2.5) AND (cash_hand_player_statistics.id_holecard>0) AND cash_hand_summary.cnt_players_f = 2 AND NOT cash_hand_player_statistics.flg_r_3bet, 1, 0])

I am pretty satisfied with it. There is actually one thing which is pretty annoying^^. Its about the effective Stack on the River.

example:

Poker Hand #RC3217652280: Hold'em No Limit ($0.5/$1) - 2025/01/07 11:40:03
Table 'RushAndCash5072126' 6-max Seat #1 is the button
Seat 1: 87dcc542 ($523.35 in chips)
Seat 2: 85485601 ($151.19 in chips)
Seat 3: 2e712d2f ($118.18 in chips)
Seat 4: Hero ($108.54 in chips)
Seat 5: daa4bdac ($103.73 in chips)
Seat 6: d59b6ffa ($109.82 in chips)
85485601: posts small blind $0.5
2e712d2f: posts big blind $1
*** HOLE CARDS ***
Dealt to 87dcc542
Dealt to 85485601
Dealt to 2e712d2f
Dealt to Hero [Ac 5h]
Dealt to daa4bdac
Dealt to d59b6ffa
Hero: folds
daa4bdac: folds
d59b6ffa: folds
87dcc542: folds
85485601: raises $2 to $3
2e712d2f: calls $2
*** FLOP *** [3h 7d 7s]
85485601: checks
2e712d2f: bets $1.98
85485601: raises $4.98 to $6.96
2e712d2f: calls $4.98
*** TURN *** [3h 7d 7s] [9h]
85485601: checks
2e712d2f: bets $24.9
85485601: calls $24.9
*** RIVER *** [3h 7d 7s 9h] [8s]
85485601: checks
2e712d2f: bets $52.29
85485601: raises $64.04 to $116.33 and is all-in
2e712d2f: calls $31.03 and is all-in
Uncalled bet ($33.01) returned to 85485601
85485601: shows [8h 7h] (Sevens Full over Eights)
2e712d2f: shows [7c Jc] (Three Sevens)
*** SHOWDOWN ***
85485601 collected $231.86 from pot
*** SUMMARY ***
Total pot $236.36 | Rake $3 | Jackpot $1.5 | Bingo $0 | Fortune $0 | Tax $0
Board [3h 7d 7s 9h 8s]
Seat 1: 87dcc542 (button) folded before Flop (didn't bet)
Seat 2: 85485601 (small blind) showed [8h 7h] and won ($231.86) with Sevens Full over Eights
Seat 3: 2e712d2f (big blind) showed [7c Jc] and lost with Three Sevens
Seat 4: Hero folded before Flop (didn't bet)
Seat 5: daa4bdac folded before Flop (didn't bet)
Seat 6: d59b6ffa folded before Flop (didn't bet)

for example in this handhistory the 2bettor on the river is Raising between 2x-2.5x, but the effective Stack of the Bettor on the River is <2x of his bet.

Is it somehow possible to include such hands in a stat which is called "River Raise Bluff Frequency <2x".

Is there somehow a way too also factor in the effective stack of the bettor on the river?
So only hands where the effective raise on the River is >2x & <2.5x are counted in the above expressions.
And hands where for example the "effective" raise is <2x are counted for the "River Raise Bluff Frequency <2x" Stat? etc.

[Flag_Hippo]

for example in this handhistory the 2bettor on the river is Raising between 2x-2.5x, but the effective Stack of the Bettor on the River is <2x of his bet.

Is it somehow possible to include such hands in a stat which is called "River Raise Bluff Frequency <2x".

You can add additional tests for the raisers river effective stack with:

Code: Select all

cash_hand_player_statistics.amt_r_effective_stack

in the same way as you are already doing for the raise size made and bet faced tests.

Is there somehow a way too also factor in the effective stack of the bettor on the river?
So only hands where the effective raise on the River is >2x & <2.5x are counted in the above expressions.
And hands where for example the "effective" raise is <2x are counted for the "River Raise Bluff Frequency <2x" Stat? etc.

Something like that would require a subquery but there shouldn't be any reason to test the effective stack of the bettor because your stat is for only two players on the river so the river effective stack of the raiser will be the same as the bettor.

[dave2085]

Code: Select all

cash_hand_player_statistics.amt_r_raise_made < cash_hand_player_statistics.amt_r_effective_stack

The expression is working, but also excludes a lot of situation like this:

Pacific Poker - $1 NL (6 max) - Holdem - 6 players
Hand converted by PokerTracker 4: http://www.pokertracker.com

SB: 103.72 BB (VPIP: 21.62, PFR: 16.22, 3Bet Preflop: 0.00, Hands: 38)
BB: 100 BB (VPIP: 22.18, PFR: 18.83, 3Bet Preflop: 9.90, Hands: 247)
UTG: 126.21 BB (VPIP: 25.00, PFR: 25.00, 3Bet Preflop: 0.00, Hands: 8)
MP: 132.9 BB (VPIP: 31.58, PFR: 15.79, 3Bet Preflop: 0.00, Hands: 21)
CO: 62.6 BB (VPIP: 14.29, PFR: 14.29, 3Bet Preflop: 0.00, Hands: 8)
Hero (BTN): 100 BB

SB posts SB 0.5 BB, BB posts BB 1 BB

Pre Flop: (pot: 1.5 BB) Hero has 9c 9h
fold, fold, fold, Hero raises to 2.5 BB, SB raises to 12 BB, fold, Hero calls 9.5 BB

Flop : (25 BB, 2 players) Qd Qh 5h
SB bets 6.25 BB, Hero calls 6.25 BB

Turn : (37.5 BB, 2 players) 9s
SB bets 12.37 BB, Hero calls 12.37 BB

River : (62.24 BB, 2 players) 2h
SB bets 31.12 BB, Hero raises to 69.38 BB and is all-in, fold

Hero wins 119.48 BB

Situation were the raise is between 2x-2.5x, but the effective stack of the 2bettor on the River is < bettors Stack. Such Scenarios should be included.

Did I incorporate it with the wrong intension?


After all
- I want to include such hand (as described here) in the Stat "River Raise Bluff Frequency 2-2.5x" (opportunities).
- But I want to exclude such hand I described in the post above (the 2bettor is raising bigger then the 2bettors actual stack). And the excluded hand should fall into the category "River Raise Bluff Frequency <2x".

Thanks for you help