Possible to find out $/hour depending on MT-ratio?

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

Possible to find out $/hour depending on MT-ratio?

Postby lolbadbeat » Wed Dec 29, 2010 4:55 pm

Hello there,
i play FL SH on 6 to 10 tables and have a hard time really figuring out what the optimal number of tables are regarding my hourly, so is it possible to run a query or script or something on my database that finds out what my hourly earnings are dependent on number of tables? would it also be possible to add rakeback to that calculation if i know the exact RB/hour/table amount?

Sorry if this is a stupid question or poorly worded, i am a tech-noob and english is my third language :)

Cheers
lolbadbeat
 
Posts: 21
Joined: Tue Jan 19, 2010 5:09 am

Re: Possible to find out $/hour depending on MT-ratio?

Postby kraada » Wed Dec 29, 2010 5:58 pm

You can find your true hourly winrate on the Sessions tab by choosing the "Sessions - By Time" report from the drop down at the top left. Since you'll see your total number of hours played in that top report, you should be able to calculate RB/hr easily from there.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Possible to find out $/hour depending on MT-ratio?

Postby lolbadbeat » Wed Dec 29, 2010 10:17 pm

i knew my post wasn't clear enough :)

i need my hourly in relation to the number of tables i play
since i sometimes play 4, sometimes 6 or 8 and sometimes up to 10 tables at once, i assume i have different winrates depending on the number of tables i play, and there has to be a breaking point where the drop in WR is too high to be compensated by the higher number of hands per hour. what i want to know is, with which number of tables do i have the maximum $/hour and would like that info from data of my previous play, if possible i would like to add the RB amount per table and hour to that calculation.
lolbadbeat
 
Posts: 21
Joined: Tue Jan 19, 2010 5:09 am

Re: Possible to find out $/hour depending on MT-ratio?

Postby WhiteRider » Thu Dec 30, 2010 5:55 am

It isn't really possible to do exactly what you want. You can sort the "Sessions by Time" report by MT Ratio to get a feel for how your results change down the list, but you can't filter by it.
You could Expand and then Export the report and import it into a spreadsheet application to analyse your results further.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


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

Who is online

Users browsing this forum: No registered users and 5 guests