Two Plus Two Newer Archives  

Go Back   Two Plus Two Newer Archives > Internet Gambling > Software
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 04-06-2007, 04:36 PM
Lyric Lyric is offline
Senior Member
 
Join Date: Feb 2006
Location: Iowa
Posts: 783
Default 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--------------------
Reply With Quote
  #2  
Old 04-06-2007, 05:28 PM
ddubois ddubois is offline
Senior Member
 
Join Date: Jan 2004
Location: Ewa Beach, HI
Posts: 3,647
Default 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.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 06:16 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.