create a stat

[masterblaster1984]

so another tracker has a stat that tells for how many hands a player hasnt raised pre flop. but the pt4 doesnt have it, i want to make a custom one.

problem is i dont know how to start, or where to start from. can you guys help me out with the definition, columns and expressions? thanks

[WhiteRider]

So is this just the opposite of PFR (how often the player raised preflop), or is it something like hands where the player VPIP'd but didn't raise?

[masterblaster1984]

So is this just the opposite of PFR (how often the player raised preflop), or is it something like hands where the player VPIP'd but didn't raise?

lets say the tracker has 50 hands from a certain tourney table since it has started. so player Y has made his last preflop raise in hand 27. all hands before that, for his stat alone are irrelevant, cause the tracker will show this stat like "23". it will just matter for how many hands this certain player hasnt raised pre. its not a %.

this must be pretty doable, but im having a blank on my mind. dont know how should a start with definitions.

[masterblaster1984]

i see like, a stats that is counting the number of hands (on the specific table alone), and it goes to zero again each time the player makes a pfr.

[kraada]

This isn't an easy one to build - you'll need direct SQL for it for certain.

[masterblaster1984]

This isn't an easy one to build - you'll need direct SQL for it for certain.

i cant see why =(

maybe my bad english wasnt able to communicate properly. its not the whole hud itself that will reset each time the player makes a pfr. its just the counting of the stat. if player hasnt made a raise neve in 100 hands, it will show 100. if player in all hands he played in the table has made a raise 10 hands ago and then nevermore, the stat will show 10. seems like the simplest stat in terms of programming, but i am a noob in it =p... so... i dont know. kinda need help here.

[4StarGen]

You cannot see why because you don't have a clue about custom stats, how PT4 and trackers in general work and SQL in general. The answer kraada gave you is obv, the correct one. If you really want some help, which is obv beyond the scope of this forum, you should contact some premium developer. Maybe they can help you. GL

[masterblaster1984]

You cannot see why because you don't have a clue about custom stats, how PT4 and trackers in general work and SQL in general. The answer kraada gave you is obv, the correct one. If you really want some help, which is obv beyond the scope of this forum, you should contact some premium developer. Maybe they can help you. GL

probably. just had to make sure that i was being able to communicate correctly, and not passing the wrong idea of what i wanted from a custom stat. english is not the main language for many like myself, so i apologize for insisting.

another question i have. if i set the cold call 2bet stat just for the sb, will it account hands that sb limped and called a raise from the bb too? or just hands that where raised from players behind the sb?

[kraada]

I understand what you want, it's just that our database doesn't store data in such a way that makes it easy to build stats in a "last X hands" manner like you want. The need for the direct query is specifically to calculate that value. It's probably possible to do with ORDER BY and LIMIT but you'd need to be careful to get the SQL right.

You can't cold call from a blind - you can only cold call when you have no money in the pot and, by definition, you have money in the small blind. That stat won't show any values in that position. What exactly are you looking to see? I'll tell you which stat is the right one.

[masterblaster1984]

I understand what you want, it's just that our database doesn't store data in such a way that makes it easy to build stats in a "last X hands" manner like you want. The need for the direct query is specifically to calculate that value. It's probably possible to do with ORDER BY and LIMIT but you'd need to be careful to get the SQL right.

You can't cold call from a blind - you can only cold call when you have no money in the pot and, by definition, you have money in the small blind. That stat won't show any values in that position. What exactly are you looking to see? I'll tell you which stat is the right one.

thank you for yout patience again.

im looking for a stat that shows me the % of times a player called a single raise. i thought that was cold call 2bet. by what you are saying, that would work for other positions but not the blinds, correct? so what should i use if i want to see how many times the small blind is calling against a button steal?