About 3bet vs steal%

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

Re: About 3bet vs steal%

Postby Mr Tiger » Mon Feb 27, 2012 5:48 pm

Mr Tiger wrote:WhiteRider
I haven't yet understood only one thing. Why am I getting value>0, if "holdem_hand_player_statistics.flg_blind_def_opp is never true for the button"?

Found out. I had a mistake in my HUD configuration.
Mr Tiger
 
Posts: 143
Joined: Tue Sep 09, 2008 5:14 am

Re: About 3bet vs steal%

Postby Mr Tiger » Mon Feb 27, 2012 8:17 pm

I've made a simplified stat "3bet BUvsCO approximately", but it gives me N/A. I don't understand, why. Here are the expressions:

(cnt_p_BU_3bet_to_CO_steal_approx / cnt_p_BU_fold_to_CO_opp_approx) * 100

cnt_p_BU_3bet_to_CO_steal_approx
sum(if[holdem_hand_player_statistics.flg_p_3bet AND
holdem_hand_player_statistics.position = 0 AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 1,1,0])

cnt_p_BU_fold_to_CO_opp_approx
sum(if[holdem_hand_player_statistics.flg_p_3bet_opp AND holdem_hand_player_statistics.position = 0 AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 1,1,0])
Mr Tiger
 
Posts: 143
Joined: Tue Sep 09, 2008 5:14 am

Re: About 3bet vs steal%

Postby WhiteRider » Tue Feb 28, 2012 4:15 am

Those expressions look OK to me - I can't see why that would be N/A unless you don't have any hands which match that situation. Are you looking at a decent sample size including hands like that?
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: About 3bet vs steal%

Postby Mr Tiger » Tue Feb 28, 2012 10:23 am

It's more than 20k hands for one player. And it still returns N/A(0/0)...
Mr Tiger
 
Posts: 143
Joined: Tue Sep 09, 2008 5:14 am

Re: About 3bet vs steal%

Postby Mr Tiger » Tue Feb 28, 2012 1:25 pm

I've solved the problem. But still I don't understand why it didn't work. I've just made the same stat with another name and column's names. After that both stats work.
Mr Tiger
 
Posts: 143
Joined: Tue Sep 09, 2008 5:14 am

Re: About 3bet vs steal%

Postby WhiteRider » Wed Feb 29, 2012 4:17 am

That's odd, but good to hear you got it working.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Previous

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

Who is online

Users browsing this forum: No registered users and 2 guests