Open Side Menu Go to the Top

02-04-2009 , 05:48 PM
is it possible to run a report to see for example all the players who have a vpip of 10 or less utg? if so how?
reports by position?
150% up to $2,000 Welcome Bonus on CoinPoker
Join the action now
Daily Rewards ? Splash Pots ? CoinRaces
reports by position?
02-05-2009 , 10:29 AM
Sure, though it will require a small amount of work.

First you need to create a stat: VP$IP UTG. Configure --> Statistics, choose Holdem Cash Player Statistics, go to the columns tab.

Create a new column: cnt_vpip_utg with definition:
sum(if[holdem_hand_player_statistics.position = X and holdem_hand_player_statistics.flg_vpip, 1, 0])

Change X to whatever position is necessary for the games that you play. At a 9 man table, UTG is 6 (button is 0, CO = 1, HJ = 2, etck.), at a 6 max table, UTG is 3.

Then create another column: cnt_vpip_utg_opp with definition:
sum(if[holdem_hand_player_statistics.position = X, 1, 0])

Create a stat putting cnt_vpip_utg over cnt_vpip_utg_opp on the Stats tab (don't forget to fill in the format tab) and apply your changes.

Then go to the reports tab, choose Holdem Cash Player Statistics from the drop down. Whatever stats you want to see in the report, add them from the bottom left pane to the top right pane.

Then click the Filters button on the top right pane. Uncheck "Filter on active player" (this makes the report look at all players not just you), and click Insert, go to the Statistics tab, choose VP$IP UTG (or whatever you called your new stat), click OK and then type in the bottom box so that it reads:
#VP$IP UTG# < 10

Click OK, save and run your report.
02-05-2009 , 10:32 AM
Yes, you can do this, but you will need to make a Custom Report on the Reports tab and use the report filters section.

UTG is a little tricky as it depends on the number of players at the table. You can filter by position off the button easily (on the standard filters button) but if you want to identify all UTG hands you will need to build a custom stat and check for position being equal to the number of players at the table - 3 (at a full 10 seat table UTG is 7 off the button, but if there are only say 8 players then UTG = 5).

You would need to build a new stat for 'VPIP UTG', and then filter on that in a custom report.

Have a look at the Custom Statistics and Reports FAQ and see if you can duplicate and adapt the VP$IP stat to include a check for UTG.
You will need these database fields:
holdem_hand_player_statistics.position
holdem_hand_summary.cnt_players
reports by position?
150% up to $2,000 Welcome Bonus on CoinPoker
Join the action now
Daily Rewards ? Splash Pots ? CoinRaces
reports by position?

      
m