size of SB openraise?

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

size of SB openraise?

Postby js2002 » Thu Apr 21, 2011 1:27 pm

Hi,

wo do I filter this in a stat?

I "need" SB openraise < 4bigblinds = true

use this?
holdem_hand_player_detail.amt_bet_p

but how?

maybet divide it tru the bigblind/the limit?

EDIT:

amount_bet_pre / amt_bb

AND

rfi

AND

not face raise pre
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: size of SB openraise?

Postby kraada » Thu Apr 21, 2011 1:40 pm

holdem_hand_player_detail.amt_p_raise_made < holdem_limit.amt_bb * 4

You want raise_made because otherwise if you limp/call 4 big blinds that would count too (amt_bet_p is the total of all preflop bets).

Edit to add: amt_p_raise_made is your first raise preflop - and it's the amount you raised to, so this will pick out any time you raise to 4 big blinds. To make sure it was an open raise you can also add the flag holdem_hand_player_statistics.flg_steal_att.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: size of SB openraise?

Postby js2002 » Thu Apr 21, 2011 1:49 pm

i found out that it is even the amt i called a 3bet with! so i have to build in "not faced raise"
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: size of SB openraise?

Postby kraada » Thu Apr 21, 2011 1:52 pm

I'm not sure what you mean - if you use amt_p_raise_made it's the absolute size of the raise you made - 3-bets shouldn't come into play.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: size of SB openraise?

Postby js2002 » Thu Apr 21, 2011 2:04 pm

i meant if i use

holdem_hand_player_detail.amt_bet_p

this only counts the amount of the pre action. doesnt matter if call3bet or openraise...

so i should use urs
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: size of SB openraise?

Postby js2002 » Fri Apr 22, 2011 4:53 am

Full Tilt Poker Game #29777625088: Table Flash - $0.02/$0.05 - No Limit Hold'em - 09:46:36 CET - 2011/04/10 [03:46:36 ET - 2011/04/10]
Seat 1: Gr33nDis3ase ($4.93)
Seat 2: Vanya Durak ($2.84)
Seat 3: fergb12345 ($6.27)
Seat 4: DimanLTD ($1.87)
Seat 5: PokerBabsko ($2.38)
Seat 6: o Fisticuffs o ($11.04)
Seat 7: draganddrop ($5.20)
Seat 8: Controller64 ($5)
Seat 9: hgrs101 ($16.43)
o Fisticuffs o posts the small blind of $0.02
draganddrop posts the big blind of $0.05
The button is in seat #5
*** HOLE CARDS ***
Dealt to draganddrop [As Qc]
Controller64 folds
hgrs101 folds
Gr33nDis3ase folds
Vanya Durak folds
fergb12345 folds
DimanLTD calls $0.05
PokerBabsko folds
o Fisticuffs o has 8 seconds left to act
o Fisticuffs o raises to $0.20
draganddrop calls $0.15
DimanLTD raises to $1.87, and is all in
o Fisticuffs o folds
draganddrop calls $1.67
DimanLTD shows [Ac Kd]
draganddrop shows [As Qc]
*** FLOP *** [Ad 4h 6h]
*** TURN *** [Ad 4h 6h] [Qs]
*** RIVER *** [Ad 4h 6h Qs] [5c]
DimanLTD shows a pair of Aces
draganddrop shows two pair, Aces and Queens
draganddrop wins the pot ($3.68) with two pair, Aces and Queens
*** SUMMARY ***
Total pot $3.94 | Rake $0.26
Board: [Ad 4h 6h Qs 5c]
Seat 1: Gr33nDis3ase didn't bet (folded)
Seat 2: Vanya Durak didn't bet (folded)
Seat 3: fergb12345 didn't bet (folded)
Seat 4: DimanLTD showed [Ac Kd] and lost with a pair of Aces
Seat 5: PokerBabsko (button) didn't bet (folded)
Seat 6: o Fisticuffs o (small blind) folded before the Flop
Seat 7: draganddrop (big blind) showed [As Qc] and won ($3.68) with two pair, Aces and Queens
Seat 8: Controller64 didn't bet (folded)
Seat 9: hgrs101 didn't bet (folded)


this hand is in the exp!
so raise made preflop has a bug?
(I just called 2 times)
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: size of SB openraise?

Postby kraada » Fri Apr 22, 2011 8:52 am

o Fisticuffs o did raise to 4 big blinds preflop . . . how exactly were you getting this hand to match?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: size of SB openraise?

Postby js2002 » Fri Apr 22, 2011 8:54 am

@reports it matches
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: size of SB openraise?

Postby kraada » Fri Apr 22, 2011 9:02 am

Yes but if you're not filtering on active player you're getting hands where anyone matched - and in this hand one player clearly did.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: size of SB openraise?

Postby js2002 » Fri Apr 22, 2011 9:05 am

i filter on active player.
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Next

Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests