Total Amount Called

[Tom Boshoff]

Hey guys, I'm looking for a conceptual formula that describes the total amount of money a player contributes to a pot through calling.

It should handle raises correctly. For example, if hero bets 5, and villain raises to 15, and hero calls 10, then we would only add 10 to the sum.

I've gone through the schema, scoured the columns, but I cannot seem to figure this out. It seems like it should be such a simple stat.

At the end, I want a stat that says how much a player contributes to the pot through calls, on average, in big blinds. But I can convert the total easily. Do you guys have any ideas?

[Flag_Hippo]

When a player faces a bet or a raise the amount they need to call is:

cash_hand_player_statistics.amt_x_bet_facing

cash_hand_player_statistics.amt_x_2bet_facing

cash_hand_player_statistics.amt_x_3bet_facing

cash_hand_player_statistics.amt_x_4bet_facing

where 'x' is the street identifier. These don't mean that the player actually called so additional tests will be needed for that.

You could also calculate the amount called on each street by subtracting a players bets and raises from the amount the player wagered on each street. This is an example but wouldn't be suitable for all cases:

Code: Select all

sum(if[cash_hand_player_statistics.cnt_f_call > 0, (cash_hand_player_statistics.amt_bet_f - (cash_hand_player_statistics.amt_f_bet_made + cash_hand_player_statistics.amt_f_raise_made + cash_hand_player_statistics.amt_f_raise_made_2)) / cash_limit.amt_bb, 0])

since anything using made is the absolute bet/raise size made by the player so amt_f_raise_made would already include amt_f_bet_made if the players flop actions where 'BRC' so you would need to include extra tests or use different columns for different possible actions. Also cash_hand_player_statistics.amt_bet_f (the total amount wagered) will only include the bets and raises made if those were actually called/raised. So a calculation for the amount called when the players actions were 'BRC' (or any other type of raise/call on the flop) would look like this:

Code: Select all

sum(if[lookup_actions_f.action SIMILAR TO '(BRC|XRC|RC)', (cash_hand_player_statistics.amt_bet_f - cash_hand_player_statistics.amt_f_raise_made) / cash_limit.amt_bb, 0])