Auto-Betfair Installation Guide

							                            Auto-BF v4 - User Settings
                                    (13th December, 2008)


Auto-BF was designed to work as a fully automated betting exchange software solution. Once the
software is loaded up each morning, you don‟t have to do anything else for it to work and trade
automatically for you. However, there are a number of special options available to users who
wish to “fine-tune” their days trading.

The following information is for those who wish to adjust and “fine-tune” their daily trading.


Firstly, you should have Auto-BF installed and be logged into the software. The software
comprises of the MarketFeeder Pro engine, and the Auto-BF software in the excel spreadsheets.


Options for the MarketFeeder Pro engine

    1) Constant Monitoring (Found in the “All Markets” tab of MarketFeeder Pro – See Below).
       This option is un-ticked by default. You should always leave this box un-ticked, unless
       you are planning to adjust your horse selections. This will be discussed later.
    2) Always show today’s bets only (Found in the “Betting Options” tab of MarketFeeder
       Pro – See Below) This is switched on by default. Again, you should leave this setting
       alone, unless you need to extract previous day‟s market data into the software. An
       example of when you would need to do this would be when you are attempting to
       recoup a loss made on a previous day, and need the software to be aware of previous
       trades. This is generally used when you are using the “Manual Override” option, where
       you are betting right up to the final race. If you end on a losing bet you will have made a
       loss for the day. The following day, you can simply alter these settings to retrieve the
       previous days market data, and simply carry on where you left off!




Options in the EXCEL „triggers‟ worksheet

The „triggers‟ worksheet, which is found in the Auto-BF/Excel software, is the main area where
you make adjustments. You can scroll to the triggers worksheet using the left/right arrows in the
bottom left corner of Excel.
The bulk of options/changes made in the „triggers‟ worksheet is made at the top of the worksheet




We will now break each part down into sections.

Section 1 (See Below)




    3) Save Changes – Found in Cell A2 – You will only need to click on this button if you
       change the horse selections; otherwise this button is not used.

    4) Activate All – Found in Cell B2 - Not used (MarketFeeder Pro full version only)

    5) Deactivate All – Found in cell C2 - Not used (MarketFeeder Pro full version only)

    6) Clear All – Found in cell D2 - Not Used (MarketFeeder Pro full version only)

    7) Manual Override – Found in cell A3 – default value is always set to “auto”. When it is
       set to “auto”, the software will monitor your betting bank throughout the day. If you get
       through around 60% of the races, and you are in profit, the software will cease trading
       for the day, ensuring you finish each day in profit. If you get through around 60% of the
       day‟s races, and are still at a loss, the software will continue to automatically trade, until
       the next win is recorded. This win should ensure you then finish the day in overall profit.
       If you change this cell to “manual”, the software will continue trading right up to the final
       race of the day, regardless of whether you are winning or losing.

    8) AF (Available Funds) - Found in cell B3. The default is 0. This means that the software
       will expose your full Betfair betting bank to trade with, and will continue trading until
       your bank balance reaches 0. If you set this to 200, then the software would cease
       trading once it detected your bank balance was equal to or less than £200.l (see the
       “Altering your default settings” section, for more details of using this option)

    9) W/P (Win/Place Market) – Found in cell D3. The default is “w”, which means the
       software will trade in the Win market my default. You can change this to “p”
       (IMPORTANT NOTE: change to either small p or w. DO NOT use capital letters!) if you
       wish to trade in the Place Market.
Section 2 – See Below




10) PPR (Profit per Race) - The default value is 0.25 (Cell F1), which is 25p. Therefore by
    leaving this value at a default of 0.25, the software will attempt to make 25p profit per
    race. If you look at the image below, it is set to 0.1, which represents 10p profit per race,
    which is what a trial user of the software will experience.

11) CLB (Consecutive Losing Bets) – The default value is 99 (cell F2). This means the
    software will continue betting until 99 consecutive losing bets are recorded before
    stopping. You can change this value to limit the number of consecutive bets the software
    will make. For example, by setting this value to 3, the software will cease trading if it
    records 3 consecutive losing bets throughout the day.

12) MO (Minimum Odds) – The default is 1.33 (Cell F3). The software will not bet on a horse,
    unless its odds are AT LEAST 1.33. You should note that occasionally horses odds will be
    below 1.33, especially in the Place Markets. If the odds are not above the value in Cell F3
    the software will not bet on the horse.

13) Loss Recovered % - Cell G1 - The default is 100 (100%). This means that the software
    will attempt to recoup 100% of your previous losses during a losing run. For example, if
    you lose £10 in race one, and your profit target is £10, then the software will now
    attempt to achieve profit of £20 (100% of previous loss + profit required) on the next
    race.

14) Resume Betting – The default value is “no”. (Cell G2) This means that as soon as your
    CLB value is matched, the software will stop betting. You need to switch this to “yes” to
    enable the “LR % once CLB exceeded” option below.

15) LR % once CLB exceeded (NOTE: Resume Betting option in Cell G2 MUST be set to
    “yes” for this setting to take effect) – This specifies the percentage of previous losses
    you wish to recoup once the CLB is matched or exceeded. This works in the exact same
    way as “Loss recovered %”

16) Recovery Mode – Cell I1 - by default this is switched off – (set to “no”) Recovery mode
    is an important new feature which allows users to recover losses incurred in the event of
    a run of consecutive losing bets. By switching on Recovery mode (set this to “yes”) you
    can specify the loss target and the number of races over which to recoup this amount.

Please note that whilst Recovery Mode is switched on, it will override all other settings,
although you can use a formula to switch this setting on dynamically.

