Search found 740 matches

Return to advanced search

Re: Range of Omaha hole cards in Filter Expression

    Can you give an example of what you want to achieve? Other than Hero holecards? And in what kind of report? Because if the queriy is put together in a certain way, a lot is possible in the Filter Expressions.
    by BillGatesIII
    Fri Sep 01, 2017 12:52 pm
     
    Forum: Custom Stats, Reports and HUD Profiles
    Topic: Range of Omaha hole cards in Filter Expression
    Replies: 9
    Views: 1345

    Re: Range of Omaha hole cards in Filter Expression

      I guess I don't understand your question. Why not use a Omaha Hi Hand Range Filter?

      Code: Select all
      67**,68**,69**,6T**,78**,79**,7T**,89**,8T**,9T**

      2017-08-30 (2).png

      2017-08-30 (3).png
      2017-08-30 (3).png (10.87 KiB) Viewed 1326 times

      2017-08-30 (4).png
      2017-08-30 (4).png (19.44 KiB) Viewed 1326 times

      Or are you looking for something else?
      by BillGatesIII
      Wed Aug 30, 2017 2:31 pm
       
      Forum: Custom Stats, Reports and HUD Profiles
      Topic: Range of Omaha hole cards in Filter Expression
      Replies: 9
      Views: 1345

      Re: All-In Equity explained

        We do have hand statistic functions 'equity_icm' and 'equity_icmpct'. It should be possible (I guess kind of easy) to add a 'equity_street' function?
        by BillGatesIII
        Sun Aug 27, 2017 12:03 pm
         
        Forum: PokerTracker 4
        Topic: All-In Equity explained
        Replies: 11
        Views: 9302

        Re: To Separate Second pair from third

        The PT4 parser gets confused when using if[] with comma's inside. The workaround is to use 'case when ... end' (that is how the if[] statement is translated to PostgreSQL by PT4 so basically we are just doing it for them already). sum(case when mod(cash_hand_summary.card_2 - 1, 13) = 2 then 1 else ...
        by BillGatesIII
        Wed Aug 16, 2017 5:14 am
         
        Forum: Custom Stats, Reports and HUD Profiles
        Topic: To Separate Second pair from third
        Replies: 16
        Views: 4845

        Re: API for plug in development

          Would you like to further explain your question? Perhaps with some examples of the use of such an API?

          Thanks.
          by BillGatesIII
          Mon Aug 07, 2017 4:20 am
           
          Forum: PT4 Feature Requests
          Topic: API for plug in development
          Replies: 2
          Views: 1231

          Re: Geometric mean of tournament players

          There is no easy way to multiply the tournament fields, you'll have to write you own function. But because of the number of players in (bigger) tourneys, changes are you will run into mathematic overflows if you multiply a lot of tourney. With some simple math, there is a way to work around that. S...
          by BillGatesIII
          Sun Aug 06, 2017 11:08 am
           
          Forum: Custom Stats, Reports and HUD Profiles
          Topic: Geometric mean of tournament players
          Replies: 6
          Views: 821

          Re: To Separate Second pair from third

            I dived into my archives and found an easier way to determine the highest card on the flop.
            Code: Select all
            (greatest(mod(cash_hand_summary.card_1 - 1, 13), mod(cash_hand_summary.card_2 - 1, 13), mod(cash_hand_summary.card_3 - 1, 13)) + 1)

            This expression returns an A as 13.
            Highest flop card.png
            Highest flop card.png (9.68 KiB) Viewed 2148 times
            by BillGatesIII
            Sun Aug 06, 2017 9:44 am
             
            Forum: Custom Stats, Reports and HUD Profiles
            Topic: To Separate Second pair from third
            Replies: 16
            Views: 4845

            Re: To Separate Second pair from third

            Guest666 wrote:Do you mean card_1 ... card_5 in tourney_hand_summary? Or is there something else?
            Is there a way to made column, which I can use in another column? for example column high_rank_flop

            If you do a search for 'intarray' on the forums you'll find a more easy solution for this.
            by BillGatesIII
            Thu Aug 03, 2017 12:39 pm
             
            Forum: Custom Stats, Reports and HUD Profiles
            Topic: To Separate Second pair from third
            Replies: 16
            Views: 4845

            Re: Custom tournament stat - No valid SQL

            Yes, it seems OK on a small sample (however it needs to be ridiculously small to be "quick"). Sorry about that, didn't test it on a big sample. This code is a bit faster but still too slow. max(case when tourney_hand_summary.id_hand = ( select thps.id_hand from tourney_hand_player_statist...
            by BillGatesIII
            Thu Aug 03, 2017 7:43 am
             
            Forum: Custom Stats, Reports and HUD Profiles
            Topic: Custom tournament stat - No valid SQL
            Replies: 9
            Views: 2027
            PreviousNext

            Return to advanced search

            cron