Hi Support guys...

I am currently under-utilising my PT3 and I was wondering if you guys can help tool me up on a few things.

I know how to use filters for level/site/date. But I was wondering how I do it for an obvious eg such as

all opponents AIPF with a 100bb stack (allin preflop) NLFR cash games

I have 500k+ hands and want to see how often cards other than AA,KK appear.


Cheers Dog

Dog,

You want to do this as a custom report, see our Custom Reports Guide.

I think you'll also need to create a custom stat referencing enum_allin to check to see if you are all in preflop as there is currently no statistic built in to PT3 for this case.

If I have some time later today I'll look into making that stat personally. (I'm also curious about the exact question you have

Well Myself and other micro fr degens - are going to try and bring to bear a Million + Db to have significant sample sizing.

Ok I will take some time out from grinding to check it out...feel free to update me on your progress kraada

It's been a busy past few days but I think I'll have some time to look into this report this afternoon. I'll definitely keep you posted.

bump kraada

here is the thread in the Micro FR forum - a couple of us mega tablers are just trying to aggregate our stats for this q. I would love to know a step by step. WIlling to share our results if you are interested.

http://forumserver.twoplustwo.com/78...-pf-ev-305477/

Please just clarify for me what you want to see in your report.
Do you want to see a list of all hands where a player got all in PF with over 100BB?
Or do you want a list of players and how often they got AI-PF >100BB?
(I suspect you want both.. - a list of all hands for all players?)

The DB fields you will need are:
holdem_hand_player_statistics.enum_allin (= 'P' for preflop)
holdem_hand_player_detail.amt_before (= size of stack - you will also need..)
holdem_limit.amt_bb (..to divide the stack size by)

When you tell us what you want to see on the report, if you can't work out how to do the filters, we'll help.

We're looking into adding All-in Preflop as a standard filter to the filters options, so once that's there, all of this work will be moot. I was hoping that this feature would make it into the next beta but that looks unlikely at this time, which is partially why I went quiet.

I'll leave this tab open so I don't forget and once my cache update is finished (should take another hour or two), I'll run this information on my 50NL database and I'll add my info to the thread for you guys.

Just looking at a database from september 2008 at FTP's .25/.50 NL, I see 770 instances of KK raising all-in preflop. On those 770 instances the net result is +257.26 bb/100.

Now that's still a damn small sample and it also doesn't include times that KK faced an all in raise and called because the face_allin flag in PT3 wasn't being set right for a while, but it should give you some idea that at least over the sample from that month, it wasn't even close. I'll do a bit more then post some stats in that thread myself.