Results 1 to 7 of 7

Thread: FORMULA Please

  1. #1
    Join Date
    Dec 2004
    Location
    Tamworth, NSW.
    Posts
    179

    Default FORMULA Please

    Hi all. Looking for a formula to arrive at the shortest Pre Post price (if possible) for each race per meeting. Also if possible one for the shortest PP price horse at each meeting for the day. ie. 6 meetings the 6 shortest price at each meeting. If Pre Post not possible perhaps shortest Sportsbet or Tattsbet early price would have to do.

    Thanks in advance.

    Norm

  2. #2
    Join Date
    Jul 2015
    Location
    Adelaide
    Posts
    33

    Default

    Norm

    Using Bestform Data : Early Market Price as an example

    Create a MyCalc (I've called mine mpdiv) with the line
    200-MPDIV
    Create a Report (I've called mine mpdiv) with the line
    MPDIV
    Link these to an Expert Mode system with the line
    0.CALCRANKMAX=1,CALCNAME=mpdiv,REPNAME=mpdiv

    This will give you the lowest priced horse in the Early Market Price for each race.
    The report will let you create a CSV file from the test results that will show you the value of MPDIV
    You can also use the CSV file to determine the lowest value from each meeting

    In the Mycalc I've assumed no horse in the market is > 200/1.
    You have to subtract the price from 200 so that the lowest price becomes the highest value.

    You could also test for Tattsbet 1st Market Win Price with 200-TB1W and a report for TB1W etc etc

    Cheers
    Brian

  3. #3

    Default i envy your coding skills Norm :)

    Quote Originally Posted by Kintala View Post
    Norm

    Using Bestform Data : Early Market Price as an example

    Create a MyCalc (I've called mine mpdiv) with the line
    200-MPDIV
    Create a Report (I've called mine mpdiv) with the line
    MPDIV
    Link these to an Expert Mode system with the line
    Create a MyCalc (I've called mine mpdiv) with the line
    200-MPDIV
    Create a Report (I've called mine mpdiv) with the line
    MPDIV
    Link these to an Expert Mode system with the line
    0.CALCRANKMAX=1,CALCNAME=mpdiv,REPNAME=mpdiv




    Brian
    Norm can this be done to isolate the highest stake race in every meeting on any day?

    dave

  4. #4
    Join Date
    Dec 2004
    Location
    Tamworth, NSW.
    Posts
    179

    Default

    Quote Originally Posted by Kintala View Post
    Norm

    Using Bestform Data : Early Market Price as an example

    Create a MyCalc (I've called mine mpdiv) with the line
    200-MPDIV
    Create a Report (I've called mine mpdiv) with the line
    MPDIV
    Link these to an Expert Mode system with the line
    0.CALCRANKMAX=1,CALCNAME=mpdiv,REPNAME=mpdiv

    This will give you the lowest priced horse in the Early Market Price for each race.
    The report will let you create a CSV file from the test results that will show you the value of MPDIV
    You can also use the CSV file to determine the lowest value from each meeting

    In the Mycalc I've assumed no horse in the market is > 200/1.
    You have to subtract the price from 200 so that the lowest price becomes the highest value.

    You could also test for Tattsbet 1st Market Win Price with 200-TB1W and a report for TB1W etc etc

    Cheers
    Brian
    Thanks again Brian..... Will get stuck into it today.

    Cheers

    Norm

  5. #5
    Join Date
    Dec 2004
    Location
    Tamworth, NSW.
    Posts
    179

    Default

    Hi Dave.

    I wish I did have those skills. This is why I am so appreciative of Brian and his helpful replies. Check back in archives and you will find many solutions attributed to Brian.

    Norm.

  6. #6
    Join Date
    Jul 2015
    Location
    Adelaide
    Posts
    33

    Default

    Dave
    I haven't been able to isolate meetings and/or races based on the highest stakes. There may be a way, but I haven't found it in many experiments.
    You can select races on prize money in a system by using the "Race Prize Money" field in the Edit System Rules screen, or by using a formula like R:STAKES>=100000 in Expert Mode.
    Cheers
    Brian

  7. #7
    Join Date
    Jun 2013
    Posts
    24

    Default

    I have to thank Brian as well.
    Brian, you have taught me quite a bit about writing up formulas simply through the way you explain what you have done when you reply to someone's question.
    As Norm has said, it is greatly appreciated.
    Cheers to you, and a Merry Christmas to everybody
    Barry

Bookmarks

Posting Permissions

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