fold to steal based on raise sizing

[iatracker]

I am totaly lost to do this custom stat , i would try to have 2 different stat to improve fold to steal :

1) fold to steal when stealer raise size = 2BB (minraise)
2) fold to steal when stealer raise size = 3BB (3x)

help would be appreciate ..seems not simple , at least is possible ?!

[Flag_Hippo]

amt_p_raise_made is the amount of the first raise by a player pre-flop so you can specify the raise size in BB using:

Code: Select all

(tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb)

or for cash games:

Code: Select all

(cash_hand_player_statistics.amt_p_raise_made / cash_limit.amt_bb)

[iatracker]

thx here is what i done :

created new column cnt_steal_def_action_fold_minraise :

Code: Select all

sum(if[tourney_hand_player_statistics.flg_blind_def_opp AND
(tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb) = 2  AND lookup_actions_p.action = 'F', 1, 0])

created second new column cnt_steal_def_opp_minraise :

Code: Select all

sum(if[tourney_hand_player_statistics.flg_blind_def_opp
AND (tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb) = 2 , 1, 0])

finaly i created new stat Fold to Steal minraise

Code: Select all

(cnt_steal_def_action_fold_minraise / cnt_steal_def_opp_minraise)*100

is it correct ?!

[iatracker]

i made the same logic for fold to steal x3 so i guess something goes wrong , result seems not coherent ..

[Flag_Hippo]

Apologies I got that the wrong way around as what you need is the size of the raise faced by the player and for the blinds you will need to account for what they have already posted like this:

cnt_steal_def_action_fold_minraise

Code: Select all

sum(if[tourney_hand_player_statistics.flg_blind_def_opp AND (tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb = 2 AND lookup_actions_p.action='F', 1, 0])

cnt_steal_def_opp_minraise

Code: Select all

sum(if[tourney_hand_player_statistics.flg_blind_def_opp AND (tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb = 2, 1, 0])

[iatracker]

Lets take a concrete example :
tournament 3 players spin blind level 10/20 .
With this calcul the minraise result will be 2.5 instead of 2 . is amt_p_2bet_facing correspond to the amount of the 2bet made or the amount to add by the BB who faced the raise ?

if amt_blind is the amount of SB and amt_p_2bet_facing is the amount of the raise , resuslt will be (40 + 10) / 20 =2.5

[Flag_Hippo]

tourney_hand_player_statistics.amt_p_2bet_facing is the size of the 2bet faced by the player and this is not the same as the size of the 2bet that was made for players who have posted blinds. For example the small blind has already invested 0.5BB so when they are facing a minraise steal the tourney_hand_player_statistics.amt_p_2bet_facing for them, as per your example, will be equal to 30 (and for the BB it will be equal to 20) so we need to add the amount they posted (tourney_hand_player_statistics.amt_blind) to get the result you want:

SB: (30 + 10) / 20 = 2

BB: (20 + 20) / 20 = 2

[iatracker]

fine , thx !