WonSDwhenOverbetRiver

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

WonSDwhenOverbetRiver

Postby js2002 » Tue Sep 14, 2010 5:02 am

wSDwOB_r Stat

DEF = bet >= 120% at river

(holdem_hand_player_detail.val_r_bet_made_pct >= 120) (rightt syntax?!) AND
holdem_hand_player_statistics.flg_showdown AND
holdem_hand_player_statistics.flg_won_hand

_______________________

(holdem_hand_player_detail.val_r_bet_made_pct >= 120) (rightt syntax?!) AND
holdem_hand_player_statistics.flg_showdown AND

plz validate, thx
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: WonSDwhenOverbetRiver

Postby js2002 » Tue Sep 14, 2010 7:50 am

PokerStars Game #45970604203: Hold'em No Limit ($0.01/$0.02 USD) - 2010/06/25 16:21:30 CET [2010/06/25 10:21:30 ET]
Table 'Galilea' 9-max Seat #4 is the button
Seat 1: renaaars ($1.56 in chips)
Seat 2: Jetztlos ($2.30 in chips)
Seat 3: DJJKjonesman ($0.80 in chips)
Seat 4: wal1977 ($2.35 in chips)
Seat 5: js2002 ($2.81 in chips)
Seat 6: Dr leroc ($1.21 in chips)
Seat 7: MrKisa ($5 in chips)
js2002: posts small blind $0.01
Dr leroc: posts big blind $0.02
faemino1981: sits out
phillager: sits out
*** HOLE CARDS ***
Dealt to js2002 [6h 3d]
MrKisa: folds
renaaars: calls $0.02
Jetztlos: calls $0.02
DJJKjonesman: folds
wal1977: calls $0.02
js2002: calls $0.01
Dr leroc: checks
*** FLOP *** [3c 3h 4h]
js2002: bets $0.10
Dr leroc: folds
renaaars: calls $0.10
Jetztlos: folds
wal1977: folds
*** TURN *** [3c 3h 4h] [9s]
Jetztlos leaves the table
js2002: checks
renaaars: bets $0.10
js2002: raises $0.48 to $0.58
renaaars: calls $0.48
*** RIVER *** [3c 3h 4h 9s] [2h]
js2002: bets $2.11 and is all-in
renaaars: calls $0.86 and is all-in
Uncalled bet ($1.25) returned to js2002
*** SHOW DOWN ***
js2002: shows [6h 3d] (three of a kind, Threes)
renaaars: shows [8h 9h] (a flush, Nine high)
js2002 said, "loool"
renaaars collected $3.03 from pot
*** SUMMARY ***
Total pot $3.18 | Rake $0.15
Board [3c 3h 4h 9s 2h]
Seat 1: renaaars showed [8h 9h] and won ($3.03) with a flush, Nine high
Seat 2: Jetztlos folded on the Flop
Seat 3: DJJKjonesman folded before Flop (didn't bet)
Seat 4: wal1977 (button) folded on the Flop
Seat 5: js2002 (small blind) showed [6h 3d] and lost with three of a kind, Threes
Seat 6: Dr leroc (big blind) folded on the Flop
Seat 7: MrKisa folded before Flop (didn't bet)


When the Caller ist short I didnt really overbet, so I have the catch that with the final pot amt I guess...
How do I get the River Potsize before SD?
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: WonSDwhenOverbetRiver

Postby js2002 » Tue Sep 14, 2010 8:20 am

((100 * holdem_hand_player_detail.amt_bet_r / holdem_hand_player_detail.val_r_bet_made_pct)) * 1.1 * 2 + ((100 * holdem_hand_player_detail.amt_bet_r / holdem_hand_player_detail.val_r_bet_made_pct))


Potsize Workaround fails due to div by zero bug!

EDIT fixed by:

if[
holdem_hand_player_detail.val_r_bet_made_pct>0,
(100 * holdem_hand_player_detail.amt_bet_r / holdem_hand_player_detail.val_r_bet_made_pct) * 1.1 * 2 + (100 * holdem_hand_player_detail.amt_bet_r / holdem_hand_player_detail.val_r_bet_made_pct)
,0]
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: WonSDwhenOverbetRiver

Postby kraada » Tue Sep 14, 2010 8:50 am

Nice workaround :)

That should all work though make sure you remove the extraneous AND in your opportunities column.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: WonSDwhenOverbetRiver

Postby js2002 » Tue Sep 14, 2010 9:09 am

FINALLY:

sum(if[
holdem_hand_player_detail.val_r_bet_made_pct>0,
if[(100 * holdem_hand_player_detail.amt_bet_r / holdem_hand_player_detail.val_r_bet_made_pct) * 1.1 * 2 + (100 * holdem_hand_player_detail.amt_bet_r / holdem_hand_player_detail.val_r_bet_made_pct)<holdem_hand_summary.amt_pot
AND (holdem_hand_player_detail.val_r_bet_made_pct > 110) AND holdem_hand_player_statistics.flg_showdown AND holdem_hand_player_statistics.flg_won_hand,1,0]
,0])
________________________________________
sum(if[
holdem_hand_player_detail.val_r_bet_made_pct>0,
if[(100 * holdem_hand_player_detail.amt_bet_r / holdem_hand_player_detail.val_r_bet_made_pct) * 1.1 * 2 + (100 * holdem_hand_player_detail.amt_bet_r / holdem_hand_player_detail.val_r_bet_made_pct)<holdem_hand_summary.amt_pot AND (holdem_hand_player_detail.val_r_bet_made_pct > 110) AND holdem_hand_player_statistics.flg_showdown,1,0]
,0])

The orange Part checks:
"Is the final pot really > than the River Pot + 2x (the River Pot *1.1)"
[1.1 because rationally when we overbet 110% the pot has to be twice at least the overbet size + pot]

With this I catch the situations where I overbet a pot but the last caller only hast f.e. 50% potsize left. These cases now come to 0 in the sum I hope. My Report looks good, but can u please verify this stat?
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: WonSDwhenOverbetRiver

Postby kraada » Tue Sep 14, 2010 9:56 am

I think that looks good.
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