Re: Your Edge
I think this does it - not quite sure though, not tested thorougly. Execute this SQL against your PT database:
------------------------ code ---------------------------
SELECT
screen_name, COUNT(game_id) AS HANDS,
SUM(total_bet) AS BET, SUM(total_won) AS WON,
ROUND(((SUM(total_won)/SUM(total_bet))-1)*100,<font color="red">3</font>) as EDGE
FROM players, game_players
WHERE players.player_id = game_players.player_id
AND screen_name='<font color="blue">your_screenname_here</font>'
GROUP BY screen_name;
--------------------------------------------------------
Alter '<font color="blue">your_screenname_here</font>' to suit.
This should give you the "edge" of the specified screenname, rounded to 3 decimal places (change the <font color="red">3</font> for more/less precision), across all levels in the PT database you run this on, for the screen name (and aliases to it) you specify.
My first HSNL post [img]/images/graemlins/smile.gif[/img] Hopefully useful to someone... or maybe I misunderstood what you are asking for?
FWIW in the quick test I ran on an old Access DB, I had a 2.77% edge over $25nl last January, which sounds within reason I think.
dave.
Edited to add: "and aliases"
|