fold to flop check raise

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

Re: fold to flop check raise

Postby kraada » Tue Dec 21, 2010 1:04 pm

Upon further inspection I agree that this should fix the heads up issue.

To use these fixes for each street (f, t, & r), duplicate cnt_x_face_xr and the three under it (_call, _raise, _fold), and rename them as you desire. Replace "(holdem_hand_player_detail.val_x_raise_aggressor_pos > holdem_hand_player_statistics.position)" with "((holdem_hand_summary.cnt_players > 2 AND holdem_hand_player_detail.val_x_raise_aggressor_pos > holdem_hand_player_statistics.position ) OR holdem_hand_summary.cnt_players = 2 AND holdem_hand_player_statistics.flg_blind_s))" where x is the street in question. Save the new columns. Duplicate the stats, change the names and columns so that you have a slightly different name and it uses your new columns.

I'll make sure we get this in our list to be fixed for a future release.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: fold to flop check raise

Postby ph757 » Tue Dec 21, 2010 1:13 pm

Go to edit stats and make the following changes:

cnt_f_face_xr should now contain:
Code: Select all
sum ( if[ flg_f_bet AND holdem_hand_player_statistics.flg_f_face_raise AND (holdem_hand_player_detail.val_f_raise_aggressor_pos > holdem_hand_player_statistics.position
OR (holdem_hand_summary.cnt_players = 2 and holdem_hand_player_statistics.flg_blind_s) ), 1, 0 ] )


cnt_f_face_xr_fold should now contain:
Code: Select all
sum ( if[ lookup_actions_f.action LIKE 'BF' and holdem_hand_player_statistics.flg_f_face_raise AND (holdem_hand_player_detail.val_f_raise_aggressor_pos > holdem_hand_player_statistics.position
OR (holdem_hand_summary.cnt_players = 2 and holdem_hand_player_statistics.flg_blind_s)), 1, 0 ] )
ph757
 
Posts: 3
Joined: Mon Dec 20, 2010 6:02 am

Previous

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

Who is online

Users browsing this forum: No registered users and 19 guests

cron
highfalutin