pct bet made o bet facing <20 is true if hero dont...

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

pct bet made o bet facing <20 is true if hero dont...

Postby marvin » Wed Oct 28, 2009 5:06 am

hero is not facing bet
1.a then IS TRUE: ( holdem_hand_player_detail.val_f_bet_facing_pct <20) why he is facing a bet of 0$( then, why 0<20%pot )
1.b then IS false: ( holdem_hand_player_detail.val_f_bet_facing_pct <20) why he is has bet opportunity
-----------
hero is not betting
2.a then is true:
(holdem_hand_player_detail.val_f_bet_made_pct < 20) why hero's bet IS 0$< 20% POT

2.b) then is false:
(holdem_hand_player_detail.val_f_bet_made_pct < 20) why no bet has been made.

TY
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: pct bet made o bet facing <20 is true if hero dont...

Postby WhiteRider » Wed Oct 28, 2009 5:35 am

I'm not sure exactly what you're asking, but if the player does not bet the flop then holdem_hand_player_detail.val_f_bet_made_pct will be 0, and if they don't face a bet on the flop then holdem_hand_player_detail.val_f_bet_facing_pct will be 0.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: pct bet made o bet facing <20 is true if hero dont...

Postby marvin » Wed Oct 28, 2009 6:26 am

may be your answere is enough for explaining, but for being sure, thinking about this (if i have understood):
action on flop (pot = 10$):
"a" check - "b" bet 1$ - "a" fold

about player "a":
( holdem_hand_player_detail.val_f_bet_facing_pct <20) TRUE (1$ is less than 0,2*10$)
(holdem_hand_player_detail.val_f_bet_made_pct < 20) TRUE he hasnt bet but (his bet pct is 0, then 0 < 0,2*10$)
(holdem_hand_player_detail.val_f_bet_made_pct >1 ) FALSE
( holdem_hand_player_detail.val_f_raise_facing_pct <20) TRUE (nobody has raised then "a is facing a raise pct=0)
(holdem_hand_player_detail.val_f_raise_made_pct < 20) TRUE (nobody has raised, then he is facing a raise pct=0)

tell me which stament is incorrect (i think are all correct)
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: pct bet made o bet facing <20 is true if hero dont...

Postby WhiteRider » Wed Oct 28, 2009 6:37 am

All are correct.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: pct bet made o bet facing <20 is true if hero dont...

Postby marvin » Wed Oct 28, 2009 7:09 am

Ty
on last row of previous post, was a mistype:
(holdem_hand_player_detail.val_f_raise_made_pct < 20) TRUE (nobody has raised, then he is facing a raise pct=0)

would be:
(holdem_hand_player_detail.val_f_raise_made_pct < 20) TRUE (nobody has raised, then raise_pct made by "a"=0 that is less than 20% of pot)
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am


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

Who is online

Users browsing this forum: No registered users and 0 guests