Can you figure out your overall edge with PokerTracker?

[beach_bum]

Hi Lyric,

Thanks for pointing me to your posts. I tried running Dave's query and it only returned errors. Can you give me the notation you used for whatever online site you were making the query on?

There are only two variables in his code that should be changed. One is my screen name (which is pretty obvious) and the other is the limit I am asking about. His code has a limit of "NL $50" which is not what I want to look at. I'd like to look at higher limits on FTP and PokerStars, but am not sure what to put in the line which defines the limit. I'm sure you didn't use NL $50 either. Do you remember what site you were looking at and what you put in the line that defines the limit?

I have posted his code below to refresh your memory.

Thanks

------------------------- 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 = '<font color="red">NL $50</font>'
AND screen_name='<font color="blue">your_screenname_here</font>'
GROUP BY screen_name;

--------------------------------------------------


[ QUOTE ]
yes, it's possible to guess using PT. i've made a couple of posts about it. search for them.

my edge was about 1.7% at about 2.5ptbb/100.

[/ QUOTE ]