Allin Preflop 1st-in

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

Allin Preflop 1st-in

Postby theperni » Wed Aug 19, 2009 6:23 am

I builded "Allin preflop" stat ( "(cnt_p_allin / cnt_hands) * 100" ); now I tried to make a FI-PF-Push (something like "(...... /cnt_p_open_opp)*100" ) starting from RFI default stat, but I'm not able write/use the correct column.

Any help is appreciated.
theperni
 
Posts: 6
Joined: Sat Aug 09, 2008 4:54 pm

Re: Allin Preflop 1st-in

Postby WhiteRider » Wed Aug 19, 2009 7:05 am

I think that a column like this:
sum( if[holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.flg_p_open_opp AND holdem_hand_player_detail.amt_p_raise_made = holdem_hand_player_detail.amt_before, 1, 0])
..should give you what you want.
This counts the times you had an open-opp and made the first raise (same as RFI), and the first raise is the same as the stack size at the start of the hand.

If you're doing this for tournaments (where it's more common I guess) you need to change the tables used, but the same fields should work.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Allin Preflop 1st-in

Postby theperni » Fri Aug 21, 2009 11:10 am

I'd like build this stat for dorn sng.

Thanks for assistance. :)
theperni
 
Posts: 6
Joined: Sat Aug 09, 2008 4:54 pm

Re: Allin Preflop 1st-in

Postby kraada » Fri Aug 21, 2009 11:18 am

See the Tutorial: Converting Cash stats to Tournament and use the same details.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


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

Who is online

Users browsing this forum: No registered users and 0 guests