Holdem Manager 2 API - Page 7
Page 7 of 31 FirstFirst ... 5678917 ... LastLast
Results 61 to 70 of 308
  1. #61
    You're out! udbrky's Avatar
    Join Date
    Jul 2008
    Posts
    20,898

    Default

    We offer a 30-day trial. You can test it and see if we meet your needs. We also provide a lot more than AHK scripts can do.
    Regards udbrky (Chris)

  2. #62
    *** HM3! *** fozzy71's Avatar
    Join Date
    Jun 2005
    Location
    HM Support
    Posts
    32,803

    Default

    Quote Originally Posted by Stasek View Post
    Can this be used to create reports grouping hands by flop highcard for example?
    I'd like to create a report where each row shows flop with that high card (rows for A-high flop, K-high flop etc.)
    Quote Originally Posted by fozzy71 View Post
    I will forward this question to the developers.
    Code:
    select StatTotalHands,StatPlayerNameAndSite,StatNetAmountWon,StatVPIP,StatPFR,StatHighCardOnFlop from stats group by StatHighCardOnFlop

  3. #63
    *** HM3! *** fozzy71's Avatar
    Join Date
    Jun 2005
    Location
    HM Support
    Posts
    32,803

    Default

    Quote Originally Posted by Flowers View Post
    Hi,

    I would like to export all hand histories that i have marked "Review"

    I tried this query:

    select * from handhistories where Reviewhandmarkingexists and HandTimestamp > {d “2014-01-01”}

    But it doesnt work. What query should i type?

    Thanks
    Ben
    Quote Originally Posted by fozzy71 View Post
    This is not a documented property in the HMQL API yet but the developer asked me to write it up as a request to be added later.

    The assigned internal ticket # on this issue is HM-8319: Add Reviewhandmarkingexists property to HMQL API

    I have added your email address to the ticket so we can notify you once we have fixed it.
    This is currently not possible in a single query. You may be able to do it in multiple queries. First,

    Code:
    select * from hands where ForReviewHandmarkingExists=true
    then for each IHM2PlayerHand returned, do this:

    Code:
    select * from handhistories where GameNumberString=xxx

  4. #64
    Junior Member
    Join Date
    Jul 2012
    Posts
    27

    Default

    Hello
    Witch query i must use to get dayly rake and profit?
    Witch query i must use to get dayly VPI and PFR?

    Thanks for help

  5. #65
    Junior Member
    Join Date
    Jul 2012
    Posts
    27

    Default

    Quote Originally Posted by marino11 View Post
    Hello
    Witch query i must use to get dayly rake and profit?
    Witch query i must use to get dayly VPI and PFR?

    Thanks for help
    I have resolvede in this way:
    select StatTotalHands, StatPlayerNameAndSite,StatFullRingPosition, StatNetAmountWon, StatAllInEVAdjustedWinnings, StatRakeAmount,StatEVBBPer100 from stats
    Now I'd like to get stats filtered by date (for example net won of last mont). In wich way can I get this?

    I have try this
    select * from hands where HandTimestamp > {d “20120101”} but this query block API

  6. #66
    *** HM3! *** fozzy71's Avatar
    Join Date
    Jun 2005
    Location
    HM Support
    Posts
    32,803

    Default

    I am sorry for the delay in reply. I will forward this question to the developers.

  7. #67
    Tech Support Manager morny's Avatar
    Join Date
    Jul 2008
    Location
    Ireland
    Posts
    20,888

    Default

    Quote Originally Posted by Matjo View Post
    There are a lot of HM stats that are not available in the appendix? Any ETA when they will appear? I am interested in positional 3b and cold call stats (for example) BB call vs EP raise or Btn 3b vs CO raise.

    Best regards,
    Mattias
    Hi, the latest PDF document now has the full list of report stats available.
    http://www.holdemmanager.com/Downloa...PIGuideV4.docx
    --------------------------------------------------------------------------------------------------------------------
    We welcome any feedback on any solutions we provide, this helps us to provide better quality solutions in the future.

  8. #68
    Junior Member
    Join Date
    Jul 2012
    Posts
    27

    Default

    Quote Originally Posted by fozzy71 View Post
    I am sorry for the delay in reply. I will forward this question to the developers.
    thanks for help. I will attend bug resolution

  9. #69
    You're out! udbrky's Avatar
    Join Date
    Jul 2008
    Posts
    20,898

    Default

    Try putting your date format like this:

    Date Property
    select * from hands where HandTimestamp > {d “2012-01-01”}
    Regards udbrky (Chris)

  10. #70
    *** HM3! *** fozzy71's Avatar
    Join Date
    Jun 2005
    Location
    HM Support
    Posts
    32,803

    Default

    Quote Originally Posted by lonelycube View Post
    .......
    b) The PDF mentions a lot of enums. Which ones are supposed to work?. e.g. "where GameType=4" works but "where FlushDrawType=1" doesn't.

    ......
    We cannot call methods from HMQL. We have added the following properties to replace the get_number... methods:

    Code:
    int GutshotStraightDraws { get; }
     int MadeStraightDraws { get; }
     int NutStraightDraws { get; }
     int OpenEndedStraightDraws { get; }
     int GutshotStraightDrawsToBeatNuts { get; }
     int GutshotStraightDrawsToBeatNutsOnFlop { get; }
     int GutshotStraightDrawsToBeatNutsOnTurn { get; }
     int GutshotStraightDrawsToBeatNutsOnRiver { get; }
     int OpenEndedStraightDrawsToBeatNuts { get; }
     int OpenEndedStraightDrawsToBeatNutsOnFlop { get; }
     int OpenEndedStraightDrawsToBeatNutsOnTurn { get; }
     int OpenEndedStraightDrawsToBeatNutsOnRiver { get; }

    We have added support for enums. The above queries should look like this:

    Code:
    select * from hands where HandCurrency=USD
    select * from hands where MaxStreetSeen=Turn

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
  •