Bet in position & Bet out of position

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

Bet in position & Bet out of position

Postby Hidro_Tracker » Sat Oct 09, 2010 8:24 am

Hello, is there a stat to know what percentage of times an opponent makes a "Bet in position" after a player has done PFR has not made the Cont Bet?

And when you make an "Bet OOP"?

Thanks and regards

Hidro
Hidro_Tracker
 
Posts: 72
Joined: Thu Apr 22, 2010 12:50 pm

Re: Bet in position & Bet out of position

Postby kraada » Sat Oct 09, 2010 9:19 am

The bet on the flop in position after the preflop raiser checked and did not cbet is a Flop Float. A bet out of position on the flop before the preflop raiser had a chance to act is a Flop Donk. A bet on the turn out of position after the preflop raiser checked behind (and did not cbet) on the flop is a Turn Probe.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Bet in position & Bet out of position

Postby Hidro_Tracker » Sat Oct 09, 2010 12:51 pm

Thanks, but thought that "Float Flop" was to call and not a Bet. I thought "Float" was to call on all streets.

And the "Donk Bet is the betting preflop OOP when the aggressor is in position in relation to us ..

The "Bet OOP" I'd like is when there has been no preflop raise (all limpers), and for example we are playing a freeplay from the Big Blind.

Thanks
Hidro_Tracker
 
Posts: 72
Joined: Thu Apr 22, 2010 12:50 pm

Re: Bet in position & Bet out of position

Postby WhiteRider » Sat Oct 09, 2010 3:53 pm

Hidro_Tracker wrote:Thanks, but thought that "Float Flop" was to call and not a Bet. I thought "Float" was to call on all streets.

Different people say "float" for different specific actions, but primarily it is calling one street to bet if the out-of-position aggressor checks the next street to you.
This also requires there to be a preflop aggressor, though.

And the "Donk Bet is the betting preflop OOP when the aggressor is in position in relation to us ..

The "Bet OOP" I'd like is when there has been no preflop raise (all limpers), and for example we are playing a freeplay from the Big Blind.

To build stats like this you can use the database field "holdem_hand_player_detail.flg_f_has_position" to build a new version of the bet flop stat.
If you want to count specifically hands where there was no raise preflop you can use "holdem_hand_player_statistics.cnt_p_raise = 0 AND NOT(holdem_hand_player_statistics.flg_p_face_raise)"

Columns like this:

cnt_p_limp_f_bet_ip =
sum( if[ holdem_hand_player_statistics.cnt_p_raise = 0 AND NOT(holdem_hand_player_statistics.flg_p_face_raise) AND holdem_hand_player_detail.flg_f_has_position AND holdem_hand_player_statistics.flg_f_bet, 1, 0 ] )

cnt_p_limp_f_bet_ip_opp =
sum( if[ holdem_hand_player_statistics.cnt_p_raise = 0 AND NOT(holdem_hand_player_statistics.flg_p_face_raise) AND holdem_hand_player_detail.flg_f_has_position AND (holdem_hand_player_statistics.flg_f_bet OR holdem_hand_player_statistics.flg_f_check), 1, 0 ] )

Then your stat could be:

( cnt_p_limp_f_bet_ip / cnt_p_limp_f_bet_ip_opp ) * 100

To build a stat from expressions like these see the Tutorial: Custom Reports and Statistics.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Bet in position & Bet out of position

Postby Hidro_Tracker » Sun Oct 10, 2010 4:51 am

Wooowww, this is mostly superior programming, lol. I'll look more closely and looking at the help link indicated and if I have any questions or need does the stat I post it again.

Thank you very much.

Hidro
Hidro_Tracker
 
Posts: 72
Joined: Thu Apr 22, 2010 12:50 pm

Re: Bet in position & Bet out of position

Postby ShyPh » Sat Nov 06, 2010 1:48 pm

WhiteRider wrote:
cnt_p_limp_f_bet_ip =
sum( if[ holdem_hand_player_statistics.cnt_p_raise = 0 AND NOT(holdem_hand_player_statistics.flg_p_face_raise) AND holdem_hand_player_detail.flg_f_has_position AND holdem_hand_player_statistics.flg_f_bet, 1, 0 ] )

cnt_p_limp_f_bet_ip_opp =
sum( if[ holdem_hand_player_statistics.cnt_p_raise = 0 AND NOT(holdem_hand_player_statistics.flg_p_face_raise) AND holdem_hand_player_detail.flg_f_has_position AND (holdem_hand_player_statistics.flg_f_bet OR holdem_hand_player_statistics.flg_f_check), 1, 0 ] )


These are very interesting stats. I've tried making equivalent columns: cnt_p_limp_f_call_ip / cnt_p_limp_f_call_ip_opp and cnt_p_limp_f_raise_ip / cnt_p_limp_f_raise_ip_opp but there are no holdem_hand_player_statistics.flg_f_call / raise entries. Any idea how I can implement these stats?
ShyPh
 
Posts: 17
Joined: Wed Apr 09, 2008 1:06 pm

Re: Bet in position & Bet out of position

Postby WhiteRider » Sat Nov 06, 2010 2:26 pm

You can call or raise more than once, so the database stores: holdem_hand_player_statistics.cnt_f_raise and holdem_hand_player_statistics.cnt_f_call, which are the count ("cnt") of how often you called or raised.
To see if you raised, use:
holdem_hand_player_statistics.cnt_f_raise > 0
..or called:
holdem_hand_player_statistics.cnt_f_call > 0
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


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

Who is online

Users browsing this forum: No registered users and 0 guests