"Hands in K" and format expression question

[mager]

Hey.
I have two question:

1. I could not make "Hands in K" work in PT4. I tried to copy the format expression from PT4:
if( (this>999 , format( '{1}k' , format_number((this / 1000) , 1 , false , false))) , this )
*(PT4 automatically change to "this" if it is the same as the value expression right?)
And it does not work. Why and how to change it?

2. I want my HUD to look more organized. In order to do so I want 100 to be seen as 99, and that the "space" for each stat on the HUD will be on the same size(based on 2 digits). I found this thread:
https://www.pokertracker.com/forums/vie ... 18&t=30233
Which after some tweaking they ended up with this expression in order to do such a thing:

Code: Select all

if ( ((cnt_vpip / cnt_hands) * 100) > 99.5, '99', (format( '{1}{2}', if ( ((cnt_vpip / cnt_hands) * 100) < 9.5, '  ', ''), format_number( ((cnt_vpip / cnt_hands) * 100), 0, false, false) ) ))

*((cnt_vpip / cnt_hands) * 100) is an example of course).
Should it work in PT4 the same way or should I change anything?
Also if I add this expression, would the stat keep being "decimal percent" formatted or it's either this or that?

3. What is "Summary type"?

Thanks.

[WhiteRider]

1. That should be fine - that's exactly what I have and it's working OK for me. What exactly isn't working?

2. That kind of expression should work the same way in PT4. It won't be "decimal percent" formatted - that expression is defining the exact formatting.

3. Summary Type is the formatting used in the summary row of reports. It doesn't affect the HUD.

[mager]

1. It generates some kind of error on the table.
I don't remember the exact error and I can't check it out because i'm importing hands. I will come back to you with this later.

2. It's probably silly, but what exactly "decimal percent" do? I see it as default on most stats. Should I add it manually to the stat's i'm adding my above custom formatting?

3. Can I use "this" instead of the whole value expression in all cases? so I will just use this formatting:

Code: Select all

if ( (this > 99.5, '99', (format( '{1}{2}', if ( (this < 9.5, '  ', ''), format_number( (this, 0, false, false) ) ))

On all of the stats? Also, in the thread you came with this formatting code, you said I need to put the same expression in the Value Expression and the Format Expression. Is it still the case? If so, putting "this" won't be right I guess.

4. Can I format a stat to only see it if it's "above/below X" AND "happened Y times"? So for example i'll use "fold to steal" for hero, and I want to see it ONLY if it's above 60%, and if it is happened more than 10 times.
It will be an efficient way to see if I'm getting exploited while multi tabling.

5. I forgot I should not import batches larger than 250K hands. I'm on ~700K/1.2M hands and i'm already down to 18 h/s which is very slow. Should I stop the import, divide it to 4-5 batches and start all over again? 60% of the hands will be duplicates but it will still finish up much fast, no?

Thanks.

[kraada]

(2) The Percent format type shows you values as a percentage - decimals allows that percentage to display decimals rather than rounding as a whole number. Since most stats are percentages most stats have this format type (you'll see that Hands is formatted as a Number).

(3) Yes, that's why we added the shortcut "this" - it makes life simpler

(4) Yes, you can use any columns in the format expression when it's an expression. For example you could have if ( this > 60 and cnt_steal_def_action_fold > 10, format_number( (this, 0, false, false), ' ')

(5) You can do this but if you check the PokerTracker.log file you can see which files were imported and save yourself the trouble of having to wait for those duplicates to be processed - going through the files and moving out the ones that were already processed by hand is likely going to be faster than waiting through duplicates.

[mager]

Here is the error I get on the table for the hands in K:
"Expression: Invalid operation specified in expression"

Why is it and what should I do?

[kraada]

It's because I missed a ) - if ( this > 60 and cnt_steal_def_action_fold > 10, format_number( (this, 0, false, false), ' ')) will work.

[mager]

It's because I missed a ) - if ( this > 60 and cnt_steal_def_action_fold > 10, format_number( (this, 0, false, false), ' ')) will work.

I was talking about the hands in K stat:
if( (this>999 , format( '{1}k' , format_number((this / 1000) , 1 , false , false))) , this )

[mager]

Also, this templet:

Code: Select all

if ( (this > 99.5, '99', (format( '{1}{2}', if ( (this < 9.5, '  ', ''), format_number( (this, 0, false, false) ) ))

(I tried also using the value instead of 'this')

Is not working. It writes that its invalid expression.
If I add "/%.2f," before, it say it is valid but it does not work on table(it just show the full expression on the table instead of the stat formatted).
(I tried adding few more ")" in the end - it made it valid but still showed the expression instead of the stat on the table)

Lastly, the stats creation is kinda buggy. It sometimes does not save the format expression, it sometimes get messed up and ask if you want to save after you saved some stat but moved to other stats already(and made no change to them). it sometimes delete the whole stat(or column, or columns and stat which based on them) if you click 'save' and then 'cancel'. Pretty annoying but it's beta after all
Can I remove the whole custom stats and columns and re-import them? I did back up to them before I started messing with them.

[kraada]

Yes you can remove and reimport custom stats - the problem with your code snippet is that you are missing three )s at the end.

Can you reproduce the problems with the stats being removed improperly? If so, and you can give us the steps, we will definitely make certain that gets fixed.

[mager]

Yes you can remove and reimport custom stats - the problem with your code snippet is that you are missing three )s at the end.

Can you reproduce the problems with the stats being removed improperly? If so, and you can give us the steps, we will definitely make certain that gets fixed.

1. I tried using it with proper amount of ")":

Code: Select all

if ( (this) > 99.5, '99', (format( '{1}{2}', if ( (this) < 9.5, ' ', ''), format_number( (this), 0, false, false) ) ))

Still not working. It is valid but it shows the full format expression on the table instead of the stat.

2. My "hands in K" still not working - as I wrote above.

3. I know I can remove and reimport custom stats. The question is can I remove all of my custom columns and stats at one and then reimport it from the backup I made? I just don't want duplicates and it I don't want it will become messy.

4. I wrote the steps of making it remove improperly: If I change something in a stat or column, press "save" and then "cancel" instead of "ok" to get out of the statistics tab.
The other problem occur when you save multiple amount of times(different stats) - without pressing quitting and re-entering the statistics tab again.