Holdem Manager 2 API

[Xyton]

Hi,

I didn't find how to select only hands played at Speed Poker. I tried using GameTypeDescription by giving it the result of StatGameTypeDescription (for example "€0.10/€0.20 NL Fast Holdem") but it doesn't work. A similar problem would be to select only NL hands or FL hands, mixing the two wouldn't be good...
Could you please give me some example to select all "NL Fast Holdem" hands or only "€0.10/€0.20 NL Fast Holdem" hands?

[fozzy71]

Hi,

I didn't find how to select only hands played at Speed Poker. I tried using GameTypeDescription by giving it the result of StatGameTypeDescription (for example "€0.10/€0.20 NL Fast Holdem") but it doesn't work. A similar problem would be to select only NL hands or FL hands, mixing the two wouldn't be good...
Could you please give me some example to select all "NL Fast Holdem" hands or only "€0.10/€0.20 NL Fast Holdem" hands?

Please try this:

select * from hands where GameType=GameType.Value

where Value is one of the GameType enums listed below.

    public enum GameType
    {
        AllGames = -1,
        HoldemNL=0, HoldemPL=1, HoldemFL=2, OmahaNL=3, OmahaPL=4, OmahaFL=5,
        HoldemNLRush=6, HoldemPLRush=7, HoldemFLRush=8, OmahaNLRush=9, OmahaPLRush=10, OmahaFLRush=11,
        HoldemNLCAP=12,
        OmahaHiLoNL=13, OmahaHiLoPL=14, OmahaHiLoFL=15, OmahaHiLoNLRush=16, OmahaHiLoPLRush=17, OmahaHiLoFLRush=18,OmahaPLCAP=19, 
        AllHoldem=20, AllOmaha=21,
        HoldemNLZoom = 22, HoldemPLZoom = 23, HoldemFLZoom = 24, OmahaNLZoom = 25, OmahaPLZoom = 26, OmahaFLZoom = 27, OmahaHiLowPLZoom = 28, OmahaHiLoFLZoom = 29, OmahaHiLoNLZoom = 30,

    };

[Xyton]

Hi,

Thank you for the reply, it works! Using value 22 returns Speed Holdem (iPoker) hands.

Btw, I noticed that with value 0 (i.e. HoldemNL) I get Cash and Tournaments hands. To get only Cash hands, I have to add the condition IsTourney=false. It didn't seem really natural at first...

[udbrky]

Thank you for the information.

[marino11]

HMQL consider hands played for fun.

Is there a way to purge hand played for fun or to filter this hands?

Thanks

[fozzy71]

We do not support/import play money hands. If some were imported please email them to us so we can prevent them from being imported in the future. You can manually delete them from the reports with the right click menu or if they are all one specific/odd stake they can be purged from the Database menu.

[marino11]

Sorry,

can I filter only hand played in cashgame?



with this query

select StatPlayerNameAndSite,StatNetAmountWon,StatNetAmountWonEUR,StatTotalHands,StatRakeAmount,StatEURRake from stats 
group by 
statgametypedescription

The last row consider hand played in tourney, but the problem is that net won tourney will beadded to won win in cash. (chip won or lost in tourney will considered maoney win or lost in cash, so 1000 chip il 1000 €)

with this query

select StatPlayerNameAndSite,StatNetAmountWon,StatNetAmountWonEUR,StatTotalHands,StatRakeAmount,StatEURRake from stats

i will obtain aresults that consider fake win in tourney.

can I filter only hand played in cashgame?

Thanks

[udbrky]

Sorry,

can I filter only hand played in cashgame?



with this query

select StatPlayerNameAndSite,StatNetAmountWon,StatNetAmountWonEUR,StatTotalHands,StatRakeAmount,StatEURRake from stats 
group by 
statgametypedescription

The last row consider hand played in tourney, but the problem is that net won tourney will beadded to won win in cash. (chip won or lost in tourney will considered maoney win or lost in cash, so 1000 chip il 1000 €)

with this query

select StatPlayerNameAndSite,StatNetAmountWon,StatNetAmountWonEUR,StatTotalHands,StatRakeAmount,StatEURRake from stats

i will obtain aresults that consider fake win in tourney.

can I filter only hand played in cashgame?

Thanks

Hi,

Thank you for the reply, it works! Using value 22 returns Speed Holdem (iPoker) hands.

Btw, I noticed that with value 0 (i.e. HoldemNL) I get Cash and Tournaments hands. To get only Cash hands, I have to add the condition IsTourney=false. It didn't seem really natural at first...

Check this out, try adding the condition to filter out the Tournament hands.

[marino11]

Check this out, try adding the condition to filter out the Tournament hands.

IsTourney=false

It works. Thanks

[udbrky]

Thank you for letting us know this is resolved.

Good luck at the tables,

Please let us know if we can help with anything else.