Some stats needed

[ZeDawning]

Hello,

I'm trying to get some specific stats which I found not existing among the selection. So I guess I should create a custom one. Definitely have almost zero knowledge on them. Tried to find them on forums but couldn't.

1. 4Bet vs Hero
I found the 3bet vs Hero (https://www.pokertracker.com/forums/vie ... 61&t=49682)and after a lot of clicking buttons and copy paste, I think I got the stat correct I think I cannot change '3bet' to 4bet since hero.flg_p_first_raise wouldn't be correct for 4bets vs Hero.

2. I'm looking for the following 3bet stats:
a) 3Bet IP vs UTG
b) 3Bet IP vs MP
c) 3Bet IP vs CO (I think this is just the stat "3bet vs CO 2bet and change position to Btn?)
d) 3Bet OOP vs UTG
e) 3Bet OOP vs MP
f) 3Bet OOP vs CO
g) 3Bet OOP vs BU

I know that there are more better stats (3bet matrix too), but I'm simply looking for these in particular. I really don't want to go to HM2 as I have a sub par PC and its gonna slow it wayyy down.
Help would be very much appreciated. Ofc if you could dumb it down, that would be even more appreciated.

[kraada]

(1) If you paste what you have, I'll gladly check it for you.

(2) We have an assortment of position vs position 3bet stats -- take a look in Configure -> Statistics and search for vs. That should show you all of them and you can see how the columns are built on the Columns page.

[ZeDawning]

Alright. I'll take a shot at coding I guess. I'll start with the 3betting vs EP IP.

So below is 3Bet vs EP 2B

cnt_p_3bet_vs_ep_2bet
sum(if[char_length(cash_hand_summary.str_aggressors_p) >= 2 and cash_hand_player_statistics.flg_p_3bet AND ((cash_hand_summary.cnt_players BETWEEN 4 and 6 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int BETWEEN 3 and 5) OR (cash_hand_summary.cnt_players BETWEEN 7 and 8 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int BETWEEN 4 and 7) OR (cash_hand_summary.cnt_players BETWEEN 9 and 10 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int BETWEEN 5 and 7)), 1, 0])

I'm not really sure what to make of this tbh. What numbers are actually EP? (I play 6max btw).
Is Btn assigned as 0, CO 1..... till SB 8?

[kraada]

This part means that the first raise came from EP:
(cash_hand_summary.cnt_players BETWEEN 4 and 6 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int BETWEEN 3 and 5) OR (cash_hand_summary.cnt_players BETWEEN 7 and 8 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int BETWEEN 4 and 7) OR (cash_hand_summary.cnt_players BETWEEN 9 and 10 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int BETWEEN 5 and 7))

Your position is cash_hand_player_statistics.position.

[ZeDawning]

a) 3Bet IP vs EP

(cnt_p_3bet_vs_ep_2bet_ip / cnt_p_3bet_opp_vs_ep_2bet_ip) * 100

cnt_p_3bet_vs_ep_2bet_ip

