Looking to hire someone who knows PT3

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Looking to hire someone who knows PT3

Postby jimmyhat1000 » Wed Jan 12, 2011 10:21 am

To forum,

Ive recently switched to Mac so am now using PT3 instead of holdem manager. am having trouble finding all the stats i want to put in my HUD. Specifically c-bet in 3 bet pot, fold to c bet in 3 bet pot, fold c bet to raise in 3 bet pots. Also if it can be done bet turn in pos after calling c bet in 3 bet pot and bet river in pos after calling c bet in 3 bet pot and turn going check check.

If someone knows where any of these stats exist in PT3 already and im simply not looking in the right spot or if someone knows how to create them and is willing to help me im willing to pay them $100 an hour to help me create them, if it only takes 15 minutes to make them, will still pay for the full hour. Can send on FTP

Mods if this in in-appropriate please remove

James
jimmyhat1000
 
Posts: 10
Joined: Sun Jan 02, 2011 11:40 pm

Re: Looking to hire someone who knows PT3

Postby kraada » Wed Jan 12, 2011 12:17 pm

You have a PM.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Looking to hire someone who knows PT3

Postby majonyjony » Wed Jan 12, 2011 1:26 pm

I'm also interested in these statistics
majonyjony
 
Posts: 116
Joined: Wed Oct 08, 2008 4:01 am

Re: Looking to hire someone who knows PT3

Postby kraada » Wed Jan 12, 2011 3:24 pm

Fold to cbet in a 3-bet pot is actually available by default as Fold to F Cbet in 3bet pots.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Looking to hire someone who knows PT3

Postby majonyjony » Thu Jan 13, 2011 4:52 am

By default?
Not in my 3.09 beta¿?¿¿?

[ img ]
majonyjony
 
Posts: 116
Joined: Wed Oct 08, 2008 4:01 am

Re: Looking to hire someone who knows PT3

Postby kraada » Thu Jan 13, 2011 9:40 am

I typed the name wrong; my apologies.

It's Fold F Cbet in 3Bet Pot - so it's above the "Fold to"s.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Looking to hire someone who knows PT3

Postby majonyjony » Thu Jan 13, 2011 11:17 am

Kraada OK thanks, no problem.
But I have questions about that statistic.
See column denominator
sum (if [holdem_hand_player_statistics.cnt_p_raise> 0 AND holdem_hand_player_statistics.flg_p_3bet_def_opp AND holdem_hand_player_statistics.enum_f_cbet_action = 'F', 1, 0])
But reading this post http://www.pokertracker.com/forums/viewtopic.php?f=18&t=32352&p=158950&hilit=3+bet+pots%20#%20p158950

It is very different,(holdem_hand_player_statistics.flg_p_3bet or holdem_hand_player_statistics.flg_p_3bet_def_opp) AND NOT (holdem_hand_player_statistics.flg_p_4bet or holdem_hand_player_statistics.flg_p_4bet_def_opp)
Than holdem_hand_player_statistics.cnt_p_raise > 0 AND holdem_hand_player_statistics.flg_p_3bet_def_opp AND ....

In the first, whom we raise, and we face a 3bet.
But include chances of call 3bet and 4 bet.
Be correct this?:
Denominator
sum(if[holdem_hand_player_statistics.enum_f_cbet_action='F' AND (holdem_hand_player_statistics.flg_p_3bet or holdem_hand_player_statistics.flg_p_3bet_def_opp) AND NOT (holdem_hand_player_statistics.flg_p_4bet or holdem_hand_player_statistics.flg_p_4bet_def_opp), 1, 0])
Numerator
sum(if[holdem_hand_player_statistics.flg_f_cbet_def_opp AND (holdem_hand_player_statistics.flg_p_3bet or holdem_hand_player_statistics.flg_p_3bet_def_opp) AND NOT (holdem_hand_player_statistics.flg_p_4bet or holdem_hand_player_statistics.flg_p_4bet_def_opp), 1, 0])
majonyjony
 
Posts: 116
Joined: Wed Oct 08, 2008 4:01 am

Re: Looking to hire someone who knows PT3

Postby kraada » Thu Jan 13, 2011 11:27 am

There's an inference involved that you're missing - in order to face a cbet we must not have made the last raise.

Therefore if we face a 3-bet and a c-bet and we don't have a check for not making a 4-bet, the only cases that can come in are cases where we 4-bet, get 5-bet and then face a c-bet. Depending on your game type and stakes this may literally never happen (and if it does it may only happen very rarely), as a normal progression of bets might be: 2-bet: 3BB, 3-bet: 9BB, 4-bet: 27BB, 5-bet: 81BB - but if you're only 100BB deep that 5-bet is going to be a shove almost all of the time.

The option you present will work but it doesn't require you to have made any raises so if you flatted a 3-bet out of the big blind and check/folded to a c-bet, that would count. Quite a few people didn't want those cases to count, and so they were not added originally to the stat in question.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests