Is there a prob bet stat for limped pots?

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

Is there a prob bet stat for limped pots?

Postby hello776 » Sat Nov 19, 2011 5:12 am

This is a common spot HU:
BTN limps, BB checks. BB checks flop, BTN checks flop.
Is there a stat which shows how often BTN folds if BB bets the turn?
hello776
 
Posts: 7
Joined: Tue May 27, 2008 9:46 am

Re: Is there a prob bet stat for limped pots?

Postby WhiteRider » Sat Nov 19, 2011 9:36 am

There isn't a built-in stat for that, but it can be made as a custom stat.

The actions column will be like this:

sum( if[ holdem_hand_summary.cnt_players=2 AND holdem_hand_player_statistics.position=9 AND lookup_actions_p.action = 'C' AND lookup_actions_f.action = 'X' AND lookup_actions_t.action = 'F', 1, 0 ] )

This says that it was a heads up hand and that the player was the small blind and only called preflop, only checked on the flop and only folded on the turn, which defines the series of actions you want.

The opportunities column is very similar except that instead of checking for the player folding the turn we check that they faced a bet (by checking that they didn't have the opportunity to open):

sum( if[ holdem_hand_summary.cnt_players=2 AND holdem_hand_player_statistics.position=9 AND lookup_actions_p.action = 'C' AND lookup_actions_f.action = 'X' AND NOT holdem_hand_player_detail.flg_t_open_opp, 1, 0 ] )

For a walkthrough of how to build a stat from these column expressions please see the Tutorial: Custom Reports and Statistics.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Is there a prob bet stat for limped pots?

Postby hello776 » Sun Nov 20, 2011 1:53 am

I tried setting up this stat for tourneys but isn't working. It just says NA on the HUD even when the situation occurs which should affect this stat.

This is how I tried creating the stat.

Column name: cnt_a_probe
Expression:
sum( if[ tourney_holdem_hand_summary.cnt_players=2 AND tourney_holdem_hand_player_statistics.position=9 AND lookup_actions_p.action = 'C' AND lookup_actions_f.action = 'X' AND lookup_actions_t.action = 'F', 1, 0 ] )

Column name: cnt_a_opp_probe
Expression:
sum( if[ tourney_holdem_hand_summary.cnt_players=2 AND tourney_holdem_hand_player_statistics.position=9 AND lookup_actions_p.action = 'C' AND lookup_actions_f.action = 'X' AND NOT tourney_holdem_hand_player_detail.flg_t_open_opp, 1, 0 ] )

For Statistic expression: (cnt_a_probe / cnt_a_opp_probe) * 100

Any idea how to fix this? I was reading the tutorial but it honestly goes over my head.
hello776
 
Posts: 7
Joined: Tue May 27, 2008 9:46 am

Re: Is there a prob bet stat for limped pots?

Postby hello776 » Sun Nov 20, 2011 3:43 am

Got it working. I had used oop in a spot where it should have been opp.
hello776
 
Posts: 7
Joined: Tue May 27, 2008 9:46 am

Re: Is there a prob bet stat for limped pots?

Postby WhiteRider » Sun Nov 20, 2011 6:10 am

Great! Thanks for letting us know.
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 1 guest