by kraada » Tue Jul 17, 2012 9:42 am
These weren't added to the defaults because we do not believe that the sample sizes will produce meaningful results for the vast majority of players.
That said, you can of course build these stats with the PT4 custom statistics options.
The position of the 3bettor can be referenced as:
substring(cash_hand_summary.str_aggressors_p from 3 for 1)::int
So for example when the CO 3bet substring(cash_hand_summary.str_aggressors_p from 3 for 1)::int = 1
You can refer to the player's own position using cash_hand_player_statistics.position.
Position 9 is always the SB, 8 is always the BB, 0 is the button 1 is the CO and it adds up going around the table from there.
You may also want to take a look at some of the stats with "vs" in the name - they show you how to construct things like "EP" and "MP". Click Configure --> Statistics, and in the Players Columns section search for vs to see all of the relevant columns - searching for vs on the Stats side will show you how they are used.
One last note - you also want to add char_length(cash_hand_summary.str_aggressors_p) >= 3 to these columns just to be sure that the hand was 3bet.
So a sample column might look like this, assuming you're talking about 6max (which has utg being position 3).
cnt_p_utg_action_fold_vs_co_3bet:
sum(if[char_length(cash_hand_summary.str_aggressors_p) >= 3 and substring(cash_hand_summary.str_aggressors_p from 3 for 1)::int = 1 and cash_hand_player_statistics.position = 3 and cash_hand_player_statistics.enum_p_3bet_action = 'F', 1, 0])
And you'd need an opportunity column which would be like:
cnt_p_utg_vs_co_3bet_opp:
sum(if[char_length(cash_hand_summary.str_aggressors_p) >= 3 and substring(cash_hand_summary.str_aggressors_p from 3 for 1)::int = 1 and cash_hand_player_statistics.position = 3 and cash_hand_player_statistics.flg_p_3bet_def_opp, 1, 0])
With this information you should be able to build all of the combinations you're looking for. Good luck!