new* stat: fold to CBet Raise in 3Bet 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

Re: new* stat: fold to CBet Raise in 3Bet pot

Postby WhiteRider » Wed Apr 01, 2009 10:03 am

That's fine, although you don't actually need holdem_hand_player_statistics.flg_f_cbet_def_opp - if holdem_hand_player_statistics.enum_f_cbet_action='R' then you must have faced a CBet. You will still need it in the opportunities column, though.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: new* stat: fold to CBet Raise in 3Bet pot

Postby js2002 » Wed Apr 01, 2009 10:09 am

german: Doppelt gemoppelt, hält besser. ;)
Try to translate that :)

have nice day
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: new* stat: fold to CBet Raise in 3Bet pot

Postby WhiteRider » Wed Apr 01, 2009 10:24 am

Sure.. :)

"Better safe than sorry".
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: new* stat: fold to CBet Raise in 3Bet pot

Postby js2002 » Wed Apr 01, 2009 5:02 pm

A friend gave me an interesting hint:

@CBet Raise 3bet Pot: He asked me if it is possible to check if villians goes broke/allin everytime the does this move.

How would you check it best way? a did NOT fold or a did went to showdown or even both or other?!

NEW IDEA INCOMING:

cbet raise in 3bet pot und call push
cbet raise in 3bet pot und fold auf push

what ya think?
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: new* stat: fold to CBet Raise in 3Bet pot

Postby WhiteRider » Thu Apr 02, 2009 3:35 am

holdem_hand_player_statistics.enum_allin
holdem_hand_player_statistics.enum_face_allin
holdem_hand_player_statistics.enum_face_allin_action

The first 2 enums all have options of N (none) or P, F, T, R for preflop, flop, turn, river and indicate when you went all in or faced an all in; and the action is N, F, C, R (none, fold, call, raise).
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: new* stat: fold to CBet Raise in 3Bet pot

Postby js2002 » Thu Apr 02, 2009 3:50 am

WhiteRider wrote:holdem_hand_player_statistics.enum_allin
holdem_hand_player_statistics.enum_face_allin
holdem_hand_player_statistics.enum_face_allin_action

The first 2 enums all have options of N (none) or P, F, T, R for preflop, flop, turn, river and indicate when you went all in or faced an all in; and the action is N, F, C, R (none, fold, call, raise).


1. whats holdem_hand_player_statistics.enum_allin=N ? villian didnt went allin?
2. Can I use holdem_hand_player_statistics.enum_allin without option, to say "any street" ?!
3. holdem_hand_player_statistics.enum_face_allin_action whats a N none reaction here?
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: new* stat: fold to CBet Raise in 3Bet pot

Postby WhiteRider » Thu Apr 02, 2009 4:30 am

1. N = you didn't face an all in.
2. enum_allin <> 'N'. (i.e. not none, so some street)
3. Sorry, there is no N reaction of course.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: new* stat: fold to CBet Raise in 3Bet pot

Postby js2002 » Thu Apr 02, 2009 4:42 am

WhiteRider wrote:1. N = you didn't face an all in.

hand_player_statistics.enum_allin=N is not face allin!

2. enum_allin <> 'N'. (i.e. not none, so some street)

if <> means sth like = then I understand


3. Sorry, there is no N reaction of course.

k


so, with hand_player_statistics.enum_allin=n I can test, if villian got allin the the hand? doesnt matter how he went allin right?!
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: new* stat: fold to CBet Raise in 3Bet pot

Postby js2002 » Thu Apr 02, 2009 5:32 am

tought little more:
whats with situations where villian has somebody $chip-covered and doesnt have to go allin to set him allin. This is not in the indicator, right?
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: new* stat: fold to CBet Raise in 3Bet pot

Postby WhiteRider » Thu Apr 02, 2009 9:10 am

<> means "not equal".
So:
holdem_hand_player_statistics.enum_allin = 'N'
..means the player did not go all in.
holdem_hand_player_statistics.enum_allin <> 'N'
..means they went all in on any street.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

PreviousNext

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

Who is online

Users browsing this forum: No registered users and 0 guests