3Bet Size PF

[hagglebaby]

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!

[Flag_Hippo]

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]

[hagglebaby]

I love you

[hagglebaby]

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!

[Flag_Hippo]

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.