4bet range

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

Re: 4bet range

Postby bender » Wed Jun 24, 2009 6:37 am

WhiteRider wrote:
stevi3p wrote:Re: float flop, I can't see that in the repository. Is there anyway of downloading that stat without having to download and import the entire layout? I don't really want many of the stats in there....

I'm sure kraada will be able to set you up with this when he gets back.


I can't find float stats in the repository.
Could you create a separate from layout float stats and put it into repository?
bender
 
Posts: 70
Joined: Wed Apr 30, 2008 3:50 pm

Re: 4bet range

Postby WhiteRider » Wed Jun 24, 2009 6:51 am

bender wrote:
WhiteRider wrote:
stevi3p wrote:Re: float flop, I can't see that in the repository. Is there anyway of downloading that stat without having to download and import the entire layout? I don't really want many of the stats in there....

I'm sure kraada will be able to set you up with this when he gets back.


I can't find float stats in the repository.
Could you create a separate from layout float stats and put it into repository?

Sorry - kraada must have missed your post before.
The Float Flop stat is attached.
Attachments
Float Flop.zip
(628 Bytes) Downloaded 497 times
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: 4bet range

Postby antiguy » Wed Dec 22, 2010 5:06 pm

I know this is an old post but how about this 4bet range stat based off First Raise instead of PFR.

Column cnt_p_4bet_after_p_first_raise
Code: Select all
sum(if[ holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.flg_p_4bet, 1, 0])

and
Column cnt_p_4bet_after_p_first_raise_opp
Code: Select all
sum(if[ holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.flg_p_4bet_opp, 1, 0])


Stat
Code: Select all
(cnt_p_first_raise / cnt_p_limp_opp) / (100 * (cnt_p_4bet_after_p_first_raise / cnt_p_4bet_after_p_first_raise_opp))


I know this won't count times a player A raises and player B 3bets and player C 4bets but wouldn't 4bets happen more often after a player A raises gets 3bet then player A 4bets? Maybe I should figure how to incorporate 4bet after 3bet when 4bet player not in pot yet into this stat. I'm new to all this so It might take me a min.

Why would you use PFR for this range anyway? It counts all pf raises right? You can't 3bet when someone 3bet you so why would you need this data in a 4bet range stat? Maybe I'm wrong. What do you think?
antiguy
 
Posts: 10
Joined: Mon Aug 09, 2010 9:37 pm

Re: 4bet range

Postby antiguy » Wed Dec 22, 2010 5:44 pm

Maybe I got it for 4bet not first raiser to include in above stat...check it out

Column cnt_p_4bet_not_p_first_raise
Code: Select all
sum(if[ (NOT(holdem_hand_player_statistics.flg_p_first_raise)) AND holdem_hand_player_statistics.flg_p_4bet, 1, 0])


Column cnt_p_4bet_not_p_first_raise_opp
Code: Select all
sum(if[ (NOT(holdem_hand_player_statistics.flg_p_first_raise)) AND holdem_hand_player_statistics.flg_p_4bet_opp, 1, 0])


Stat 4Bet Range of First Raise
Code: Select all
(cnt_p_first_raise / cnt_p_limp_opp) / (100 * ( (cnt_p_4bet_after_p_first_raise / cnt_p_4bet_after_p_first_raise_opp) + (cnt_p_4bet_not_p_first_raise / cnt_p_4bet_not_p_first_raise_opp) ) )


As I am writing this I got to thinking... This would be the same as
Stat
Code: Select all
(cnt_p_first_raise / cnt_p_limp_opp) / (100 * (cnt_p_4bet / cnt_p_4bet_opp))

right? I'm always making things harder for myself!!!!
antiguy
 
Posts: 10
Joined: Mon Aug 09, 2010 9:37 pm

Re: 4bet range

Postby kraada » Wed Dec 22, 2010 6:02 pm

That all looks good to me - and yes, you're right about the very last stat, but don't feel bad, I still do that too :)
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Previous

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

Who is online

Users browsing this forum: No registered users and 5 guests