Update spreadsheet but retain odds calc

Please post any questions regarding the program here.

Moderator: 2020vision

Update spreadsheet but retain odds calc

Postby andyh » Wed May 16, 2007 2:49 pm

Hi all, I have been following the instructions shown below to set up triggered betting. My only problem is that I bet to liability so I also need the spreadsheet to take perform a liability calc and insert calculated stake. This would be fine but each time the market refreshes the sheet gets wiped. Can anybody suggest a method to calculate a liability stake when a horse from sheet 2 is matched to sheet 1.

Cheers in advance

Andy

Instructions followed-

Sheet2 to contain

Horse name in column A odds in column B stake column C

Sheet1 as follows

In the odds column O you need to copy and paste the following into O5 to say O50 to cover all runners

=IF(ISNA(VLOOKUP(A5,Sheet2!$A$1:$C$100,2,FALSE)),"",VLOOKUP(A5,Sheet2!$A$1:$C$100,2,FALSE) )

in stake column P copy the follwoing from P5 to P50

=IF(ISNA(VLOOKUP(A5,Sheet2!$A$1:$C$100,3,FALSE)),"",VLOOKUP(A5,Sheet2!$A$1:$C$100,3,FALSE) )

Basically it just check the name of the horse against your list of bets and if it finds a match it'll stick the odds in the column O for you and stake in column P.

for the trigger column just copy and paste the following from N5 to N50

=IF(AND(MINUTE($D$2)<1,O2>0),"LAY","WAITING")

Any problems just give us a shout.

You have to make sure the names match exactly with the way betfair have entered them for it to kick off.


Just have your bettrader set to auto select markets and ensure the clock on your PC is set correctly

Easy enough to add another column to sheet 2 if you're backing and laying and amend =IF(AND(MINUTE($D$2)<1,O5>0),"BACK","") so it picks the LAY or BACK form the column using VLOOKUP same as for the odds etc

Forgot to mention you'll need a macro in the worksheet to clear the cell references when it switches between markets on auto select. I just use the code below that someone else posted a while back

Just open up the visual basic editor and paste below into sheet1

Private Sub Worksheet_Calculate()
Static MyMarket As Variant
Application.EnableEvents = False
Application.Calculation = xlCalculationManual
If [A1].Value = MyMarket Then
GoTo Xit
Else
MyMarket = [A1].Value
Range("Q5:U80").Value = ""
End If
Xit:
Application.EnableEvents = True
Application.Calculation = xlCalculationAutomatic
End Sub
andyh
 
Posts: 21
Joined: Thu Feb 08, 2007 11:24 am

Return to Help

Who is online

Users browsing this forum: No registered users and 24 guests

Sports betting software from Gruss Software


The strength of Gruss Software is that it’s been designed by one of you, a frustrated sports punter, and then developed by listening to dozens of like-minded enthusiasts.

Gruss is owned and run by brothers Gary and Mark Russell. Gary discovered Betfair in 2004 and soon realised that using bespoke software to place bets was much more efficient than merely placing them through the website.

Gary built his own software and then enhanced its features after trialling it through other Betfair users and reacting to their improvement ideas, something that still happens today.

He started making a small monthly charge so he could work on it full-time and then recruited Mark to help develop the products and Gruss Software was born.

We think it’s the best of its kind and so do a lot of our customers. But you can never stand still in this game and we’ll continue to improve the software if any more great ideas emerge.