how do I make this stat positional ??

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

how do I make this stat positional ??

Postby orentha » Sun Mar 01, 2009 7:54 pm

I'm trying to get the "fold to 4bet after 3 betting stat" to be by position.
here's my stat:
Code: Select all
(cnt_p_fold_to_4bet_after_3bet / cnt_p_fold_to_4bet_after_3bet_opp) * 100


and I dont know how to add this code to make it for EP:
Code: Select all
and ((holdem_hand_summary.cnt_players = 4 and holdem_hand_player_statistics.position = 1) or
(holdem_hand_summary.cnt_players = 5 and holdem_hand_player_statistics.position = 2) or
(holdem_hand_summary.cnt_players = 6 and holdem_hand_player_statistics.position = 3) or
(holdem_hand_summary.cnt_players = 7 and holdem_hand_player_statistics.position = 4) or
(holdem_hand_summary.cnt_players = 8 and (holdem_hand_player_statistics.position = 4 or holdem_hand_player_statistics.position = 5)) or
(holdem_hand_summary.cnt_players = 9 and (holdem_hand_player_statistics.position = 5 or holdem_hand_player_statistics.position = 6)) or
(holdem_hand_summary.cnt_players = 10 and (holdem_hand_player_statistics.position = 6 or
holdem_hand_player_statistics.position = 7)))



I've tried a couple different ways, and I cant get the expression to be valid...
I have no idea where parenthesis or commas or any kind of "code" formatting needs to go...
orentha
 
Posts: 29
Joined: Thu Jan 24, 2008 7:39 pm

Re: how do I make this stat positional ??

Postby kraada » Mon Mar 02, 2009 10:52 am

That code goes in the column. What's your definition for cnt_p_fold_to_4bet_after_3bet?

(Incidentally these exact positional stats will be included in the next version of the Advanced HUD, which I expect to release very soon.)
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: how do I make this stat positional ??

Postby orentha » Mon Mar 02, 2009 1:57 pm

here's what I have for the column for the stat:

Code: Select all
sum(if[(holdem_hand_player_statistics.flg_p_3bet) AND (holdem_hand_player_statistics.flg_p_fold),1,0])
orentha
 
Posts: 29
Joined: Thu Jan 24, 2008 7:39 pm

Re: how do I make this stat positional ??

Postby kraada » Mon Mar 02, 2009 2:38 pm

Make the column like this then:

sum(if[(holdem_hand_player_statistics.flg_p_3bet) AND (holdem_hand_player_statistics.flg_p_fold) and ((holdem_hand_summary.cnt_players = 4 and holdem_hand_player_statistics.position = 1) or
(holdem_hand_summary.cnt_players = 5 and holdem_hand_player_statistics.position = 2) or
(holdem_hand_summary.cnt_players = 6 and holdem_hand_player_statistics.position = 3) or
(holdem_hand_summary.cnt_players = 7 and holdem_hand_player_statistics.position = 4) or
(holdem_hand_summary.cnt_players = 8 and (holdem_hand_player_statistics.position = 4 or holdem_hand_player_statistics.position = 5)) or
(holdem_hand_summary.cnt_players = 9 and (holdem_hand_player_statistics.position = 5 or holdem_hand_player_statistics.position = 6)) or
(holdem_hand_summary.cnt_players = 10 and (holdem_hand_player_statistics.position = 6 or
holdem_hand_player_statistics.position = 7))),1,0])
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 1 guest