Calling station tendency

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

Re: Calling station tendency

Postby kraada » Wed May 27, 2009 2:42 pm

Hrm, I think so. I'm not sure why it's calculated that way to be honest.

Build this column:
cnt_f_face_bet_or_raise

sum(if[(holdem_hand_player_detail.amt_f_bet_facing > 0) or (holdem_hand_player_detail.amt_f_raise_facing > 0), 1, 0])

then use that as your opportunities column.

Then create the stat as (cnt_f_fold / cnt_f_face_bet_or_raise) * 100. You can only fold when you face a bet or raise (I guess open folding can come up but honestly even on sites where you can do it it's awfully rare I'm sure), so the count of how many times you fold should be sufficient here.

You can substitute _t_ and _r_ for turn and river instead of _f_ to make the other columns as needed.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Previous

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

Who is online

Users browsing this forum: No registered users and 3 guests