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