#1
|
|||
|
|||
PT all-in analysis (cross-post)
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. |
#2
|
|||
|
|||
Re: PT all-in analysis (cross-post)
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 |
#3
|
|||
|
|||
Re: PT all-in analysis (cross-post)
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.
|
#4
|
|||
|
|||
Re: PT all-in analysis (cross-post)
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! |
#5
|
|||
|
|||
Re: PT all-in analysis (cross-post)
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 |
#6
|
|||
|
|||
Re: PT all-in analysis (cross-post)
Sorry for the delay, I worked from home yesterday ~Teck
<font color="blue"> string sbWhere = ""; sbWhere = " AND (g.date_played>=#" + dateFrom + "# And g.date_played<=#" + 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<>''"); sb.Append(" AND (p.chip_count<=p.pre_flop_bet=-1)"); sb.Append(" AND g.players_saw_flop=2 AND p2.player_id<>"+playerID); if (dateFilter) { sb.Append(sbWhere); } </font> |
|
|