Player Categorization Custom Stat

[wallacedavidl]

Hey, Team -

This is my first crack at creating a custom STAT. I created two columns, c_vpip and c_pfr, which are copies of VPIP and PFR. i didn't know if I could just use VPIP and PFR directly in the statistic logic or not. Following is the nested if statistic statement I composed. I don't see an option to select a text string type format for it. I get an Invalid message when I seek to validate it. Please advise. Thanks, David.

disp_cat: if ((c_vpip > 20 and c_pfr < (c_vpip – c_pfr))
, format('LAP')
, if (c_vpip <= 20 and c_pfr < (c_vpip – c_pfr))
, format('TAP')
, if (c_vpip <= 10 and c_pfr > (c_vpip – c_pfr))
, format('NIT')
, if (c_vpip >= 36 and c_pfr > (c_vpip – c_pfr))
, format('MAC')
, if ((c_vpip >= 10 and c_vpip <= 20)
and c_pfr > (c_vpip – c_pfr))
, format('TAG')
, if ((c_vpip > 20 and c_vpip <= 35)
and c_pfr > (c_vpip – c_pfr))
, format('LAG')
, format('-'))

[Flag_Hippo]

This is my first crack at creating a custom STAT. I created two columns, c_vpip and c_pfr, which are copies of VPIP and PFR.

There is no column called 'VPIP' or 'PFR' so if you have made copies of items with those names you have copied the statistics and not the columns. The 'VPIP' statistic is calculated using three columns (cnt_vpip, cnt_hands & cnt_walks) in this formula:

Code: Select all

(cnt_vpip / (cnt_hands - cnt_walks)) * 100

If you wanted to format based on stat values you need to reference these columns and not the statistic itself - see this thread for an example.

[wallacedavidl]

What I should've said originally is that I created the c_vpip and c_pfr columns by duplicating cnt_vpip and nct_pfr, so I think that part is okay...

Some else though, on the Statistic Detail tab, there aren't any Available Categories. I will read the post you recommended.

[wallacedavidl]

Hey, thanks a million. I didn't have the correct number of ")" in my statement. Thanks again and respectfully, David.

[wallacedavidl]

I'm now having an issue color coding my new custom stat. So, I have this stat that calculates out TAG, LAG, etc. Based on the value that stat calculates, I want to use various colors. Let's say, if my new PCAT statistic has a value of TAG, I want to display it in RED. How do I write the condition expression on the Color tab to do this?

[wallacedavidl]

Hey, I got it - I needed single quotes.

[wallacedavidl]

I'm doing something wrong. I created a custom statistic that ID player types by using VPIP and PFR. The types displayed in the HUD, such as TAG and LAG don't match the logic of my statistic. Below is my definition of everything and reasoning. Please provide feedback on what I'm doing wrong...

DESCRIPTION:

This statistic categorizes players as LAP, TAP, NIT, MAC, TAG and LAG.


COLUMNS:

Both VPIP and PFR are percentages, therefore, there’s no direct way to directly use them in the math calculations to ID Player categorizations – you must convert them to decimals. Convert each percentage to a decimal by dividing it by 100, and use those columns in the PCAT statistic to ID a player’s categorization.

C_VIP: c_vpip / 100
C_PFR: cnt_pfr / 100



STATISTIC:

if (C_VPIP > .20 AND (C_PFR < (C_VPIP - C_PFR)),
format('LAP'),
if (C_VPIP <= .20 AND (C_PFR < (C_VPIP - C_PFR)),
format('TAP'),
if (C_VPIP <= .10 AND (C_PFR > (C_VPIP - C_PFR)),
format('NIT'),
if (C_VPIP > .36 AND (C_PFR > (C_VPIP - C_PFR)),
format('MAC'),
if ((C_VPIP >= .10 AND C_VPIP <= .20) AND (C_PFR > (C_VPIP - C_PFR)),
format('TAG'),
if ((C_VPIP > .20 AND C_VPIP <= .35) AND (C_PFR > (C_VPIP - C_PFR)),
format('LAG'), format('-')))))))

[wallacedavidl]

I don't see a format spot for custom columns. I want my two columns to be two position decimals.

[wallacedavidl]

Hey, Team -

You can close this one. I just saw cnt_vpip and cnt_pfr are stored as decimals. Lol. Look before you leap. Thanks for everything.