Add AvgROI%, as counted by SharkScope

[lumst]

I'm sorry, it seems we are talking about very different things&
I'm telling you that particular statistic takes more than 3 hours to calculate and suggesting the easy way to speed it up to 15 seconds - modify Results page.

Maybe I could get you wrong.
Which way exactly can I add some columns to the "Results/Tournaments/By Buy-In" page?

I just need mathematical statistic of ROI
It doesnt matter technically for me - would it be either PT4 statistic in "My Reports" , or just a column at PT4 "Results/By Buyin", or anywhere else
It only matters that I could get the data within a minute. and be easily useful.
Still feel two new columns would be the best solution

[kraada]

It sounds to me like you're suggesting modifying the default stats in that report. What I'm trying to say is that you can add stats to the report you want. Just right click the report and choose Configure Report. Find the stat you want on the left hand side and double click it to add it to the report. That will add the stat to the report in question.

Also if you created a custom report with just the ROI stat it should load very quickly. Are you seeing the delay with just that stat there?

[lumst]

Oh, yeah. I apologize for misunderstanding from the very start.
I thought you meant "reports" - is the stuff under "My reports" tab, and not at "Results" tab.
Now I see, that the table at "Results/Tournament/By BuyIn" - its "report" too, using your terminology.

Ok, now I have added "Buyins Won" and several derived custom stats to "Results/Tournament/By BuyIn" -> right click "Configure reports".
Yes, as you told, now it goes in 20 secs for all the 85000 tourneys.
Thats good, very good.

So now I just would be aware that the same stats are working very different time at Results page and "My reports" page. Perhaps, "My Reports" could analyze much more stuff than simple Tourney Results page, thats why it looks to all the tables.

[kraada]

Right, My Reports is a lot more powerful - you and do some fancy stuff there. I'm sorry for the confusion but I'm glad we got it all sorted out

[lumst]

Yeah, its working absolutely great. It has inspired me for the next ideas.

1) It would be great to plot the "Buyins Won" line next to lines "My C Net Won($)" and "ROI%".
If all the games would be of the same buyin, the two lines "Buyins Won" and "My C Net Won($)" would be identical.

Sure, "Buyins Won" = "ROI%" * cnt_tourneys.
So these lines would be pretty similar, but now "ROI%" line is almost unusable for me, because of the huge scale at left side: at leftmost few points I always have either -100% or +200%. And rightmost points are always near zero. Their values are almost impossible to read.
I've already reported it https://www.pokertracker.com/forums/viewtopic.php?f=58&t=43894
"Buyins Won" line would be far more readable.

2) BTW, like at SharkScope advanced query, it would be also useful lines "Buyins Won+rakeback", "rakeback($)" and "My C Net Won($)+rakeback($)". And let user specify rakeback percentage in an combobox. So new lines each tourney would be higher and higher than its origins.
Thats the SharkScope's sample of three lines "My C Net Won($), "rakeback($)" and "My C Net Won($)+rakeback($)", when rakeback is user-specified as 58%. So during 25000 games rakeback is $15000.
If user would specify different percentage, say, 40%, lines "rakeback($)" and "My C Net Won($)+rakeback($)" would be lower

[kraada]

(1) You can see a Buy-Ins Won line on the Results -> Overview graph, just tick the "BUY" option - it was added I believe in the last PT4 version that wasn't a Zoom fix.

(2) There should be a couple of rakeback stats in the Warehouse for tournaments - you should be able to use one of those to make these stats and then they will graph properly.

[lumst]

1) Thanks, I've found it. This new feature comes in so invisible manner, so I havent noticed it

2) Thanks for the hint. I have found, how could I insert any stat into "View Stats/T/Graphs" page.
However, warehouse doesn't contain,the right stat, so I had finally to create my own custom: " var_amt_net_curr_conv + amt_fee_curr_conv * 0.58"

Now I have the following graphing trouble: (yes, i'm aware, that "Some stats cannot be displayed in every graph type")
I've created a stat with value "sqrt( cnt_tourneys )". In the report its working fine.
However, in the graph, I cannot draw it correctly. I'd like to see the usual graph for square root. I tried to paint it with the series of black dots here

- if I tick "Sum Results" - it draws straight line, going up
- If I dont tick "Sum Results" - it draws straight horizontal line with value=1
I understand, that graph is being drawed tourney-by-tourney, pixel-by-pixel, and at each point, only one tourney is being observed, and cnt_tourneys=1
Is there, during graphing, some variable, that contains current tourney number in current graph, that I could use in calculation?

[kraada]

I'll have to think a bit about how to draw that - you're right as to why it's not seeing it (at each point the number of tourneys is 1) but it seems like it should be doable. I'll make a note to poke at it and see what I can come up with.

[pt4pt4pt4]

- if I tick "Sum Results" - it draws straight line, going up
- If I dont tick "Sum Results" - it draws straight horizontal line with value=1
I understand, that graph is being drawed tourney-by-tourney, pixel-by-pixel, and at each point, only one tourney is being observed, and cnt_tourneys=1
Is there, during graphing, some variable, that contains current tourney number in current graph, that I could use in calculation?

Try this config if this gives you what you want:


select SUM RESULTS
select MOVING AVERAGE ENABLE
select 5 UNITS

do not select Trails

[lumst]

select SUM RESULTS
select MOVING AVERAGE ENABLE
select 5 UNITS
do not select Trails

No, this config gives me horizontal line with the value=1