Steal limped pot stat

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

Steal limped pot stat

Postby Harnas31 » Fri Nov 25, 2011 9:26 am

Can I get this stat ?
Player is last to act in a limped pot.
The flop comes and everybody checks to that player. He bets and this betting is treated as stealing a limped pot.
Harnas31
 
Posts: 43
Joined: Sat Nov 27, 2010 12:44 pm

Re: Steal limped pot stat

Postby kraada » Fri Nov 25, 2011 10:51 am

Create the following two columns and use them to build your custom stat.

cnt_f_steal_limped_pot: sum(if[holdem_hand_player_detail.flg_f_has_position and not(holdem_hand_player_statistics.flg_p_face_raise) and holdem_hand_player_statistics.flg_p_limp and holdem_hand_player_statistics.flg_f_bet, 1, 0])

cnt_f_steal_limped_pot_opp: sum(if[holdem_hand_player_detail.flg_f_has_position and not(holdem_hand_player_statistics.flg_p_face_raise) and holdem_hand_player_statistics.flg_p_limp and holdem_hand_player_detail.flg_f_open_opp, 1, 0])

For more on creating custom statistics please see the Tutorial: Using Custom Statistics and Reports.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


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

Who is online

Users browsing this forum: No registered users and 2 guests