SNG Tracker 2.0

[MortenTA]

this just looks sooo nice.. its like christmas [img]/images/graemlins/grin.gif[/img]

[rvg72]

[ QUOTE ]
Marry me.

[/ QUOTE ]

Well with the amount of time I spent between programming and watching the world cup over the weekend I might just be single now... What are the chances that you are a hot chick?

[WebGuySteve]

I [img]/images/graemlins/heart.gif[/img] RVG

[rvg72]

Here is tonight's screen shot - this tab is taking longer than I thought but it is looking pretty nice. It shows your finish distribution and running finish distribution for the current filter. So, you can quickly see how your 1st place or any other position % has dropped or gained over time. There are still a few things missing on this tab and a bug (the last entry in the running chart should equal the frequency in the overall chart) but that's all I got in me tonight.

[costanza_g]

[ QUOTE ]
Finish distribution over time

[/ QUOTE ]

That is sick!!! [img]/images/graemlins/shocked.gif[/img]

[AllinDan]

[ QUOTE ]
I [img]/images/graemlins/heart.gif[/img] RVG

[/ QUOTE ]

[bruin]

this looks freakin' sexy.

keep up the good work.

[Paul B.]

Hey rvg, SNGT2 is looking good so far. I don't like how high the Finish Distribution chart is.. it takes up too much vertical space and the hollow middle kind of hurts my eyes, to be frank. What I think would be interesting would be to compare finish distributions in a clustered column (like in Excel).

Like this...

... but with finish distribution for specified buyin levels. On its own tab, since it would be pretty big.

If you can't do that, I think it would be better having three separate charts where the one chart is now.

[ben_]

[ QUOTE ]
[ QUOTE ]
Hey rvg, could you plot hourly rate by tourney? Kind of like the "ROI/ITM" tab in version 1, but with hourly rate.

[/ QUOTE ]

Good ideas - keep them coming.

[ QUOTE ]
Edit: one more thing. I import my SNGs from PT. Could you make sure that SNG Tracker 2.0 counts "1-Table" and "Speed/Turbo" SNGs as the same? thanks

[/ QUOTE ]

I never use Poker Tracker for SNG's (just Limit) - could you explain this a little more? DId PT used to count them as 1-Table and now it calls them SPeed/Turbo? If so, how do you know that "1 Table" is a speed and not a regular? I'm going to have to import a bunch of my SNG's into PT to see but any info you can give me now will speed things up for me.

thanks,

rvg

[/ QUOTE ]


RVG,

If you take a look at the PT database, and check out the tourneys table, you will notice a "table_type" column.
The different values are as follows.

S&G 1 Table 1
Multi-Table 2
Heads Up (2 pl.) 3
S&G 2 Table 4
S&G 3 Table 5
Heads Up (4 pl.) 6
Heads Up (MTT) 7
S&G 5 Table 8
S&G Speed//Turbo 9
S&G 1 Step 10
S&G 1 Step Higher 11
S&G 1 Step Mini 12
S&G Qualifier 13
S&G 2 Step 14
S&G 2 Step Higher 15
S&G 2 Step Mini 16
S&G 6 Players 17

So you will want to import those columns with the value 1 or 9.
You might want to run something similar to

<font class="small">Code:</font><hr /><pre>
SELECT tourney.site_id,
tourney.tourney_start,
tourney.tourney_end,
tourney.tourney_number,
tourney.buy_in,
tourney.fee,
tourney.table_type,
tourney.tourney_type,
tourney.number_of_players,
tourney_summary.amt_won,
tourney_summary.place_of_finish,
Ltrim(tourney.tourney_number) AS tournament_number,
tourney_summary.actual_buy_in AS abuyin,
tourney_summary.actual_fee AS afee
FROM tourney,
tourney_summary,
poker_sites,
tourney_summary AS winner,
players
WHERE (tourney.tourney_id = tourney_summary.tourney_id)
AND (tourney.site_id = poker_sites.site_id)
AND (tourney_summary.player_id = (SELECT player_id
FROM players
WHERE screen_name = 'Player Screen Name To Import'))
AND (tourney.tourney_id = winner.tourney_id)
AND (winner.player_id = players.player_id)
AND (tourney.table_type IN (1,
9))
AND (winner.place_of_finish = 1);
</pre><hr />

Cheers,
ben

[rvg72]

Thanks a lot Ben,

rvg