PokerTracker

I'm trying to create a custom stat about how often a player shoves given that their M is small. It would be limp_open_shove / limp_open_shove_opp, where limp_open_shove_opp is defined as "M < 5 and player_can_open_pot", i.e.:

Code: Select all

sum(if[live_tourney_player.amt_stack / (live_tourney_table.amt_bb + live_tourney_table.amt_sb + (live_tourney_table.amt_ante * live_tourney_table.cnt_players)) < 5 and tourney_hand_player_statistics.flg_p_open_opp, 1, 0])

The problem is that the first condition about the M value (everything before the "and") is only evaluated once, and makes the entire column either 0 (if it resolves false) or leaves it unaffected (if it resolves true). What I want, of course, is that it is evaluated separately for each hand, just as the field tourney_hand_player_statistics.flg_p_open_opp. I also tried reducing it to just one condition (e.g., live_tourney_player.amt_stack < 1000) to test, and it's the same issue. I assume I'm using the wrong fields, but which fields should I use instead?

(limp_open_shove has the identical problem, so the definition doesn't really matter.)

Data from the live table isn't stored in the database and it's not possible to mix data from the live tables with other database tables. To calculate the players M you will need to use this:

Code: Select all

(tourney_hand_player_statistics.amt_before / (tourney_blinds.amt_bb + tourney_blinds.amt_sb + (tourney_hand_player_statistics.amt_ante * tourney_hand_summary.cnt_players)))

Awesome. Thanks! Full formulas (in case someone wants to copy them):

Open Shove with M < 5 (stat):

Code: Select all

(cnt_p_openshove / cnt_p_openshove_opp ) * 100

cnt_p_openshove (column):

Code: Select all

sum(if[(tourney_hand_player_statistics.amt_p_raise_made >= tourney_hand_player_statistics.amt_p_effective_stack and tourney_hand_player_statistics.flg_p_first_raise and tourney_hand_player_statistics.flg_p_open_opp and (tourney_hand_player_statistics.amt_before / (tourney_blinds.amt_bb + tourney_blinds.amt_sb + (tourney_hand_player_statistics.amt_ante * tourney_hand_summary.cnt_players))) < 5), 1, 0])

cnt_p_openshove_opp (column):

Code: Select all

sum(if[(tourney_hand_player_statistics.amt_before / (tourney_blinds.amt_bb + tourney_blinds.amt_sb + (tourney_hand_player_statistics.amt_ante * tourney_hand_summary.cnt_players))) < 5 and tourney_hand_player_statistics.flg_p_open_opp, 1, 0])