List of custom stats that aren't working uploaded on site

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

List of custom stats that aren't working uploaded on site

Postby Letissie » Thu Jan 08, 2009 3:40 pm

Some of the custom stats uploaded by users on site aren't working properly.

I've downloaded them all and i'm gonna test them on Beta 23 on pop up.

I'll write down the ones that doesn't work.

Also a real and good stats for 3Bet pot is needed since the ones uploaded works wierd.
With a HUGE sample of hand they still display N/A all the time.

kraada if you can create a pack for that it would be perfect!

After the stats diplayed on Replay and EV graph PT3 will be simply perfect.
I'm trying all the major software and i can say PT3 is by far the best. You can edit everything and the code is so deep.

Very nice program and thx for the fast answer.



V.
Letissie
 
Posts: 39
Joined: Thu Apr 10, 2008 9:31 am

Re: List of custom stats that aren't working uploaded on site

Postby kraada » Thu Jan 08, 2009 4:00 pm

If you find definite errors in uploaded stats let me know and I'll make sure to get them removed. Those stats are uploaded by end users and we don't do a lot of checking other than to make sure they're valid stats before loading them into the repository.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: List of custom stats that aren't working uploaded on site

Postby Letissie » Fri Jan 09, 2009 4:17 am

Stats not working:


Cbet by position pack on page 6 (Stats doesn't give any value not even N/A)
Avg. # of tablers on page 2
Hands played w k on page 3 notation / color range cannot be changed after 1k is always the same
S-Position 6max on page 3

All EB1983 stats need revision gives wierd value like 200% or 3/0



V.
Letissie
 
Posts: 39
Joined: Thu Apr 10, 2008 9:31 am

Re: List of custom stats that aren't working uploaded on site

Postby kraada » Fri Jan 09, 2009 10:46 am

We'll look into these.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: List of custom stats that aren't working uploaded on site

Postby WhiteRider » Tue Feb 24, 2009 12:56 pm

Letissie wrote:Cbet by position pack on page 6 (Stats doesn't give any value not even N/A)

Do you mean "Raises Cbet by position stevi3p Dec 08, 2008"?
These work fine for me - exactly what is the problem?
If not those, which exactly?

Avg. # of tablers on page 2

Again, fine for me - what is the problem?

Hands played w k on page 3 notation / color range cannot be changed after 1k is always the same

This is a known issue and is due to the format expression being used for colouring instead of the value expression.

S-Position 6max on page 3

What exactly is wrong with these - they work OK for me.

All EB1983 stats need revision gives wierd value like 200% or 3/0

All of these give sensible values for me. Can you give me an example of a specific stat which doesn't work?
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: List of custom stats that aren't working uploaded on site

Postby Dan_Jazz_Man » Mon Dec 21, 2009 1:32 pm

I get weird results for EB1983's stats too (DL-ed them today):
- For many players I get NA for Call 3Bet Preflop - Fold CBet Flop and positive values for Call 3Bet Preflop - Fold CBet Turn.
How is this possible? Doesn't the C-bet turn imply that there was a C-bet Flop?
- Call 3Bet Preflop - Raise CBet Flop Percentage; I see values like 200 (2/1) a lot.
Dan_Jazz_Man
 
Posts: 476
Joined: Sun Feb 03, 2008 5:58 pm

Re: List of custom stats that aren't working uploaded on site

Postby kraada » Mon Dec 21, 2009 2:20 pm

I don't have those custom stats installed on my system at the moment; could you copy and paste the column definitions (and value expression from the stat)? That should illuminate things considerably.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: List of custom stats that aren't working uploaded on site

Postby Dan_Jazz_Man » Mon Dec 21, 2009 2:43 pm

Fold CBet Flop in 3-bet pot:
(cnt_p_3bet_f_cbet_def_action_fold / cnt_p_3bet_f_cbet_def_opp) * 100
cnt_p_3bet_f_cbet_def_action_fold = sum(if[ holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.enum_f_cbet_action='F', 1 , 0 ])
cnt_p_3bet_f_cbet_def_opp = sum(if[ holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_f_cbet_def_opp, 1 , 0 ])

Fold CBet Turn in 3-bet pot:
(cnt_p_3bet_t_cbet_def_action_fold / cnt_p_3bet_t_cbet_def_opp) * 100
cnt_p_3bet_t_cbet_def_action_fold = sum(if[ (holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_4bet_def_opp) AND holdem_hand_player_statistics.enum_t_cbet_action='F', 1 , 0 ])
cnt_p_3bet_t_cbet_def_opp = sum(if[ (holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_4bet_def_opp) AND holdem_hand_player_statistics.flg_t_cbet_def_opp, 1 , 0 ])

Raise CBet Flop in 3-bet pot:
(cnt_p_3bet_f_cbet_def_action_raise / cnt_p_3bet_f_cbet_def_opp) * 100
cnt_p_3bet_f_cbet_def_action_raise= sum(if[ (holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_4bet_def_opp) AND holdem_hand_player_statistics.enum_f_cbet_action='R', 1 , 0 ])
cnt_p_3bet_f_cbet_def_opp = sum(if[ holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_f_cbet_def_opp, 1 , 0 ])
Dan_Jazz_Man
 
Posts: 476
Joined: Sun Feb 03, 2008 5:58 pm

Re: List of custom stats that aren't working uploaded on site

Postby Dan_Jazz_Man » Mon Dec 21, 2009 2:44 pm

I'm guessing this is because of holdem_hand_player_statistics.flg_p_4bet_def_opp being in there.
Dan_Jazz_Man
 
Posts: 476
Joined: Sun Feb 03, 2008 5:58 pm

Re: List of custom stats that aren't working uploaded on site

Postby kraada » Mon Dec 21, 2009 3:29 pm

Fold CBet Flop in 3-bet pot:
(cnt_p_3bet_f_cbet_def_action_fold / cnt_p_3bet_f_cbet_def_opp) * 100
cnt_p_3bet_f_cbet_def_action_fold = sum(if[ holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.enum_f_cbet_action='F', 1 , 0 ])
cnt_p_3bet_f_cbet_def_opp = sum(if[ holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_f_cbet_def_opp, 1 , 0 ])

This stat is poorly named; it's actually how often you fold to a cbet in a 4 bet pot where you make the 3bet. The only way you can face a cbet after making a 3bet is if someone else 4bets you.

Fold CBet Turn in 3-bet pot:
(cnt_p_3bet_t_cbet_def_action_fold / cnt_p_3bet_t_cbet_def_opp) * 100
cnt_p_3bet_t_cbet_def_action_fold = sum(if[ (holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_4bet_def_opp) AND holdem_hand_player_statistics.enum_t_cbet_action='F', 1 , 0 ])
cnt_p_3bet_t_cbet_def_opp = sum(if[ (holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_4bet_def_opp) AND holdem_hand_player_statistics.flg_t_cbet_def_opp, 1 , 0 ])

Here it's anytime you faced a 3bet or 4bet, so it's a bit more explicit; this only counts times you actually face double barrels. Otherwise this should work. (Note you can have never made a raise preflop and still have it counted in this stat.)


Raise CBet Flop in 3-bet pot:
(cnt_p_3bet_f_cbet_def_action_raise / cnt_p_3bet_f_cbet_def_opp) * 100
cnt_p_3bet_f_cbet_def_action_raise= sum(if[ (holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_4bet_def_opp) AND holdem_hand_player_statistics.enum_f_cbet_action='R', 1 , 0 ])
cnt_p_3bet_f_cbet_def_opp = sum(if[ holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_f_cbet_def_opp, 1 , 0 ])

Here your problem is the opportunities column isn't what you want at all. To match you want:
cnt_p_3bet_f_cbet_def_opp= sum(if[ (holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_4bet_def_opp) AND holdem_hand_player_statistics.flg_f_cbet_def_opp, 1 , 0 ])

That's probably why you're getting 2/1 results in places. Similar comments about not raising preflop apply as per the last stat.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Next

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

Who is online

Users browsing this forum: No registered users and 0 guests