Author Topic: Question: Calculate Average Odd to tigger  (Read 2413 times)

Tags:
  • All members
  • Posts: 33
Question: Calculate Average Odd to tigger
« on: 08 Aug 2015, 09:46 »
Hi all

I have a little problem, i have no idea how i solve it.
-> I like to calculate the average between back/ lay when there are gaps in the markets

Lay 1.8 - Back 2.0  -> I like to trigger when the average (1.8+2.0/2=1.9) is between min 1.3 and max 2.50 and the tick-difference is smaller than 20. The requested odd to bet on will be 1.90

How can i set this up? ???

Thank you 

  • Guest
Re: Question: Calculate Average Odd to tigger
« Reply #1 on: 08 Aug 2015, 17:19 »
Hi,

This strategy has been tried a few times in various guises, including by myself a few times.

I would advise you to getMfpro to write you the trigger. Otherwise, you will go around in circles and end up surrounded by zeros!!

Post a request either paid for (ie private) or free here

newbielink:http://community.welldonesoft.com/make-me-a-trigger!/ [nonactive]

good luck
Larp

  • Élite
  • Posts: 431
*
Re: Question: Calculate Average Odd to tigger
« Reply #2 on: 09 Aug 2015, 09:21 »
That's fairly straight forward I think.  Use these conditions all conjoined by AND conditions:

Selection's back_price Is greater than 0 
Selection's lay_price Is less than r_ticks(back_price,20)
Selection's Trigger Expression (back_price+lay_price)/2  is between 1.3 and 2.5

Then in the amount box also use:

(back_price+lay_price)/2

I think this should do it but I may have missed a subtlety?

Example attached but test with caution (this one is set to back once per selection but you don't say which you want to do, back or lay). 

Good luck.

  • All members
  • Posts: 33
Re: Question: Calculate Average Odd to tigger
« Reply #3 on: 09 Aug 2015, 18:06 »
Thank you alfaman! I'll give it a try!  :)

  • All members
  • Posts: 44
Re: Question: Calculate Average Odd to tigger
« Reply #4 on: 09 Aug 2015, 23:48 »
Hi,
Just a comment from a newbie re taking the average of 'odds'.

Be careful!
Odds express a ratio and taking a simple average may cause grief.

It is necessary to first convert the odds to a probability, take the average, THEN convert back to the new value 'average odds'.

Example: Average of odds 1.3 and odds 1.5 is 1.39 not 1.4, close so maybe not critical.
               Average of odds 2.0 and odds 5.0 is 2.86 not 3.5, not close so could be ruinous!

  • Élite
  • Posts: 431
*
Re: Question: Calculate Average Odd to tigger
« Reply #5 on: 10 Aug 2015, 17:32 »
Tupp

I have no idea why you think that to be the case.  on that basis the average of 10 and 30 is 15 which is not the case.

Anyway I am not going to argue - believe what you like.  I did what was asked by Murf, who like me,  thinks the arithmetic average of n numbers is sum(n)/n

I take Benko's point but that is not what was asked for (as I appreciate he realises).

The main thing is - does the trigger do what was requested?

More interestingly is avg(.....) an MF pro function?  It is not in the manual.

 

Please note, BetFair is seems to be currently OFFLINE