Continuation Bets - Pokertracker Analysis

[kross]

[ QUOTE ]
Is there any way you could set this up for PostGres?

[/ QUOTE ]

I messed with the script a bit, and here it is working for PostgreSQL:

<font class="small">Code:</font><hr /><pre>
///// change settings here /////
var screen_name = 'YourScreenName';
var ptdb = 'PTPGSQL1';
var ptusername = 'postgres';
var ptpassword = 'password';

////////////////////////////////
///// Globals /////////
var db = new ActiveXObject("ADODB.Recordset");
var cstring = "Provider=MSDASQL;DSN=" + ptdb + ";UID=" + ptusername + ";PWD=" + ptpassword;
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,"+
" 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,"+
" 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, 0, 1);
echoout += "\nHands Raised PF:\t\t";
echoout += db("Hands_when_PFR")+
"\nPlayers Called\t\t" + (cold_callers-1)+
"\nContinuation Bet Flop:\t" + db("C_BET") +
"\t\tSuccess:\t" + Math.round(((db("C_BET")-db("Went_to_turn"))/db("C_BET"))*10000)/100+
"\nContinuation Bet Turn:\t" + db("Second_barrel") +
"\t\tSuccess:\t" + Math.round(((db("Second_barrel")-db("Went_to_river"))/db("Second_barrel"))*10000)/100+"\n\n";
db.Close();
}
WScript.Echo(echoout);
</pre><hr />

[gosquad]

very nice kross. thanks. Gonna give this a try.

[jbird]

Doesn't work for me when I double click it tries to open with dreamweaver....anybody know how I can run it without this happening I'd like to see my stats....

[oyvindgee]

1 opponent:
Flop - 59% success
Turn - 65.01% success

2 opponents:
Flop - 47.15%
Turn - 74.21%

3 opponents:
Flop - 50%
Turn - 73.68%

Pretty cool script. Not sure what to make of this though.

[kross]

[ QUOTE ]
Doesn't work for me when I double click it tries to open with dreamweaver....anybody know how I can run it without this happening I'd like to see my stats....

[/ QUOTE ]

Instead of double-clicking, try right-click, then Open With-&gt;Windows Script Host

Or, try running from a command prompt:

cd &lt;directory with continuation_bets.js file&gt;
wscript continuation_bets.js