5B preflop?

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

5B preflop?

Postby kes1981 » Fri Aug 20, 2010 5:51 pm

I'm going a little overboard, but is there a way to make a fold to 5B? I tried replacing sum(if[holdem_hand_player_statistics.enum_p_4bet_action='F', 1, 0]) with sum(if[holdem_hand_player_statistics.enum_p_5bet_action='F', 1, 0]) but it's not valid.
kes1981
 
Posts: 141
Joined: Tue Aug 10, 2010 6:28 pm

Re: 5B preflop?

Postby kraada » Fri Aug 20, 2010 6:47 pm

That database field does not exist and as such you cannot build that stat.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: 5B preflop?

Postby kes1981 » Fri Aug 20, 2010 7:22 pm

Anyway to add something that says fold to raise...

After the expression for the player 4B, is there anything I can add that shows he folded to a raise?
kes1981
 
Posts: 141
Joined: Tue Aug 10, 2010 6:28 pm

Re: 5B preflop?

Postby WhiteRider » Sat Aug 21, 2010 5:23 am

You could count times that the player 4-bets and folds to a 4-bet, using holdem_hand_player_statistics.flg_p_4bet AND holdem_hand_player_statistics.enum_p_4bet_action='F'.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: 5B preflop?

Postby kes1981 » Sat Aug 21, 2010 3:32 pm

WhiteRider wrote:You could count times that the player 4-bets and folds to a 4-bet, using holdem_hand_player_statistics.flg_p_4bet AND holdem_hand_player_statistics.enum_p_4bet_action='F'.


Wouldn't that come back as invalid since a 4B can only fold to a 5B... I'll give it a try
kes1981
 
Posts: 141
Joined: Tue Aug 10, 2010 6:28 pm

Re: 5B preflop?

Postby WhiteRider » Sat Aug 21, 2010 4:32 pm

All bets 4-bet or higher are counted as 4-bets. That's why there are no 5-bet database fields.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: 5B preflop?

Postby kes1981 » Sat Aug 21, 2010 4:45 pm

WhiteRider wrote:All bets 4-bet or higher are counted as 4-bets. That's why there are no 5-bet database fields.


Any chance of a comprehensive guide to stat making? This is bar none the most powerful tool in any poker tracking software, but the learning curve is VERY high. It took me 3 days to figure out and the reason I spent so much time is because I'm a dork. Once I figured out the structure, it was pretty easy. The problem is that I started out using the wrong stats as examples (some are just very long for no reason and have bad structures)
kes1981
 
Posts: 141
Joined: Tue Aug 10, 2010 6:28 pm

Re: 5B preflop?

Postby WhiteRider » Sat Aug 21, 2010 4:47 pm

Check out the Tutorial: Custom Reports and Statistics.
It's pretty long, but as you say the subject is pretty big.
If there's anything you don't understand in there please let me know and I'll try to explain, and update the tutorial.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: 5B preflop?

Postby bloodndef » Mon Aug 23, 2010 2:19 pm

Here's what I'm using to define 5-betting and it seems to get the job done... What are its flaws?



5bet after 3betting:

(cnt_p_5b_after_3b_times / cnt_p_5b_after_3b_opp) * 100

cnt_p_5b_after_3b_times

Code: Select all
sum(if[(holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.enum_p_4bet_action='R'), 1, 0])


cnt_p_5b_after_3b_opp

Code: Select all
sum(if[(holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_p_4bet_def_opp), 1, 0])
bloodndef
 
Posts: 99
Joined: Fri Feb 27, 2009 1:28 am

Re: 5B preflop?

Postby kraada » Mon Aug 23, 2010 2:45 pm

That could also be a 3-bet/6-bet - if you're multiway that sort of thing is definitely possible. That said, I would not expect it to be common.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Next

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

Who is online

Users browsing this forum: No registered users and 0 guests