Fold2OverbetRiver

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

Fold2OverbetRiver

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

sum(if[
(holdem_hand_player_detail.val_r_bet_facing_pct >= 120) AND (lookup_actions_r.action SIMILAR TO '(F|XF)%')
, 1, 0])
______________

sum(if[
(holdem_hand_player_detail.val_r_bet_facing_pct >= 120) AND
, 1, 0])

Does this work correct? So we really have a "bet defense oppertunity"?
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Fold2OverbetRiver

Postby js2002 » Tue Sep 14, 2010 6:10 am

The Denumerator doesnt get TRUE for this hand:

PokerStars Game #45969705204: Hold'em No Limit ($0.01/$0.02 USD) - 2010/06/25 15:49:32 CET [2010/06/25 9:49:32 ET]
Table 'Euterpe II' 9-max Seat #5 is the button
Seat 5: der Gärtner1 ($0.86 in chips)
Seat 6: js2002 ($1.60 in chips)
der Gärtner1: posts small blind $0.01
js2002: posts big blind $0.02
*** HOLE CARDS ***
Dealt to js2002 [Qd 9d]
davito933 leaves the table
der Gärtner1: calls $0.01
js2002: checks
*** FLOP *** [9h Kh Td]
js2002: checks
der Gärtner1: bets $0.02
js2002: calls $0.02
*** TURN *** [9h Kh Td] [8s]
js2002: checks
der Gärtner1: checks
*** RIVER *** [9h Kh Td 8s] [5d]
js2002: checks
der Gärtner1: bets $0.12
js2002: calls $0.12
*** SHOW DOWN ***
der Gärtner1: shows [8h 8d] (three of a kind, Eights)
js2002: mucks hand
der Gärtner1 collected $0.31 from pot
*** SUMMARY ***
Total pot $0.32 | Rake $0.01
Board [9h Kh Td 8s 5d]
Seat 5: der Gärtner1 (button) (small blind) showed [8h 8d] and won ($0.31) with three of a kind, Eights
Seat 6: js2002 (big blind) mucked [Qd 9d]
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Fold2OverbetRiver

Postby js2002 » Tue Sep 14, 2010 6:16 am

lol nice bug: > 0 works

So bet_made defintion != bet_facing definition

In made I have to use 120 and in facing 1.2 right?!


STRANGE: the "bet facing %" returns 60 at this hand! but its 150%

bet = 12 pot = 8
(12/20) * 100 is the formula I guess

so (bet/(pot+bet)) * 100
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Fold2OverbetRiver

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

Yeah, the val_x_raise_facing_pct fields are the percentage of the pot you have to call.

To convert it to the amount of the pot that he bet you use this formula:

amt_x_bet_facing / ((amt_x_bet_facing * 1/val_x_raise_facing_pct) - amt_x_bet_facing)
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Fold2OverbetRiver

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

kraada wrote:Yeah, the val_x_raise_facing_pct fields are the percentage of the pot you have to call.

To convert it to the amount of the pot that he bet you use this formula:

amt_x_bet_facing / ((amt_x_bet_facing * 1/val_x_raise_facing_pct) - amt_x_bet_facing)



Example: Pot 8$ facing bet of 12$ which is 150% Overbet in my definition

Then I use ur formula:

12/ ((12*1/60)-12) (the 60 come from val_x_BET_facing_pct) why raise, there is no raise?!

12/0,2-12

12/-11,8

-1,0169492 ????

This result cant be right. I think the result should be 150 or what do we expect?
Why this "*1"?
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Fold2OverbetRiver

Postby kraada » Tue Sep 14, 2010 12:26 pm

Sorry the bet facing and raise facing fields work the same - I'd worked it out recently with raise facing and forgot to change it in my post.

Using your example of bet = 12, initial pot of 8, amt_r_bet_facing = 8, val_r_bet_facing_pct = 12/20.

