val_t_BET/RAISE_facing_pct val_t_BET/RAISE_made_pct

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

val_t_BET/RAISE_facing_pct val_t_BET/RAISE_made_pct

Postby marvin » Sat Oct 17, 2009 9:39 am

TURN: A bet 2$ in pot that was 10$ (now the pot is 12$) - B raise putting in the pot 12$ (now the pot is 24$) - C put in 50$ (the pot now is 74$). A pays (for calling) 48$ and B pay 38$.

C doesnt face a bet (but a raise) so, if i want use a counter about how much time he has faced bet over 40% of the pot this sum for him in this case is 0 right?
sum (if holdem_hand_player_detail.val_t_bet_facing_pct >=40 , 1, 0])


about B, how much is his val_t_raise_made_pct:? 100*10/14 (why he must call 2 on a pot of 12, so the pot is 14, and the left 10 (from his 12) is the raise?
about A how much is val_t_raise_facin_pct? he must pay 48 on a pot of 74? so 100*48/74 ?

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

Re: val_t_BET/RAISE_facing_pct val_t_BET/RAISE_made_pct

Postby kraada » Sat Oct 17, 2009 10:01 am

I believe for C bet_facing in this instance is 0, and I'm fairly certain your math is correct on all of the percentage points.
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