Bet Flop & Fold Flop in Limp Pot

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 Flop & Fold Flop in Limp Pot

Postby VNix » Fri Jan 14, 2011 12:17 pm

Hello!

Please help me...this stats wrong or not ?:

Bet Flop:

((cnt_f_bet - cnt_f_cbet - cnt_f_donk - cnt_f_float) / (cnt_f_bet - cnt_f_cbet - cnt_f_donk - cnt_f_float + cnt_f_check)) * 100

Fold Flop:

((cnt_f_bet_def_action_fold - cnt_f_cbet_def_action_fold - cnt_f_donk_def_opp_action_fold - cnt_f_float_def_opp_action_fold ) / (cnt_f_bet_def_opp - cnt_f_cbet_def_opp - cnt_f_donk_def_opp - cnt_f_float_def_opp )) * 100

I need only Unraised Preflop (Limped Pots)...
VNix
 
Posts: 11
Joined: Thu Apr 15, 2010 2:49 pm

Re: Bet Flop & Fold Flop in Limp Pot

Postby kraada » Fri Jan 14, 2011 12:48 pm

That looks like it should work I think, but there may be some cases that I'm not thinking of off the top of my head. The safer way would be to build new columns specifically for limp pots - then you'd be certain you've got the proper situations counted.
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 9 guests