PT all-in analysis (cross-post)

[djames]

I posted this in the software forum, but I know of a few PT query'ers among STTF, so:

I'm about to programmatically analyze all hands where I've gone all-in preflop (push/fold) in SnGs.

I believe I can find such hands by restricting to those where tourney_game_player.pre_flop_bet = tourney_game_players.chip_count.

Before I start, I'm checking to see if anyone out there already has such a set of queries through this post.

Anyone? Thanks.

[TeckChavez]

A few months ago I did a just-for-fun program that might have what you are looking for. The thread describing it is here:
http://forumserver.twoplustwo.com/showfl...rue#Post4760246

It has been a while, but if you want I could give you the source code or open it up again and copy/paste the queries it is using here.

~Teck

[blackize]

Teck I never could get your program running properly. I always get "No value given for one or more required parameters" as an error msg.

[djames]

Teck, I'd be very interested in the queries that fuel your program. I think that would be more useful to me than your program itself just because I'll want to look at a ton of stuff.

Any help you can offer I'd great appreciate. Thanks!

[TeckChavez]

k, I have the source code on my external hard drive at work. I will take a look on monday & post them. The queries are more for what hands I pushed/got called or called with all my chips and what the opponents hand was. I then iterate through the records and tally up how many chips I was supposed to win (if I was 67% to win a 1000 pot than I should have won 670).

~Teck

[TeckChavez]

Sorry for the delay, I worked from home yesterday ~Teck
<font color="blue">
string sbWhere = "";
sbWhere = " AND (g.date_played&gt;=#" + dateFrom + "# And g.date_played&lt;=#" + dateTo + "#)";

StringBuilder sb = new StringBuilder();

sb.Append("SELECT p.hole_cards, p2.hole_cards, g.pot, p.won_hand");
sb.Append(" FROM tourney_game_players AS p2");
sb.Append(" INNER JOIN (tourney_game AS g");
sb.Append(" INNER JOIN tourney_game_players as p");
sb.Append(" ON (g.tourney_id = p.tourney_id) AND (g.game_id = p.game_id))");
sb.Append(" ON (p2.game_id = g.game_id) AND (p2.tourney_id = g.tourney_id)");
sb.Append(" WHERE p.player_id=" + playerID);
sb.Append(" AND p2.hole_cards&lt;&gt;''");
sb.Append(" AND (p.chip_count&lt;=p.pre_flop_bet=-1)");
sb.Append(" AND g.players_saw_flop=2 AND p2.player_id&lt;&gt;"+playerID);
if (dateFilter)
{
sb.Append(sbWhere);
} </font>