Examples 41-45
Example 41. I'd like to back/lay the first three favourites in all selected races with a fixed liability (say £10) only when the under/over round greater/less than a specified amount (say 70%) and the volume of bets is say greater than say £100,000. I'd like to kick this off in advance of racing and leave to automatically bet throughout the day.
Settings configuration:
"Max attempts on failure" - set to "-1"
You will need to set up three triggers - each one representing one selection that you'll be betting on.
Trigger 1, row 5
Cell: "Selection Unmatched Back"
Condition: "is equal to"
Trigger Value: "0"
Action: "back"
Price: "IF(market_volume>100000, back_price, 0)"
Amount: "IF(100/r_1_backp + 100/r_2_backp + 100/r_3_backp)<70, 10/back_price, 0)"
Market: "All Currently Monitored"
Selection: "Winner"
Active: "once idle & wait"
Trigger 2
Cell: "Triggers Worked Out"
Condition: "is equal to"
Trigger Value: "5"
Action: "back"
Price: "back_price"
Amount: "10/back_price"
Market: "All Currently Monitored"
Selection: "Second Winner"
Active: "once idle & wait"
Trigger 3
Cell: "Triggers Worked Out"
Condition: "is equal to"
Trigger Value: "5"
Action: "back"
Price: "back_price"
Amount: "10/back_price"
Market: "All Currently Monitored"
Selection: "Third Winner"
Active: "once idle & wait"
As you can see all the important conditions are set up in the first trigger, using pre-defined trigger variables in Price and Amount columns.
Triggers 2 and 3 simply watch if the first trigger has worked out and then bet on second and third winners respectively.
If you want to modify the liability then instead of "10/back_price" put in something different than 10.
The over/under round limit is set up in the formula 100/r_1_backp + 100/r_2_backp + 100/r_3_backp) < 70.
Example 42. I back on a selection expecting that the price will shorten eventually. I want to create triggers that will perform a stop-loss function if a price has grown instead, say in 4 ticks.
More than that I want to lay if the price has dropped in, say, 10 ticks, to secure equal profit for all selections.
Settings configuration:
"Max attempts on failure" - set to "-1"
Trigger 1 - stop-loss
Cell: "Selection Matched Lay"
Condition: "is equal to"
Trigger Value: "0"
Action: "cancel then lay"
Price: "lay_price"
Amount: "IF(lay_price >= bm_1_backp + 4 * p_tick, bm_1_backa, 0)"
Market: select the market
Selection: choose the selection
Active: "once & wait"
Trigger 2 - profit generator
Cell: "Selection Matched Lay"
Condition: "is equal to"
Trigger Value: "0"
Action: "cancel then lay"
Price: "lay_price"
Amount: "IF(lay_price <= bm_1_backp - 10 * p_tick, bm_1_backa*bm_1_backp/lay_price, 0)"
Market: select the market
Selection: choose the selection
Active: "once & wait"
Both triggers lay on the selection that was previously back. But the first one does this if the price has reached a certain high level - to prevent loss.
The second one takes advantage of the obvious price speculation and lays at a lower price and a specially computed amount that will guarantee equal profit on all selections.
The triggers can not be executed together because each one checks in its condition that the matched lay part is zero.
In case there was an unmatched bet, it is being cancelled because the action is "cancel then lay".
Example 43. I would like to pick the favourite priced under 4.0, whose price has dropped in 3 or more ticks over the last 10 minutes.
When the above is satisfied I want to back 10 GBP on this selection. If, on the contrary, the price has grown up, say, in 4+ ticks, I want to lay on it.
Later on, I want the software to stop-loss this bet or close my position with equal profit on all selections.
Let's break this example into two parts. The first part will post the first bet, depending on the price tendency.
Settings Configuration:
"Price Trend Range": if refresh rate is 2 sec, then set it to 10 min * 60 sec / 2 sec = 300 refreshes. Accordingly if the refresh rate is 5 sec, then set it to 120 and so on.
"Max attempts on failure" - set to "-1"
If you don't want to trade in-play, turn off "Allow triggers/booking/offsets with In-Running markets"
First Part:
Trigger 1
Cell: "Selection Matched Back"
Condition: "is equal to"
Trigger Value: "0"
Action: "back"
Price: "back_price"
Amount: "IF(AND(back_price < 4.0, p_dif <= -3 * p_tick), 10, 0)"
Market: select the market or choose "All Currently Monitored"
Selection: "Winner"
Active: "once & wait"
Trigger 2
Cell: "Selection Matched Lay"
Condition: "is equal to"
Trigger Value: "0"
Action: "lay"
Price: "lay_price"
Amount: "IF(AND(back_price < 4.0, p_dif >= 4 * p_tick), 10, 0)"
Market: select the market or choose "All Currently Monitored"
Selection: "Winner"
Active: "once & wait"
The second part will be stop-loss or profit generator. Regarding the second part please see the previous trigger example No 42. Note that if you initially backed, then stop-loss will be lay bet. Otherwise stop-loss will be back bet. So you will need to substitute the actions and formulas accordingly.
Tip: if you are not very experienced in Excel formulas and the concept of triggering, turn "Test Mode" on for testing the first part of the example.
Example 44. I want to lay the first and second winners each time when the price of each of them is below 2.0.
Settings Configuration:
In "Trigger Options":
Max Attempts on Failure - set to "-1"
Repetition Interval - set to at least twice as much as your refresh rate to give MF Pro enough time to update bets list
Cell: "Any Selection Lay Price"
Condition: "is less than"
Trigger Value: "2.0"
Action: "lay"
Price: "lay_price"
Amount: "IF(AND(AND(r_1_layp<2.0, r_2_layp<2.0), OR(lay_price<=r_1_layp, lay_price<=r_2_layp)), 2, 0)"
Market: "All Currently Monitored"
Selection: "All Matching Selections"
Active: "repeat at intervals"
As you can see without the additional condition in the "Amount" column the software would lay on all selections which are priced under 2.0.
However the additional formulas limits that to the first two winners. Besides they prevent betting if there is only one runner priced <2.0.
Example 45. I want to lay a number of selection in each event after the event has gone INPLAY at a certain odd/stake. And then proceed to cancel all other unmatched bets as soon as one of the bets is matched.
Settings Configuration:
Trigger Options:
Allow triggers/booking/offset with In-Running Markets - turned ON
Trigger 1, in row 5
Cell: "1"
Condition: "is equal to"
Trigger Value: "1"
Action: "lay"
Price: set the price
Amount: "set the amount"
Market: select from the drop-down list or choose "All Currently Monitored" etc.
Selection: choose a selection or set to "All Selections", "All Except Winner" etc.
Active: "once in-play & wait"
Trigger 2, in row 6
Cell: "Selection Matched Lay"
Condition: "is greater than"
Trigger Value: "0"
Action: "react on price"
Price: "2"
Amount - leave blank
Market: select the same market as in trigger 1
Selection: "All Selections"
Active: "once in-play & wait"
Trigger 3
Cell: "Triggers Worked Out"
Condition: "is equal to"
Trigger Value: "6"
Action: "cancel lay"
Price, Amount - leave blank
Selection: "All Selections"
Active: "once in-play & wait"
The first trigger contains a fake condition - in fact it doesn't need any condition at all because as soon as the market turns in-play bets will be placed anyway.
The second trigger seeks for any selection that has a matched bet and "remembers" this event due to the "react on price" Action.
The third trigger is executed immediately as the second trigger has worked out, and cancels all remaining unmatched bets.
Note that we can't assign the "cancel lay" Action to the second trigger because in this case MF Pro will try to cancel lay bets only for the selection which complies with the Condition.
