How steal stats are calculated from database?
Results 1 to 4 of 4
  1. #1
    Junior Member
    Join Date
    Mar 2017
    Posts
    7

    Default How steal stats are calculated from database?

    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

  2. #2
    *** HM3! *** fozzy71's Avatar
    Join Date
    Sep 1971
    Location
    HM Support
    Posts
    32,041

    Default

    Quote Originally Posted by tangyves View Post
    ...

    but for PFfoldToSteal
    sum("FacingStealFolded") / sum("FacingSteal")

    Quote Originally Posted by tangyves View Post
    or CallStealFromSB, ...
    sum("FacingStealCalled", "FirstRaiserPositionType == (short)PositionType.SmallBlind") / sum("FacingSteal", "FirstRaiserPositionType == (short)PositionType.SmallBlind")

  3. #3
    Junior Member
    Join Date
    Mar 2017
    Posts
    7

    Default

    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

  4. #4
    Junior Member
    Join Date
    Mar 2017
    Posts
    7

    Default

    Thanks for your reply.

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

Similar Threads

  1. steal stats..fold to steal=tot Steal success%...
    By Bopo in forum General Support
    Replies: 4
    Last Post: 03-18-2012, 10:55 AM
  2. How is steal calculated in HEM
    By Sokol in forum Manager General
    Replies: 2
    Last Post: 10-10-2010, 04:07 PM
  3. How is steal success % calculated
    By Ron200 in forum Manager General
    Replies: 1
    Last Post: 07-31-2009, 09:13 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •