To build an application that will automaticly bet on betfair markets as previously discussed.
Application is to be built in Visual basic 2010 with all files to be provided. I use Access 2000
for database's The date format on my machine is YYYY-MM-DD.
Download the required files from betfair.
Store the marketID Betfair Start time and My Start time in an Access 2000 database . The
required fields in the database are
BetFair Start Time
My Start Time
I can provide the market strings for the markets I want
Display them in a list sorted on start [url removed, login to view] My Start Time is null then sort the list on
Betfair start time. (betfair do not always update an ammended start time reason for my start
time) I will update my start time.
A race will be processed with subs and functions.
Placing mostly lays bets based on a price i will provide via [url removed, login to view] an extra column in
datagrid view to display this price on the left. When that race is closed the next race on the
list will start to be processed.
The main thing that can go wrong is race times change so having the ability to check race
times and not hang on a suspended or closed race. And to check that the current race starts
before the next race in the list.
When runners are removed before the start Betfair remove all lay bets so being able to quickly
be the first up with prices can be good. Removed runners is in one of there JASON calls I think.
To be able to access all betfair markets but this can be hidden or in a menu as i rarely use
Display data in datagridview as in spreadsheet . I can proide screenshot if you can't open spreadsheet.
One extra row between runners.
Unmatched bets on bottom row. Matched bets on top [url removed, login to view] bet matched the cell background color
is set to green.
4 columns for Back size back price, lay size, lay price.
background colors to be the same as spreadsheet for betfair prices . Pink and Blue
List box on left hand side of each runner.
With selections Normal , Lay, Bet All Back , Back. default is normal.
Market percentage at top for both Back and lay. Either calculate the market percentage from the
given prices or it may be available from a jason request .
Loop the cells containing Betfair best Bid /Offer. percent = percent + 100 / cell value
100/ cell value will give you the market percentage for that runner,
Extra column on left of selection where I will insert my ratedPrice from database. My prices
market percentage to be displayed at top of column. Timer to be set to request data from data
base based on how close we are to start time of race.
Text Box at top left of application for Maxiumin Liability to lay for all selections.
I think i can code the below. I have the vba code .
sub Book - To initial set prices and size based on what is bid and what my ratedPrice is
and what my Max liability is.
sub TakeUnders - to take any bet offered below my price * 1.2 to max liability + x amount
Sub updatePrices - to check betfairs latest prices in the grid and compare to my bid prices.
. If my bid Price is not top bid compare it to my ratedPrice and adjust my
bid price and size .Ignore bids less the $6(Betfair Bots) To do this it may be
best to store betID's in either another database or a hidden column.
I will be available via chat to discuss anything that is unclear.