Examples 26-30
Example 26. I want to set up the program the night before or early morning to work once betfair sets a price. E.g. if a horse's price is 3.5 at 7am with £10 available, then 3.2 with £20 available and I want to back £500, I would have to take a small amount and leave the rest on the lay side unmatched.. But, is there any way i could set a level at 3.0 and it would bet up to my £500 limit anything above that?
That's an easy thing to do. Here are the required steps:
- uncheck "Constant Monitoring" and set "Start at", "Finish at" options to define when you want to start your monitoring and when you wish to finish it, for example Start at 06:00 am and finish at 07:00 pm
- set the refresh rate to anything more than 10 seconds - you don't need to maintain frequent monitoring because prices will be changing very slow
- set "Profit/Loss Limit" option to "500" - to make it stop betting as soon as "-500" is showing for at least one runner.
Then create this single trigger:
Cell: "Winner Selection Back Price"
Condition: "is greater than"
Trigger Value: "3.0"
Action: "back"
Price: "back_price"
Amount: "back_amount"
Market: obviously you'll want to apply this trigger to multiple markets, so you may select "All Currently Monitored". But if you have a specific market in mind then select it from the drop-down list
Selection: "Winner"
Active: "always"
This trigger will back a winner each time it's priced over 3.0. And it will place exactly the amount that is currently offered - to guarantee that it will be matched. Thus it will do the betting in several steps each time taking small amounts. If you want to make double sure that the bet will be matched you can key in "back_amount/2" or "back_amount*2/3". You can also place your bet at a price slightly better than the current back offer. In this case you may enter "1_back_price" - to place it 1 tick higher - or "2_back_price" etc. Or you may even back at the lay price, then enter "lay_price" in the Price column.
If you want to bet on any runner instead of just "Winner" then in the Cell column select "Any Selection Back Price" and in the Selection column - "All Matching Selections".
The trigger will stop betting as soon as at least one runner has a negative liability of 500 or higher.
Example 27. Before any triggers start, the race needs to have been in running for at least 45 seconds. Lay the leader if its price is <1.5 >1.01 and moving out rapidly say +2 points since the last refresh.
And if the above was executed then back the second favourite horse if its price has dropped significantly (more than 5 points since the last refresh).
Trigger 1, row 5
Cell: "Any Selection Price Leap"
Condition: "is greater than"
Trigger Value: "2"
Action: "lay"
Price: "best"
Amount: "IF(AND(NOW()-event_off > 0.000521, r2_leap<-5, lay_price>1.01, lay_price<1.5), 4, 0)"
Market: select from the drop-down list
Selection: "All Matching Selections"
Active: "once each in-play market"
Trigger 2
Cell: "Triggers Worked Out"
Condition: "is equal to"
Trigger Value: "5"
Action: "back"
Price: "best"
Amount: "4"
Market: the same as above
Selection: "Second Winner"
Active: "once each in-play market"
This combination of triggers was tested on two races and one football match.
The first trigger looks for any selections with price leap over 2. Price leap indicates how much the price of a selection has changed since the last refresh, measured in price ticks.
When such runners are found we need to apply other conditions to them. That's why we put a formula into the "Amount" column. It contains of the following parts:
1. NOW()-event_off > 0.000521 - true if it's been more than 45 seconds since the event's actual beginning
2. r2_leap<-5 - true if the price leap of the second winner is less than -5 (that is, it dropped for more than 5 points). The trigger variable r2_leap returns the price leap for the second runner in the list sorted by price.
3. lay_price>1.01, lay_price<1.5 - true if the lay price of the selection in question is within the range of 1.01 and 1.5
When all the three conditions are true we may place a bet. "All Matching Selections" specified in the "Selection" column refer to the runners with price leap greater than 2. However the third condition in the "Amount" formula eliminates the possibility of it being not a winner (if its price is below 1.5) so if even there were more than two runners with price leap >2, the bet will be placed only on the winner.
The second trigger places the back bet on the second winner IF the first trigger has worked out. Both triggers will be executed almost instantly.
Please note: if you don't find the aforesaid trigger variables in your copy of MarketFeeder Pro make sure that you have the latest build of the application which you can download for free using the same download link as always.
Example 28. Back the horse before the off. Example = £10 @ 5.
If the horse contracts to 50% of the initial back price, lay the horse so that an equal green figure is achieved across the whole field
If the horse drifts to 120% of it's price then lay it to recover the initial back amount.
Trigger 1, row 5
Cell: "1"
Condition: "is equal to"
Trigger Value: "1"
Action: "back"
Price: "5.0"
Amount: "10"
Market: select from the list
Selection: choose from the drop-down list
Active: "once each market"
Trigger 2
Cell: "Triggers Worked Out"
Condition: "is equal to"
Trigger Value: "5"
Action: "lay"
Price: "lay_price"
Amount: "IF(AND(lay_matched=0, profit_loss>0, lay_price < ((profit_loss/10)+1)*0.5), (10*lay_price)/((profit_loss/10)+1)), 0)"
Market: the same as above
Selection: "All Matching Selections"
Active: "once each in-play market"
Trigger 3
Cell: "Triggers Worked Out"
Condition: "is equal to"
Trigger Value: "5"
Action: "lay"
Price: "lay_price"
Amount: "IF(AND(lay_matched=0, profit_loss>0, lay_price >= ((profit_loss/10)+1)*1.2), 10, 0)"
Market: the same as above
Selection: "All Matching Selections"
Active: "once each in-play market"
Example 29. Lay the horse pre race. Monitor the in running market and let the lay bet stand UNLESS the price of the laid selection drops below 1.2 in which case back it back to recover the initial stake.
Trigger 1, row 5
Cell: "1"
Condition: "is equal to"
Trigger Value: "1"
Action: "lay"
Price: "best"
Amount: "10"
Market: select from the list
Selection: choose from the drop-down list
Active: "once each idle market"
Trigger 2
Cell: "Triggers Worked Out"
Condition: "is equal to"
Trigger Value: "5"
Action: "back"
Price: "back_price"
Amount: "IF(AND(profit_loss<0, back_price<1.2), -profit_loss/(back_price-1), 0)"
Market: the same as above
Selection: "All Matching Selections"
Active: "once each in-play market"
Example 30. I want to monitor horse races early in the day, from 8:30 am to 1:00 pm.
I want to look for a "steamer" horse - that is a runner with a price that drops down as compared to the price in the beginning of monitoring. If such horse's prices drops to >=5 ticks over the last 30 minutes or more, then I want to back on it at the best price to secure a £100 GBP profit on this runner. There is also one more condition: the runner's odds must be within the range of 3.0 to 14.0
Then I want the software to email me as soon as this trigger has been executed.
First of all we need to configure the settings of the application:
1. Set "Refresh Rate" to 10 seconds. We don't need to update the prices frequently.
2. Set "Price Trend Range" to 180 - to register the difference between prices within the last 180 refreshes, which - according to the refresh rate - makes 30 minutes
3. Uncheck "Constant Monitoring" and set "Start At" to "8:30", "Finish At" - to "13:00" - or "1:00 PM".
4. In the "Trigger Options" tab set "Max Attempts on Failure" to "-1" - the trigger will need to monitor the condition in Amount column endlessly.
If you want to use the second trigger that will email you as soon as trigger 1 is executed, you need to set up your email details correctly in "Trigger Options" tab.
The best way to do it is to open your email client software (for instance Outlook Express) and copy all the settings from there into MF Pro.
Trigger 1, row 5
Cell: "Any Selection Back Price"
Condition: "is between"
Trigger Value: "3.0, 14.0"
Action: "back"
Price: "back_price"
Amount: "IF(AND(HOUR(NOW())>=9, p_rate*180 < -5.0), 100/(back_price-1), 0)"
Market: select from drop-down list
Selection: "All Matching Selections"
Active: "once each idle market"
Trigger 2
Cell: "Triggers Worked Out"
Condition: "is equal to"
Trigger Value: "5"
Action: "email"
Price: leave blank
Amount: leave blank
Market: "All Currently Monitored"
Selection: leave blank
Active: "once each market"
A couple of words about the first trigger. As you can see its main condition is "Any Selection Back Price is between 3 and 14". We're using this condition to spot a certain range of runners for further analysis. Then, additional conditions are given in the Amount column. As always we use the Excel IF function to return a valid amount if the conditions are met, or return zero otherwise - and make MarketFeeder Pro try again later.
The condition HOUR(NOW())>=9 is needed to let it wait for at least 30 minutes since the start of the monitoring before it makes any bets.
p_rate*180 is a formula that returns the price difference between the first and 180's refreshes in ticks. Since p_rate is a pre-defined trigger variable showing price rate, and price rate is a number of ticks divided by the number of refreshes, it will return in fact the price leap over the last 180 refreshes. If it is negative and less than 5.0 we get the "steamer" horse, and the Amount becomes 100/(back_price-1). The latter is a simple calculation to generate a profit of £100 when the bet is placed on the runner at the current price.
