Holdem Manager 2 API - Page 2
Page 2 of 31 FirstFirst 123412 ... LastLast
Results 11 to 20 of 308
  1. #11
    Senior Member
    Join Date
    May 2009
    Posts
    159

    Default

    try

    select * from hands where IsTourney=true

  2. #12
    Member
    Join Date
    Apr 2009
    Posts
    91

    Default

    Is it possible to list other players? Like for instance list of players on my dbase with respective VPIP?

  3. #13
    Member
    Join Date
    Apr 2009
    Posts
    91

    Default

    Should not the following querie return all hands i have played in a torney in the Btn?

    select * from hands where IsTourney=True and PositionType="Button"

  4. #14
    Senior Member
    Join Date
    May 2009
    Posts
    159

    Default

    I assume it should work but does not.

    You can use ButtonOffset=0 instead I think

  5. #15
    Senior Member
    Join Date
    Sep 2011
    Posts
    132

    Default

    Hi!

    I am not sure what I am doing wrong.

    On page 3 of the pdf, the following text is displayed:

    API Testing Tool
    The test API client facilitates development of 3rd party tools by providing a convenient interface to
    run queries which are returned in both a datagrid as well as raw JSON. You can download this
    API here

    However, the link seems broken as the file downloaded is invalid.

    Am I doing something wrong here?

    Thanks in advance!

  6. #16
    Senior Member
    Join Date
    May 2009
    Posts
    159

    Default

    They didn't release it but the mentioned report in this thread is a good substitute.

  7. #17
    Senior Member
    Join Date
    May 2009
    Posts
    159

    Lightbulb stat query bug

    If I query for

    StatThreeBetHeroRaiseFromBB
    StatThreeBetHeroRaiseFromSB
    StatThreeBetHeroRaiseFromBTN
    StatThreeBetHeroRaiseFromCO
    StatThreeBetHeroRaiseFromMP

    they all return the value of StatThreeBetHeroRaiseFromMP

    i.e. http://localhost:8001/Query?q=select...20from%20stats

  8. #18
    Senior Member
    Join Date
    Sep 2011
    Posts
    132

    Default

    Thanks lonelycube

    I was wondering:

    1. Would it be possible to get, for example, a list of players who have a btn steal % of 50 and more?

    2. If not, would it be possible to get the btn steal % for player X? So far, all the stats I seem to be able to get for is StatPlayerNameAndSite

    I tried this, but without success:

    http://localhost:8001/Query?q=select StatTotalHands,StatVPIP,StatPFR,StatThreeBet,StatW entToShowdown, StatPlayerNameAndSite, StatWonShowdown,StatPostflopAggression,StatPostflo pAggressionPercentage where StatPlayerNameAndSite=X

    (I am sorry, my SQL knowledge is very rusty)
    Last edited by nbenitus; 04-29-2014 at 04:48 PM.

  9. #19
    Senior Member
    Join Date
    May 2009
    Posts
    159

    Default

    I think you cannot do 1) as you have to select a player in HM2. So you always query against that player and not the whole "database".

  10. #20
    Senior Member
    Join Date
    Sep 2011
    Posts
    132

    Default

    Thanks again

Similar Threads

  1. Replies: 3
    Last Post: 12-02-2018, 05:29 PM
  2. How Do I Import hands from holdem manager 1 to holdem manager 2?
    By rockstarhobbo in forum General Support
    Replies: 5
    Last Post: 11-11-2011, 09:20 AM
  3. Replies: 1
    Last Post: 11-08-2011, 08:06 PM
  4. Replies: 1
    Last Post: 08-30-2011, 09:58 PM
  5. Latest version of Holdem Manager killed Holdem Manager
    By TLXLM in forum Manager General
    Replies: 2
    Last Post: 09-06-2008, 11:09 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •