Page 1 of 1

Call River Allin

PostPosted: Wed Mar 21, 2012 1:20 pm
by lunalucky
Hi all, I want to create a stat to calculate the % of call Allin on river. Can you help me?
Thanks

Re: Call River Allin

PostPosted: Wed Mar 21, 2012 2:52 pm
by kraada
Yes, create the following two columns:

cnt_r_face_allin_action_call:
sum(if[holdem_hand_player_statistics.enum_r_allin_action = 'C', 1, 0])

cnt_r_face_allin: sum(if[holdem_hand_player_statistics.enum_r_allin_action <> 'N', 1, 0])

Put the former over the latter and multiply by 100 to get your statistic.

For more on building custom statistics in PT3, please see the Tutorial: Using Custom Statistics and Reports.

Re: Call River Allin

PostPosted: Fri Mar 23, 2012 9:58 am
by lunalucky
But I don't find enum_r_allin_action. Why?

Re: Call River Allin

PostPosted: Fri Mar 23, 2012 10:18 am
by WhiteRider
That database field doesn't exist - there isn't a separate face-allin field for each street - you need to check that you faced an all-in on the river, and that you called when you faced an all-in, like this:

holdem_hand_player_statistics.enum_face_allin = 'R' AND holdem_hand_player_statistics.enum_face_allin_action = 'C'

The 'R' means river, it could also be P, F or T, or N for none.
The 'C' at the end means call, it could also be F or R for fold or raise.