efficient way to convert many tourn. stats/columns into cash

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

efficient way to convert many tourn. stats/columns into cash

Postby merkur33 » Fri Nov 27, 2009 2:17 pm

I only play tournaments atm, and i have lots of costum tourney stats (maybe 100 or more, which i all need, believe it or not... :? ) and im thinking about converting them all to cash and give this a try again (because maybe i dont suck as bad at cash games any longer as i did one year ago...). But the procedure to convert them manually is way to complicated (I maybe lost one month of poker just to figure out stats and huds). Is there any workaround with search&replace involved? Basically i just have to replace "tournament_" with nothing in lots of configuration files, or am i wrong? Later on i could then tweak one or antoher stat which doesn't work in cash, but it would save me lots of work.

Oh, and just in case i wanted to repeat an old feature request: It would be swell if the layout of hud profiles would be stored seperated from the configuration of hud stats. So we could have one basic setup of how the hud is organised (which groups hold which stats, and how are they layouted/colored), and different profiles how it is displayed at different sites and/or seating scemes, multabling and the like. (where are which permanent groups located on the screen, and which popup group(s) do they have). This would be much easier to maintain, now i need to update eight different hud layouts anytime i add or edit one single stat. (Multitabling yes/no, shorthanded/full table, Pokerstars/Full Tilt).
merkur33
 
Posts: 126
Joined: Tue Nov 25, 2008 11:57 am

Re: efficient way to convert many tourn. stats/columns into cash

Postby kraada » Sat Nov 28, 2009 9:56 am

If you're only changing the location of the statistics, you don't need an entirely separate profile. PT3 recognizes different table types and if you relocate then save the layout once you're on one of those different table types, PT3 won't get confused between a FT and PS table. Of course, if you want entirely different stats then you will need a new profile.

There isn't a better way to change the statistics en masse at this point, I'm afraid. It's been requested in the past but I don't know when it would become available.

In the meantime, though I can suggest a couple of things to make it easier on you:
(1) Copy and paste all of the definitions to a file in Wordpad
(2) Use find/replace to replace tourney_holdem with holdem.
(3) Copy and paste all of the definitions back into the cash section.

It's tedious, but it is quite a bit faster than copying and pasting and deleting one at a time for sure (I've converted a few dozen stats at a time before, so for what it's worth, I do feel your pain).
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: efficient way to convert many tourn. stats/columns into cash

Postby merkur33 » Sat Nov 28, 2009 12:10 pm

I figured something like this, but i made pokerstars profiles just in case, because i didn't want to srcrew anything up again (having made a very frustrating experience with corrupted configuration files, no backups and lots of work to do again...) Just for clarification, am i right with this assumption:

when i have the same profile for the following tourneys:
9-max at full tilt,
6-max at full tilt,
9-max at stars,
10-max at stars
it wont mix them up? For sure? Cool.

What's with those four-max-shootout tourneys at Stars? Last time i tried them (do they even have them anymore?) PT couldn't handle them at all, hud-wise.

Yeah, i figured i would end up with something like this. Its way better this way then do all the copy&paste in PT, at least. Anyhow, no pain, no gain :| I will to this the next time i need to come off-tilt again. BTAICBW...
merkur33
 
Posts: 126
Joined: Tue Nov 25, 2008 11:57 am

Re: efficient way to convert many tourn. stats/columns into cash

Postby kraada » Sat Nov 28, 2009 12:23 pm

the same profile for the following tourneys:
9-max at full tilt,
6-max at full tilt,
9-max at stars,
10-max at stars
it wont mix them up?


For sure. The 4-max tournaments are still going to be a bit problematic as there is no 4-max table type defined in PT3.

Sorry I didn't have a better answer for you, but honestly, once you really get into the groove you will find it takes less time than you thought.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: efficient way to convert many tourn. stats/columns into cash

Postby merkur33 » Sat Nov 28, 2009 12:49 pm

Maybe this is of any interest:
I have solved for me the problem with adapting the hud to multitabling/singletabling like this: I have five main groups with the most important stats:
General (with WTSD, tAF, Saw flop%),
Preflop (VPIP, PFR, RFIFq (that is how often is he first in when he raises), CCPF and Steal%, colored with other basic stats like Fold to PFR, 3Bet%, Fold PFR to 3bet, and Fold Steal to Resteal.),
Flop (with Bet%, Cbet%, Raise%..., colored with Fold Bet to Raise, Fold to Bet and Donk%),
Blinds (Fold BB to Steal, Fold SB to Steal, and Check% BB)
and Informational (Player Name, Hands, notes Icon, colored with BB/100).
When im Singletabling i have a big positional Stats window permanent also, that shows me VPIP, PFR, FtPFR, RFI, RFIFq, Limp% and Fold Limp% per Position (EP, MP, LP, SB and BB). When mutlitabling i have this as a popup window only (allthough its maybe the most usefull stat group at all)
Then i have popup windows with M-Based stats, and detailed Preflop, Flop and Results Windows, that show u basically anything you want.
All of this is formatted to show up only if the denominator is reasonably high (normally greater than 10...) So i basically need a costum stat for everything, because otherwise i can't edit the formatting.

