Holdem Manager 2 API

[Matjo]

Please request the stats you want so that we can look into it.

3b and cold call all positions vs positions for example.

BB vs EP, MP, CO, BTN, SB (3b/cc)
SB vs EP, MP, CO, BTN (3b/cc)
BTN vs EP, MP, CO (3b/cc)
CO vs EP, MO (3b/cc)
MP vs EP (3b/cc)

It was more a general question if it is very hard to allow these queries or if there is any other reason for not having all the stats queriable.

Best regards,
Mattias

[udbrky]

I have escalated your issue to our 2nd level support techs and they will respond to your email as soon as possible.

[udbrky]

This is not possible in the HM2 API currently. We will keep it in consideration for the future, but we do not have an ETA for when or if it will be.

[mjackson]

Just reiterating the request that all villain stats be made queryable. It may not be a hugely popular request but it would be an absolutely huge addition for the people who want/need to do it.

In the meantime is there any way villain stats can be extracted from the DB itself in postgresql? I tried once but the structure of the data is somewhat mystifying. I'm currently using a clunky homemade autoit script to gather data on villain stats, to say its inefficient hardly describes how bad the process is. Thanks.

[udbrky]

This is not possible. What exactly are you trying to do?

[mjackson]

This is not possible. What exactly are you trying to do?

Just one example is running simple linear regression on two stats, say figuring how closely River fold to cbet single raised pot correlates with totrivfold. How could I easily get a sample for those stats of the 100 players in my db with the most hands?

[fozzy71]

Just one example is running simple linear regression on two stats, say figuring how closely River fold to cbet single raised pot correlates with totrivfold. How could I easily get a sample for those stats of the 100 players in my db with the most hands?

This is not possible in HM2 but it should be possible in HM3 I believe.

[maestro]

Seems LIMIT condition in query works wrong:

SELECT StatPFR FROM stats LIMIT 1000

(returns hero PFR based on first 1000 hands) works fine

SELECT StatPFR FROM stats LIMIT 1000;0

(makes the same) works fine

SELECT StatPFR FROM stats LIMIT 1000;1

(returns hero PFR based on 1-1001 hands) returns "na"

How can I solve the problem?

[udbrky]

What are you trying to query exactly? I'm not personally familiar with using the limit, but in doing some research, this seems like it is by SQL design - the first # is the amount of entries and the 2nd is the # with which the list starts.

[udbrky]

I'm learning more about SQL on codeacademy. I've done some SQL classes, but not as knowledgeable as I want to be. I see about the limit now, but had trouble trying to emulate your code. Can you email us the exact query you are trying to use and let us know what you are trying to create a report of?

Please create a support ticket via the 'Contact Support' link here - https://support.holdemmanager.com/ - and if there is a forum thread with additional information please link to this thread and let us know your forum name if there are several people in the thread.