Stats based only on hands played vs hero ?

[kraada]

To create your stat you need to add two new columns in the Holdem Cash Player Statistics section:

cnt_p_face_minsteal:*
sum(if[holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_detail.val_p_raise_facing_pct < 30, 1, 0])

cnt_p_face_minsteal_action_fold:
sum(if[holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_detail.val_p_raise_facing_pct < 30 and lookup_actions_p.action = 'F', 1, 0])

Put the latter over the former, multiply by 100 and you have your percentage. (For a more detailed account of custom stat creation, please see the Tutorial: Using Custom Statistics and Reports.)


*The reason 30% was used is that certain limits do not add up nicely in the small blind amount. In .1/.25 you would need it to be slightly higher as the blinds are a smaller percentage of the pot than, say, 1/2. Please note: this stat will not work for tables with antes, and you will need to recalculate the percentage value for ante tables.

[WhiteRider]

joker :

"Before I start to work on it, can you confirm that I understand correctly what you said - I will be able to make a HUD stats like "fold BB to 2bb SB steal" ?"

whiterider :

"Yes, you can do that."

Is there than any other way how to make it at the moment ?

Sorry - I misunderstood what you were trying to do since the last couple of posts were about this custom report.

[joker]

Thank you very much it seems to be working. Can you please explain me connection between 30 % you selected and value of original raise / pot ? I want to make more stats like this with different betsizes from the stealer, can I check for exact value instead of range ? Thank you.

[kraada]

Let's look at the simplest example, when blinds are 1 and 2.

When the button minraises, he raises to 4. Thus the total pot is 4+2+1 or 7. 2/7 = 28.5%.

As I said at certain limits with asymmetrical blinds there are other issues to contend with - at .1/.25 the raise is to .5, so the raise percentage is .25/.85 = 29.4%. I couldn't think of any other limit with a smaller small blind to big blind ration but I figured 30% would be safest just in case there were such a thing. And it's unlikely that anybody will ever raise 2.01 at a 1/2 table . . .

[joker]

ok thank you very much for quick response

[joker]

I have one more question, I really tried to figure it out myself, but I failed. My point is - I want to know how many times people are folding to my certain open bet size, which is 4.2 on 1/2 ... so I figured out that the pot ratio will be 2.2/7.2 = 30,55555 %. Knowing this I tried to modify your colums to show only percentage of hands when player was facing this sized steal and fold, so I was experimenting with operators like "< 31, > 30" "< 31 and > 30" but it is not valid SQL format. I also read your post about operators and I think that ROUND function can solve my problem if I roud 30,5 to 31 and than set "...raise_facing_pct = 31". Can you help me with this please ?

[kraada]

The simplest lexical way to deal with the problem is:

sum(if[holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_detail.val_p_raise_facing_pct BETWEEN 30.5 and 30.6, 1, 0])

Then anything between (and including) 30.5 and 30.6 will match. The above expression also validates properly for me.

[joker]

Unfortunatelly it seems like I still can´t get the right number. When I run a custom report mentioned before with filter :

holdem_hand_player_statistics.id_hand in (SELECT holdem_hand_player_statistics.id_hand from holdem_hand_player_statistics, holdem_hand_player_detail, player, holdem_limit, settings where player.id_player = holdem_hand_player_statistics.id_player and player.id_player = (SELECT setting_value::int from settings where setting_name = 'my_player_id') and holdem_hand_player_detail.id_player = holdem_hand_player_statistics.id_player and holdem_hand_player_detail.id_hand = holdem_hand_player_statistics.id_hand and holdem_limit.id_limit = holdem_hand_player_statistics.id_limit and holdem_hand_player_statistics.flg_steal_att and holdem_hand_player_detail.amt_p_raise_made = 2.1 * holdem_limit.amt_bb)

with stat "fold BB to SB steal" I receive quite different numbers from what I can see in each individual player using this new stat we have created today :

(cnt_p_face_minsteal_action_fold / cnt_p_face_minsteal) * 100

cnt_p_face_minsteal:

sum(if[holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_detail.val_p_raise_facing_pct BETWEEN 30.5 and 30.6, 1, 0])

cnt_p_face_minsteal_action_fold:

sum(if[holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_detail.val_p_raise_facing_pct BETWEEN 30.5 and 30.6 and lookup_actions_p.action = 'F', 1, 0])

But I expected that they will show same value. Do you see something wrong in my process / colums / thinking ?

[kraada]

You're using the stat "Fold BB to SB Steal" - the stats I built for you are based on all steals, not just those steals that are blind vs blind. If you've got any data from non-heads-up hands, that's probably the reason for the discrepancy.

[joker]

Is it possible to modify original columns in "Fold BB to SB steal" with expresion with stat what you build like :

sum(if[substring(lookup_actions_p.action from 1 for 1)='F' AND
holdem_hand_player_statistics.position = 8 AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 9 AND holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_detail.val_p_raise_facing_pct BETWEEN 30.5 and 30.6,1,0])

sum(if[holdem_hand_player_statistics.position = 8 AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 9 AND holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_detail.val_p_raise_facing_pct BETWEEN 30.5 and 30.6 ,1,0])

?