W$SD% vs Pot Size

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):

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)

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?

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

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.

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)?

worked like a charm, i'll post my results soon

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.

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.

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..

Interesting. Everyone seems to be just on the good side of 50%. The profit edge is very thin.

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.

How many hands, 10K+? Can I just turn off seeing limit hands? Is there anyway to remove them from my Database?

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

Think I got it to work.



6K hands at NL20, WSD 20%, W$SD 62%. Yes, I am camping.

any chance you can explain this in laymans terms as its been bumper arkana?

I thought it was W$SD vs Po$$e$ed, booo!

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.