max back amount formula

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

Sorry, I did not get your explanation. You want to get the amount of the maximum sized bet in the market?

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
 

Any ideas?
Thanks
R

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

Hi Mark,
Will test it tomorrow.
Many thanks
R

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

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.)

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

Works great on my end too! Thank you for this.