folding bb to sb steal

[awesemo]

Hi,

I was wondering if there is a way I can find the percentage of times a player folds their big blind to a preflop raise from the sb to open the pot. thanks for the help.

[WhiteRider]

This is available as a Custom Stat on page 4 of the stats section of the Repository, called "BB folds to SB blind steal" (by me!).

[denutza]

After putting this custom stat in, my cache would no longer update..I contacted support and
was told to change a few variables:

NEW:

cnt_p_BB_fold_to_SB:

Code: Select all

sum(if[holdem_hand_player_statistics.flg_p_fold AND
holdem_hand_player_statistics.position = 8 AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 9 AND holdem_hand_player_statistics.flg_blind_def_opp,1,0])


and
cnt_p_BB_fold_to_SB_opp:

Code: Select all

sum(if[holdem_hand_player_statistics.position = 8 AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 9 AND holdem_hand_player_statistics.flg_blind_def_opp,1,0])


Now my log files show a bunch of errors of type: [PostgresPreparedStatement (Error)] Unable to execute prepared query: prepared_statement_2; Reason: Fatal Error (ERROR: numeric field overflow DETAIL: A field with precision 9, scale 2 must round to an absolute value less than 10^7. )

and it still is taking forever for it to Update the Cache.


The only thing I changed was adding the stat to the Tournament Player Statistics Section as well.

Here is the remaining code:

Value Expression

Code: Select all

if( cnt_p_BB_fold_to_SB_opp > 0, (cnt_p_BB_fold_to_SB / cnt_p_BB_fold_to_SB_opp) * 100, 0 )


Format Expression:

Code: Select all

format_number( if( cnt_p_BB_fold_to_SB_opp > 0, (cnt_p_BB_fold_to_SB / cnt_p_BB_fold_to_SB_opp) * 100, 0 ), 1, false, false)


Format Summary Expression:

Code: Select all

format_number( if( cnt_p_BB_fold_to_SB_opp > 0, (cnt_p_BB_fold_to_SB / cnt_p_BB_fold_to_SB_opp) * 100, 0 ), 1, false, false)


[WhiteRider]

I can't see anything wrong with what you've entered there, so Please enable logging, reproduce the problem and submit your PokerTracker.log file to the Support system , and link to this thread in the reference field of the ticket so that we can investigate.