Raise Cbet Flop IP / Bet 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

Raise Cbet Flop IP / Bet Turn

Postby js2002 » Fri Feb 04, 2011 1:46 pm

New plan:

1. Villian raises my cbet in position and bets on turn.
other:
2. and checkbehinds

unimportant right now just idea:
(and raises my donkbet
and folds to my donkbet
and calls my donkbet)

MORE:
Villian raises my cbet in position and bets on turn. /folds /calls /raises




psydo-code:
1. denumerator:
flop cbet action=raise AND "posi < PFA posi" AND "Turn open opp"

2. same like 1. but other numerator --> the checkbehind

Questions:

How do I check "was the cbet raise the closing flop action?" Is "%R" possible?
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Raise Cbet Flop IP / Bet Turn

Postby js2002 » Fri Feb 04, 2011 2:45 pm

sum(if[
holdem_hand_player_statistics.enum_f_cbet_action='R'
AND lookup_actions_f.action LIKE 'R' to be sure that this is the last action!
AND holdem_hand_player_detail.val_p_raise_aggressor_pos > holdem_hand_player_statistics.position
AND holdem_hand_player_detail.flg_t_open_opp
, 1, 0])

this ok?

(note: non HU table prove, will follow)
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Raise Cbet Flop IP / Bet Turn

Postby js2002 » Fri Feb 04, 2011 3:30 pm

UPDATE: built in the HU saveness, please validate

DENUMERATOR:

sum(if[
(holdem_hand_summary.cnt_players > 2
AND holdem_hand_player_statistics.enum_f_cbet_action='R'
AND lookup_actions_f.action LIKE 'R'
AND holdem_hand_player_detail.val_p_raise_aggressor_pos > holdem_hand_player_statistics.position
AND holdem_hand_player_detail.flg_t_open_opp)
OR
(holdem_hand_summary.cnt_players = 2
AND holdem_hand_player_statistics.enum_f_cbet_action='R'
AND lookup_actions_f.action LIKE 'R'
AND holdem_hand_player_detail.val_p_raise_aggressor_pos < holdem_hand_player_statistics.position
AND holdem_hand_player_detail.flg_t_open_opp)
, 1, 0])
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Raise Cbet Flop IP / Bet Turn

Postby WhiteRider » Fri Feb 04, 2011 5:17 pm

Looks OK.
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 2 guests