pokertracker question

[veganmav]

inspired by pokerbobs 12 bet fold to 13 bet posts etc. [img]/images/graemlins/smile.gif[/img]


Is there anyway to serch for hands where I 3-bet and then folded to a cap?

Or I guess even hands where I 3bet, and then i can look for the cap fold myself.

any ideas?

[Municipal Hare]

Do you know how to run SQL queries against your database? Here's what I came up with.

SELECT game_number
FROM game_players AS gp INNER JOIN game AS g
ON gp.game_id = g.game_id
WHERE gp.player_id = (select player_id from players where screen_name = '<font color="red">Me</font>')
AND blind_amt=<font color="orange">3</font>
AND (gp.<font color="blue">turn</font>_bet = <font color="green">18</font> AND gp.<font color="blue">t</font>call = 0 AND gp.<font color="blue">t</font>fold &gt; 0)

Replace <font color="red">Me</font> with your screenname.
Replace <font color="orange">3</font> with the size of a small bet in the limit you're looking for.
Replace <font color="green">18</font> with the real-money raise size you're looking for.
Replace <font color="blue">turn</font> with river or flop and <font color="blue">t</font> with r or f as you like.

[veganmav]

i will do this, if you explain to me how, to run sql queries against my database.

[Municipal Hare]

If yours is an Access database, open ptrack.mdb, select Queries, make a new one, switch from Design View to SQL View, and paste and execute my query.

If yours is a PostgreSQL database, run pgAdmin, double-click your database on the left pane, enter the admin password, click the HOLDEM database, find the SQL button up top, and paste and execute my query.

Should work.