#1
|
|||
|
|||
SQL -- your edge vs other winning players
I'd like to run another query. Perhaps someone can help make the code....
The point would be to see if you're winning vs other winning players/pros, and how much compared to donkeys. So query looks for "edge" vs players who: Have VPIP between 15-35% Have a PFR that is at least half of their VPIP. Have aggression factor over 2. Everyone else is a donkey, and we want to run a query against them too. There should be a "min amount bet" requirement too, say 10bb. This would find hands where you and at least one another good player put over 10bb in the pot, and no donks put over 10bb in the pot. The second query would find the opposite, where no good player puts over 10bb in, but at least one donk does. Here is working code for "edge" calc created by Dave: --------------code------------------ SELECT screen_name, COUNT(game_players.game_id) AS HANDS, SUM(total_bet) AS BET, SUM(total_won) AS WON, ((SUM(total_won)/SUM(total_bet))-1)*100 as EDGE, SUM(total_won)-SUM(total_bet) as PROFIT FROM players, game_players, game, game_level WHERE players.player_id = game_players.player_id AND game_players.game_id = game.game_id AND game.game_level_id = game_level.game_level_id AND game_level.game_level_desc = 'NL ($10) (6 max)' AND screen_name='SCREEN NAME' GROUP BY screen_name; -------------end code-------------------- |
#2
|
|||
|
|||
Re: SQL -- your edge vs other winning players
Edit: Nevermind; fixed my problem. Make sure you use your primary screen name as pokertracker understands it, and not one of your aliases.
|
|
|