antiquated stat, check please

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

antiquated stat, check please

Postby js2002 » Tue Sep 28, 2010 1:47 pm

sum(if[ holdem_hand_player_statistics.cnt_p_raise > 0 AND
holdem_hand_player_statistics.flg_p_3bet_def_opp AND holdem_hand_player_statistics.flg_f_cbet_def_opp AND
holdem_hand_player_statistics.enum_f_cbet_action='R' AND
holdem_hand_player_statistics.enum_face_allin='F' AND
holdem_hand_player_statistics.enum_face_allin_action='F'
, 1 , 0 ])

Player raises the cbet at flop in a 3bet pot and folds to a allin (after his raise, so the allin is a flop 3bet I guess)

1. Can u please check my stat? I think holdem_hand_player_statistics.cnt_p_raise > 0 is obsolete/antiquated and u do it better in stats like "fold to cbet in 3bet pot" etc

2. A bro (fan :) greetings!) wants to have this stat ajusted: the allin should not be a allin, it should be a flop 3bet (facing).
How Do I replace holdem_hand_player_statistics.enum_face_allin='F' ? I want sth like "face flop 3bet='F' " (EDIT: holdem_hand_player_statistics.flg_f_face_raise check maybe enough?)

thx in advance

Jürgen
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: antiquated stat, check please

Postby kraada » Tue Sep 28, 2010 2:25 pm

If you're deep, that stat could also go off if you 4bet cold, get 5bet, call, face a cbet and raise it. I'm not sure if it matters for you or not, but that would qualify as well as it's currently set up. If you want to ignore situations where you 4bet though, that's easy to add.

As to the flop, holdem_hand_player_statistics.flg_f_3bet_def_opp is true if the player faced a 3bet on the flop.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: antiquated stat, check please

Postby js2002 » Tue Sep 28, 2010 2:45 pm

...
Last edited by js2002 on Tue Sep 28, 2010 2:46 pm, edited 1 time in total.
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: antiquated stat, check please

Postby js2002 » Tue Sep 28, 2010 2:46 pm

...
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: antiquated stat, check please

Postby js2002 » Tue Sep 28, 2010 2:51 pm

kraada wrote:If you're deep, that stat could also go off if you 4bet cold, get 5bet, call, face a cbet and raise it. I'm not sure if it matters for you or not, but that would qualify as well as it's currently set up. If you want to ignore situations where you 4bet though, that's easy to add.

As to the flop, holdem_hand_player_statistics.flg_f_3bet_def_opp is true if the player faced a 3bet on the flop.


finally I got it.

I ll ignore these spote because in many build-in stats, this is the standard, f.e. fold to cbet in 3bet pot: this stat is meant 3bet+, though ALL OK now!

EDIT:
flop cbet in 3bet pot is also 5bet but no 4bet (because we cant 3bet when we 3bet)
sum(if[ holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_f_cbet, 1 , 0 ])

Is this ok then?!
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: antiquated stat, check please

Postby kraada » Tue Sep 28, 2010 3:56 pm

I think it should be.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: antiquated stat, check please

Postby js2002 » Tue Sep 28, 2010 4:32 pm

well I think I could be not well-formed because sometimes 3bet+ means 3bet or 4bet or 5bet .... and sometimes like here it means 3bet or 5bet or 7bet ....
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: antiquated stat, check please

Postby WhiteRider » Wed Sep 29, 2010 3:33 am

Can you clarify, please - do you want to include or exclude pots where there is more than a 3-bet, and exactly what you're trying to count?
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: antiquated stat, check please

Postby js2002 » Wed Sep 29, 2010 3:40 am

To go in line with the build-in stats ...wait I dont know really because:

The build-in stat "fold to cbet in 3bet pot" is 3bet+
The build-in stat "3bet" is 3bet (without +)



for 3bet pots, I guess I want only 3bet definition.

1. So I wounder why "The build-in stat "fold to cbet in 3bet pot" is 3bet+" ?

2. sum(if[ holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_f_cbet, 1 , 0 ]) for this I guess we need: NOT face 4bet in to exclude higher but we could overjump the 4bet facing so that we only face a 5bet. how do we block that? f.e. with sth like "%R" ?
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: antiquated stat, check please

Postby WhiteRider » Wed Sep 29, 2010 3:46 am

"Fold to CBet in 3bet pot" is a custom stat - you would have to ask the author why it was built like that. What do you want to see in YOUR stat?
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Next

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

Who is online

Users browsing this forum: No registered users and 1 guest