SNG HU stat fold to...

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

SNG HU stat fold to...

Postby olistr » Fri Apr 20, 2012 10:55 am

Can I find somewhere stat fold to flop bet in limped pot , IP and OOP for HU SNG?
olistr
 
Posts: 53
Joined: Wed May 14, 2008 4:32 am

Re: SNG HU stat fold to...

Postby kraada » Fri Apr 20, 2012 12:23 pm

These stats don't exist by default but you can build them.

For In Position use these columns:

cnt_f_fold_vs_bet_limped_pot_ip: sum(if[lookup_actions_p.action = 'C' and not(holdem_hand_player_statistics.flg_p_face_raise) and holdem_hand_player_detail.flg_f_has_position and lookup_actions_f.action = 'F', 1, 0])

cnt_f_face_bet_limped_pot_ip: sum(if[lookup_actions_p.action = 'C' and not(holdem_hand_player_statistics.flg_p_face_raise) and holdem_hand_player_detail.flg_f_has_position and holdem_hand_player_detail.amt_f_bet_facing > 0, 1, 0])

For Out of Position use these columns:

cnt_f_fold_vs_bet_limped_pot_oop: sum(if[lookup_actions_p.action = 'X' and not(holdem_hand_player_detail.flg_f_has_position) and not(holdem_hand_player_statistics.flg_p_face_raise) and lookup_actions_f.action = 'XF', 1, 0])

cnt_f_face_bet_limped_pot_oop: sum(if[lookup_actions_p.action = 'X' and not(holdem_hand_player_detail.flg_f_has_position) and not(holdem_hand_player_statistics.flg_p_face_raise) and lookup_actions_f.action LIKE 'X_%', 1, 0])

For more on creating custom statistics please see this tutorial.
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