jtag64
11-12-2010, 11:58 AM
I am working on a project to construct realistic hand ranges, and I am hoping to write an SQL query based on HEM data that can help with this construction.
The information I'm looking for is all available in some fashion in the HUD, but probably needs to be summed up somehow. What I'm looking for is a query to return the following rows. For each hand where we know a player's holecards, I would like to see.
playername
holecards
position (EP, MP, CO, BTN, SB, BB)
Player's total VPIP from this position
Player's total PFR from this position
How player entered the hand (call, raise, reraise).
the "from this position" is important - I happen to play with stats of 17 VPIP/13 PFR, but of course my raising range on the button is much wider than it is from EP. So if I raise up 82s on the button to steal blinds, I would want to see my BTN VPIP/PFR, not my overall 17/13 number.
My hope is to come up with information like "JTs is hand that's played in EP only by people with a VPIP of 30 or more". Stuff like that.
thank you
The information I'm looking for is all available in some fashion in the HUD, but probably needs to be summed up somehow. What I'm looking for is a query to return the following rows. For each hand where we know a player's holecards, I would like to see.
playername
holecards
position (EP, MP, CO, BTN, SB, BB)
Player's total VPIP from this position
Player's total PFR from this position
How player entered the hand (call, raise, reraise).
the "from this position" is important - I happen to play with stats of 17 VPIP/13 PFR, but of course my raising range on the button is much wider than it is from EP. So if I raise up 82s on the button to steal blinds, I would want to see my BTN VPIP/PFR, not my overall 17/13 number.
My hope is to come up with information like "JTs is hand that's played in EP only by people with a VPIP of 30 or more". Stuff like that.
thank you