PokerTracker

Hi,

Is there anyway I could build a custom stat to show the Limp/fold vs AI % from the SB?

Thanks

This:

cash_hand_summary.str_aggressors_p = '9' and cash_hand_summary.str_actors_p LIKE '9%'

..defines an open raise by the small blind. (The first "aggressor" and the first "actor" were both position 9, the SB).

This:

cash_hand_player_statistics.amt_p_2bet_facing >= (cash_hand_player_statistics.amt_p_effective_stack - (2 * cash_limit.amt_bb))

..says that the size of the 2bet (first raise) the player was facing is at least as large as their effective stack.
(I have deducted 2 BBs from the effective stack since the BB already has 1 BB in the pot, and to avoid any edge cases with exact numbers. You may want to allow more leeway here if you want to include more "not quite all-in" situations.)

If you add both of those parts into new columns you can make new stats based on the existing call/fold stats.
For an overview of how custom stats are made in PT4 see the Custom Stats Guide, and for a deeper dive and examples of how to make new versions of stats see the Tutorial: Custom Reports and Statistics.