Broken stat

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

Broken stat

Postby pat3392 » Fri Feb 18, 2011 7:25 pm

There's something wrong with this custom stat, people are limping yet it stays at 0

Value Expression: ( cnt_p_limp_bs / cnt_p_limp_opp_bs ) * 100

cnt_p_limp_opp_bs=

sum( if[ (NOT(tourney_holdem_hand_player_statistics.flg_p_face_raise) OR (tourney_holdem_hand_player_statistics.flg_p_limp) OR (tourney_holdem_hand_player_statistics.flg_p_first_raise)) AND NOT(tourney_holdem_hand_player_statistics.flg_blind_b) and

(tourney_holdem_hand_player_detail.amt_before / ( tourney_holdem_blinds.amt_bb + tourney_holdem_blinds.amt_sb + (tourney_holdem_hand_summary.cnt_players * tourney_holdem_hand_player_detail.amt_ante)) >= 7)


, 1, 0])

cnt_p_limp_bs=

sum( if[tourney_holdem_hand_player_statistics.flg_p_limp and

(tourney_holdem_hand_player_detail.amt_before / ( tourney_holdem_blinds.amt_bb + tourney_holdem_blinds.amt_sb + (tourney_holdem_hand_summary.cnt_players * tourney_holdem_hand_player_detail.amt_ante)) >= 7)


, 1, 0])

Some people have numbers on their preflop limp, so it could simply be a matter of refresh rates. However, a player whom I have 1200 hands on limped UTG, so I'm pretty skeptical

My VP$IP/PFR don't seem to be adding up either. Some players have a VP$IP 40, yet a PFR of 11 and preflop limp of 0. Here's my definitions for the two

VP$IP: (cnt_vpip_bs / cnt_hands_bs) * 100

cnt_vpip_bs=

sum(if[tourney_holdem_hand_player_statistics.flg_vpip and

(tourney_holdem_hand_player_detail.amt_before / ( tourney_holdem_blinds.amt_bb + tourney_holdem_blinds.amt_sb + (tourney_holdem_hand_summary.cnt_players * tourney_holdem_hand_player_detail.amt_ante)) >=7)

, 1, 0])

cnt_hands_bs=

sum(if[
(tourney_holdem_hand_player_detail.amt_before / ( tourney_holdem_blinds.amt_bb + tourney_holdem_blinds.amt_sb + (tourney_holdem_hand_summary.cnt_players * tourney_holdem_hand_player_detail.amt_ante)) >= 7)
, 1, 0])

PFR: (cnt_pfr_bs / cnt_hands_bs) * 100

cnt_pfr_bs=

sum(if[tourney_holdem_hand_player_statistics.cnt_p_raise > 0 and

(tourney_holdem_hand_player_detail.amt_before / ( tourney_holdem_blinds.amt_bb + tourney_holdem_blinds.amt_sb + (tourney_holdem_hand_summary.cnt_players * tourney_holdem_hand_player_detail.amt_ante)) >= 7)


, 1, 0])


The 3 stats are colour coded, not sure if that could be having some sort of impact
pat3392
 
Posts: 142
Joined: Wed Jan 27, 2010 7:44 pm

Re: Broken stat

Postby WhiteRider » Sat Feb 19, 2011 6:11 am

I can't see anything wrong with your expressions, and it's certainly possible to have a VP$IP much higher than PFR and never limp - some people will always open with a raise if they are first to enter the pot, but will call behind if there are other limpers or raises.

Try adding your stats to the reports in the main application (Tutorial: Configure Built-in Reports) and see what values you get.
Adding them to the Positions tab reports, for instance, will let you narrow things down significantly.
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