Fold to Shove with bet amount invested

[rapmaster_c]

Hi,
I have created a stat but I'm not sure if I'm using the right columns so please tell me if its correct.
I want to get a stat, which tells me the % of folding the hand when facing an allin with a certain bet amount(measured in BB) of the player already invested(preflop, without antes, blinds included)

The stat is: FoldToShove_pct: (cnt_foldtoshove / cnt_faceshove)*100
the columns:
cnt_faceshove:
sum(if[tourney_hand_player_statistics.enum_face_allin = 'P'
AND
((amt_p_raise_made / tourney_blinds.amt_bb)
BETWEEN 0.00 AND 0.00)
, 1, 0])

cnt_foldtoshove:
sum(if[tourney_hand_player_statistics.enum_face_allin = 'P'
AND tourney_hand_player_statistics.enum_face_allin_action = 'F'
AND
((amt_p_raise_made / tourney_blinds.amt_bb)
BETWEEN 0.00 AND 0.00)
, 1, 0])

so here I want to get the % of fold then facing an allin where I haven't invested anything yet(except the antes).
but it seems amt_p_raise_made doesn't include the blinds posted - which i want
I am looking for a column that includes the blinds but excludes the ante - so basically the whole current betamount infront of a player.
I tried with amt_bet_p instead of amt_p_raise_made but the results seem to be too tight.
Help please

[WhiteRider]

Unfortunately there isn't any way to tell how many chips have been put in before any particular action, and I'm not sure whether we can tell whether the all-in is faced before the player has made any action. (The actions column is easy, but the opportunities column isn't.)

[rapmaster_c]

oh okay
So i am wondering, what exactly is
amt_p_raise_made and amt_bet_p returning?

[WhiteRider]

amt_p_raise made is the amount of money or chips bet in the players first raise.
amt_bet_p is the total amount of money or chips bet preflop.

Neither of those tells you when the money or chips were bet in relation to any other players' actions though.

[rapmaster_c]

Hi,
So
amt_p_raise_made returns the raise amount of the first raise(only if raised - else zero ?) and
amt_bet_p: do you mean total amount of chips of all players betted or only for the specific player selected? if it is for one player - does it include the antes and blinds? e.g. I am sitting in the BB and I have posted 20 to antes and 100 for the bb. Its checked to me. If I check too whats will the value return?

2. I noticed that you have all the essential information in the hand details(playback/replay hand). So is there another way(other than using standard columns) to get the desired information(even if it would take some time)?

[rapmaster_c]

is there a column that returns the total amount of chips invested preflop(blinds included) - regardless of the players' action?

[WhiteRider]

is there a column that returns the total amount of chips invested preflop(blinds included) - regardless of the players' action?

That is what "amt_bet_p" stores.

amt_p_raise_made returns the raise amount of the first raise(only if raised - else zero ?)

Correct.

2. I noticed that you have all the essential information in the hand details(playback/replay hand). So is there another way(other than using standard columns) to get the desired information(even if it would take some time)?

No. The Replayer works differently to the stat system, by parsing the hand history text. The stat system does not have access to that functionality.

[rapmaster_c]

Hi,
I thought about a workaround for my problem: getting the % of folding to an allin when nothing was invested yet.
So here is my solution:
stat: foldtoshove_pct = (cnt_foldtoshove_noaction / cnt_faceshove_noaction)*100
the columns:
cnt_faceshove_noaction:
sum(if[tourney_hand_player_statistics.enum_face_allin = 'P'
AND( lookup_actions_p.action = 'F'
OR lookup_actions_p.action = 'C'
OR lookup_actions_p.action = 'R' )
, 1, 0])
### I decreased all the situations where I was faced with an allin to those situations where I only made one action: that means i have done nothing before facing an allin(ergo i have invested nothing yet - except blinds) - because if both stacks are equal(at least the selected player is covered because enum_face_allin = 'P') I can only take one action.

cnt_foldtoshove_noaction:
sum(if[tourney_hand_player_statistics.enum_face_allin = 'P'
AND tourney_hand_player_statistics.enum_face_allin_action = 'F'
AND
((amt_bet_p / tourney_blinds.amt_bb)
BETWEEN 0.00 AND 0.00)
, 1, 0])
###here I select all of the situations where i haven t invested any chips at all
===========================================
Please let me know what you think about that.

[kraada]

I think that should work.

[WhiteRider]

That will work unless you are deeper stacked, and there are other deeper stacked players. For example if you call (or raise) the all-in and a 3rd player re-raises then you will make another action.