How steal stats are calculated from database?

[tangyves]

Hi, i am exploring your sqlite3 database.

I am wondering how steal stats are calculated?

For example three bet, i understand. because i could see two columns 'couldthreebet' and 'didthreebet' for compiledplayerresults.

but for PFfoldToSteal or CallStealFromSB, i don't understand how those are calculated?

Thanks a lot

[fozzy71]

...

but for PFfoldToSteal

sum("FacingStealFolded") / sum("FacingSteal")

or CallStealFromSB, ...

sum("FacingStealCalled", "FirstRaiserPositionType == (short)PositionType.SmallBlind") / sum("FacingSteal", "FirstRaiserPositionType == (short)PositionType.SmallBlind")

[tangyves]

Thank you for your response.
But i did not see those columns in compiledplayerresults table.

My version is 3.1.15
here are columns I found in compiledplayerresults by alphabetical
bbgroup_id
bigblindstealattempted
bigblindstealdefended
bigblindstealreraised
calledflopcontinuationbet
calledfourbetpreflop
calledrivercontinuationbet
calledthreebetpreflop
calledturncontinuationbet
calledtwopreflopraisers
compiledplayerresults_id
couldcoldcall
couldpfr
couldsqueeze
couldthreebet
couldvpip
didcoldcall
didsqueeze
didthreebet
facedfourbetpreflop
facedthreebetpreflop
facingflopcontinuationbet
facingrivercontinuationbet
facingturncontinuationbet
facingtwopreflopraisers
flopcontinuationbetmade
flopcontinuationbetpossible
foldedtoflopcontinuationbet
foldedtofourbetpreflop
foldedtorivercontinuationbet
foldedtothreebetpreflop
foldedtoturncontinuationbet
gametype_id
numberofplayers
pfrhands
playedyearandmonth
player_id
raisedflopcontinuationbet
raisedfourbetpreflop
raisedrivercontinuationbet
raisedthreebetpreflop
raisedturncontinuationbet
raisedtwopreflopraisers
rivercallippassonturncb
rivercontinuationbetmade
rivercontinuationbetpossible
riverfoldippassonturncb
riverraiseippassonturncb
sawflop
sawlargeshowdown
sawlargeshowdownlimpedflop
sawnonsmallshowdown
sawnonsmallshowdownlimpedflop
sawshowdown
smallblindstealattempted
smallblindstealdefended
smallblindstealreraised
totalaggressivepostflopstreetsseen
totalamountwonincents
totalbbswon
totalbets
totalcalls
totalcashoutamountwonincents
totalcashoutbbswon
totalhands
totalpostflopstreetsseen
totalrakeincents
turncallippassonflopcb
turncontinuationbetmade
turncontinuationbetpossible
turnfoldippassonflopcb
turnraiseippassonflopcb
vpiphands
wonhand
wonhandwhensawflop
wonhandwhensawriver
wonhandwhensawturn
wonlargeshowdown
wonlargeshowdownlimpedflop
wonnonsmallshowdown
wonnonsmallshowdownlimpedflop
wonshowdown

[tangyves]

Thanks for your reply.

I can not find FacingStealCalled and other columns you mentioned in compiledplayerresults table.