Hand Value Stats

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

Hand Value Stats

Postby jscobie » Sat Oct 29, 2011 3:19 pm

Hi, I downloaded Kraada's pop up for the hand value table. It is excellent but I would like to seperate the reraising table into a 3 betting table and a 4 betting table, rather than one for both.

The code for the columns is currently sum(if[(holdem_hand_player_statistics.flg_p_3bet or holdem_hand_player_statistics.flg_p_4bet) AND holdem_hand_player_statistics.id_holecard = 156, 1, 0])

For only 3 bets would I just remove the 4 bet part

sum(if[(holdem_hand_player_statistics.flg_p_3bet) AND holdem_hand_player_statistics.id_holecard = 156, 1, 0])

or say AND NOT

sum(if[(holdem_hand_player_statistics.flg_p_3bet AND NOT holdem_hand_player_statistics.flg_p_4bet) AND holdem_hand_player_statistics.id_holecard = 156, 1, 0])

Would the same apply to 4 bets?
jscobie
 
Posts: 76
Joined: Sat Apr 30, 2011 10:48 am

Re: Hand Value Stats

Postby WhiteRider » Sat Oct 29, 2011 4:50 pm

You've got the idea! Whether or not you include NOT 4-bet depends on whether you want to exclude pots where the player 4-bet as well as 3-bet. If you only want to count hands where they 3-bet and didn't 4-bet or higher, which I guess you probably do, then you'll want to include the NOT.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


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

Who is online

Users browsing this forum: No registered users and 0 guests