PT rakeback Q

[Voltron87]

If I look at the "total rake" stat under the general tab of PT, is that roughly how much rake ive generated? Can I just multiply this by the decimal of rakeback I get to find approximately how much I'll get paid? Or is that stat nowhere close to what im looking for?

[grinin]

Game Notes tab > Show only hand played by (your screen name) > Get all button

Take rake shown divide by avg. players per hand (APH) x rakeback percent

[_dave_]

Copy &amp; paste the following WSH/JavaScript code into notepad, change the <font color="blue">blue</font> parts to match your PTDB / player name / RB%, then save the file as rb.js in the same directory as your PTDB files, usually "C:\Program Files\Poker Tracker V2\". Double click the file to run it.

<font class="small">Code:</font><hr /><pre>
var db = new ActiveXObject("ADODB.Recordset");
var cstring = "Driver={Microsoft Access Driver (*.mdb)};DBQ=<font color="blue">ptrack5.mdb</font>";
var sql = "SELECT Count(game_players.game_id) AS Hands,"
+ " Sum(game.rake/ game.number_of_players) AS MGR, MGR*<font color="blue">0.25</font> AS Rakeback"
+ " FROM players INNER JOIN (game INNER JOIN game_players ON game.game_id ="
+ " game_players.game_id) ON players.player_id = game_players.player_id"
+ " WHERE (((game_players.hole_card_1) Is Not Null)"
+ " AND ((players.screen_name)='<font color="blue">voltron87</font>'));";
db.Open(sql, cstring, 1, 3);
WScript.Echo("Hands:\t\t" + db(0) + "\nMGR:\t\t" + db(1) + "\nRakeback:\t" + db(2));
db.Close();
</pre><hr />

This produces accurate total MGR/RB figures for the selected PT database. If you have more than the current months hands in the selected DB, the figures produced will include these older hands.

[Voltron87]

very cool, thank you.