[_dave_]

Hi DavidC,

I thought this was quite an interesting subject, mainly I have been thinking about doing something like this sort of analysis with interest in locating the best limit for clearing bonuses that have raked hand requirements. Never got round to it though, until now.

You will need to know the database name you wish to query, use Poker Tracker "File -> Maintain Database Names" to find this name. In my code below, ptrack8 is my database name.

Copy & Paste the following code into windows notepad, and save in the same folder as your poker tracker database. Usually this is "C:\Program Files\Poker Tracker V2". Save file as "rakedhands.js" - name not important, .js extension required. This is Windows JScript code.

You can alter the min/max players, the limit, and the minimum rake required to count as a raked hand also.

Enjoy,

Dave.

<font class="small">Code:</font><hr /><pre>
///// change settings here /////

var minrake = 0.01;
var minplayers = 4;
var maxplayers = 5;
var level = '$2/$4';
var ptdb = 'ptrack8';

////////////////////////////////

var db = new ActiveXObject("ADODB.Recordset");
var cstring = "Driver={Microsoft Access Driver (*.mdb)};DBQ="+ptdb+".mdb";

var sql = "SELECT Count(game.game_id) AS Hands FROM game"
+ " WHERE game.number_of_players &gt;= " + minplayers
+ " AND game.number_of_players &lt;= " + maxplayers
+ " AND game.game_level_id=(SELECT game_level_id FROM game_level"
+ " WHERE game_level_desc='"+level+"');"

db.Open(sql, cstring, 1, 3);
var totalhands = db(0)+0;
db.Close();

var sql = "SELECT Count(game.game_id) AS Hands FROM game"
+ " WHERE game.number_of_players &gt;= " + minplayers
+ " AND game.number_of_players &lt;= " + maxplayers
+ " AND game.rake &gt; " + minrake
+ " AND game.game_level_id=(SELECT game_level_id FROM game_level"
+ " WHERE game_level_desc='"+level+"');"

db.Open(sql, cstring, 1, 3);
var rakedhands = db(0)+0;
db.Close();

var pcnt = Math.round(rakedhands / totalhands * 10000)/100;

WScript.Echo("Number of Hands:\t\t" + totalhands
+ "\nraked hands:\t\t" + rakedhands
+ "\nraked percent:\t\t"+ pcnt + "%");



</pre><hr />