Help_ Call PFR based on $$$

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

Help_ Call PFR based on $$$

Postby kelso101 » Wed Nov 17, 2010 7:22 pm

NEED HELP

I been trying for a week to come up with a stat and got nothing but a terrible headache.

I want stats (1) ..how often a player calls a PFR in the amount X times the big blind.
(2) how often a player faces a PFR in the amount X times the big blind.

I been using amt_p_raise_facing but I can’t get the amount X times the big blind in the expression.

x- can be any multiple of the big blind...i want to creat multiple stats with different amouts
kelso101
 
Posts: 10
Joined: Tue Apr 15, 2008 8:31 am

Re: Help_ Call PFR based on $$$

Postby kraada » Wed Nov 17, 2010 7:54 pm

You'll have to make different custom stats for each X that you want. The general form would be:

cnt_p_face_pfr_x_bb: sum(if[holdem_hand_player_detail.amt_p_raise_facing = (x * holdem_limit.amt_bb), 1, 0])

cnt_p_call_pfr_x_bb: sum(if[holdem_hand_player_detail.amt_p_raise_facing = (x * holdem_limit.amt_bb) and ((holdem_hand_player_statistics.flg_p_limp and lookup_actions_p.action LIKE 'CC%') OR lookup_actions_p.action LIKE 'C%'), 1, 0])

Replace the "x" with the number of big blinds you desire.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Help_ Call PFR based on $$$

Postby kelso101 » Thu Nov 18, 2010 5:58 pm

Thank You for your Help. My headache is gone.

The results from these stats were not what I expected. I expected the call pct to fall as the size of the PFR grew but it didnt (on the average for all the players).
kelso101
 
Posts: 10
Joined: Tue Apr 15, 2008 8:31 am

Re: Help_ Call PFR based on $$$

Postby kraada » Thu Nov 18, 2010 6:11 pm

Yeah stats can show you some surprising tendencies :)
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