Calculating granted Betfred-Points (BFP)

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

Calculating granted Betfred-Points (BFP)

Postby MeHasFlush » Sun Nov 01, 2009 12:22 pm

Hi,

i want to make a custom stat that calculates my VIP-Points on Betfred Poker (BFP), that i earn per MGR. But as i'm completely new to custom stats, i'm a little bit lost ^^. Maybe you can help me out (i only want to calculate for the highest Level "Diamond")?

GOAL: Calculate the BFP for every hand (if nessesary) and display them as a sum in the "General" tab behind each played limit.

I can describe how the stat should look in general, but i don't know how to translate it to the correct syntax and how to implement that in PT3:

- there are 8 different level of rake (MGR) taken
- for each level different BFP amounts are granted
- as i only need it for the VIP level diamond, the BFP are fix for each level

so the general calculation should look like this, right (the amounts are real values, taken from the betfred site)?

Code: Select all

if[holdem_hand_summary.amt_mgr >= 0.1 AND holdem_hand_summary.amt_mgr <= 0.25] -> BFP = 0.25
if[holdem_hand_summary.amt_mgr >= 0.26 AND holdem_hand_summary.amt_mgr <= 0.50] -> BFP = 2
if[holdem_hand_summary.amt_mgr >= 0.51 AND holdem_hand_summary.amt_mgr <= 1.00] -> BFP = 4
if[holdem_hand_summary.amt_mgr >= 1.01 AND holdem_hand_summary.amt_mgr <= 1.50] -> BFP = 7
if[holdem_hand_summary.amt_mgr >= 1.51 AND holdem_hand_summary.amt_mgr <= 2.00] -> BFP = 9
if[holdem_hand_summary.amt_mgr >= 2.01 AND holdem_hand_summary.amt_mgr <= 2.50] -> BFP = 13
if[holdem_hand_summary.amt_mgr >= 2.51 AND holdem_hand_summary.amt_mgr <= 3.00] -> BFP = 15
if[holdem_hand_summary.amt_mgr >= 3.01 AND holdem_hand_summary.amt_mgr <= 5.00] -> BFP = 15



What do i have to do to convert this to a real stat and how do i do it?

Thank you very much for your help in advance!
MeHasFlush
 
Posts: 18
Joined: Fri Mar 28, 2008 5:52 pm

Re: Calculating granted Betfred-Points (BFP)

Postby WhiteRider » Sun Nov 01, 2009 1:07 pm

There are already stats like this for other sites available for download from the Repository. Have a look at how one of those is built and you should be able to adpat it to your needs - it sounds like you understand roughly what you need to do.
Custom Statistics and Reports FAQ
If you need further help please post back and tell us where you are stuck.
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 7 guests