Custom Stat: Cbet% with Flushdraw

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

Custom Stat: Cbet% with Flushdraw

Postby shahrad » Mon Dec 06, 2010 3:30 am

I have done a Cbet stat with a flushdraw in a Heads up pot. Now this doesn't help me much, how must I have to change it for differing between Nut Flush draw and Non Nut flush draw.
sum(if[omaha_hand_player_statistics.flg_f_cbet and NOT(omaha_hand_player_statistics.flg_p_4bet or omaha_hand_player_statistics.flg_p_3bet) and omaha_hand_player_combinations.flg_f_flush_draw and NOT(omaha_hand_player_combinations.flg_f_2pair or omaha_hand_player_combinations.flg_f_straight or omaha_hand_player_combinations.flg_f_threeoak or omaha_hand_player_combinations.flg_f_fullhouse or omaha_hand_player_combinations.flg_f_fouroak) and omaha_hand_summary.cnt_players_f=2, 1, 0])

I would also like to have a cbet stat which shows how often someone cbets his Top pair on the flop. In the hand detail there is only one pair but not top pair.
shahrad
 
Posts: 118
Joined: Fri Oct 08, 2010 1:51 pm

Re: Custom Stat: Cbet% with Flushdraw

Postby kraada » Mon Dec 06, 2010 9:42 am

The database element for picking out nut flush draw vs other flush draw is known to be non-functional at this point in time. If you create a support ticket we will make sure you are notified when it is fixed.

For top pair, you can use the details explained in this post in order to pick out those situations (it should work just the same for Omaha as it does for Holdem).
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