Open Side Menu Go to the Top
Register
Will Buy New Stats Will Buy New Stats

12-29-2009 , 12:39 PM
I've been trying to learn the process for creating stats but it just hasn't been a success.

I am willing to pay someone on FTP to create a few different stats for me. PM me if you're interested.
12-29-2009 , 02:08 PM
What sort of things are you after?
We're happy to help you build them, and it's possible some are already in the Repository.
12-29-2009 , 02:25 PM
Quote:
Originally Posted by WhiteRider
What sort of things are you after?
We're happy to help you build them, and it's possible some are already in the Repository.
Okay, I just didn't want to show how ignorant I am. I actually want this for HU play:

http://www.pokertracker.com/forums/v...p?f=18&t=23877

I didn't mention it because, well, that thread seems to walk you through the majority of it, yet I can't even kind of figure out how to set it up.

Also, I want a donk bets and then folds to raise stat, but the one in the repository always has N/A, no matter how often it happens.
12-29-2009 , 11:51 PM
You might also want to take a read through this tutorial. It's long but it will give you a lot of the tools you need to use the information from the thread you linked to start building stats.

And for what it's worth, once you've built one or two you will start to get the hang of it, and it's very, very worth learning.
01-01-2010 , 10:53 PM
I did my best to make it, but it keeps coming up N/A for my opponent bet turn after I missed cbet stat. I'm willing to accept that this sort of thing just doesn't fall within my skillset. If someone wants to make me one, I'm still willing to pay for it.
01-02-2010 , 07:57 AM
Please either post the expressions you are using for your columns here, or export your stat and attach it to a Support ticket, and explain exactly what you want to calculate and we'll help you fix it.
01-02-2010 , 03:57 PM
Quote:
Originally Posted by WhiteRider
Please either post the expressions you are using for your columns here, or export your stat and attach it to a Support ticket, and explain exactly what you want to calculate and we'll help you fix it.
I got this from the thread I linked to earlier. I'm using this for the number of times an opponent calls a raise, checks through the flop and then bets the turn.

sum( if[ holdem_hand_player_statistics.position = 8 and lookup_actions_p.action = 'c' and lookup_actions_f.action = 'x' and lookup_actions_t.action like 'b%', 1, 0 ] )


This is the number of opportunities to bet the turn after calling a raise and checking through the flop. I'm sure this is likely where I screwed up.

sum( if[ holdem_hand_player_statistics.position = 8 and lookup_actions_p.action = 'c' and lookup_actions_f.action = 'x', 1, 0 ] )
01-02-2010 , 07:34 PM
For your first definition, you are potentially missing out on times when someone calls a raise, then gets reraised. If you want to include those you'd want to change it to: lookup_actions_p.action LIKE 'C%'.

With regards to your second definition, the same bits above apply, but you also want to add "and holdem_hand_player_detail.flg_t_open_opp", to ensure that you have a chance to open the turn. If you have a time where the SB flats a button steal and you call as well in the BB, then the flop is checked around, then the SB bets the turn the definition you listed will be satisfied but it really isn't an opportunity to bet (since you're facing a bet).
01-02-2010 , 09:31 PM
Quote:
Originally Posted by Kraada
For your first definition, you are potentially missing out on times when someone calls a raise, then gets reraised. If you want to include those you'd want to change it to: lookup_actions_p.action LIKE 'C%'.

With regards to your second definition, the same bits above apply, but you also want to add "and holdem_hand_player_detail.flg_t_open_opp", to ensure that you have a chance to open the turn. If you have a time where the SB flats a button steal and you call as well in the BB, then the flop is checked around, then the SB bets the turn the definition you listed will be satisfied but it really isn't an opportunity to bet (since you're facing a bet).
Well, I was referring specifically to HU play, so villain would always be acting first on the turn. I thought I mentioned that, sorry.
01-03-2010 , 11:00 AM
Ah, in that case it should work just fine as you have it. For what it's worth my other additions wouldn't make it not work heads up though.
01-03-2010 , 02:39 PM
Quote:
Originally Posted by Kraada
Ah, in that case it should work just fine as you have it. For what it's worth my other additions wouldn't make it not work heads up though.
It's still not working, though.

(cnt_bet_t_no_cbet / cnt_opp_bet_t_no_cbet) * 100

That's the formula I have. Not sure if this matters, but I have the columns and the statistics in the Holdem Cash Player Statistics section.
01-03-2010 , 03:22 PM
That's the correct section.

Make sure that the actions strings you're comparing are all in upper case ('B' not 'b').

What is "not working" exactly?
Do the columns verify OK - have you been able to save the columns and stat?
Are you just getting the wrong numbers?

Post your updated columns again..
01-03-2010 , 03:34 PM
Quote:
Originally Posted by WhiteRider
That's the correct section.

Make sure that the actions strings you're comparing are all in upper case ('B' not 'b').

What is "not working" exactly?
Do the columns verify OK - have you been able to save the columns and stat?
Are you just getting the wrong numbers?

Post your updated columns again..
I actually have lower case letters. It wouldn't verify originally when upper case, but when I changed them, it did. They all verify and the stats save but always show up, "n/a", despite numerous instances.

Does it impact anything that I'm using the Mac version?

I'll try making them caps.
01-03-2010 , 03:38 PM
Okay, just changed from this:

sum( if[ holdem_hand_player_statistics.position = 8 and lookup_actions_p.action = 'c' and lookup_actions_f.action = 'x' and lookup_actions_t.action like 'b%', 1, 0 ] )

...to this:

SUM( IF[ holdem_hand_player_statistics.position = 8 AND lookup_actions_p.action = 'C' AND lookup_actions_f.action = 'X' AND lookup_actions_t.action LIKE 'B%', 1, 0 ] )

I tried it that way originally, but it wouldn't validate. This time it did. I must have messed something up the first time. I'll report back as soon as my cache has updated.
01-03-2010 , 05:44 PM
The Mac version shouldn't make any difference.
Please also post your expression for "cnt_opp_bet_t_no_cbet" - if you're getting N/A then it is not finding any opportunities, which that column defines.
Did you change the case there too?
01-03-2010 , 05:52 PM
I changed:

sum( if[ holdem_hand_player_statistics.position = 8 and lookup_actions_p.action = 'c' and lookup_actions_f.action = 'x', 1, 0 ] )

...to:

SUM( if[ holdem_hand_player_statistics.position = 8 AND lookup_actions_p.action = 'C' AND lookup_actions_f.action = 'X', 1, 0 ] )
01-03-2010 , 06:15 PM
OK, thanks.
I can't see why that wouldn't work, as long as you're sure you've seen that situation come up..

Please export your stat and attach it to a Support ticket so that we can investigate.
Include a link to this thread too, so that we can refer back.
01-03-2010 , 06:41 PM
I just had the situation come up twice and it still says N/A. I submitted a support ticket.

Thanks!
01-03-2010 , 07:18 PM
OK, we'll get back to you via your ticket.
01-04-2010 , 08:25 PM
Just wanted to give props to the awesome customer service. Thanks again!
01-05-2010 , 06:22 AM
You're welcome!

      
m