Popup for Preflop Ranges

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

Popup for Preflop Ranges

Postby kes1981 » Sat Nov 06, 2010 7:07 pm

I have spent a little time trying to figure it out, but no luck. I want a pop up that will give me ranges for certain actions (3B blinds vs button, etc...)

I'm thinking I would make it under the "Single Hand Details" in configure stats, but no clue what the next step would be.
kes1981
 
Posts: 141
Joined: Tue Aug 10, 2010 6:28 pm

Re: Popup for Preflop Ranges

Postby kes1981 » Sat Nov 06, 2010 7:36 pm

nevermind, found the post
kes1981
 
Posts: 141
Joined: Tue Aug 10, 2010 6:28 pm

Re: Popup for Preflop Ranges

Postby kes1981 » Sat Nov 06, 2010 8:01 pm

This is what I have come up with but I'm getting an error:

cnt_3BbuttonvsCO_AA: sum(if[lookup_actions_p.action LIKE 'R%' AND holdem_hand_player_statistics.position = 0 AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 1 AND holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_statistics.id_holecard = 1,1,0])

This is for the # of times a person 3B AA on the button versus a cutoff open. PT3 is saying it's not a valid SQL.

Is this the correct column for the amount of times he had AA on the button vs a cutoff open?

cnt_3BbuttonvsCO_chances: sum(if[holdem_hand_player_statistics.position = 0 AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 1 AND holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_statistics.id_holecard = 1,1,0])
kes1981
 
Posts: 141
Joined: Tue Aug 10, 2010 6:28 pm

Re: Popup for Preflop Ranges

Postby WhiteRider » Sun Nov 07, 2010 5:42 am

Both of those expressions validate for me - you are entering them in Expression field on the Columns tab, in the Holdem Cash Player Statistics section, right?

cnt_3BbuttonvsCO_AA:
sum(if[lookup_actions_p.action LIKE 'R%' AND holdem_hand_player_statistics.position = 0 AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 1 AND holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_statistics.id_holecard = 1,1,0])

..looks OK, but actually checks for times the button made the last aggressive action preflop.
If you want to check for 3-bets explicitly you'll need to check for "holdem_hand_player_statistics.flg_p_3bet" (instead of the "actions" check).

Similarly for your "chances" column, it only says the button faced a raise, not that they faced a 2-bet (first raise) explicitly. To do that you could use:
holdem_hand_player_statistics.flg_p_3bet_opp
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Popup for Preflop Ranges

Postby kes1981 » Sun Nov 07, 2010 6:07 pm

WhiteRider wrote:Both of those expressions validate for me - you are entering them in Expression field on the Columns tab, in the Holdem Cash Player Statistics section, right?

cnt_3BbuttonvsCO_AA:
sum(if[lookup_actions_p.action LIKE 'R%' AND holdem_hand_player_statistics.position = 0 AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 1 AND holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_statistics.id_holecard = 1,1,0])

..looks OK, but actually checks for times the button made the last aggressive action preflop.
If you want to check for 3-bets explicitly you'll need to check for "holdem_hand_player_statistics.flg_p_3bet" (instead of the "actions" check).

Similarly for your "chances" column, it only says the button faced a raise, not that they faced a 2-bet (first raise) explicitly. To do that you could use:
holdem_hand_player_statistics.flg_p_3bet_opp



Yeah, I did put 'cnt_3BbuttonvsCO_AA' into the expression field... oops. The stat ended up being incorrect (it was always 0/0). I'm going to try it with your suggestions now.

Also, it takes FOREVER to update my cache after making this stat. Yesterday, it took 2 hours for the one stat and it looks like it will take forever right now. Is there any workaround for that? Can I create a stat while auto importing (since it is constantly updating the cache)?
kes1981
 
Posts: 141
Joined: Tue Aug 10, 2010 6:28 pm

Re: Popup for Preflop Ranges

Postby kes1981 » Sun Nov 07, 2010 8:26 pm

Good news: The stat seems to be working since it's no longer 0/0

Bad news: It always returns 100% for every player (2/2, 9/9, etc).

I want the stat to show % of times a person 3B a given hand... so if villan had AA on the button 15 times (that went to showdown) when the CO opens and only 3B 5 times (20%) would my current setup show that? I have to do this for every single hand so would like to save myself work :)

Finally, is this the best way to approach it for ranges? With my approach, it's hard to get a feel for the air they are 3B in this spot (A8o, would be hard to showdown that hand).
kes1981
 
Posts: 141
Joined: Tue Aug 10, 2010 6:28 pm

Re: Popup for Preflop Ranges

Postby WhiteRider » Mon Nov 08, 2010 5:31 am

What expressions are you using now?
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Popup for Preflop Ranges

Postby kes1981 » Mon Nov 08, 2010 11:00 am

My original expression with the changes you recommended...
kes1981
 
Posts: 141
Joined: Tue Aug 10, 2010 6:28 pm

Re: Popup for Preflop Ranges

Postby kraada » Mon Nov 08, 2010 11:13 am

That might in part be due to the fact that you only get data on the opponent's hand if he gets to showdown. So to have an opportunity here he'd need to not 3-bet preflop, but get to showdown with his aces - I don't know how likely that is going to be. But 3-betting probably makes it more likely on the whole (especially at lower limits) to get to showdown. For example, if the original raiser had KK and got 3-bet preflop the money may well entirely go in preflop. If the guy with aces just calls and the board comes A high, or comes 5 6 7 monotone, or comes JT9 monotone there are plenty of ways the hands might end up not getting to showdown.
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 0 guests