17) Loss Target – Recovery Mode must be switched to “yes” for this to work. You can
    specify the amount lost you wish to recoup. You can also use this option dynamically.

18) No. of Races – Specify the number of races over which to secure your “Loss Target”.
    For example, if your Loss target is £100 and so set the “No. of races” option to 2, then
    the software will attempt to recoup £50 of the loss for each race.
    Section 3 – See Below




    19) Race Filtering – This is switched off by default. You can tell the software to skip any
        individual races you do not wish to bet on, regardless of any other settings, for whatever
        reason. You need to type “n” (Without quotations) in the cell adjacent to the race in
        column K in order to filter out a particular race. The software will then know to
        completely skip those races.




Section 4 – See Below




The Selection Column (Column I) allows you to override the selections we have loaded into the
software. You do not have to do this if you don‟t want to, but you may have specific selections
you wish to bet on so this will allow you to do so. This is an advanced option, so we need to
explain in greater detail how to do this.
First of all, you need the software to retrieve all market data for the race, so that the software is
fully aware of what selections are available in the race.


To do this, you first of all need to identify which races you are planning to change. If you look at
the image below you will see that the races are in order of time….The win races, followed by the
Place races. If you try to select a different horse before racing starts (I.e. when the software is in
its idle phase) then you won‟t see any other selections available. We need to tell the software to
retrieve the market data for these races.




If you wanted to change the default selection for the 15:40 at Plumpton from “Wiesenfurst” to
Southern Exit, you would do the following.

    1. Go to the MarketFeeder Engine and turn ON “Constant Monitoring”
    2. Click on “Save Settings”
    3. Go and make a cup of tea for 10-15 minutes! – The software will now retrieve ALL
       market information, and this will take some time. It may seem like the software has
       stopped doing anything, but its most likely still extracting market info, so be PATIENT
       and wait for around 10-15 minutes for all market data to be retrieved.
    4. After around 15 minutes, un-tick the “Constant Monitoring” box, and again click “Save
       Settings”. All the market data should now have been captured, so we can now make our
       changes.
    5. You can now revisit the “triggers” worksheet, and the different horse selections for the
       15:40 Plumpton race should now be available.




IMPORTANT NOTE: As well as all the horse selections, you will also see a number of other entries
in the drop-down menu. You should ignore these other entries. You should ONLY select horse
entries which have numbers at the end of them.


    6. Once you have done this, you need to click on the Save Changes button in cell A2 of the
       triggers page, to confirm your new selections.




The selections are now saved, and the software will bet on the selections you have chosen.


NOTE: IF your system reboots, or the software shuts down, the selections you made will NOT be
saved. You will need to make your selections again. Be very careful of this. The software does
not SAVE options or settings when the software has been shut down.




Default Settings

What can I expect, if I leave the settings at default?
The software will do the following:

It will place a bet based on the selection shown in column I of the triggers page, and the default
criteria. It will attempt to achieve 25p profit per race (According to default PPR) providing the
odds available are above 1.33, and you have enough money in your account to cover the bet.

If you happen to lose this bet, the software will begin recalculating the amount required to bet
on the next race, in order to secure 25p profit, as well as attempting to recoup 100% of the
previous loss (According to the default setting of “Loss Recovered %”). For example, if you lost
20p in the first race, then the software‟s profit target in the second race would now be
20p+25p=45p so it would calculate the amount needed to bet in order to secure a 45p profit.

Many people simply chose to change their PPR (profit per race) which is the simplest setup. For
example, changing the PPR from 0.25 to 1 will mean that you are telling the software to try and
win you £1 profit per race, and whenever you lose a bet, it immediately recalculates in order to
recoup your loss as well as win you the desired PPR.



                      Altering your default settings:
                               (Remember this is optional)

MarketFeeder Pro section

    1) Always Show today’s bets only – Found in the “betting options” tab of MarketFeeder
       Pro. We recommend that his setting should be changed only when using the Manual
       override setting. You can un-tick this box and specify the previous days date. This will
       allow Auto-BF to reference yesterdays betting and effectively allows the software to carry
       on from the previous day‟s betting.

For example, say it is the 31st of June, and you finished yesterday (the 30th June) at a loss, and
want to pick up form where you left off. You would un-tick the “Always show today‟s bets only”
box, and change the date to 30/07/06. The software now extracts the account summary from the
previous day, so knows where to pick up from.

NOTE: You should NOT use this feature if you make personal bets with this betfair account,
between Auto-BF trading sessions, as your personal bets would also be referenced!!

NOTE: You need to press the “Save Settings” button at the bottom of MarketFeeder Pro,
whenever you change anything in MarketFeeder Pro to confirm your changes.




    Dynamic settings for advanced Excel users –

    All trigger option values can be controlled dynamically, using various Excel Formulas. You
    literally add the formula into the cell, and it will allow this value to be controlled dynamically.
    I.e., it will change as the day progresses.

    Some examples:

    You could set your PPR to dynamically change to 0.5% of Your Betting Bank
    You could set your CLB to change based on the odds available
    You could set your MO to increase progressively after each successive losing bet
You could set your Loss Recovered to decrease progressively after each successive losing bet.
You could set your Recovery Mode to switch on once your overall losses exceed a specified
value.
You could set your Loss target to follow the value of your losses
You could set your No. of races, based on your CLB option.
You could tell the software to change from the Win Market to the Place Market if it detects x
number of consecutive losing bets.


As always, if you have any questions regarding the new settings, or have any comments or
suggestions, then please do not hesitate to contact us.



                                         Auto-BF