WTSD in 3 bet pots

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

WTSD in 3 bet pots

Postby js2002 » Tue Nov 03, 2009 12:43 pm

Psydocode:

flg_SD AND
(
(3bet_def_opp AND NOT(flg_4bet))
OR
(flg_3bet AND NOT(4bet_def_opp))
)

real code:
sum(if[holdem_hand_player_statistics.flg_showdown AND (
(holdem_hand_player_statistics.flg_p_3bet_def_opp AND NOT(holdem_hand_player_statistics.flg_p_4bet)) OR (holdem_hand_player_statistics.flg_p_3bet AND NOT(holdem_hand_player_statistics.flg_p_4bet_def_opp))
)
, 1, 0])
__________
sum(if[holdem_hand_player_statistics.flg_f_saw AND (
(holdem_hand_player_statistics.flg_p_3bet_def_opp AND NOT(holdem_hand_player_statistics.flg_p_4bet)) OR (holdem_hand_player_statistics.flg_p_3bet AND NOT(holdem_hand_player_statistics.flg_p_4bet_def_opp))
)
, 1, 0])


correct? and good solution?
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: WTSD in 3 bet pots

Postby kraada » Tue Nov 03, 2009 12:52 pm

Looks good to me and that looks like the simplest solution as well.
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