3Bet Size PF

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

3Bet Size PF

Postby hagglebaby » Sat Apr 13, 2024 8:55 pm

I'm looking for a custom column for all hands report. pf 3 Bet Size (currency or BB's doesn't really matter).

I would like the amount of the actual 3 bet. Not the amount that the active player bet pf in a 3 bet pot. I don't want the latter because it could include 4 bets, further action etc.

I'm interested in a report column for it so I can export it and look at it in excel.

I tried:

cash_hand_player_statistics.amt_3bet_p

but it says it's not SQL.

thanks!
hagglebaby
 
Posts: 6
Joined: Sat May 20, 2017 12:06 am

Re: 3Bet Size PF

Postby Flag_Hippo » Sun Apr 14, 2024 5:27 am

cash_hand_player_statistics.amt_3bet_p will not validate as it doesn't exist in the PokerTracker 4 database schema. You would need to use the following expression instead:

Code: Select all
if[cash_hand_player_statistics.flg_p_3bet, cash_hand_player_statistics.amt_p_raise_made, 0]
Flag_Hippo
Moderator
 
Posts: 14583
Joined: Tue Jan 31, 2012 7:50 am

Re: 3Bet Size PF

Postby hagglebaby » Mon Apr 15, 2024 7:29 am

I love you
hagglebaby
 
Posts: 6
Joined: Sat May 20, 2017 12:06 am

Re: 3Bet Size PF

Postby hagglebaby » Mon Apr 15, 2024 7:52 am

I would like to also be able to see 4 bet sizing, 5 bet sizing etc. I've tried the same format, and it is valid. The only problem is that it flags the hand but then returns the first raise the active player made. For instance in a BTN vs SB pot where there is a 4 bet, the following column expression correctly flags the pot as a 4 bet pot, but it returns the BTN's RFI size. If i make the active player the SB, the following expression correctly flags the hands as 4 bet pots but it will return the first raise size the active player made so it returns the 3 bet size.

if[cash_hand_player_statistics.flg_p_4bet, cash_hand_player_statistics.amt_p_raise_made, 0]

thanks!
hagglebaby
 
Posts: 6
Joined: Sat May 20, 2017 12:06 am

Re: 3Bet Size PF

Postby Flag_Hippo » Mon Apr 15, 2024 1:15 pm

cash_hand_player_statistics.amt_p_raise_made is the size of a players first preflop raise. If you want the size of their second preflop raise then you would need to use cash_hand_player_statistics.amt_p_raise_made_2 instead. Bear in mind players can cold 4bet so in those cases the 4bet size would be equal to cash_hand_player_statistics.amt_p_raise_made rather than cash_hand_player_statistics.amt_p_raise_made_2.
Flag_Hippo
Moderator
 
Posts: 14583
Joined: Tue Jan 31, 2012 7:50 am


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 11 guests

cron
highfalutin