so its lots of stuff i have to do while folding all the time :D

Earlier on i had different stats versions of the main stats for shorthanded situations where the color coding was different, adapted to other averages of stats when referring shorthanded play, but i basically dont do this anymore because it doesnt really pay off.

Main advantage to have it organised this way is, i have the same groups for all situations, only the destribution of popup/permanent is different - its much easier to maintain.
merkur33
 
Posts: 126
Joined: Tue Nov 25, 2008 11:57 am

Re: efficient way to convert many tourn. stats/columns into cash

Postby kraada » Sat Nov 28, 2009 1:11 pm

That's an interesting way to organize things; thanks for sharing!
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: efficient way to convert many tourn. stats/columns into cash

Postby merkur33 » Sat Nov 28, 2009 8:41 pm

I took much benefit from your various hud stuff, so i just wanted to give a little bit back... I just want do add another thing: I have a different approach to coloring stats, which is, as i think, both more accurate and intuitive, but also much more work to configure and maintain. I basically use color ranges for player characteristics. for example, red=aggressive, turqouise=average, blue=conservative (passive). I adjust now this color distribution accordingly to the typical values for the specific stat. (I get the averages by looking for them in a report of all players i have more than 200 hands from.) For example for PFR, i have (from 0 upwards): 0 <- light blue (extremly passive) -> 6 <- blue (passive) -> 8 turqouise (avarage) 11 pink (slightly aggressive)14 red (aggressive )19 light red (exremly aggresive) 100. Notice that the width of the ranges is narrowing towards the average, so it gives me the most accurate read in the most likely zone. Then i have the same color relation for "3bet PF", only now i have 0 light blue 3 blue 4 turqouise 5 pink 6 red 9 light red 100. So now the average zone around 4.5 is even more narrow. Of course one has to adjust the averages to the typical environment one plays in, these values are from FT 9 to 45-man tourneys with 10-30$ buyin, and some MTT with the same buyin range.

My second relation is either "fearless - careful", when referrring to "fold to x"-Stats, or "good - bad", when referring to result-based stats. It is green (carefull, or bad player), turqouise (average), red (daring, good player). This relation i use for example for Fold to PFR, Fold to Steal, Fold Steal to Resteal, Fold CBet to Raise, Fold to Donkbet, Fold after Flop Aggression when facing resistance later on... ; or W$WSF, W$SD, Won when calling the flop, Won when 3betting preflop...

Then i have another relation for "generally loose - generally tight", which is blue (conservative, tight), turqouise (average), yellow (slightly loose), orange (loose). I use this for example for vpip, limp%, WTSD, CCPF, Saw flop, and the like. I use this relation for more general stats representing the overall tendency of the player to play hands/see flops/see showdowns and the like. When representing the likeliness to fold to any specific form of aggression, i prefer the "fearless-careful"-relation.

(Of course these charakterizations are hightly disputable, "fearless" mostly means "dumb", "stubborn", or "mad", and careful often means "timid", "weak" or "a nice fellow who just wants to play a few cards"... my stats are mostly green, for example :D )

Its of course important to use also the conditioned formatting to only display the figures if they have a reasonable denominator, which can take a while, depending on the specific stat. Otherwise you get flooded with 100%, 50% or whatever, which doesn't has any significance. I found the denominator of 10 is a good meassure for the most stats to give it a certain credibility, sometimes i wait for 20.


http://yfrog.com/0tmyhudj
http://yfrog.com/31myhud2j

This is my hud. Unfortunately the colors are much more pale than they are actually, but maybe one gets a pictuere. Or course all of this is a matter of taste and being used to it, but the fact that the same color stands everytime for a similar characteristic, no matter what the numbers are, is very good to read for me. 70% can be light red and mean an insanely high PFR, or light green and mean that he folds 70% of his limps when raised.
merkur33
 
Posts: 126
Joined: Tue Nov 25, 2008 11:57 am

Re: efficient way to convert many tourn. stats/columns into cash

Postby kraada » Sun Nov 29, 2009 9:43 am

