Need help with creating a few custom 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

Need help with creating a few custom stats

Postby imSiankO » Tue Mar 20, 2012 1:12 pm

I need help creating some custom stats in PT4, the most important one is probably:
- Postflop Total Aggression Frequency
since i was using that one quite a bit in HM2 to know vs which villain it was a good idea to trap and who was really passive postflop.

and the two other stats that i'd like to create are:
- Flop CBet in 4Bet+ Pot
- Fold to Flop CBet in 4Bet+ Pot

i've looked last night a bit but i really have no idea how to do it :(
imSiankO
 
Posts: 1
Joined: Sat Mar 17, 2012 1:19 pm

Re: Need help with creating a few custom stats

Postby kraada » Tue Mar 20, 2012 4:24 pm

"Postflop Total Aggression Frequency" in PT4 is called Total AFq and is available by default.

To create Flop CBet in 4Bet+ Pot create two new columns in the Columns Page (you'll want these to be Players Columns).

cnt_f_cbet_4b_pot: sum(if[ char_length(cash_hand_summary.str_aggressors_p) >= 4 and cash_hand_player_statistics.flg_f_cbet, 1, 0])

cnt_f_cbet_opp_4b_pot: sum(if[ char_length(cash_hand_summary.str_aggressors_p) >= 4 and cash_hand_player_statistics.flg_f_cbet_opp, 1, 0])

Use these columns to build your statistic - you want to put the former over the later and multiply by 100 to get your stat (many stats are built with this kind of construction - you should be able to figure it out if you look at a couple).

For Fold to Flop CBet in 4Bet+ Pot use these columns:

cnt_f_cbet_def_action_fold_4b_pot: sum(if[ char_length(cash_hand_summary.str_aggressors_p) >= 4 and cash_hand_player_statistics.enum_f_cbet_action = 'F', 1, 0])

and

cnt_f_cbet_def_opp_4b_pot: sum(if[ char_length(cash_hand_summary.str_aggressors_p) >= 4 and cash_hand_player_statistics.flg_f_cbet_def_opp, 1, 0])

Again, put the former over the latter and multiply by 100.

Also, expect the sample sizes in these stats to be very small. These things feel like they come up a lot but when you look at the numbers it's always less than it feels like it should be.
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 13 guests