Holdem Manager 2 API

[SossioAruta]

The query I run:

select StatFullRingPosition, StatTotalHands
from stats
where
isTourney = true and
HandTimestamp > {d "2017-06-20 11:59:00 PM"} and
FacingUnopenedPotPreflop = true and
HandAnteSize > 0
and EffectiveStackSizeInBBs >= 12 and
EffectiveStackSizeInBBs <= 15
and NumberOfPlayers >= 8
and NumberOfPlayers <= 10 and
PreflopOpenPotAmountInBB > 10 group by StatFullRingPosition

The filter I use:
ScreenHunter_910 Oct. 27 17.15.jpg
Obv I have the same date filter of the query and I'm in the tournament analysis tab.

Yes, the # of hands returned by the query differs from the # of the filter itself (I'm studing frequencies, so I'm looking for the repetition of a specific situation in another specific situation).

I think the problem is this: selecting for hands where PreflopOpenPotAmountInBB > 10, I've found same hands in which hero is not raising preflop 10bbs, but he is raising 2bb and then, facing a 3bet, he is raising again(4betting)>10bbs! Obv this is not the situation i'm looking for. On the other side, when I use the filter in the report, I have never seen such a situation in a hand reported (in fact, # of total hands by query > # of total hands by filter).

Hope I've been clear.

[SossioAruta]

Any news about my issue?

I have another similar problem: I'm studing min-raise open frequencies (so the query will be something like this: select _stat_ from stats where ... and PreflopOpenPotAmountInBB < x) but in this case it happens that a hand where hero in raise/4betting is not selected. Of course the open raise size is < x but the total amount in bbs raised preflop is > x (after 4betting).

Let me know

[udbrky]

I want to let you know that your issue has been received and will be tested in the order it was received.

Once we have tested and documented it thoroughly we will send you our results and/or ask for any other info/files that we may need to help resolve it.

[garywood]

I want to print out a simple VPIP stat from a specific player using HMQL; how would I do this?
This is as far as I've gotten:
http://localhost:8001/Query?q=select StatVPIP from stats where StatPlayerNameAndSite = "PLAYERNAME"
With the goal to print this player's over all VPIP from all hands played total.

[udbrky]

I want to print out a simple VPIP stat from a specific player using HMQL; how would I do this?
This is as far as I've gotten:
http://localhost:8001/Query?q=select StatVPIP from stats where StatPlayerNameAndSite = "PLAYERNAME"
With the goal to print this player's over all VPIP from all hands played total.

It will only query the active player in reports. So change the player name in reports.

[VinQbator]

Hi,

Will HM-8260 be resolved in HEM2 or we need to wait until HEM3 API? When can we expect HEM3 API to be released?

Thanks!

[udbrky]

I do not have an ETA on either. HM3 is still in Beta. At the minimum, when it is officially released.

[Maskoe]

Hi,
from what i've read its not possible to filter by different players. I need to switch the current player within the actual application.
Is there any way to automate that? loop through all available players and then do my query?

[udbrky]

Hi,
from what i've read its not possible to filter by different players. I need to switch the current player within the actual application.
Is there any way to automate that? loop through all available players and then do my query?

That is not possible. I do not know if it will be for HM3.

[iDev]

API working fine, but no instruction how I can select VPIP for a specific player on the table.


As example:

select StatTotalHands,StatPlayerNameAndSite,StatFullRingP osition,StatNetAmountWon,StatBigBlindsPer100,StatV PIP,StatPFR,StatThreeBet,StatWentToShowdown,StatWo nShowdown,StatPostflopAggression,StatPostflopAggre ssionPercentage from stats group by StatPlayerNameAndSite

http://localhost:8001/Query?q=select...yerNameAndSite

Response:

{
  "ResultType": "Stats",
  "Errors": [
    
  ],
  "QueryTime": 1.4976,
  "Results": [
    {
      "Player": "P NAME",
      "Position": ""EP+2"",
      "bb100": "-15.70",
      "NetWon": "579.00",
      "PFR": "0.22",
      "Agg": "1.00",
      "Agg%": "0.30",
      "3Bet": "0.17",
      "TotalHands": "39",
      "VPIP": "0.23",
      "WTSD%": "0.56",
      "W$SD%": "0.60"
    }
  ]
}

How to change a player on request to API?
At the moment default player selected from HM UI.