6max First In Raise Stats

[andyakb]

Im pretty new to all of this, so please go easy on me ;) . Anyways, Im trying to create a stat that shows how often a player open raised [i.e. no limpers or raisers before them] and also one to show how often they raised first in.

Now, for the raised first in, I want to create a column called, for example, RFI_Button [based off the PFR 6max Button stat] which has the following code:

Code: Select all

SUM(if[holdem_hand_player_statistics.cnt_p_first_raise > 0 AND holdem_hand_player_statistics.position = 0,1,0])

And then for the stat itself simply have:

Code: Select all

(RFI_Button / RFI_button_opp) * 100

However, after thinking about it for awhile, I do not know how to code something to show how often there is a chance for the button to be the first to raise. Also, I feel like if you could figure out how often there is no raise before the button, then it would be fairly easy to figure out how often there were also no limpers allowing me to create another stat to see how often the button _open_ raised.

Do you guys have any suggestions? This is probably formatted and worded very poorly, but this is my first real attempt at figuring this stuff out and any help would be appreciated.

-Andy

[WhiteRider]

The best way to build this will be to look at the existing built-in "RFI" stat and duplicated the columns and add your check for position.
Make sure you have Beta 17, though, because the RFI stat was just fixed..

[WhiteRider]

Sorry, I also meant to say...

In this expression:
[quote="andyakb"]Now, for the raised first in, I want to create a column called, for example, RFI_Button [based off the PFR 6max Button stat] which has the following code:

Code: Select all

SUM(if[holdem_hand_player_statistics.cnt_p_first_raise > 0 AND holdem_hand_player_statistics.position = 0,1,0])

/quote]
..you are trying to use a Column (cnt_p_first_raise) as a database field (holdem_hand_player_statistics.cnt_p_first_raise, which doesn't exist).

To construct something like this, instead of using the cnt_p_first_raise Column directly, you should copy it's contents across to your expression.

The way the "Sum( if[ " part works is to go through each hand for the player and use the "if" to determine whether to "Sum" (i.e. count) 1 or 0. So the bit inside the first part of the "if" needs to evaluate for each hand, not all hands together.