amount bet in HUD

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

amount bet in HUD

Postby agragr » Thu Jan 27, 2011 6:55 am

Can somehow be in the HUD display amount bet (First in) in BB ?
agragr
 
Posts: 22
Joined: Thu Nov 26, 2009 12:23 pm

Re: amount bet in HUD

Postby kraada » Thu Jan 27, 2011 9:53 am

You could display the average size someone uses, yes, though you'd need to create a custom statistic which would then be displaying. Would this be for tournaments or cash games?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: amount bet in HUD

Postby agragr » Thu Jan 27, 2011 11:16 am

For tournaments
agragr
 
Posts: 22
Joined: Thu Nov 26, 2009 12:23 pm

Re: amount bet in HUD

Postby kraada » Thu Jan 27, 2011 11:23 am

You'll want to create the following new column:

cnt_p_rfi_bb_total: sum(if[tourney_holdem_hand_player_statistics.flg_p_first_raise AND tourney_holdem_hand_player_statistics.flg_p_open_opp, tourney_holdem_hand_player_detail.amt_p_raise_made / tourney_holdem_blinds.amt_bb, 0])

Divide this column by cnt_p_raise_first_in in your stat's value expression and you'll see the average bet size in big blinds that the player raised first in.

For more on creating custom statistics and reports please see the Tutorial: Using Custom Statistics and 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 0 guests