Thanks for that; I know everybody has different criteria that they like. When I built my HUD, I wanted to use actual numerical values simply to avoid having to try and figure out "what is passive" and "what is loose" sort of questions (as I was also planning on posting my HUD from day 1), as they're awfully tough questions to get good answers to.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: efficient way to convert many tourn. stats/columns into cash

Postby merkur33 » Sun Nov 29, 2009 5:39 pm

You're right, this can lead to endless discussions that are touching the most complex parts of poker strategy. however, by orientating my reads strictly at the average environment one actually plays in, one gets at least a decent prospect of how loose/timid/tight/whatever a person is relative to the average other villain. There are several ways to play profitable poker, with average stats or (more often) with non-average stats , but if i know this player folds more often his flop bets to raises than your average other opponent, i have something reliable to start with.

(i forgot to say that my stat averages are all from 7-10 player at the table. Shorthanded situations have other requirements; at a certain point its a more complex picture of situation (position, Ms, player mood, loosing/winning streaks, whatever...), player profile (from previous hud reads and made conclusions from those, eventual recent bahavior changes and from observed plays) is more relevant than a single hud stat alone, so in a way what one or another stat shows at a given moment, is far less important.)

Also, many stats are really typical in a certain region of the 100%-Range. By having a linear color distribution, one gives away too easily the most important advantage of coloring stats at all: you can read and understand them very easy and fast (almost as fast as these popular autorate-icons, which i don't like much, for several reasons). If one has a PFR of well above 20% in fullring-tourneys, i dont really care if its 28% or 58%, he is an probably an aggrodonk anyway. what im far more interested in is wheter it is 10, 12, 14 or 16%... Now i don't really know exactly how yo have the color distribution in your current hud, but i thought it was linear, and i think this is often shifting the attention towards regions that are not really relevant.

What i wanted to ask: I stumbled across your approach/workarround to get a players actual M. 8-) 8-) 8-) 8-) 8-) 8-) Very cool! I will get something in this direction ASAP. Now what i dont get completely: You said it would work only if one refreshes every hand. I have this set to "every two hands" or even higher, for i think you gain much perfomace by doing this, esp. when multitabling. what would happen if i still refresh every second hand and mybe up the "seconds"-thing to 60 or 70? It would basically work, but lag/be inaccurate at blind changes a little more then your version, or am i wrong? And a second question: by using this timestamp-variable-trick, couldn't we get also a "recent 10 Minutes" or so picture that shows the current image? So maybe we recognise more easy when he changes gears... something i wanted to have since ages... Im always very baffled of how my stats read after 20 or 30 hands and how much they differ from my long term averages, due to bad/good cards/mood or whatever. I would like to know when someone plays very different than his normal style, and then i could start thinking about why he does that and when he better should stop doing it, otherwise i put him on tilt/desperation/fatigue/cleptomania (steal sickness) or whatever.
merkur33
 
Posts: 126
Joined: Tue Nov 25, 2008 11:57 am

Re: efficient way to convert many tourn. stats/columns into cash

Postby kraada » Sun Nov 29, 2009 8:41 pm

merkur33 wrote:You're right, this can lead to endless discussions that are touching the most complex parts of poker strategy. however, by orientating my reads strictly at the average environment one actually plays in, one gets at least a decent prospect of how loose/timid/tight/whatever a person is relative to the average other villain. There are several ways to play profitable poker, with average stats or (more often) with non-average stats , but if i know this player folds more often his flop bets to raises than your average other opponent, i have something reliable to start with.


