Author Topic: max back amount formula  (Read 4509 times)

Tags:
  • All members
  • Posts: 829
max back amount formula
« on: 18 Sep 2014, 10:55 »
hi,
can someone please advise me how to do the following:
Formula to place a back bet of the max amount of either player.
within the last 4 bets, but apply to only one trigger.
Let's suppose Trigger A places flat 10.00 bets but Trigger B places variable size bets and this is the trigger I am interested in applying the bet amount formula to.
example:

Trigger A  Nadal  10.00
Trigger B  Murray 12.00
Trigger B  Nadal   12.00
Trigger A  Nadal   10.00
Trigger B  Nada    12.00l
Your first reaction might be to assign each trigger with the appropriate bet amount however that is not what I want as I plan to modify the formula and add other criteria which will vary the bet size, I just haven't gotten around to it yet.
So, maximum bet size of last four bets.
Many thanks
R
My grandma taught me not to run downstairs and never back odds on.

  • Administrator
  • Posts: 8821
  • Gender: Female
*
Re: max back amount formula
« Reply #1 on: 19 Sep 2014, 09:24 »
Sorry, I did not get your explanation. You want to get the amount of the maximum sized bet in the market?
Always try your triggers in Test Mode before switching to real money!

Follow us on Twitter.

Join our WhatsApp chat!

Присоединяйтесь к официальному Telegram-каналу!

  • All members
  • Posts: 829
Re: max back amount formula
« Reply #2 on: 19 Sep 2014, 17:41 »
hi Oxa,

I'd like to bet the highest bet amount of the last 4 bet amounts
example
The below is one event

Nadal 13
Nadal  22
Murray 28
Nadal  16

The next bet I want is  28

Thanks
R
 
My grandma taught me not to run downstairs and never back odds on.

  • All members
  • Posts: 829
Re: max back amount formula
« Reply #3 on: 21 Sep 2014, 22:18 »
Any ideas?
Thanks
R
My grandma taught me not to run downstairs and never back odds on.

  • Moderator
  • Posts: 3597
*
Re: max back amount formula
« Reply #4 on: 22 Sep 2014, 06:57 »
Hi
Please try this. I have not tested it.
Amount:
Code: [Select]
MAXV(s_1_bm_1_backa,s_1_bm_2_backa,s_1_bm_3_backa,s_1_bm_4_backa,s_2_bm_1_backa,s_2_bm_2_backa,s_2_bm_3_backa,s_2_bm_4_backa)
Condition:
markets number of matched back bets is equal to 4
Please read the following disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

  • All members
  • Posts: 829
Re: max back amount formula
« Reply #5 on: 22 Sep 2014, 08:16 »
Hi Mark,
Will test it tomorrow.
Many thanks
R
My grandma taught me not to run downstairs and never back odds on.

  • All members
  • Posts: 829
Re: max back amount formula
« Reply #6 on: 24 Sep 2014, 22:04 »
Hi Mark,
After testing had some log errors. Usual price/bet amount ones.
To make it easier can we just say max bet size of last two bets.
(not player related)
Thanks
R

My grandma taught me not to run downstairs and never back odds on.

  • Moderator
  • Posts: 3597
*
Re: max back amount formula
« Reply #7 on: 25 Sep 2014, 08:05 »
Hi
I think you will still need to collate the bets on each selection in order to get the maximum matched back amount in the whole market. The MAXV function should work correctly.

The attached screenshot shows how I tested it and you can see the formula returns the maximum back matched amount in the market (here I have limited it to the last two bets on each selection.)
Please read the following disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

  • All members
  • Posts: 829
Re: max back amount formula
« Reply #8 on: 25 Sep 2014, 09:38 »
Hi Mark,
Humblest of apologies, I missed a bracket in the formula.
I gotta get down to Spec Savers :)
Thanks for the screenshot.
Cheers
R
My grandma taught me not to run downstairs and never back odds on.

  • All members
  • Posts: 80
Re: max back amount formula
« Reply #9 on: 05 Oct 2014, 15:35 »
Works great on my end too! Thank you for this.
Automatic isn't always everything.

 

Please note, BetFair is seems to be currently OFFLINE