RFI or Steal from all positions. And complete from SB.

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

RFI or Steal from all positions. And complete from SB.

Postby nyjedsazi » Mon Sep 27, 2010 10:35 am

I mean utg1, utg2, utg3, mp1, mp2, mp3.

Can I use for that Attempt to Steal? (Because I already made stats, but I don't know works it or not, because they don't work, but maybe )

I need to do RFI from all positions. But can I use as the basis for this attempt to steal stats? I ask because I had already made such stats, but I do not know if they do not work by themselves or because I have not made the database cache. Or ATS is not suitable, as originally made only for the latter position and need to make them using the RFI?

1 Another thing I would do complete sb and limp btn stats when there is no raisers or limpers, as a basis, I took ats_opportunities. Add limp in numerator and ats_opp in denominator. It works.

2 But after that I decided to make new stats: complete and face raise and fold / complete and face raise.

3 And one more : complete and not face raise and bet flop / complete and not face raise.

Now in stats denominator in last two stats shows the same results like 1st stats. Why?

And it is true that for correct working new stats every time I need to do database cache?
This is a very long time and I saw that the new stats can work without it, the only doubt has caused the situation to the RFI from all positions.
nyjedsazi
 
Posts: 42
Joined: Thu Jun 03, 2010 5:04 pm

Re: RFI or Steal from all positions. And complete from SB.

Postby kraada » Mon Sep 27, 2010 10:50 am

I believe there are RFI stats available by position in the repository, you may want to take a look there to see if you can save yourself time and effort here.

You cannot attempt to steal in any position other than the CO, BTN or SB - those are the only positions where stealing is possible. With regards to (2) and (3), what were you using as your oppotunities column? You'll probably want to use the times they actually completed, not the times they had a chance to.

You need to update the cache in order for data to work in the HUD. If you want to test a stat you can do that in a custom report without updating the cache, just the report will take a little while.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: RFI or Steal from all positions. And complete from SB.

Postby nyjedsazi » Mon Sep 27, 2010 11:47 am

All stats works after cache. Of course except ats from utg and etc.

Thank you! Your help is as always very useful.
nyjedsazi
 
Posts: 42
Joined: Thu Jun 03, 2010 5:04 pm

Re: RFI or Steal from all positions. And complete from SB.

Postby nyjedsazi » Mon Sep 27, 2010 12:35 pm

And one more question, сan I run the report separately for different levels of blinds?
nyjedsazi
 
Posts: 42
Joined: Thu Jun 03, 2010 5:04 pm

Re: RFI or Steal from all positions. And complete from SB.

Postby kraada » Mon Sep 27, 2010 1:29 pm

Yes, you can, if you add the Limit stat then it'll break the report up by limit. If you only want to see data from one limit and only see one line of data per player, you can filter via the blue Filters link on the left.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: RFI or Steal from all positions. And complete from SB.

Postby nyjedsazi » Mon Sep 27, 2010 3:21 pm

kraada wrote:Yes, you can, if you add the Limit stat then it'll break the report up by limit. If you only want to see data from one limit and only see one line of data per player, you can filter via the blue Filters link on the left.


I need that for tourneys. I didn't find limit stat in config in report menu. Please explain how to do that in details. Thank you.
nyjedsazi
 
Posts: 42
Joined: Thu Jun 03, 2010 5:04 pm

Re: RFI or Steal from all positions. And complete from SB.

Postby kraada » Mon Sep 27, 2010 4:14 pm

The stat you want is called "Blinds" - sorry I was giving you the cash games version.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: RFI or Steal from all positions. And complete from SB.

Postby nyjedsazi » Mon Sep 27, 2010 6:14 pm

Yeah, i tried it when you said about limits, but it doesn't work too.
nyjedsazi
 
Posts: 42
Joined: Thu Jun 03, 2010 5:04 pm

Re: RFI or Steal from all positions. And complete from SB.

Postby kraada » Mon Sep 27, 2010 6:37 pm

What happens when you add that stat to your report then?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: RFI or Steal from all positions. And complete from SB.

Postby nyjedsazi » Tue Sep 28, 2010 8:01 am

I installed the new version and it works now. :D
nyjedsazi
 
Posts: 42
Joined: Thu Jun 03, 2010 5:04 pm


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

Who is online

Users browsing this forum: No registered users and 0 guests