sum(if[char_length(cash_hand_summary.str_aggressors_p) >= 2 and cash_hand_player_statistics.flg_p_3bet AND ((cash_hand_summary.cnt_players BETWEEN 4 and 6 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int BETWEEN 3 and 5) OR (cash_hand_summary.cnt_players BETWEEN 7 and 8 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int BETWEEN 4 and 7) OR (cash_hand_summary.cnt_players BETWEEN 9 and 10 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int AND substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int > cash_hand_player_statistics.position, 1, 0])

cnt_p_3bet_opp_vs_ep_2bet_ip

sum(if[char_length(cash_hand_summary.str_aggressors_p) >= 2 and cash_hand_player_statistics.flg_p_3bet_opp AND ((cash_hand_summary.cnt_players BETWEEN 4 and 6 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int BETWEEN 3 and 5) OR (cash_hand_summary.cnt_players BETWEEN 7 and 8 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int BETWEEN 4 and 7) OR (cash_hand_summary.cnt_players BETWEEN 9 and 10 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int AND substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int > cash_hand_player_statistics.position, 1, 0])

b) 3Bet IP vs MP

(cnt_p_3bet_vs_mp_2bet_ip / cnt_p_3bet_opp_vs_mp_2bet_ip) * 100

cnt_p_3bet_vs_mp_2bet_ip
sum(if[char_length(cash_hand_summary.str_aggressors_p) >= 2 and cash_hand_player_statistics.flg_p_3bet AND ((cash_hand_summary.cnt_players BETWEEN 3 and 6 and substring(cash_hand_summary.str_aggressors_p from 2 for 1) = '2') OR (cash_hand_summary.cnt_players BETWEEN 7 and 8 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int BETWEEN 2 and 3) OR (cash_hand_summary.cnt_players BETWEEN 9 and 10 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int AND substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int > cash_hand_player_statistics.position, 1, 0])

cnt_p_3bet_opp_vs_mp_2bet_ip
sum(if[char_length(cash_hand_summary.str_aggressors_p) >= 2 and cash_hand_player_statistics.flg_p_3bet_opp AND ((cash_hand_summary.cnt_players BETWEEN 3 and 6 and substring(cash_hand_summary.str_aggressors_p from 2 for 1) = '2') OR (cash_hand_summary.cnt_players BETWEEN 7 and 8 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int BETWEEN 2 and 3) OR (cash_hand_summary.cnt_players BETWEEN 9 and 10 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int AND substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int > cash_hand_player_statistics.position, 1, 0])

c) 3Bet IP vs CO
3bet vs CO 2bet and change position to Btn
*Should it be CO open or CO 2bet here?

Is this correct?
Should format type be 'percent'? and summary type be 'same as format'?

[ZeDawning]

d) 3Bet OOP vs UTG
Same as UTG IP but change int > cash_hand_player_statistics.position, 1, 0]) to int < cash_hand_player_statistics.position, 1, 0])

e) 3Bet OOP vs MP
Follow d)

f) 3Bet OOP vs CO
I'm stuck here.

sum(if[cash_hand_player_statistics.flg_p_3bet and cash_hand_summary.str_aggressors_p LIKE '81%', 1, 0])

How do I change this to OOP?

[kraada]

(a) & (b) look good. You're correct about (c), (d) and (e).

substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int < cash_hand_player_statistics.position

is going to be OOP regardless of the position of the 2bettor so you can add that it and it will work for (f) as well.

[ZeDawning]

Sorry man. Didn't understand. The codes were copy paste with some adjustments from a thread I stumbled on (just in case you thought I understood all these codes )

Erm so did you mean

cnt_p_3bet_vs_co_2bet_ip

sum(if[char_length(cash_hand_summary.str_aggressors_p) >= 2 and cash_hand_player_statistics.flg_p_3bet AND ((cash_hand_summary.cnt_players BETWEEN 3 and 6 and substring(cash_hand_summary.str_aggressors_p from 2 for 1) = '1') OR (cash_hand_summary.cnt_players BETWEEN 7 and 8 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int BETWEEN 2 and 3) OR (cash_hand_summary.cnt_players BETWEEN 9 and 10 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int AND substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int > cash_hand_player_statistics.position, 1, 0])

So CO should be changed to 1 and for Btn it should be changed to 0 yes?
I just am lost on which codes to erase (since UTG/MP has multiple numbers)

[ZeDawning]

Also I just pasted the code (from a) in Expression and it says 'The statement is not valid SQL". Is there something I missed?

[kraada]

You can replace the entire thing there isn't a different CO depending on the number of players at the table. Like so:
sum(if[char_length(cash_hand_summary.str_aggressors_p) >= 2 and cash_hand_player_statistics.flg_p_3bet AND substring(cash_hand_summary.str_aggressors_p from 2 for 1) = '1' AND substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int > cash_hand_player_statistics.position, 1, 0])

In (a) you had mismatched parentheses. This works:

sum(if[char_length(cash_hand_summary.str_aggressors_p) >= 2 and cash_hand_player_statistics.flg_p_3bet AND ((cash_hand_summary.cnt_players BETWEEN 4 and 6 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int BETWEEN 3 and 5) OR (cash_hand_summary.cnt_players BETWEEN 7 and 8 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int BETWEEN 4 and 7) OR (cash_hand_summary.cnt_players BETWEEN 9 and 10 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int AND substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int > cash_hand_player_statistics.position)), 1, 0])