W$SD when c/r turn

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

W$SD when c/r turn

Postby urtaxman » Tue Apr 12, 2011 5:42 pm

Hi,

I want "W$SD when turn check raise". I want to know how often a player won the hand on showdown when he check raise turn. It seems to me the kind of stats that should be included on default. I couldn't find it. Maybe I am just not looking at right place. Anyhow, I guess I can try to make custom stats by modifying "W$SD when bet or raise", but I just want to ask before I start working on this. Thanks
urtaxman
 
Posts: 4
Joined: Mon Dec 07, 2009 12:58 am

Re: W$SD when c/r turn

Postby kraada » Tue Apr 12, 2011 5:59 pm

That stat is not available by default but it can certainly be built.

If you just want to see your W$SD in those spots though you could also filter for times you check/raised the turn and look at your W$SD with the filter enabled and that will tell you your W$SD when the turn is check/raised.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: W$SD when c/r turn

Postby urtaxman » Wed Apr 13, 2011 12:17 pm

thanks,

I actually want to use stats in HUD. I remember seeing a option of applying filter to stats (not sure) on config stats page. I just checked and couldn't figure out how to apply filter to W$SD. I mean, in theory, I can build new stats by applying filter to W$SD, right? Thanks in advance.
urtaxman
 
Posts: 4
Joined: Mon Dec 07, 2009 12:58 am

Re: W$SD when c/r turn

Postby kraada » Wed Apr 13, 2011 12:39 pm

You'd need to build two new columns for this, one for the times they went to showdown when check raising the turn, one for the times they did that and won.

Those columns would be defined as:

cnt_wtsd_when_xr_turn: sum(if[holdem_hand_player_statstics.flg_t_check_raise and holdem_hand_player_statistics.flg_showdown, 1, 0])

cnt_wtsd_won_when_xr_turn: sum(if[holdem_hand_player_statistics.flg_t_check_raise and holdem_hand_player_statistics.flg_showdown and holdem_hand_player_statistics.flg_won_hand, 1, 0])

Put the latter over the former in the stat and multiply by 100 to get the number you want to see. For more on building custom statistics please see the Tutorial: Using Custom Statistics & Reports.
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 1 guest