PDA

View Full Version : The Cygnus Project: Playerhandscashmisc Table



Cygnus
11-20-2008, 06:39 PM
Playerhandscashmisc

playerhand_id int4
stacksize int4
effectivestacksize int4
seatnumber int2
offthebutton int2
finalhandtype_id int2
ishero bool
sawflopastype_id int2
betamountpreflop int4
callamountpreflop int4
postamountpreflop int4
totalbetspreflop int2
totalcallspreflop int2
threebetresponsetype_id int2
fourbetresponsetype_id int2
limpreraisedpreflop bool
bbstealattempted bool
bbstealdefended bool
bbstealreraised bool
sbstealattempted bool
sbstealdefended bool
sbstealreraised bool
preflopraisepercentofpot float4
facingraisepercentofpot float4


Starting to understand this table better now. Reserving this thread for questions about the columns.

Cygnus

kz282
09-16-2010, 05:24 PM
Hello Guys,

I would like to know what does the sawflopastype_id field contain.

Kind regards,
kz282

Rattanat
10-21-2010, 10:28 PM
Hello Guys,

I would like to know what does the sawflopastype_id field contain.

Kind regards,
kz282

+1 anyone??

morny
10-23-2010, 02:11 AM
Im not 100% sure but i would say theres a reasonable chance it shows As PFR or VS PFR or something like that, checking out a few hands might confirm this.

TheZepper
10-25-2010, 04:30 PM
The sawflopastype_ID field identifies 11 different categories of PF hands that see (or don't) see the flop. Their are several inconsistencies/irregularities in how certain PF hands are treated (the discrepencies are related to hands in which hero acts 2 or more times PF), but in general the fields are:

-1 - No see flop or All-in PF
0 - Limped Pots
1 - Single Raised Pots v PFR
2 - Single Raised Pots as PFR
3 - Call 3Bet
4 - as 3 BTR
5 - Call 4Bet
6 - as 4BTR
7 - Call 2+Raisers
8 - Raise 2+Raisers and
9 - Limp/Re-Raise

Rattanat
10-26-2010, 09:52 AM
thx

rapmaster
05-24-2011, 09:28 PM
If I want to determine an all in push, is it right to compare the betamountpreflop with the stacksize? Or should i take filter by where stacksize = 0? Where is the exact difference between effectivestacksize and stacksize?