Indeed, I quite agree. But I'm sure you can see how, given that I was planning to distribute my HUD and that I didn't want to go into deep data analysis of trying to ascertain what ranges to use, why I would use linear ranges (which I'll talk more about in a bit).


merkur33 wrote:(i forgot to say that my stat averages are all from 7-10 player at the table. Shorthanded situations have other requirements; at a certain point its a more complex picture of situation (position, Ms, player mood, loosing/winning streaks, whatever...), player profile (from previous hud reads and made conclusions from those, eventual recent bahavior changes and from observed plays) is more relevant than a single hud stat alone, so in a way what one or another stat shows at a given moment, is far less important.)


All of my analysis and play is for full ring as well; I have admittedly played very little short handed poker and won't claim to know one bit what the proper adjustments are.

merkur33 wrote:Also, many stats are really typical in a certain region of the 100%-Range. By having a linear color distribution, one gives away too easily the most important advantage of coloring stats at all: you can read and understand them very easy and fast (almost as fast as these popular autorate-icons, which i don't like much, for several reasons). If one has a PFR of well above 20% in fullring-tourneys, i dont really care if its 28% or 58%, he is an probably an aggrodonk anyway. what im far more interested in is wheter it is 10, 12, 14 or 16%... Now i don't really know exactly how yo have the color distribution in your current hud, but i thought it was linear, and i think this is often shifting the attention towards regions that are not really relevant.


That's why I have two sets of ranges, and I chose my stats I use for coloring carefully. Remember, I don't color based on a stat's value, I color based on other stats' values. The stats that I use as color values are:
Limp/Fold %, PFR & Fold to 3bet %, 3bet vs steal %, LWPC (limp behind limpers %), Fold to 3-bet % after stealing, fold to flop cbet %, winning % given any postflop raise, fold to c-bet in 3bet pots, float turn % and fold to steal %.

So for example, my VP$IP is colored by a player's limp/fold %. A VP$IP 20 can have any number of colors - red if the player never limp/folds, magenta if he always limp/folds and anywhere in between. I find this particularly useful for a variety of reasons:
(1) It lets me see a bunch of other stats at all times on my HUD but without making things feel extremely cluttered. Once you get used to thinking "I can steal, what color is that number in? Oh, they fold to steal a lot, let's steal ATC", you'll find that it works really well.
(2) These stats(*) tend not to matter what the specific value is. I don't care if someone folds to steal 83% or 85%. If I have two villains folding 80%+ I can steal ATC profitably on the button.
(3) The stats tend to mesh with their color which makes the color easier to remember (e.g. Flop C-bet % is colored by Fold to Flop C-bet %, this makes sense).
(4) I don't play so many tables that I can't just read the numbers for stats when I care about the numbers. If I want to know someone's exact VP$IP, there it is right in front of me.

I find this approach works extremely well for me, but even ignoring the "how do you figure out what is a tight/loose range" question, I wanted to be able to remember what the values behind the colors were. If I have 10 different color ranges to remember, I'll never keep them straight. Creating one color specturm to use universally helped a lot, so I now always know that cyan is 80-90%. For ATS & Fold to 3-bet that means the guy gives up his steals at the drop of a hat (ie- weak play) but for Float Turn % it means that the guy bets the turn a lot if you cbet the flop then "give up" (ie- aggressive play). Remembering what the stat is helps me adjust at the table to the different color values, it does require actual thinking while I play though.

(*) Two of the above stats: 3bet vs steal and LWPC only tend to have very small values, so I used a different set of ranges for these values given that the numbers tend to be compressed. So instead of 10% blocks I went with 2% blocks. As it is, I don't really use the color for LWPC very much, so I could probably replace it with something better, the problem is, I can't figure out what to replace it with. 3-bet vs steal color is great though as you can tell very quickly which people are 3betting vs steals wider than they 3bet normally.



merkur33 wrote:What i wanted to ask: I stumbled across your approach/workarround to get a players actual M. 8-) 8-) 8-) 8-) 8-) 8-) Very cool! I will get something in this direction ASAP. Now what i dont get completely: You said it would work only if one refreshes every hand. I have this set to "every two hands" or even higher, for i think you gain much perfomace by doing this, esp. when multitabling. what would happen if i still refresh every second hand and mybe up the "seconds"-thing to 60 or 70? It would basically work, but lag/be inaccurate at blind changes a little more then your version, or am i wrong? And a second question: by using this timestamp-variable-trick, couldn't we get also a "recent 10 Minutes" or so picture that shows the current image? So maybe we recognise more easy when he changes gears... something i wanted to have since ages... Im always very baffled of how my stats read after 20 or 30 hands and how much they differ from my long term averages, due to bad/good cards/mood or whatever. I would like to know when someone plays very different than his normal style, and then i could start thinking about why he does that and when he better should stop doing it, otherwise i put him on tilt/desperation/fatigue/cleptomania (steal sickness) or whatever.


Yeah, I was particularly happy with the M workaround, I'm glad you like it :)

Setting it to every two hands won't work though unless you also divide the M value by two. You see, what PT3 is actually doing is summing up all values that match a given set of parameters, namely that the hand happened in the last X seconds. If multiple hands get in that range, you'll get double, triple or more of the actual value you want. That's why you want to refresh every hand and keep the number of seconds low - if you don't, you'll get numbers way out of whack. I did quite a bit of testing before settling on 30 seconds. It seemed to be enough time that PT3 could always get there but not so much time that two hands could ever finish within that window.

You could definitely use this plan to get recent temporal snapshots, just the thing to keep in mind is that people can very easily get a run of cards and just raise 3 hands in a row because hey they have the cards to raise. So long as you keep that in mind, feel free to play with it and see what sort of recent X minutes stats work well for you - I'd be curious how those work out if you build them.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Next

Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 19 guests

cron