Saw flop stat and float bet stat question

[Suboptimal88]

The saw flop stat counts for both 3-bet and non 3-bet pots right? is there a way to make a separate stat for 3-bet and non 3-bet pots? also is there a way to add *fold to float bets flop,turn etc* for 3-bet pots only?

[WhiteRider]

You're correct about "saw flop". Any of those stats can be made as custom stats. Take a look at how some of the existing "3bet pot" and "non-3bet pot" stats are made to see how it is done.

Custom Stats Guide
Tutorial: Custom Reports and Statistics

[Suboptimal88]

can these value expressions work? cnt_f_saw_3bet_pot (for 3-bet pots) and cnt_f_saw - cnt_f_saw_3bet_pot? (for non 3-bet pots)

At the insert tab , i cant find a column or a type to express *at 3-bet pots* *at non-3bet pots*.


And another question

Is it possible to create a raise first in success stat too? from all positions?

[WhiteRider]

can these value expressions work? cnt_f_saw_3bet_pot (for 3-bet pots) and cnt_f_saw - cnt_f_saw_3bet_pot? (for non 3-bet pots)

At the insert tab , i cant find a column or a type to express *at 3-bet pots* *at non-3bet pots*.

No, you will need to make new columns for your new stats. Check out the guides I linked to see how custom stats work.

Is it possible to create a raise first in success stat too? from all positions?

Yes, that is possible. You don't need to make stats for each position - you can make one stat and set the Position property when you add it to the Hud, or view it in a By Position report.

[Suboptimal88]

OK i understand how am i supposed to create columns and then statistics with them but i dont know how to type expressions with the insert , what order the words should have etc , i mean i dont understand the language... you made an example on your guide with the *fold to raise after limp* stat but anyway , is there a dictionary or something to show you how to type expressions? what to insert and form a valid sentence? or is there a forum to ask for someone else to make expressions for the stats you want and then copy paste them ?

[WhiteRider]

Read the guides linked above - the latter goes into quite a lot of detail. It was written for PT3, but the same principals apply to PT4.
Take a look at how other similar stats are made to see what database fields to use. A degree of knowledge is required to build custom stats, but it can be learned by looking at examples and following the guides. If you're still stuck please post back and tell us what you have so far and we'll help you out.

[Suboptimal88]

sum(if[(cash_hand_player_statistics.flg_p_3bet_def_opp OR cash_hand_player_
statistics.flg_p_4bet_def_opp) AND cash_hand_player_statistics.flg_f_saw, 1, 0])

Would this work? looking flop anytime there was a 3-bet or more preflop? i looked up in two columns with these 2 elements and tried to combined them in the most
logical way i could. Btw i have no idea what def , opp and flg means.

[Suboptimal88]

Some more stats , sorry for double posting , just want to see if they are valid

First in raise success

sum(if[cash_hand_player_statistics.flg_p_first_raise and cash_hand_player_statistics.flg_won_hand and not(cash_hand_player_statistics.flg_f_saw) and not(cash_hand_player_statistics.flg_p_limp_def_opp) and not(cash_hand_player_statistics.flg_p_3bet_def_opp) and not(cash_hand_player_statistics.flg_p_4bet_def_opp), 1, 0])


All in success , im not sure about this one , it probably means any all in? how do we say first raise all in?


sum(if[cash_hand_player_statistics.flg_p_allin and cash_hand_player_statistics.flg_won_hand and not(cash_hand_player_statistics.flg_f_saw) and not(cash_hand_player_statistics.flg_p_limp_def_opp) and not(cash_hand_player_statistics.flg_p_3bet_def_opp) and not(cash_hand_player_statistics.flg_p_4bet_def_opp), 1, 0])


Fold to float bet at turn in a 3-bet pot , this one looks harder

sum(if[cash_hand_player_statistics.flg_p_3bet) AND not(cash_hand_player_statistics.flg_f_face_raise) AND lookup_actions_f.action LIKE '%R'
and cash_hand_player_statistics.flg_t_open_opp AND cash_hand_player_statistics.amt_t_bet_facing >
0 AND substring(lookup_actions_t.action from 1 for 2) = 'XF', 1, 0])

[Suboptimal88]

sorry for triple posting , couldnt edit the last one.


Is it possible to create a stat where you can see the *fold to first in raise* to the players on your left and then use it as a table stat? this would be a really strong stat.

*on your left* is what matters here , if i use a traditional fold to stat as a table stat then it will count the players on my right too.

[kraada]

def means "defense", "opp" means opportunity and "flg" means flag (that is, the value is boolean). There is no flag in the database "not(cash_hand_player_statistics.flg_p_limp_def_opp) ".

Simplest would actually be: "sum(if[cash_hand_player_statistics.flg_p_first_raise and cash_hand_player_statistics.flg_p_open_opp and cash_hand_player_statistics.flg_won_hand and not(cash_hand_player_statistics.flg_f_saw) and lookup_actions_p.action = 'R', 1, 0])"

The lookup actions string is the string of all actions that player made on the street in question (_p is pre flop). So in this case we check that it's equal to 'R' and nothing else -- so the player raised pre flop and did nothing else, and we know he won and didn't see a flop so his first raise must have done it. I added in a check that the player had a chance to open as well - meaning there were no limpers.

You can look at the columns for any of our built in stats as well and that should be very useful for you (for example, you could look at cnt_p_raise_first which is used in Raise First In to see about flg_p_open_opp).

You can't set table averages to only count some of the players.