MW pot gets checked around. X% bet out on Turn

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

MW pot gets checked around. X% bet out on Turn

Postby Highstakes0 » Fri Dec 09, 2011 4:24 pm

MW pot gets checked around. X% bet out on Turn when Villain is in first position.
Is there a stat for this in HUD?`Couldn't find it.
Is it possible to get one or a smart way to
extrapolate to get the information?

sry if wrong forum
Highstakes0
 
Posts: 23
Joined: Mon Mar 10, 2008 6:49 am

Re: MW pot gets checked around. X% bet out on Turn

Postby kraada » Fri Dec 09, 2011 6:47 pm

There isn't a stat for this at the moment but it could be built. You'd build the columns like so:

cnt_t_bet_mw_x_flop: sum(if[lookup_actions_f.action = 'X' and holdem_hand_summary.cnt_players_f >= 3 and holdem_hand_player_detail.flg_t_first and holdem_hand_player_statistics.flg_t_bet, 1, 0])

and

cnt_t_first_mw_x_flop: sum(if[lookup_actions_f.action = 'X' and holdem_hand_summary.cnt_players_f >= 3 and holdem_hand_player_detail.flg_t_first, 1, 0])

Put the former over the latter and multiply by 100 to get your stat. For more on custom statistics and reports 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 1 guest