amt_r_bet_facing / ((amt_r_bet_facing * 1/val_r_bet_facing_pct) - amt_r_bet_facing) =
8 / ((8 * 1 / (12 / 20)) - 8) =
8 / ((8 * 20/12) - 8) =
8 / (8 * 5 / 3) - 8 =
8 / (40/3 - 8) =
8 / (16/3) = 24 / 16 = 1.5.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Fold2OverbetRiver

Postby js2002 » Tue Sep 14, 2010 12:55 pm

1. no amt_r_bet_facing is 12. He bet 12 into a River Pot of 8. Thats 1,5 or 150%
Why is ur result correct, when the value entered is wrong?!

I added this to hand section:
if[holdem_hand_player_detail.amt_r_bet_facing>0 AND holdem_hand_player_detail.val_r_bet_facing_pct >0,holdem_hand_player_detail.amt_r_bet_facing / ((holdem_hand_player_detail.amt_r_bet_facing * 1/holdem_hand_player_detail.val_r_bet_facing_pct) - holdem_hand_player_detail.amt_r_bet_facing),0]

It fails, corruct values lie 19.0 and -4 etc...


2. please tell about the "*1"
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Fold2OverbetRiver

Postby kraada » Tue Sep 14, 2010 2:04 pm

That's a very good question! Looking at it again with that in mind I think we may be able to simplify the equation considerably - it looks like the actual bet amount is totally dropping out of the equation. This should give the same result:

(val_x_bet_facing_pct / (1 - val_x_bet_facing_pct))

(12/20) / (8/20) = 12 / 8 = 1.5

To make it a percentage you'd need to multiply by 100.

Think about val_x_bet_facing_pct as a fraction: it's initial bet divided by the original pot plus the bet. That is, val_x_bet_facing_pct = b / (b + p). What you want is to convert that to: b/p. My initial formula was what I came up with after a bit of work - the above formula is a heck of a lot cleaner and we can show that it'll work out properly:

(b / (b + p)) / (1 - (b / (b + p))) = b / b + p - b = b / p.

And the * 1/x was to create the reciprocal, note the number of parentheses used. Either way the above formula is a whole lot cleaner.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Fold2OverbetRiver

Postby js2002 » Tue Sep 14, 2010 2:23 pm

val_x_bet_facing_pct = b / (b + p)

I was on pencil & paper this far. So my formula was: x = (b/(b+p)) = the facing_pct "result"

But then I failed to convert the formula in combination with y = (b/p) *100 = 150

Im really math failor!

If u like please tell me the way (simpler than above) from x = (b/(b+p)) to the needed formula with help by y = (b/p).
We want the y on a clear side so that we can later make sth like "150<the formula result".
So I guess the first step is: *p so we have
y*p = b, step 2 we replace every b in formula 1 with (y*p)
x = ((y*p)/((y*p)+p))

Ok I got a formula, I cant go on and make it simplier.
But the bigger problem now is:

I see that we dont have p = pot! we have the bet facing (12) and the bet made (12)

So I hope u see were I got stuck.

In the meantime I ll try this:


(val_x_bet_facing_pct / (1 - val_x_bet_facing_pct))

I dont knwo excatly how u made it but It will work I strongly guess.
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Fold2OverbetRiver

Postby js2002 » Tue Sep 14, 2010 2:38 pm

b
b
b
b

DOUBLEPOST

if[holdem_hand_player_detail.amt_r_bet_facing>0 AND holdem_hand_player_detail.val_r_bet_facing_pct >0,(holdem_hand_player_detail.amt_r_bet_facing*100 / 100*(1 - holdem_hand_player_detail.amt_r_bet_facing)),0]

I need the 100s because of the FUCKING div by zero bug!

sooo puked out....


At least: the cloumn produces also shit. by hand it calculates the correct results. But in PT3 it just fucks me.
0.25 up to -5 values. yes I updated the cache lately.

n8 I give up and use the annoying 52.5454545454 value for 110 or 120 % (cant remember) I guess it was 110
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