Searching PT for All-in hands

[AliasMrJones]

Over the past 5 days, I think I've taken more beats all-in than in my previous 750 at the 55s. I can't seem to win when I'm all-in, and when you play tight early and pushbot late, if you can't win an all-in...

So, I would like to look up hands where either I or my opponent go all-in preflop and try to figure out just how bad has my luck been? Does anyone know of an easy way to pinpoint hands that I'm involved in where someone is all-in preflop?

I'm fluent in SQL and have Access so I can write queries against the database easily. I'll go look for myself, but thought if someone could save me some time, why not ask.

[MightyMouse2]

better idea. keep a microsoft word document open while you play. any questionable move you make, post on the forum.

[AliasMrJones]

[ QUOTE ]
better idea. keep a microsoft word document open while you play. any questionable move you make, post on the forum.

[/ QUOTE ]

You're missing the point. I already post hands in the forum. I also review my pushes in SnGPT. I can see if I am making good or bad pushes. But, that doesn't tell me how lucky or unlucky I am when I make those good pushes and get called. If I lose 3 all-ins in a row when I push and get called as a 4-1 favorite, there's nothing to post but bad beat stories.

I'm looking for a way to quantify how lucky/unlucky I have been when pushing or calling all-in preflop as obviously this is key to winning SnGs. I don't currently have a way to do the hand evaluations other than manually in Pokerstove or other software. This might be something others would want as well. Sort of a "luckbox-o-meter". It might help people quantify whether their 75% ROI is because of luck or skill when they have less than the 8 bajillion games they need to have a reasonable confidence interval.

[Gobgogbog]

I'm not sure how useful it is going to be unless you also evaluate the starting hands you're dealt compared to your opponents. I mean say three SNGs in a row you get AA versus their KK, and you get sucked out on every time. The numbers are going to say you got a lot more unlucky than you did.

[BradleyT]

It looks like I'm winning my all ins too often and need to loosen up wouldn't you think?






Edit - actually I didn't parse out when I get called so this would include successful blind steals too I guess.

[Gobgogbog]

Bradley, what are you using to get that?

[AliasMrJones]

[ QUOTE ]
I'm not sure how useful it is going to be unless you also evaluate the starting hands you're dealt compared to your opponents. I mean say three SNGs in a row you get AA versus their KK, and you get sucked out on every time. The numbers are going to say you got a lot more unlucky than you did.

[/ QUOTE ]

My plan at first is just to produce a list of all the hands where I or my opponent get all-in with my hand and his hand and then run it manually and mark each as lucky unlucky or standard.

[BradleyT]

When I saw this thread I couldn't get a query to work in Access so I wrote a quick program to do it for me.

However it won't work for anyone else because it has my database imported into the project.



However, maybe one of the other programmers on here can take this code and make a distributable app (like adding a file dialog browse box, asking for player name or ID, etc.

The main form is just a gridview, two labels and a datasource (my pt database).


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

Imports System.Data
Public Class Form1
Dim bindDT As New Data.DataTable

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load, MyBase.Load
Dim wonCount As Integer = 0
Dim lostCount As Integer = 0
bindDT = MakeNamesTable()

Me.Tourney_game_playersTableAdapter.Fill(Me.Ptrack 6DataSet1.tourney_game_players)
Dim myDT As New Data.DataTable

myDT = Me.Tourney_game_playersTableAdapter.GetData
For x As Integer = 0 To myDT.Rows.Count - 1
If myDT.Rows(x).Item("player_id").ToString = "161" Then
If myDT.Rows(x).Item("pre_flop_bet").ToString = myDT.Rows(x).Item("chip_count").ToString Then
Dim myRow As Data.DataRow
myRow = bindDT.NewRow()
myRow("My Hand") = myDT.Rows(x).Item("Hole_Card_1").ToString &amp; " " &amp; myDT.Rows(x).Item("Hole_Card_2").ToString
myRow("Bet Size") = myDT.Rows(x).Item("chip_count").ToString
If myDT.Rows(x).Item("Won_Hand").ToString = "1" Then
myRow("Won") = "Y"
wonCount += 1
Else
myRow("Won") = "N"
lostCount += 1
End If
myRow("Blind") = Replace(myDT.Rows(x).Item("blind_amt").ToString, "0.0000", "-")
bindDT.Rows.Add(myRow)
End If
End If

Next
DataGridView1.DataSource = bindDT
WonCountLabel.Text = CStr(wonCount)
LostCountLabel.Text = CStr(lostCount)
End Sub

Private Function MakeNamesTable() As DataTable
' Create a new DataTable titled 'Names.'
Dim namesTable As DataTable = New DataTable("All_In")
' Add three column objects to the table.
Dim card1 As DataColumn = New DataColumn()
card1.DataType = System.Type.GetType("System.String")
card1.ColumnName = "My Hand"
namesTable.Columns.Add(card1)
Dim card2 As DataColumn = New DataColumn()
card2.DataType = System.Type.GetType("System.String")
card2.ColumnName = "Bet Size"
namesTable.Columns.Add(card2)
Dim Blind As DataColumn = New DataColumn()
Blind.DataType = System.Type.GetType("System.String")
Blind.ColumnName = "Blind"
namesTable.Columns.Add(Blind)
Dim Bet As DataColumn = New DataColumn()
Bet.DataType = System.Type.GetType("System.String")
Bet.ColumnName = "Won"
namesTable.Columns.Add(Bet)
' Return the new DataTable.
MakeNamesTable = namesTable
End Function


End Class

</pre><hr />

[tigerite]

Oh nooo not VB!! If you'd done it in C# I could..

[LALDAAS]

That is a pretty cool little table. I wish I could wright quick little programs.:P