Excel Integration
Excel Integration (Download sample sheets)
Bet Minder can output your selections, market prices, current bets (that it has made) and full account statement (for the day) into an excel spread sheet.
Open the Excel Activation window from the tool bar in the ‘Add Selections’ window.
Current bets and account statement sheets are optional as they can take a small amount of time to populate and you may not need them for your intended purpose.
Simply select an existing excel spread sheet and Bet Minder will create the correct worksheets for you. Click Activate to activate the excel system for all of your Bet Minder bets.
Always override checked means you must, within your excel spread sheet, (with macros) tell the system you want to place the bets otherwise Bet Minder will not place the bets you have chosen. Unchecked and Bet Minder will place the bets as specified but you have the chance to change them to a ‘no bet’ and just to log the information if you wish to.
Read/Write Delay is the pause time (in milliseconds) between writing to the spread sheet and reading the spread sheet. The recommendation is to leave this on 100 unless you are running macros that require a time lag in Bet Minder.
Update: Show balance option has now been added
The Spread sheet
Bet Minder will create sheets: BM Bets, BM Odds, BM Current Bets, BM Account Statement to write the information to.
An example BM Bets Sheet:
Column B is filled with race information; Start Time, Market, Market ID, Race Status, Distance (in furlongs) and your current actual Betfair Balance.
Cell A1 has OK printed to it as the last thing it does on this sheet and this is the last sheet to be printed to the workbook.
Information about your selections is printed in rows starting at cell D2.
Order info:
Qual – Did the bet qualify. In Bet Minder this should always be a 1, but you can override it to a 0 if you need to.
Price – The price (odds) of the order.
Size – The size (stake) of the order.
Type – The bet type B or L of the order.
Points – N/A – Only for Tipster Services.
Order – Set to 1 for true or 0 for false. if you have set ‘always override’ to yes then this will print as 0 otherwise it will print a 1 for each qualifying runner.
Done? – Bet Minder prints a 1 here when it has read the information and understood it as a bet to place on Betfair.
Runner Info:
Runner – The name of the runner
Runner ID – The Betfair ID for this runner
B1P – The price (odds) of the best back price
S1S – The available amount to back at the best price.
L1P – The price (odds) of the best lay price
L1S – The available amount to lay at the best price.
R.Fact – The reduction factor of the selection.
Last – The last price matched.
NearSP – The near Betfair Starting price.
FarSP – The far Betfair Starting price.
Total Matched – The total amount of money matched in relation to this selection so far.
Sort – The sort order on the Betfair market (0 indexed – 0 is the first number).
Macros
Cell A1 has ‘OK’ written to it so you can trigger a macro to read the information when it has finished printing.
In Visual Editor for Sheet1(BM Bets) you can write code with an event handler for cell A1, eg:
This sub routine is triggered when there is a change in a cell, if the target address is cell A1 and the value in A1 is ‘OK’ then you can fire you own subs or functions to read and write to the excel spreadsheet. Here we can see we are calling a sub called ‘DoBets’ when A1 has been populated.
- Private Sub Worksheet_Change(ByVal Target As Range)
- If Target.Address = “$A$1″ And Range(“$A$1″).Value = “OK” Then
- DoBets()
- End If
- End Sub
In the ‘DoBets’ Sub here we have simply look for runners with 1 in the Qual column and set a price of 2, a stake of 2 and set the Order column to a 1 so Bet Minder will read it as a bet.
Note that we are inside a Do Loop looping through the rows (starting from row 2) and we need to exit to loop when there are no more printed lines, see line 8,9,10.
- Private Sub DoBets()
- Dim Count As Integer
- Do
- ‘Loop through the rows looking for a qualifier
- Count = Count + 1
- ‘Exit the loop if we have reached the end
- If Cells(Count + 1, 5).Value = “” Then
- Exit Do
- End If
- If Cells(Count + 1, 4).Value = 1 Then ‘ Its a quailfier
- ‘Enter whatever stake and price you want
- Cells(Count + 1, 5).Value = 20 ‘ price
- Cells(Count + 1, 6).Value = 2 ‘ size
- Cells(Count + 1, 7).Value = “B” ‘ type
- Cells(Count + 1, 8).Value = 1 ‘ points
- Cells(Count + 1, 9).Value = 1 ‘ place bets (1/0)
- End If
- Loop
- ‘Thats all folks!!
- End Sub
This is a very basic example, you can code your own more complex macros or look at having them made for you. There are many sites where you can ask for development work like ‘rent a coder’ and we also have a list of developers that can code macros, please get in touch for more information.
More Worksheets:
Bet Minder also prints more information to worksheets for use in your Macros
In your code you can set objects to the worksheets so you can read the information from your ‘BM Bets’ Sheet Macro:
- ‘Set Worksheet Objects
- Dim OddsSheet As Worksheet
- Set OddsSheet = Sheets(“BM Odds”)
- Dim CurrentBetsSheet As Worksheet
- Set CurrentBetsSheet = Sheets(“BM Current Bets”)
- Dim AccountsSheet As Worksheet
- Set AccountsSheet = Sheets(“BM Account Statement”)
BM Odds Worksheet
This has the same information as the Bet Sheet but with all the runners, not just the runners you selected, and without the ordering columns (Qual, Price,Size,Type,Points and Order).
Optional Worksheets:
Current Bets are bets that have been made by Bet Minder on that PC and for Betfair account that it is running on.
The account statement is the full Betfair account statement for the current Betfair account. This will include all bets (up to 1000 of) settled on your account for that day.
Any of the information in these sheets can be used by your Macro’s if you wish.
