Call River Allin

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Call River Allin

Postby lunalucky » Wed Mar 21, 2012 1:20 pm

Hi all, I want to create a stat to calculate the % of call Allin on river. Can you help me?
Thanks
lunalucky
 
Posts: 3
Joined: Thu Oct 15, 2009 5:54 am

Re: Call River Allin

Postby kraada » Wed Mar 21, 2012 2:52 pm

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.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Call River Allin

Postby lunalucky » Fri Mar 23, 2012 9:58 am

But I don't find enum_r_allin_action. Why?
lunalucky
 
Posts: 3
Joined: Thu Oct 15, 2009 5:54 am

Re: Call River Allin

Postby WhiteRider » Fri Mar 23, 2012 10:18 am

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.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests