Continuation Bets - Pokertracker Analysis

[_dave_]

Hi, I am an occasional poster / daily lurker here on this forum, hello to all. Thanks to everyone for posting, therefore helping me learn this difficult game.

Anyhow, a few days ago there was a post regarding the value of continuation bets - this got me thinking, and I meant to do this in response to that thread, but I didn't get round to making it until now.

This script will give you your Poker Tracker stats for continuation bets on the flop & turn, against up to 5 callers. I believe it to be calculating correctly, but I am not too sure - If anyone sees a problem, please correct me.

Here goes:

Copy & paste the following code to notepad, change 'settings' Section to match your screen name / chosen Poker Tracker database. Save the file in your Program Files\Poker Tracker V2 folder, or wherever you have installed PT. Save as "continuation_bets.js". Double Click the *.js file to run it.

I believe this only works on Access databases - those who are using PT+Postgres will need to make some some changes to the cstring variable.


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

///// change settings here /////
var screen_name = '_dave_';
var ptdb = 'ptrack10';

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

///// Globals /////////
var db = new ActiveXObject("ADODB.Recordset");
var cstring = "Driver={Microsoft Access Driver (*.mdb)};DBQ="+ptdb+".mdb";
var totalhands = 0;
var sql = '';
var echoout = '';
var cold_callers = 1;

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

echoout += "Screen Name:\t\t" + screen_name + "\n\n"


while ( cold_callers &lt;=5)
{
cold_callers++;
sql = "SELECT Max(players.screen_name) AS Screen_name,"
+ " SUM(game_players.pre_flop_raise_n) AS Hands_when_PFR,"
+ " SUM(game_players.fbet) AS C_BET, (SELECT Count(game.turn) AS Went_to_turn"
+ " FROM players, game, game_players"
+ " WHERE players.screen_name='"+screen_name+"'"
+ " AND game_players.pre_flop_raise_n=1"
+ " AND game_players.fbet = 1"
+ " AND game.players_saw_flop = "+cold_callers
+ " AND game.game_id = game_players.game_id"
+ " AND players.player_id = game_players.player_id) AS Went_to_turn,"
+ " round(((C_BET-Went_to_turn)/C_BET)*10000)/100 AS C_BET_WORKED,"
+ " SUM(game_players.tbet) AS Second_barrel,"
+ " (SELECT Count(game.river) AS Went_to_river"
+ " FROM players, game, game_players WHERE players.screen_name='"+screen_name+"'"
+ " AND game_players.pre_flop_raise_n=1 AND game_players.fbet = 1"
+ " AND game_players.tbet = 1 AND game.players_saw_flop = "+cold_callers
+ " AND game.game_id = game_players.game_id"
+ " AND players.player_id = game_players.player_id) AS Went_to_river,"
+ " round(((Second_barrel-Went_to_river)/Second_barrel)*10000)/100 AS T_BET_WORKED,"
+ " AVG(game.players_saw_flop)"
+ " 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 (((players.screen_name)='"+screen_name+"')"
+ " AND ((game_players.pre_flop_raise_n)=1)"
+ " AND ((game.flop_1) Is Not Null)) AND game.players_saw_flop = "+cold_callers+";";


db.Open(sql, cstring, 1, 3);
echoout += "\nHands Raised PF:\t\t" + db(1)
+ "\nPlayers Called\t\t" + (cold_callers-1)
+ "\nContinuation Bet Flop:\t" + db(2) + "\t\tSuccess:\t" + db(4)
+ "\nContinuation Bet Turn:\t" + db(5) + "\t\tSuccess:\t" + db(7) +"\n\n";
db.Close();
}


WScript.Echo(echoout);


</pre><hr />

Enjoy!

Dave.