I have been making great use of the All Players Reports in the 'My Reports' tab of PT4 recently. I have a fairly large data base with ~23 million 6max hands. Now, I would like to filter reports in certain ways but I'm having a tough time. It is my understanding that the best way for me to achieve what I'm trying to do is through the use of Expression Filters.
For example, I'd like to, on an All Players Report where the 'Players' report stat is removed ('Hands' is really the only stat I need for now), see the number of hands where a player with some VPIP range (say between 20 and 30 percent) bet out of position on the flop. My idea is to then look at the number of times a player with this VPIP range saw the flop (without going all in preflop) and get an idea of how often they take this action. I've found a number of posts asking how to do things like this but most of the information given was a bit overwhelming and I found it difficult to make use of it as I have zero base understanding of these expression filters-- I'm hoping someone could clear up some of my questions so that I am able to make use of these posts.
1. Is what I'm trying to do possible (filter by both VPIP and certain actions in the hand)? I read this - https://www.pokertracker.com/forums/viewtopic.php?f=18&t=20574 - forum post where someone appears to say that such a thing is not possible without some workaround-- that was however in 2009 so maybe things are different now. If it is doable, would anyone mind writing out a piece of code showing how this can be achieved with expression filters just to get me started (unless it is complicated and would take too much time-- I assume that isn't the case).
2. Is it possible to use both expression and normal/regular filters at the same time or would this all need to be done as an expression filter?
Some questions so that I may try to start creating some very basic expression filters:
3. I occasionally see people create expression filters where someone wants to evaluate VPIP and they simply write
- Code: Select all
#VPIP#
- Code: Select all
((cnt_vpip / (cnt_hands - cnt_walks)) * 100)
4. I also often see people use
- Code: Select all
cash_hand_player_statistics
5. If I want to learn to be able to easily create my own expression filters, what do I need to learn? Basic SQL?
Sorry for all the questions... as I said I was just overwhelmed by the info on expression filters as I had no base understanding of it. Any help is greatly appreciated. Thank you
