Some interesting non-PokerTracker stats
 

My .5/1 Flop Actions: BB/hand, Count
(1=true, 0=false), VPIP 14 and Total AF (not including PF) 2.3.

I used the PT DB to get them while working on an unrelated project and thought they were VERY interesting stats.

Check out the dismal value of the "no bet/raise call" (this includes call, call/call, check/call and coldcalling a raise) .

fbet=1 AND fraise=1: 3.5 (BB/hand), 218 (hands)
fbet=0 AND fraise=1: 2.9, 670
fbet=1 AND fraise=0: 1.6, 3356
fraise=1 AND fcall=1: 1.1, 230
fbet=1 AND fcall=1: 0.7, 463
fbet=0 AND fraise=0 AND fcall=1: .096, 1215
fbet=0 AND fraise=0 AND ffold=1: -0.7, 5079
fcall=1 AND ffold=1: -1.6, 14
(fbet=1 OR fraise=1) AND ffold=1: -2.1, 99

Un-accounted-for (rare and +EV to call stats) bad data (I think): calling capped flops counts as calling.

Comments welcome, I will do a turn and river breakdown soon.

Re: Some interesting non-PokerTracker stats
 

B-R-C-K-F
02-1-0-0-0-0
03-1-1-0-0-0
04-1-0-1-0-0
05-1-0-0-0-1
06-1-1-1-0-0
07-1-1-0-0-1
09-1-0-1-0-1
10-1-1-1-0-1
11-0-1-0-0-0
12-0-1-1-0-0
13-0-1-0-1-0
14-0-1-0-0-1
15-0-1-1-1-0
16-0-1-1-0-1
17-0-1-0-1-1
18-0-1-1-1-1
19-0-0-1-0-0
20-0-0-1-1-0
21-0-0-1-0-1
22-0-0-1-1-1
23-0-0-0-1-1
24-0-0-0-0-1


Here's the full breakdown.

r-11/$8.32/101 means 101 times I raised the river as my only action and net 8.32 BB per hand.
t-4/$0.44/248 means 248 times I bet and called the turn and net .44 BB per hand.

f-2/$1.95/2882
f-3/$4.33/133
f-4/$0.47/377
f-5/($1.90)/92
f-6/$2.34/85
f-7/0
f-9/($4.00)/1
f-10/0
f-11/$3.45/480
f-12/$0.77/136
f-13/$7.79/36
f-14/($6.08)/6
f-15/($3.39)/9
f-16/0
f-17/0
f-18/0
f-19/$0.29/733
f-20/($0.16)/469
f-21/($1.50)/12
f-22/($1.50)/1
f-23/($0.67)/2993
f-24/($0.74)/2073



t-2/$3.03/2455
t-3/$7.94/53
t-4/$0.44/248
t-5/($2.52)/106
t-6/$7.71/39
t-7/0
t-9/0
t-10/0
t-11/$6.13/149
t-12/$2.06/36
t-13/$5.86/32
t-14/($2.83)/3
t-15/($2.08)/3
t-16/0
t-17/0
t-18/0
t-19/$0.73/706
t-20/($0.01)/459
t-21/($3.36)/18
t-22/($3.50)/2
t-23/($0.94)/1030
t-24/($1.06)/945



r-2/$5.15/1537
r-3/$10.10/39
r-4/($0.45)/153
r-5/($3.46)/29
r-6/$6.12/65
r-7/0
r-9/0
r-10/0
r-11/$8.32/101
r-12/$0.90/28
r-13/$5.84/9
r-14/($9.25)/2
r-15/($7.50)/1
r-16/0
r-17/0
r-18/0
r-19/$0.00/564
r-20/($0.85)/392
r-21/($4.69)/13
r-22/0
r-23/($1.66)/512
r-24/($1.76)/486

Re: Some interesting non-PokerTracker stats
 

Do you have the SQL queries used for these or are they quite easy? It would be good to be able to compare your stats with ours to find some trends.

Re: Some interesting non-PokerTracker stats
 

SELECT * FROM game_players WHERE player_id=#playerid#
AND #curturn#bet=0
AND #curturn#raise=0
AND #curturn#call=0
AND #curturn#check=0
AND #curturn#fold=0

Change 0 to 1 depending on what data you want and add up the total_won and total_bet fields.