|
arkana
|
11-23-2005, 09:20 AM
Post subject: W$SD% vs Pot Size
|
#1 (permalink)
|
|
Full House
Join Date: Mar 2005
Posts: 1,109
|
|
Instead of hijacking Fnord's thread further I decided to make a new thread for this. I am really interested to see how people's won $ at showdown % changes for bigger pots (ie your W$SD% for pots bigger than a minimum size). I have created a script to output the W$SD% for 20,30,40,50,60,70,80 BB minimum pots from your PokerTracker database. All you need to run this is to copy the code below into notepad, edit the screen_name, big_blind (if you make it 1 then it uses all hands where the big blind is $1) and ptdb (your PT db name) values and save as a .js file in your PT directory. You can run it by just double clicking on the file. PT screws up the big_blind for certain types of HHs (I think Prima is one where it doesnt work) so if you want to see which levels will be used open your PT database and look in the game_level table where you can see the big_blinds for the levels.
Please run this and post your output with your winrate as I think these values are quite interesting.
Edit: If you have limit hands in your db they will be included so make sure you only have NL hands in there.
Code:
///// change settings here /////
var screen_name = 'AArkana';
var big_blind = 1;
var min_pot = 20;
var ptdb = 'ptrack';
////////////////////////////////
///// Globals /////////
var db = new ActiveXObject("ADODB.Recordset");
var cstring = "Driver={Microsoft Access Driver (*.mdb)};DBQ="+ptdb+".mdb";
var totalhands = 0;
var sql = '';
var echoout = '';
//////////////////////
echoout += "Screen Name:\t\t" + screen_name + "\n\n"
while (min_pot <= 80)
{
sql = "SELECT"
+" SUM(went_to_showdown_n),"
+" SUM (won_hand), "
+" round(avg((won_hand / went_to_showdown_n) * 100), 2)"
+" FROM game INNER JOIN game_players ON game.game_id = game_players.game_id"
+" WHERE"
+" went_to_showdown_n=1"
+" AND game_players.player_id IN (select player_id from players where screen_name='"+screen_name+"')"
+" AND pot>"+(min_pot*big_blind)
+" AND (SELECT game_level_big_bet FROM game_level WHERE game_level.game_level_id = game.game_level_id) = "+big_blind
+" GROUP by game_players.player_id";
db.Open(sql, cstring, 1, 3);
echoout += "\nMinimum Pot: "+min_pot+"BBs\nWent to showdown:\t" + db(0)
+ "\nTimes Won:\t\t" + db(1)
+ "\nPercentage:\t\t" + db(2) +"\n\n";
db.Close();
min_pot+=10;
}
WScript.Echo(echoout);
Here is my output (about 10k hands at 100NL with a winrate of about 4.5PTBB):
|
|
|
Play for FREE and practice your game at...
Join the FTR Poker Forum to disable these banners and start posting!
|
|
evovolvo
|
|
Join Date: Mar 2005
Posts: 78
|
|
Very nice script indeed 
I only got 2500 hands in the DB atm, but this is how mine came out.
(Winrate 7.8BB/100, std derivation 27.7, NL $50)
|
|
|
|
finky
|
|
Flush
Join Date: Oct 2005
Location: London
Posts: 270
|
|
Nice work !
I have a problem tho, I can view other players stats but when it comes to my own it says "At most one record can be returned by this subquery" I think its because I have accounts at a few sites with the same screen name.
Bit thick when it comes to all this coding malarky, any sugestions?
|
|
|
|
arkana
|
|
Full House
Join Date: Mar 2005
Posts: 1,109
|
|
Evolvo did you change the big_blind value to 0.5 (for NL50)?
Finky change this line:
Code:
+" AND game_players.player_id=(select player_id from players where screen_name='"+screen_name+"')"
to
Code:
+" AND game_players.player_id IN (select player_id from players where screen_name='"+screen_name+"')"
(The equal sign should be replaced with IN)
Let me know if it works
EDIT: im going to update the query
|
|
|
|
evovolvo
|
|
Join Date: Mar 2005
Posts: 78
|
|
Quote:
|
Originally Posted by arkana
Evolvo did you change the big_blind value to 0.5 (for NL50)?
|
I didn't at first, but then no hands came up at all since I only play $50 tables.
I changed to 0.5 and it worked great.
|
|
|
|
arkana
|
|
Full House
Join Date: Mar 2005
Posts: 1,109
|
|
Your W$SD is very high for the smaller pots which is quite strange, you are probably running very hot. What is your overall W$SD% (in PT)?
|
|
|
|
finky
|
|
Flush
Join Date: Oct 2005
Location: London
Posts: 270
|
|
worked like a charm, i'll post my results soon
|
|
|
|
evovolvo
|
|
Join Date: Mar 2005
Posts: 78
|
|
Quote:
|
Originally Posted by arkana
Your W$SD is very high for the smaller pots which is quite strange, you are probably running very hot. What is your overall W$SD% (in PT)?
|
56%
Forgot to mention that I play shorthanded games only (6 ppl), not full ring.
|
|
|
|
finky
|
|
Flush
Join Date: Oct 2005
Location: London
Posts: 270
|
|
Cant seem to post directly, anyhoo
http://snipurl.com/k618
total W$SD 52%
Seems a bit flat, like to see what everyone else has.
This is over 5.5K hands at 100NL, PTBB17/100 (running crazy hot), SD 46/100, shorthanded and full ring.
|
|
|
|
johnny_fish
|
|
4-of-a-Kind
Join Date: Sep 2005
Location: donkaments weeeeeeeeeeee
Posts: 2,186
|
|
I have 21K hands 20NL @7.5PTBB/100 with a W$SD% of 50. W$SD% is constant between 55 and 56 over all BB ranges.
15K hands 50NL @-0.2PTBB/100, W$SD% 50. Here it's pretty constant too, about 53% at the smaller pots, 48-49 medium, 50-52 large pots.
Don't know what to think about these stats..
|
|
|
|
EricE
|
|
Full House
Join Date: Jun 2005
Posts: 894
|
|
Interesting. Everyone seems to be just on the good side of 50%. The profit edge is very thin.
|
|
Stakes: Playing $0.10/$0.25 NL
|
|
arkana
|
|
Full House
Join Date: Mar 2005
Posts: 1,109
|
|
I was expecting the W$SD% to increase as the minimum pot increased for winners but so far only my stats show that pattern, guess it has a lot to do with your style (how much you press thin edges) and how hot you are running if its a small sample.
Need more, come one people dont be shy.
|
|
|
|
rubixstreub
|
|
Full House
Join Date: Jul 2005
Location: Dallas, TX
Posts: 887
|
|
How many hands, 10K+? Can I just turn off seeing limit hands? Is there anyway to remove them from my Database?
|
|
|
|
arkana
|
|
Full House
Join Date: Mar 2005
Posts: 1,109
|
|
Quote:
|
Originally Posted by RubixNL
How many hands, 10K+? Can I just turn off seeing limit hands? Is there anyway to remove them from my Database?
|
You can try adding this line:
Code:
+" AND (SELECT game_level_desc FROM game_level WHERE game_level.game_level_id = game.game_level_id) LIKE '%NL%'"
just before the GROUP by line
|
|
|
|
CBone
|
|
Join Date: Jan 2006
Posts: 32
|
|
Think I got it to work.
6K hands at NL20, WSD 20%, W$SD 62%. Yes, I am camping.
|
|
|
|
Miffed22001
|
|
Straight Flush
Join Date: Jun 2005
Location: Marry Me Cheryl!!!
Posts: 8,181
|
|
any chance you can explain this in laymans terms as its been bumper arkana?
|
|
|
|
drmcboy
|
|
DrButtInski
Administrator
Join Date: Aug 2004
Posts: 9,602
|
|
I thought it was W$SD vs Po$$e$ed, booo!
|
|
|
|
arkana
|
|
Full House
Join Date: Mar 2005
Posts: 1,109
|
|
Quote:
|
Originally Posted by Miffed22001
any chance you can explain this in laymans terms as its been bumper arkana?
|
The W$SD% statistic in PT is simply the number of pots you won at showdown divided by the number of pots where you went to showdown. In NL most of the money is won and lost in the really big pots, which tend to be much fewer than the other smaller pots and since the normal W$SD% doesnt take this into account W$SD% as a function of minimum pot size is therefore an interesting statistic to look at. This script basically gives you your W$SD% for pots filtered by a certain minimum pot size. Unfortunately I think you need a really big sample size because over 10k hands I only went to showdown 67 times in pots over 50bbs.
|
|
|
English
Deutsch
Español
Français
Italiano
Nederlands
Pусский
Svenska
05-26-2012, 03:08 PM Australia Legalized Online Poker coming up in next 6 to 12 Months
Linear Mode
