naming poker actions

[yaqb_pl]

please help me to name all poker actions possible by poker tracker fields
i may have lack on poker knowledge and poker tracker database structure

1. Pre flop
flg_p_open
,flg_p_open_opp
,flg_p_first_raise
,flg_p_limp
,flg_p_fold
,flg_p_ccall
,flg_vpip
,cnt_p_call
,cnt_p_raise

is it all i need to get all possible actions? is any field not important (vpip, open_opp)

in order of most popular

[true] - [category] - [action]

[open_opp, fold] - [FOLD] - [OPEN FOLD ?]
[fold] - [FOLD] - [FOLD]
[none] - [ ?] - [DONATED ?]
[open, open opp, first raise] - [RAISE] - [OPEN RAISE]
[open, open opp, limp] - [CALL] - [OPEN LIMP]
[limp] - [CALL] - [LIMP]
[first raise] - [RAISE] - [RAISE]
[vpip, cnt_p_call =1] - [CALL ?] - [CALL ?]
[cold call] - [CALL] - [COLD CALL]
[open, open opp, limp, cnt_p_call =2] - [CALL] - [LIMP/CALL]
[cnt_p_raise=1] - [RAISE] - [3 BET ?]
[open, open opp, limp, fold] - [CALL] - [LIMP/FOLD]
[open_opp] - [??] - [is it check when someone else posted blind as well ?]
[open, open opp,first raise, cnt_p_raise =1, cnt_p_call =1] - [RAISE] - [OPEN RAISE/CALL]


to be continued

[WhiteRider]

It looks like you have a pretty good grasp of things there.

cnt_p_raise records then number of times the player raised preflop, so cnt_p_raise=1 doesn't necessarily mean it was any particular type of raise - it could have been an open-raise or a 3-, 4- or 5-bet, etc., it just means the player raised exactly once. The same with cnt_p_call.

You have an open_opp even if someone posted a penalty blind, as long as no one has yet VP$IP before your first action.

For a full list of database fields see the Database Schema.

You may also find the actions strings useful to define some exact betting sequences - see "Constructing Column Expressions > String Expressions and Functions" in the Tutorial - Custom Reports and Statistics for more information.

[yaqb_pl]

cnt_p_raise records then number of times the player raised preflop, so cnt_p_raise=1 doesn't necessarily mean it was any particular type of raise - it could have been an open-raise or a 3-, 4- or 5-bet, etc., it just means the player raised exactly once. The same with cnt_p_call.

cnt_p_raise=1 but other flags are false - combined it means that player raised and it wasnt first raise..so it is 3 bet, or it could be X bet after another X bet - but this is what i cant check with this stats.
am i right?

Limp is any 1bb call? not only first?
Maybe limp should be a category because it makes difference when someone pays only 1 bb.

[yaqb_pl]

here is full list of preflop actions

