Probe Bet in Specific Situation

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Probe Bet in Specific Situation

Postby Mr Tiger » Mon Mar 05, 2012 7:33 pm

The stat has to be the Probe Bet on the Turn (bet turn after PF aggressor checked back on the flop) in 2bet pot (one time raised pot), when there are only 2 players saw the Flop. Please check:

(cnt_t_probe_2b_pot_2pl / cnt_t_probe_2b_pot_2pl_opp) * 100

cnt_t_probe_2b_pot_2pl
sum(if[holdem_hand_player_statistics.flg_t_bet and lookup_actions_f.action LIKE 'X' AND (lookup_actions_p.action LIKE 'C' OR (lookup_actions_p.action LIKE 'CC' AND holdem_hand_player_statistics.flg_p_limp)) AND holdem_hand_player_statistics.flg_p_face_raise AND NOT(holdem_hand_player_detail.flg_t_has_position) AND holdem_hand_summary.cnt_players_f=2, 1, 0])

cnt_t_probe_2b_pot_2pl_opp
sum(if[holdem_hand_player_detail.flg_t_open_opp and lookup_actions_f.action LIKE 'X' AND (lookup_actions_p.action LIKE 'C' OR (lookup_actions_p.action LIKE 'CC' AND holdem_hand_player_statistics.flg_p_limp)) AND holdem_hand_player_statistics.flg_p_face_raise AND NOT(holdem_hand_player_detail.flg_t_has_position) AND holdem_hand_summary.cnt_players_f=2, 1, 0])
Mr Tiger
 
Posts: 143
Joined: Tue Sep 09, 2008 5:14 am

Re: Probe Bet in Specific Situation

Postby Mr Tiger » Mon Mar 05, 2012 8:39 pm

And, please, also check this stat for the River:

(cnt_r_probe_2b_pot_2pl / cnt_r_probe_2b_pot_2pl_opp) * 100

cnt_r_probe_2b_pot_2pl
sum(if[holdem_hand_player_statistics.flg_r_bet and lookup_actions_t.action LIKE 'X' and holdem_hand_player_statistics.enum_f_cbet_action = 'C' and NOT(lookup_actions_f.action LIKE '%R') AND
NOT(holdem_hand_player_detail.flg_t_has_position) AND (lookup_actions_p.action LIKE 'C' OR (lookup_actions_p.action LIKE 'CC' AND holdem_hand_player_statistics.flg_p_limp) OR lookup_actions_p.action LIKE 'R') AND holdem_hand_summary.cnt_players_f=2, 1, 0])

cnt_r_probe_2b_pot_2pl_opp
sum(if[holdem_hand_player_detail.flg_r_open_opp and lookup_actions_t.action LIKE 'X' and holdem_hand_player_statistics.enum_f_cbet_action = 'C' and NOT(lookup_actions_f.action LIKE '%R') AND
NOT(holdem_hand_player_detail.flg_t_has_position) AND (lookup_actions_p.action LIKE 'C' OR (lookup_actions_p.action LIKE 'CC' AND holdem_hand_player_statistics.flg_p_limp) OR lookup_actions_p.action LIKE 'R') AND holdem_hand_summary.cnt_players_f=2, 1, 0])
Mr Tiger
 
Posts: 143
Joined: Tue Sep 09, 2008 5:14 am

Re: Probe Bet in Specific Situation

Postby WhiteRider » Tue Mar 06, 2012 4:23 am

They look good! :)

In the river version you don't need "NOT(lookup_actions_f.action LIKE '%R')" because if there are 2 players to the flop and the player called a c-bet then they can't have raised later, but that won't matter.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Probe Bet in Specific Situation

Postby Mr Tiger » Tue Mar 06, 2012 8:37 am

Thanks for the answer :)
Mr Tiger
 
Posts: 143
Joined: Tue Sep 09, 2008 5:14 am

Re: Probe Bet in Specific Situation

Postby Mr Tiger » Tue Mar 06, 2012 5:54 pm

I've just made a stat "Fold to River Probe bet after Flop Float in 2bet pot with 2 players saw Flop": the player call PF, Float F, Check behind Turn and Fold to River Bet. But it always returns 0/0 (even with very large sample size). I don't understand, what's wrong here:

(cnt_r_probe_2b_pot_2pl_FloatF_def_action_fold / cnt_r_probe_2b_pot_2pl_FloatF_def_opp) * 100

cnt_r_probe_2b_pot_2pl_FloatF_def_action_fold
sum(if[lookup_actions_r.action = 'F' and lookup_actions_t.action = 'X' AND holdem_hand_player_statistics.flg_t_cbet_opp AND holdem_hand_player_detail.flg_t_has_position AND holdem_hand_summary.cnt_players_f=2 AND NOT(lookup_actions_f.action = '%R%') AND holdem_hand_player_statistics.flg_p_face_raise AND (lookup_actions_p.action = 'C' OR (lookup_actions_p.action LIKE 'CC' AND holdem_hand_player_statistics.flg_p_limp)), 1, 0])

cnt_r_probe_2b_pot_2pl_FloatF_def_opp
sum(if[holdem_hand_player_detail.amt_r_bet_facing > 0 and lookup_actions_t.action = 'X' AND holdem_hand_player_statistics.flg_t_cbet_opp AND holdem_hand_player_detail.flg_t_has_position AND holdem_hand_summary.cnt_players_f=2 AND NOT(lookup_actions_f.action = '%R%') AND holdem_hand_player_statistics.flg_p_face_raise AND (lookup_actions_p.action = 'C' OR (lookup_actions_p.action LIKE 'CC' AND holdem_hand_player_statistics.flg_p_limp)), 1, 0])
Mr Tiger
 
Posts: 143
Joined: Tue Sep 09, 2008 5:14 am

Re: Probe Bet in Specific Situation

Postby kraada » Tue Mar 06, 2012 6:40 pm

You can't have a chance to cbet the turn when your initial preflop action was only to call - that is why you are always getting 0 here.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Probe Bet in Specific Situation

Postby Mr Tiger » Tue Mar 06, 2012 6:50 pm

Why? For example, I call PF on the button vs raise from the CO. Then CO checks on the Flop, I bet. And then I can Cbet the Turn.
Mr Tiger
 
Posts: 143
Joined: Tue Sep 09, 2008 5:14 am

Re: Probe Bet in Specific Situation

Postby WhiteRider » Wed Mar 07, 2012 4:36 am

A "CBet" is a continuation bet, and you can only "continue" when you were the preflop aggressor, and on each street you can only cbet if you cbet the previous street. If you were not the last to raise preflop you cannot make a cbet at any point.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Probe Bet in Specific Situation

Postby Mr Tiger » Wed Mar 07, 2012 8:49 am

For example, I call PF on SB vs BU. Then I donk the flop, he calls, then I bet the turn. So, is this turn bet a CBet? I always thought, that Cbet is your bet (when opening the action on current street), when you were an aggressor on previous street. And it doesn't depend on your preflop actions if you are C-betting the river.
Mr Tiger
 
Posts: 143
Joined: Tue Sep 09, 2008 5:14 am

Re: Probe Bet in Specific Situation

Postby kraada » Wed Mar 07, 2012 9:47 am

Not in PokerTracker terms - you can cbet the flop if you were the last preflop aggressor. You can only cbet the turn if you cbet the flop, and you can only cbet the river if you cbet the turn. Doing anything else breaks the chain (if you get raised and you 3bet you can still keep cbetting but if you get raised and call you cannot).
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Next

Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 8 guests

cron