Examples 56-60
Example 56. At 2 minutes before the off I want to lay 20 GBP on the third winner if it is priced between 5.0 and 9.0, and if there are at least 8 runners in the race.
When the event goes in-play I want to back this selection if its price drops to 1.3 or lower, to cover any loss.
Settings Configuration:
Max attempts on failure - set to "-1"
Allow triggering/offset no sooner than ... min. before the event's start - turned ON and set to "2"
Trigger 1:
Cell: "Third Winner Lay Price"
Condition: "is between"
Trigger Value: "4.9, 9.2"
Action: "lay"
Price: "lay_price"
Amount: "IF(runner_number>7, 20, 0)"
Market: "All Currently Monitored"
Selection: "Third Winner"
Active: "once idle & wait"
Trigger 2:
Cell: "Selection Matched Lay"
Condition: "is greater than"
Trigger Value: "0"
Action: "back"
Price: "best"
Amount: "-profit_loss/(back_price-1)"
Market: "All Currently Monitored"
Selection: "All Selections"
Active: "once in-play & wait"
The first trigger has two conditions: first being the main one, in the Cell, Condition, Trigger Value fields. And the second one in the Amount column formula, using runner_number trigger variable.
The second trigger will be activated only if there is some matched lay bet on that selection - that is if the first trigger's bet has been matched (and it may stay unmatched if the price leaps up in the very moment of your betting). If you wish the first trigger's bet to be matched for sure, put "best" into the Price column instead of "lay_price".
Pay attention that the second trigger bets to cover the full amount of the loss for that runner, yet leaving a great potential loss on other selections in case another runner becomes a winner.
So you may modify the Amount column to something else if you want to just minimize the losses.
For example, if you wish to spread the loss equally among all selections modify it to:
Amount: "-profit_loss+20/back_price"
where 20 is your initial bet amount.
Example 57. If a selection's back amount divided by the lay amount is less than or equal to 0.20 then place a back bet at the current odds.
At the same time place a lay bet on the same selection at the back odds minus 0.2. Both stake amounts would be the same, for example £10.
Trigger 1, row 5
Cell: "Any Selection Back/Lay Ratio"
Condition: "is equal or less than"
Trigger Value: "0.2"
Action: "back"
Price: "best"
Amount: "10"
Market: "All Currently Monitored"
Selection: "First Matching Selection"
Active: "once & wait"
Trigger 2
Cell: "Triggers Worked Out"
Condition: "is equal to"
Trigger Value: "5"
Action: "lay"
Price: "back_price-0.2"
Amount: "10"
Market: "All Currently Monitored"
Selection: "All Matching Selections"
Active: "once & wait"
I want to mention that you can customize the Price of the second bet a little. Currently it lays at back_price-0.2 which is not effective if the price is too low (then 0.2 is a way too big offset) or too high (then 0.2 wouldn't fit into a tick).
So you could set it to, say, back_price-2*p_tick - in order to adjust the price to the current price range.
Example 58. I want to lay the top two favourites 1 min before the off, then during in-play, if the price of either of those selections drops below 1.3, back that selection to cover its losses.
Settings Configuration:
Max attempts on failure - set to "-1"
Allow triggering/offset no sooner than ... min. before the event's start - turned ON and set to "1"
Trigger 1:
Cell: "1"
Condition: "is equal to"
Trigger Value: "1"
Action: "lay"
Price: "best"
Amount: "IF(OR(back_price<=r_1_backp, back_price<=r_2_backp), 10, 0)"
Market: select the market or choose "All Currently Monitored"
Selection: "All Selections"
Active: "once idle & wait"
Trigger 2:
Cell: "Selection Matched Lay"
Condition: "is greater than"
Trigger Value: "0"
Action: "back"
Price: "best"
Amount: "IF(back_price<1.3, 10, 0)"
Market: the same market
Selection: "All Selections"
Active: "once in-play & wait"
The first trigger lays the two favourites. Pay attention to the condition in the Cell column. It is fake (1 is always equal to 1), because we locate the favourites using trigger variables in the Amount column. The literal meaning of this formula is: if the back price of the selection is either equal or less than the winner's or equal or less than the second winner's, then the Amount should be 10. Otherwise it should be 0 (and another attempt will be made). Replace 10 with whatever you want to bet.
If you want to lay on the winners only if their price is below some point, say, below 4.0, then modify Cell, Condition and Trigger Value fields in the following way:
Cell: "Second Winner Back Price"
Condition: "is less than"
Trigger Value: "4"
The second trigger is applied to selections with matched lay amount - that is with one of the two selections that were traded in the first trigger. The condition in the Amount column checks if the price of the runner is below 1.3, otherwise no bets will be made.
Example 59. I want to dutch (by backing) the first 4 runners in a race 1 min before the start. If I won the previous race or just beginning my session I want to win 4 GBP. But later I want to adjust this number according to the amount I might lose in the previous race. Say if I lost £10 I want to win those £10 + 4 in the next race.
Settings Configuration:
Max attempts on failure - set to "-1"
Allow triggering/offset no sooner than ... min. before the event's start - turned ON and set to "1"
First .. favourites only - turned ON and set to "4"
Cell: "1"
Condition: "is equal to"
Trigger Value: "1"
Action: "back"
Price: "IF(b_book<100, back_price, 0)"
Amount: "IF(VALUE('list of events'!K3)<0, ((4-'list of events'!K3)/(1-b_book/100))/back_price, (4/(1-b_book/100))/back_price)"
Market: select the market
Selection: "All Selections"
Active: "once & wait"
We do not need a min condition for this trigger (all calculations will be made inside Price and Amount) so we set a fake condition (1 is equal to 1) there.
Since MF Pro will monitor only the top 4 runners the book% will be automatically calculated for those ones, skipping all the other runners in the race.
The trigger variable b_book in the Price and Amount columns returns current back book%.
The formula in the Amount column calculates how much needs to be bet on each runner depending on the winnings you expect. The IF condition makes an adjustment of this amount in case the last won value is negative (i.e. you lost last time).
The trigger was tested in three races, each time giving correct results.
Be prepared to spend much money on betting if the book% is not attractive enough (80% and higher).
For example, if book is 96% and you want to earn £10, your liability will make around £240 - this is how much you will lose if none of the four runners wins.
Example 60. 2 min before the start lay 10 GBP on the specified selections which have a lay price of 7.0 or less.
Once the event is in-play lay any remaining selections previously not matched which also trade at 7.0 or less. Then back any of the previously matched selections which subsequently have a back price of 1.3 or less to reduce the losses.
Settings Configuration:
Max attempts on failure - set to "-1"
Allow triggering/offset no sooner than ... min. before the event's start - turned ON and set to "2"
Constant Monitoring - turned OFF
Start Monitoring Event at ... minutes before the beginning - turned ON and set to "5"
Select the markets you want to trade in after you have arranged the settings.
Also go to "My Markets" sheet and clicking on each market in the list pick the selections of your interest, unticking all the others. Don't forget to save each list.
Trigger 1
Cell: "Any Selection Lay Price"
Condition: "is equal or less than"
Trigger Value: "7.0"
Action: "lay"
Price: "lay_price"
Amount: "10"
Market: "All Currently Monitored"
Selection: "All Matching Selections"
Active: "once idle & wait"
Trigger 2
Cell: "Any Selection Lay Price"
Condition: "is equal or less than"
Trigger Value: "7.0"
Action: "lay"
Price: "lay_price"
Amount: "IF(AND(back_matched=0, lay_matched=0, lay_price>1.3), 10, 0)"
Market: "All Currently Monitored"
Selection: "All Matching Selections"
Active: "once in-play & wait"
Trigger 3
Cell: "Selection Matched Lay"
Condition: "is greater than"
Trigger Value: "0"
Action: "back"
Price: "best"
Amount: "IF(back_price<=1.3, 10, 0)"
Market: "All Currently Monitored"
Selection: "All Selections"
Active: "once in-play & wait"
The highlighted "10" is the default betting amount. If you want to change it replace it everywhere where it is highlighted.
The first two Triggers lay on any selection that is priced under 7.0.
The formula in the Amount field of the Trigger 2 prevents it from betting if a stop-loss bet has been already placed on that selection and if the price is less than 1.3.
