new report request

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

new report request

Postby mrj3 » Mon Apr 13, 2009 11:33 am

I cant create custom stats or reports, but find them really useful.
Maybe soemone who can find my idea worth to make it.

So I think river calls should be monitored in comparison of the existing pot size.

If you want to find out wheter or not your river call are profitable, you normally filter "any river calls" for it would count all the money you invested in the pot during the whole hand included all the streets.

I think it would be much more accurate If you have to call 60 into a pot of 160 (100+60) the report only counted that you lose 60 with the call, but win 160 if you win.

for example if you raise flop, turn, with your set, and CS calls with flushdraw, which gets there by the river, and my opponent goes allin and has 10+12BB left for a pot of 160BB I would consider I only lose 10+12BB with that call.

I hope I could explain myself:)

regards
mrj
mrj3
 
Posts: 15
Joined: Thu Oct 09, 2008 8:17 am

Re: new report request

Postby kraada » Mon Apr 13, 2009 1:02 pm

It sounds like you're requesting a particular statistic more than a report?

I'm not sure what you would want on the report: the pot size of the river when you're facing a bet and you call, and the amount you had to call, and what else?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: new report request

Postby mrj3 » Mon Apr 13, 2009 4:09 pm

kraada wrote:It sounds like you're requesting a particular statistic more than a report?

I'm not sure what you would want on the report: the pot size of the river when you're facing a bet and you call, and the amount you had to call, and what else?


Ill try to explain.
I would like to find out if river calls are profitable, counting only the money I have to put in on the river.

lets say HU.
1. like if the pot is 50 on the river and my opponent bets 30 I have to call 30 and win 80 if I win but if I lose, I only lose 30
2. If you filter "any river call" now, tracker would say I win (50+30+30)/2=55 and lose the same amount if I lose.

But if there is a river bet, the money on the middle is not yours any more, so you can look at it as if it were dead money regarding your call.
I would like the report to sum river calls profit counting with case 1.
mrj3
 
Posts: 15
Joined: Thu Oct 09, 2008 8:17 am

Re: new report request

Postby kraada » Mon Apr 13, 2009 5:16 pm

You'll need to create two new stats for this report:

River Bet Facing and Amount To Win on River.

You'll want to create both in the Holdem Cash Hand section.

River Bet Facing will be equal to holdem_hand_player_detail.amt_r_bet_facing

Amount To Win on River is a bit trickier. I'm defining this to be the amount you would win given that you:
(a) face a bet on the river
(b) don't face a raise on the river
and
(c) there are no people who can overcall after you.

I'd like to avoid (c) issues, unfortunately the database isn't robust enough to handle that particular case.

ATWoR is defined as: 100 * holdem_hand_player_detail.amt_r_bet_facing / holdem_hand_player_detail.val_r_bet_facing_pct

This works because the bet facing can be thought of as a fraction: (current bet / size of pot) * 100. Therefore since we know the current bet you can retrieve the size of the pot.
(Let b = the size of the bet, p = the size of the pot previous to the bet. val_r_bet_facing_pct in those terms is 100 * b / p, and amt_r_bet_facing is b. To get p, then, we divide b by b/p*100 which yields p/100. Multiplying by 100 yields p.)

Create a report with those two custom stats while using the simple filters for facing a river bet and seeing a showdown and not raising and you'll see what I think you want.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: new report request

Postby mrj3 » Mon Apr 13, 2009 6:27 pm

thank you,

Ill get on it and report when its done:)
mrj3
 
Posts: 15
Joined: Thu Oct 09, 2008 8:17 am

Re: new report request

Postby mrj3 » Tue Apr 14, 2009 11:58 am

I am not much of a programer:) I have been trying though but cant even create this correctly
River Bet Facing will be equal to holdem_hand_player_detail.amt_r_bet_facing

It sais the the expression is not valid.

I tried to check other stats for example but it defines its own functions and stuff.

Is there a tutorial for this with simple examples to start for an absolute beginner?
mrj3
 
Posts: 15
Joined: Thu Oct 09, 2008 8:17 am

Re: new report request

Postby kraada » Tue Apr 14, 2009 12:32 pm

The Custom Stats and Reports FAQ has links to several simple walkthroughs that should help.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


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

Who is online

Users browsing this forum: No registered users and 4 guests

cron