flg_p_open flg_p_open_opp flg_p_first_raise flg_p_limp flg_p_fold flg_p_ccall flg_vpip cnt_p_call cnt_p_raise count
OPEN OPP FOLD 0 0 1735799
FOLD 0 0 1687054
0 0 219043
OPEN OPEN OPP FIRST RAISE VPIP 0 1 193833
OPEN OPEN OPP LIMP VPIP 1 0 159991
LIMP VPIP 1 0 136166
FIRST RAISE VPIP 0 1 77366
VPIP 1 0 59707
COLD CALL VPIP 1 0 45600
OPEN OPEN OPP LIMP VPIP 2 0 43079
OPEN OPEN OPP LIMP FOLD VPIP 1 0 39265
VPIP 0 1 28444
LIMP FOLD VPIP 1 0 16255
OPEN OPP 0 0 13241
OPEN OPEN OPP FIRST RAISE VPIP 1 1 13103
LIMP VPIP 2 0 11321
OPEN OPEN OPP FIRST RAISE FOLD VPIP 0 1 10563
FIRST RAISE VPIP 1 1 4444
VPIP 1 1 4321
OPEN OPEN OPP FIRST RAISE VPIP 0 2 3615
FOLD COLD CALL VPIP 1 0 2324
FIRST RAISE FOLD VPIP 0 1 2320
OPEN OPEN OPP LIMP VPIP 1 1 2169
COLD CALL VPIP 2 0 2045
FIRST RAISE VPIP 0 2 1140
OPEN OPP VPIP 1 0 1003
FOLD VPIP 1 0 731
VPIP 0 2 698
VPIP 2 0 618
FOLD VPIP 0 1 577
OPEN OPEN OPP FIRST RAISE VPIP 1 2 434
OPEN OPEN OPP LIMP VPIP 2 1 392
LIMP VPIP 1 1 350
OPEN OPEN OPP VPIP 1 0 189
OPEN OPEN OPP LIMP VPIP 3 0 178
FIRST RAISE VPIP 1 2 134
COLD CALL VPIP 1 1 128
OPEN OPEN OPP LIMP FOLD VPIP 2 0 108
VPIP 1 2 96
OPEN OPEN OPP FIRST RAISE VPIP 0 3 82
OPEN OPEN OPP FOLD VPIP 1 0 62
OPEN OPEN OPP LIMP VPIP 1 2 62
LIMP VPIP 2 1 50
LIMP VPIP 3 0 46
OPEN OPEN OPP FIRST RAISE VPIP 2 1 34
LIMP FOLD VPIP 2 0 31
OPEN OPP VPIP 0 1 30
OPEN OPEN OPP FIRST RAISE FOLD VPIP 1 1 29
FIRST RAISE VPIP 0 3 24
OPEN OPEN OPP VPIP 2 0 24
COLD CALL VPIP 3 0 20
COLD CALL VPIP 2 1 19
FIRST RAISE VPIP 2 1 15
VPIP 0 3 14
VPIP 2 1 13
OPEN OPEN OPP FIRST RAISE FOLD VPIP 0 2 13
OPEN OPEN OPP LIMP FOLD VPIP 1 1 11
OPEN OPEN OPP LIMP VPIP 2 2 10
OPEN OPEN OPP FIRST RAISE VPIP 1 3 10
FIRST RAISE FOLD VPIP 1 1 10
FOLD COLD CALL VPIP 2 0 9
FIRST RAISE FOLD VPIP 0 2 7
OPEN OPP VPIP 2 0 6
VPIP 3 0 5
OPEN OPP VPIP 1 1 4
OPEN OPEN OPP FIRST RAISE VPIP 0 4 4
VPIP 1 3 4
LIMP VPIP 1 2 3
COLD CALL VPIP 1 2 3
VPIP 0 4 3
OPEN OPEN OPP LIMP VPIP 4 0 3
OPEN OPEN OPP FIRST RAISE VPIP 1 4 2
FIRST RAISE VPIP 1 3 2
OPEN OPP FOLD VPIP 1 0 2
OPEN OPEN OPP VPIP 1 1 2
OPEN OPP VPIP 0 2 2
OPEN OPEN OPP FIRST RAISE VPIP 4 1 2
FOLD VPIP 0 2 2
LIMP VPIP 2 2 2
OPEN OPEN OPP LIMP VPIP 3 1 2
FOLD VPIP 2 0 2
OPEN OPEN OPP LIMP VPIP 1 3 2
FOLD VPIP 1 1 1
COLD CALL VPIP 1 3 1
VPIP 4 0 1
LIMP FOLD VPIP 1 1 1
LIMP VPIP 3 1 1
COLD CALL VPIP 4 0 1
FIRST RAISE VPIP 0 4 1
LIMP VPIP 4 0 1
FOLD VPIP 3 0 1
OPEN OPEN OPP LIMP VPIP 2 3 1

92 rows with 10 columns retrieved.

SELECT flg_p_open, flg_p_open_opp, flg_p_first_raise, flg_p_limp, flg_p_fold,
flg_p_ccall, flg_vpip, cnt_p_call, cnt_p_raise, count
FROM actions;

[kraada]

Yes cnt_p_raise could be 1 with a 3bet or a 4bet. You can find out what kind of raise it is by looking at flg_p_3bet and flg_p_4bet (if both are false it was a single raise, if one is true you know what kind of raise it was). A limp is any 1bb call, whether or not you are first to do it.

[yaqb_pl]

so i need 2 stats more

,flg_p_3bet
,flg_p_4bet

and question:
vpip, cnt_p_call=1. is it when blind called raise? isnt it COLD CALL then ?

[yaqb_pl]

i wish i could edit post any time
questions:
cnt_p_call=1, cnt_p_raise=1, flg_p_4bet true
COLD CALL/4BET
or
4BET/CALL ?

cnt_p_call=1, cnt_p_raise=2, flg_p_3bet true, flg_p_4bet true
looks like 3bet/5bet/call
flg_p_4bet is for 4bet and further reraises?

[kraada]

A cold call is only when you call a raise without having any money in the pot. A blind has money in the pot by definition, so can never cold call.

With regards to your second setup: if cnt_p_call = 1, cnt_p_raise = 1 and flg_p_4bet is true, we do not know whether the person called first or raised first. He may have 4bet and then called a shove, or called, then faced a 3bet and 4bet over the top of that. You'd need to look at the facing 4bet flag at a minimum (as if he didn't face a 4bet then he couldn't have 4bet/called, which reduces the options to just call/4b). Also, you don't know in this case if he called cold for certain as he could have been a blind.

You can only have flg_p_3bet and flg_p_4bet both true if you 3bet and 5bet. But in this case it could also have been a limp/reraise, then a 5bet as you haven't ruled out flg_p_limp. And yes flg_p_4bet is for any bet above a 4bet (5bet, 6bet, etc.), though really they don't come up nearly as much as you would think.

[WhiteRider]

With regards to your second setup: if cnt_p_call = 1, cnt_p_raise = 1 and flg_p_4bet is true, we do not know whether the person called first or raised first. He may have 4bet and then called a shove, or called, then faced a 3bet and 4bet over the top of that. You'd need to look at the facing 4bet flag at a minimum (as if he didn't face a 4bet then he couldn't have 4bet/called, which reduces the options to just call/4b). Also, you don't know in this case if he called cold for certain as he could have been a blind.

You could use the actions strings as I mentioned earlier to determine whether the player raised first or called first.