RFI and Steal by "2-3bb" and more

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

RFI and Steal by "2-3bb" and more

Postby nyjedsazi » Sun Aug 08, 2010 3:53 pm

Hi!

How do the stat for tourney, which would help differentiate raises a 2-3 big blinds from others (from more than 3bb to all-in)?
For RFI and steals for all standard positions.

Thank you.
nyjedsazi
 
Posts: 42
Joined: Thu Jun 03, 2010 5:04 pm

Re: RFI and Steal by "2-3bb" and more

Postby kraada » Sun Aug 08, 2010 5:01 pm

Duplicate whatever columns you need and add this to the condition at the beginning of the if statement in order to pick out only situations where the person raised from 2 to 3 big blinds:

"(tourney_holdem_hand_player_detail.amt_p_raise_made BETWEEN tourney_holdem_blinds.amt_bb * 2 AND tourney_holdem_blinds.amt_bb * 3) AND "
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: RFI and Steal by "2-3bb" and more

Postby WhiteRider » Mon Aug 09, 2010 3:05 am

See this tutorial for how to build a new version of a stat.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: RFI and Steal by "2-3bb" and more

Postby nyjedsazi » Mon Aug 09, 2010 5:17 am

Thank you!
I will try it today.
nyjedsazi
 
Posts: 42
Joined: Thu Jun 03, 2010 5:04 pm

Re: RFI and Steal by "2-3bb" and more

Postby nyjedsazi » Mon Sep 27, 2010 10:04 am

Thank you very much! It works!
nyjedsazi
 
Posts: 42
Joined: Thu Jun 03, 2010 5:04 pm


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

Who is online

Users browsing this forum: No registered users and 0 guests